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

taUpdateCreateVendorRcd

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
VENDORIDchar(15)Yes Vendor ID IN
VENDNAMEchar(64)Yes Vendor Name: Required for new record IN
VENDSHNMchar(15)No Vendor Short Name IN
VNDCHKNMchar(64)No Vendor Check Name IN
HOLDtinyintNo Hold; 0=Not on Hold; 1=Hold; Default=0 on new record IN
VENDSTTSsmallintNo Status: 1=Active; 2=Inactive; 3=Temporary; Default=1 on new record IN
VNDCLSIDchar(10)No Class ID IN
VADDCDPRchar(15)No Primary Address ID IN
VNDCNTCTchar(60)No Contact IN
ADDRESS1char(60)No Address1 IN
ADDRESS2char(60)No Address2 IN
ADDRESS3char(60)No Address3 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
PHNUMBR1char(21)No Phone1 IN
PHNUMBR2char(21)No Phone2 IN
PHNUMBR3char(21)No phone3 IN
FAXNUMBRchar(21)No Fax Number IN
TAXSCHIDchar(15)No Tax Schedule IN
SHIPMTHDchar(15)No Shipping Method IN
UPSZONEchar(3)No UPS Zone IN
VADCDPADchar(15)No Purchase Address ID IN
VADCDTROchar(15)No Remit To Address ID IN
VADCDSFRchar(15)No Ship From Address ID IN
ACNMVNDRchar(20)No Vendor Account IN
COMMENT1char(30)No Comment1 IN
COMMENT2char(30)No Comment2 IN
NOTETEXTvarchar(8000)No Note Text IN
CURNCYIDchar(15)No Currency ID IN
RATETPIDchar(15)No Rate Type ID IN
PYMTRMIDchar(20)No Payment terms ID IN
DISGRPERsmallintNo Discount Grace Period: Max value=99 IN
DUEGRPERsmallintNo Due Date Grace Period: Max value=99 IN
PYMNTPRIchar(3)No Payment Priority IN
MINORDERnumeric(19,5)No Minimum Order IN
TRDDISCTnumeric(19,5)No Trade Discount IN
TXIDNMBRchar(11)No Tax ID IN
TXRGNNUMchar(25)No Tax Registration IN
CHEKBKIDchar(15)No Checkbook ID IN
USERDEF1char(20)No User-Defined 1 IN
USERDEF2char(20)No User-Defined 2 IN
TEN99TYPEsmallintNo Tax Type: 1=Not a 1099 Vendor; 2=Dividend; 3=Interest; 4=Misc.; Default=1 on new vendor IN
TEN99BOXNUMBERsmallintNo Ten 99 Box Number IN
FREEONBOARDsmallintNo FOB: 1=None; 2=Origin; 3=Destination; Default=1 on new vendor IN
USERLANGsmallintNo User Language; Default=0 on new record IN
MINPYTYPsmallintNo Minimum Payment Type: 0=No Minimum; 1=Percent; 2=Amount; Default=0 on new record IN
MINPYDLRnumeric(19,5)No Minimum Payment Dollar Amount: Used if @I_vMINPYTYP=2 IN
MINPYPCTnumeric(19,5)No Minimum Payment Percent: Used if @I_vMINPYTYP=1 IN
MXIAFVNDsmallintNo Maximum Invoice Amount Type: 0=No Maximum; 1=Amount; Default=0 on new record IN
MAXINDLRnumeric(19,5)No Maximum Invoice Dollar Amount: Used if @I_vMXIAFVND=1 IN
CREDTLMTsmallintNo Credit Limit Type: 0=No Credit; 1=Unlimited; 2=Amount; Default=1 on new record IN
CRLMTDLRnumeric(19,5)No Credit Limit Dollar Amount: Used if @I_vCREDTLMT=2 IN
WRITEOFFsmallintNo Writeoff Type: 0=Not Allowed; 1=Unlimited; 2=Maximum IN
MXWOFAMTnumeric(19,5)No Maximum Writeoff Amount: Used if @I_vWRITEOFF=2 IN
Revalue_VendortinyintNo Revalue Vendor: 0=Do Not Revalue; 1=Revalue; Default=1 on new record IN
Post_Results_TosmallintNo Post Results To: 0=Payables/Discount Acct; 1=Purchasing Offset Acct; Default=0 on new record IN
KPCALHSTtinyintNo Maintain History - Calendar Year: 0=Do Not Maintain; 1=Maintain; Default=1 on new record IN
KPERHISTtinyintNo Maintain History - Fiscal Year: 0=Do Not Maintain; 1=Maintain; Default=1 on new record IN
KPTRXHSTtinyintNo Maintain History - Transaction: 0=Do Not Maintain; 1=Maintain; Default=1 on new record IN
KGLDSTHStinyintNo Maintain History - Distribution: 0=Do Not Maintain; 1=Maintain; Default=1 on new record IN
PTCSHACFsmallintNo Use Cash Account From: 0=Checkbook; 1=Vendor; Default=0 on new record IN
PMCSHACTNUMSTvarchar(75)No Cash Account: Only valid if @I_vPTCSHACF=1 IN
PMAPACTNUMSTvarchar(75)No Account Payable Account IN
PMDAVACTNUMSTvarchar(75)No Terms Discount Available Account IN
PMDTKACTNUMSTvarchar(75)No Terms Discount Taken Account IN
PMFINACTNUMSTvarchar(75)No Finance Charges Account IN
PMPRCHACTNUMSTvarchar(75)No Purchases Account IN
PMTDSCACTNUMSTvarchar(75)No Trade Discount Account IN
PMMSCHACTNUMSTvarchar(75)No Miscellaneous Account IN
PMFRTACTNUMSTvarchar(75)No Freight Account IN
PMTAXACTNUMSTvarchar(75)No Tax Account IN
PMWRTACTNUMSTvarchar(75)No Writeoffs Account IN
ACPURACTNUMSTvarchar(75)No Accrued Purchases Account IN
PURPVACTNUMSTvarchar(75)No Purchase Price Variance Account IN
UseVendorClasstinyintNo Flag to have class setting roll down to parameters that are not passed in. Uses the @I_vVNDCLSID class IN
CreateAddresstinyintNo Flag to allow an address code to be created on the fly IN
UpdateIfExiststinyintNo Flag to allow updates: 0=Create only; 1=Update if exists; 2=Create, do NOT update(no error) 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 Create Custom Business Logic INOUT
oErrStringvarchar(255)No Create Custom Business Logic 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