POPTYPE | smallint | Yes | Receipt Type 1=Shipment 3=Shipment/Invoice | IN |
POPRCTNM | char(17) | Yes | Receipt Number | IN |
PONUMBER | char(17) | Yes | Purchase Order Number if receiving against a PO | IN |
ITEMNMBR | char(30) | Yes | Item Number | IN |
ITEMDESC | char(100) | No | Item Description for NON-INVE | IN |
VENDORID | char(15) | Yes | Vendor ID | IN |
RCPTLNNM | int | No | Receipt Line Number | IN |
VNDITNUM | char(30) | Yes | Vendor Item Number | IN |
VNDITDSC | char(100) | No | Vendor Item Description | IN |
ACTLSHIP | datetime | No | Actual Ship Date | IN |
INVINDX | int | No | Inventory Index | IN |
InventoryAccount | varchar(75) | No | Inventory Account | IN |
UOFM | char(8) | No | Unit of Measure | IN |
UNITCOST | numeric(19,5) | Yes | Unit Cost set to 0 if using @I_vAUTOCOST | IN |
EXTDCOST | numeric(19,5) | Yes | Extended Cost set to 0 if not using @I_vAUTOCOST | IN |
NONINVEN | smallint | No | Non-Inventory | IN |
JOBNUMBR | char(17) | No | Job Number | IN |
BOLPRONUMBER | char(30) | No | BOL/Pro Number | IN |
QTYSHPPD | numeric(19,5) | Yes | Quantity Shipped | IN |
QTYINVCD | numeric(19,5) | Yes | Quantity Invoiced if @I_vPOPTYPE = 3 | IN |
AUTOCOST | int | Yes | Extended Cost set to 0 if not using @I_vAUTOCOST | IN |
Purchase_IV_Item_Taxable | smallint | No | Purchase Inventory Item Taxable 1=Taxable,2=Nontaxable,3=Base on Vendor | IN |
Purchase_Item_Tax_Schedu | char(15) | No | Purchase Item Tax Schedule - blank unless @I_vPurchase_IV_Item_Taxable = 1 | IN |
Purchase_Site_Tax_Schedu | char(15) | No | Purchase Site Tax Schedule | IN |
TAXAMNT | numeric(19,5) | No | Tax Amount | IN |
Landed_Cost_Group_ID | char(15) | No | Landed Cost Group ID | IN |
LOCNCODE | char(10) | No | Location code in Receiving | IN |
POLNENUM | int | No | PO Line Number Must be unique per PO | IN |
receiptdate | datetime | Yes | Required if using Landed Cost | IN |
CURNCYID | char(15) | No | Currency ID - pulls from PO unless not doing receiving against a PO | IN |
ProjNum | char(15) | No | Project Number, for use with Project Accounting only | IN |
CostCatID | char(15) | No | Cost Category ID, for use with Project Accounting only | IN |
AutoAssignBin | smallint | No | Use Default Bin - will use the PORECEIPTBIN bin - from the item site combination or the site default | IN |
CMMTTEXT | varchar(500) | No | Comment Text | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Return value: 0=No Errors, 1=Error Occurred | INOUT |
oErrString | varchar(255) | No | Return Error Code List | INOUT |