Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Skip Navigation LinkseConnect Module : Type : Node : Fields Easy Navigation

taPoLine

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
POTYPEsmallintNo PO Type - 1 = Standard, 2 = Drop Ship, 3 = Blanket, 4 = Drop Ship Blanket IN
PONUMBERchar(17)No PO Number - Unique identifier for the PO IN
DOCDATEdatetimeYes Document Date Date of the PO Required for PA IN
VENDORIDchar(15)No Vendor ID - ID of the vendor you're purchasing items from IN
LOCNCODEchar(10)No Location Code - ID of the site for which you're purchasing the items IN
VNDITNUMchar(30)No Vendor Item Number IN
ITEMNMBRchar(30)No Item Number IN
QUANTITYnumeric(19,5)No Quantity - Total Quantity for line Item IN
QTYCANCEnumeric(19,5)No Quantity Cancelled - Quantity that is to be canceled IN
FREEONBOARDsmallintNo Terms of sale - identify point at which ownership of goods passes to buyer. 1=None,2=Origin,3=Destination IN
REQSTDBYchar(20)No Requested by - Person or department who requested this line item IN
COMMNTIDchar(15)No Comment ID IN
COMMENT_1char(50)No Comment part 1 IN
COMMENT_2char(50)No Comment part 2 IN
COMMENT_3char(50)No Comment part 3 IN
COMMENT_4char(50)No Comment part 4 IN
REQDATEdatetimeYes Required date by which the items must be received IN
RELEASEBYDATEdatetimeYes Date the purchase order line needs to be released to the vendor to receive the item by the Required Date IN
PRMDATEdatetimeNo Date the vendor promised you would receive merchandise or services IN
PRMSHPDTEdatetimeNo Date the vendor promised the merchandise would be shipped IN
NONINVENsmallintNo 0=Inventory item, 1=Non Inventory item IN
IVIVINDXintNo Inventory Account Index IN
InventoryAccountvarchar(75)No Inventory Account Number String IN
ITEMDESCchar(100)No Item Description for the line item IN
UNITCOSTnumeric(19,5)No Unit Cost for the item in the specified unit of measure IN
VNDITDSCchar(100)No Vendor Item Description for the line item IN
UOFMchar(8)No Unit of Measure in which this item is being purchased 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
BSIVCTTLsmallintNo Based on invoice total IN
TAXAMNTnumeric(19,5)No Tax Amount IN
BCKTXAMTnumeric(19,5)No Backout Tax Amount IN
Landed_Cost_Group_IDchar(15)No Landed Cost Group ID IN
PLNNDSPPLIDsmallintNo Planned Supplier ID IN
SHIPMTHDchar(15)No Shipping Method IN
BackoutTradeDiscTaxnumeric(19,5)No Backout Trade Discount Tax Amount IN
POLNESTAsmallintNo PO Line Status - (valid: 1=new, 2=released 3=change order, 4=received, 5=closed, 6 =cancelled) IN
CMMTTEXTvarchar(500)No Comment Text; only use if not using @I_vCOMMENT_1 thu @I_vCOMMENT_4 IN
ORDintNo Sequence number used to track each item. Must be unique per PO IN
CUSTNMBRchar(15)Yes Customer Number IN
ADRSCODEchar(15)No Address Code IN
CMPNYNAMchar(64)No Name IN
CONTACTchar(60)No Contact IN
ADDRESS1char(60)No Address Line 1 IN
ADDRESS2char(60)No Address Line 2 IN
ADDRESS3char(60)No Address Line 3 IN
CITYchar(35)No City IN
STATEchar(29)No State IN
ZIPCODEchar(10)No Zip Code IN
CCodechar(6)No Country Code IN
COUNTRYchar(60)No Country IN
PHONE1char(21)No Phone 1 IN
PHONE2char(21)No Phone 2 IN
PHONE3char(21)No Phone 3 IN
FAXchar(21)No Fax IN
Print_Phone_NumberGBsmallintNo Print_Phone_NumberGB (0-4 valid) used on drop ship PO's for 12.0 IN
CURNCYIDchar(15)No Currency ID 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
LineNumberintNo Line Number, Blanket PO's IN
UpdateIfExistssmallintNo Used to Add/Modify existing documents - 1=Add/Modify - partial updates allowed IN
NOTETEXTvarchar(8000)No Notes field IN
RequesterTrxsmallintNo Requester Transaction - 0=false,1=true - if true then 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 Error Code INOUT
oErrStringvarchar(255)No List of errors encountered 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
site