Skip Navigation LinkseConnect Module : Type : Node : Fields Easy Navigation

taPopRcptLineInsert

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
POPTYPEsmallintYes Receipt Type 1=Shipment 3=Shipment/Invoice IN
POPRCTNMchar(17)Yes Receipt Number IN
PONUMBERchar(17)Yes Purchase Order Number if receiving against a PO IN
ITEMNMBRchar(30)Yes Item Number IN
ITEMDESCchar(100)No Item Description for NON-INVE IN
VENDORIDchar(15)Yes Vendor ID IN
RCPTLNNMintNo Receipt Line Number IN
VNDITNUMchar(30)Yes Vendor Item Number IN
VNDITDSCchar(100)No Vendor Item Description IN
ACTLSHIPdatetimeNo Actual Ship Date IN
INVINDXintNo Inventory Index IN
InventoryAccountvarchar(75)No Inventory Account IN
UOFMchar(8)No Unit of Measure IN
UNITCOSTnumeric(19,5)Yes Unit Cost set to 0 if using @I_vAUTOCOST IN
EXTDCOSTnumeric(19,5)Yes Extended Cost set to 0 if not using @I_vAUTOCOST IN
NONINVENsmallintNo Non-Inventory IN
JOBNUMBRchar(17)No Job Number IN
BOLPRONUMBERchar(30)No BOL/Pro Number IN
QTYSHPPDnumeric(19,5)Yes Quantity Shipped IN
QTYINVCDnumeric(19,5)Yes Quantity Invoiced if @I_vPOPTYPE = 3 IN
AUTOCOSTintYes Extended Cost set to 0 if not using @I_vAUTOCOST IN
Purchase_IV_Item_TaxablesmallintNo Purchase Inventory Item Taxable 1=Taxable,2=Nontaxable,3=Base on Vendor IN
Purchase_Item_Tax_Scheduchar(15)No Purchase Item Tax Schedule - blank unless @I_vPurchase_IV_Item_Taxable = 1 IN
Purchase_Site_Tax_Scheduchar(15)No Purchase Site Tax Schedule IN
TAXAMNTnumeric(19,5)No Tax Amount IN
Landed_Cost_Group_IDchar(15)No Landed Cost Group ID IN
LOCNCODEchar(10)No Location code in Receiving IN
POLNENUMintNo PO Line Number Must be unique per PO IN
receiptdatedatetimeYes Required if using Landed Cost IN
CURNCYIDchar(15)No Currency ID - pulls from PO unless not doing receiving against a PO IN
ProjNumchar(15)No Project Number, for use with Project Accounting only IN
CostCatIDchar(15)No Cost Category ID, for use with Project Accounting only IN
AutoAssignBinsmallintNo Use Default Bin - will use the PORECEIPTBIN bin - from the item site combination or the site default IN
CMMTTEXTvarchar(500)No Comment Text IN
RequesterTrxsmallintNo Requester Transaction - 0=false,1=true - if true than populates Requester shadow table IN
USRDEFND1char(50)No User Defined field - developer use only IN
USRDEFND2char(50)No User Defined field - developer use only IN
USRDEFND3char(50)No User Defined field - developer use only IN
USRDEFND4varchar(8000)No User Defined field - developer use only IN
USRDEFND5varchar(8000)No User Defined field - developer use only IN
ErrorStateintNo Return value: 0=No Errors, 1=Error Occurred INOUT
oErrStringvarchar(255)No Return Error Code List INOUT
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3