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

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


eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
POTYPEsmallintYes PO Type 1=Standard, 2=Drop Ship IN
PONUMBERchar(17)Yes PO Number Unique identifier for the PO IN
VENDORIDchar(15)Yes Vendor ID ID of the Vendor you are purchasing from IN
VENDNAMEchar(64)No Vendor Name Name of the Vendor IN
DOCDATEdatetimeYes Document Date Date of the PO IN
BUYERIDchar(15)No Buyer Id Buyer who is responsible for the purchase order IN
ALLOWSOCMTStinyintNo Allow Sales Commitments 1=Allow PO to be committed to SOP line items IN
TRDISAMTnumeric(19,5)No Trade Discount Amount IN
FRTAMNTnumeric(19,5)No Freight Amount IN
MSCCHAMTnumeric(19,5)No Miscellaneous Charge Amount IN
TAXAMNTnumeric(19,5)No Tax Amount IN
SUBTOTALnumeric(19,5)No Subtotal = Total before taxes IN
CUSTNMBRchar(15)No Customer ID to which the vendor is shipping the items on a drop shipIN
PRSTADCDchar(15)No Primary Ship to Address Code address to which the order is being sent IN
CMPNYNAMchar(64)No Company Name associated with the Ship to Address ID IN
CONTACTchar(60)No Contact person for the Ship to Address ID IN
ADDRESS1char(60)No Address line 1 for the Ship to Address ID IN
ADDRESS2char(60)No Address line 2 for the Ship to Address ID IN
ADDRESS3char(60)No Address line 3 for the Ship to Address ID IN
CITYchar(35)No City for the Ship to Address ID IN
STATEchar(29)No State for the Ship to Address ID IN
ZIPCODEchar(10)No Zip code for the Ship to Address ID IN
CCodechar(6)No Country Code for the Ship to Address ID IN
COUNTRYchar(60)No Country for the Ship to Address ID IN
PHONE1char(21)No Phone number 1 for the Ship to Address ID IN
PHONE2char(21)No Phone number 2 for the Ship to Address ID IN
PHONE3char(21)No Phone number 3 for the Ship to Address ID IN
FAXchar(21)No Fax number for the Ship to Address ID IN
Print_Phone_NumberGBsmallintNo Print_Phone_NumberGB valid 0-4 on POTYPE 2,4 IN
VADCDPADchar(15)No Vendor Address Code Purchase Address ID IN
PURCHCMPNYNAMchar(64)No Purchase Company Name IN
PURCHCONTACTchar(60)No Purchase Contact IN
PURCHADDRESS1char(60)No Purchase Address 1 IN
PURCHADDRESS2char(60)No Purchase Address 2 IN
PURCHADDRESS3char(60)No Purchase Address 3 IN
PURCHCITYchar(35)No Purchase City IN
PURCHSTATEchar(29)No Purchase State IN
PURCHZIPCODEchar(10)No Purchase Zip Code IN
PURCHCCodechar(6)No Purchase Country Code IN
PURCHCOUNTRYchar(60)No Purchase Country IN
PURCHPHONE1char(21)No Purchase Phone 1 IN
PURCHPHONE2char(21)No Purchase Phone 2 IN
PURCHPHONE3char(21)No Purchase Phone 3 IN
PURCHFAXchar(21)No Purchase Fax IN
PRBTADCDchar(15)No Bill to Address ID IN
SHIPMTHDchar(15)No Shipping method IN
PYMTRMIDchar(20)No Payment term ID extended to your company by the vendor IN
DSCPCTAMnumeric(19,5)No Discount Percent Amount IN
DSCDLRAMnumeric(19,5)No Discount Dollar Amount IN
DISAMTAVnumeric(19,5)No Discount Available Amount IN
DUEDATEdatetimeNo Due Date IN
DISCDATEdatetimeNo Discount Date IN
TXRGNNUMchar(25)No Vendor's tax registration number IN
CONFIRM1char(20)No Confirm 1 Name of the person the order should be approved by 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
HOLDtinyintNo Hold Flag 0 = not on hold, 1 = on hold IN
TAXSCHIDchar(15)No Tax Schedule ID IN
Purchase_Freight_TaxablesmallintNo Purchase Freight Taxable 1=Taxable, 2=NonTaxable, 3=Based on Vendor IN
Purchase_Misc_TaxablesmallintNo Purchase Misc Taxable 1=Taxable, 2=NonTaxable, 3=Based on Vendor IN
FRTSCHIDchar(15)No Freight Tax Schedule ID IN
MSCSCHIDchar(15)No Misc Tax Schedule ID IN
FRTTXAMTnumeric(19,5)No Freight Tax Amount IN
MSCTXAMTnumeric(19,5)No Misc Tax Amount IN
BCKTXAMTnumeric(19,5)No Back Tax Amount IN
BackoutFreightTaxAmtnumeric(19,5)No Backout Freight Tax Amount IN
BackoutMiscTaxAmtnumeric(19,5)No Backout Misc Tax Amount IN
BackoutTradeDiscTaxnumeric(19,5)No Backout Trade Disc Tax Amount IN
USINGHEADERLEVELTAXESsmallintNo Using Header Level Taxes Flag 0 = no (default), 1 = yes IN
CURNCYIDchar(15)No Currency ID IN
XCHGRATEnumeric(19,5)No Exchange Rate IN
RATETPIDchar(15)No Rate Type ID IN
EXPNDATEdatetimeNo Expiration Date IN
EXCHDATEdatetimeNo Exchange Date IN
EXGTBDSCchar(30)No Exchange ID Desc. IN
EXTBLSRCchar(50)No Exchange Rate Source IN
RATEEXPRsmallintNo Rate Expiration 1=Daily, 2=Weekly, 3=Bi-Weekly, 4=Semi-Monthly, 5=Monthly, IN
DYSTINCRsmallintNo Days to Increment IN
RATEVARCnumeric(19,5)No Rate Variance IN
TRXDTDEFsmallintNo Trx Date Default 0=Exact Date, 1=Next Date, 2=Previous Date IN
RTCLCMTDsmallintNo Rate Calc. Method The breakdown is: 0=Multiply, 1= Divide IN
PRVDSLMTsmallintNo Previous Days Limits Added for Multi-Currency - MC40300 IN
DATELMTSsmallintNo Date Limits 0=Unlimited, 1=Limited IN
TIME1datetimeNo Time 1 IN
USERIDchar(15)No User to Enter (USER2ENT) IN
POSTATUSsmallintNo 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
PRMDATEdatetimeNo Promise Date IN
PRMSHPDTEdatetimeNo Promise Ship Date IN
REQDATEdatetimeYes Required Date IN
CONTENDDTEdatetimeNo Contract Expiration Date IN
CNTRLBLKTBYsmallintNo Control Blanket By 0=Quantity, 1=Value IN
REQTNDTdatetimeNo Requisition Date 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 List of errors encountered 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