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

taUpdateCreateCustomerRcd

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
CUSTNMBRchar(15)Yes Customer Number IN
HOLDtinyintNo Hold Status: 0=Not On Hold; 1=On Hold; Default=0 on new record IN
INACTIVEtinyintNo Inactive: 0=Active; 1=Inactive; Default=0 on new record IN
CUSTNAMEchar(64)No Customer Name IN
SHRTNAMEchar(15)No Short Name; Default=@I_vCUSTNAME if not passed in IN
STMTNAMEchar(64)No Statement Name; Default=@I_vCUSTNAME if not passed in IN
CUSTCLASchar(15)No Class ID IN
CUSTPRIORITYsmallintNo Priority; valid values 1 (none) to 100; Default=1 on new record IN
ADRSCODEchar(15)No Primary Address ID IN
CNTCPRSNchar(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 IN
CCodechar(6)No Country Code IN
COUNTRYchar(60)No Country IN
PHNUMBR1char(21)No Phone 1 IN
PHNUMBR2char(21)No Phone 2 IN
PHNUMBR3char(21)No Phone 3 IN
FAXchar(21)No Fax IN
UPSZONEchar(3)No UPS Zone IN
SHIPMTHDchar(15)No Shipping Method IN
TAXSCHIDchar(15)No Tax Schedule IN
SHIPCOMPLETEtinyintNo Ship Complete Documents: 0=False; 1=True; Default=0 on new record IN
PRSTADCDchar(15)No Ship To Address Code IN
PRBTADCDchar(15)No Bill To Address Code IN
STADDRCDchar(15)No Statement To Address Code IN
SLPRSNIDchar(15)No Salesperson ID IN
SALSTERRchar(15)No Sales Territory IN
USERDEF1char(20)No User-Defined 1 IN
USERDEF2char(20)No User-Defined 2 IN
COMMENT1char(30)No Comment 1 IN
COMMENT2char(30)No Comment 2 IN
CUSTDISCnumeric(19,5)No Trade Discount IN
PYMTRMIDchar(20)No Payment Terms IN
DISGRPERsmallintNo Discount Grace Period IN
DUEGRPERsmallintNo Due Date Grace Period IN
PRCLEVELchar(10)No Price Level IN
NOTETEXTvarchar(8000)No Note Text IN
BALNCTYPtinyintNo Balance Type: 0=Open Item 1=Balance Forward; Default=0 on new record IN
FNCHATYPsmallintNo Finance Charge Type: 0=None; 1=Percent; 2=Amount; Default=0 for new record IN
FNCHPCNTnumeric(19,5)No Finance Charge Percent: Used if @I_vFNCHATYP=1 IN
FINCHDLRnumeric(19,5)No Finance Charge Dollar: Used if @I_vFNCHATYP=2 IN
MINPYTYPsmallintNo Minimum Payment Type: 0=No Minimum; 1=Percent; 2=Amount; Default=0 for new record IN
MINPYPCTnumeric(19,5)No Minimum Payment Percent: Used if @I_vMINPYTYP=1 IN
MINPYDLRnumeric(19,5)No Minimum Payment Dollar Amount: Used if @I_vMINPYTYP=2 IN
CRLMTTYPsmallintNo Credit Limit Type: 0=No Credit; 1=Unlimited; 2=Amount; Default=0 on new record IN
CRLMTAMTnumeric(19,5)No Credit Limit Amount: Used if @I_vCRLMTTYP=2 IN
CRLMTPERsmallintNo Credit Limit Period: Used if @I_vCRLMTTYP=2 and the Credit Limit Warning in GP is used IN
CRLMTPAMnumeric(19,5)No Credit Limit Period Amount: Used if @I_vCRLMTTYP=2 and Credit Limit Warning in GP is used IN
MXWOFTYPsmallintNo Maximum Writeoff Type: 0=Not Allowed; 1=Unlimited; 2=Maximum; Default=0 for new record IN
MXWROFAMnumeric(19,5)No Maximum Writeoff Amount: Used if @I_vMXWOFTYP=2 IN
Revalue_CustomertinyintNo Revalue Customer: 0=Do Not Revalue; 1=Revalue; Default=1 for new record IN
Post_Results_TosmallintNo Post Results To: 0=Rec./Discount Acct; 1=Sales Offset Acct; Default=0 on new record IN
ORDERFULFILLDEFAULTtinyintNo Order Fulfillment Shortage: 1=None; 2=Back Order Remaining; 3=Cancel Remaining; Default=1 on new record IN
INCLUDEINDPtinyintNo Include In Demand Planning: 0=Do Not Include; 1=Include; Default=1 on new record IN
CRCARDIDchar(15)No Credit Card ID IN
CRCRDNUMchar(20)No Credit Card Number IN
CCRDXPDTdatetimeNo Credit Card Expiration Date IN
BANKNAMEchar(30)No Bank Name IN
BNKBRNCHchar(20)No Bank Branch IN
USERLANGsmallintNo User Language; Default=0 on new record IN
TAXEXMT1char(25)No Tax Exempt 1 IN
TAXEXMT2char(25)No Tax Exempt 2 IN
TXRGNNUMchar(25)No Tax Registration IN
CURNCYIDchar(15)No Currency ID IN
RATETPIDchar(15)No Rate Type ID IN
STMTCYCLsmallintNo Statement Cycle: 1=No Statement; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Bimonthly; 7=Quarterly IN
KPCALHSTtinyintNo Maintain History - Calendar Year: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record IN
KPERHISTtinyintNo Maintain History - Fiscal Year: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record IN
KPTRXHSTtinyintNo Maintain History - Transaction: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record IN
KPDSTHSTtinyintNo Maintain History - Distribution: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record IN
Send_Email_StatementstinyintNo Send E-mail Statements: 0=Do Not Send Statements; 1=Send Statements; Default=0 on new record IN
ToEmail_Recipientchar(80)No To... E-mail Recipient: Separate each recipient with a ";" IN
CcEmail_Recipientchar(80)No Cc... E-mail Recipient: Separate each recipient with a ";" IN
BccEmail_Recipientchar(80)No Bcc... E-mail Recipient: Separate each recipient with a ";" IN
CHEKBKIDchar(15)No Check Book ID IN
DEFCACTYsmallintNo Cash Account From: 0=Checkbook; 1=Customer; Default=0 on new record IN
RMCSHACTNUMSTvarchar(75)No Cash Account: Only valid if @I_vDEFCACTY=1 IN
RMARACTNUMSTvarchar(75)No Accounts Receivable Account IN
RMSLSACTNUMSTvarchar(75)No Sales Account IN
RMCOSACTNUMSTvarchar(75)No Cost Of Sales Account IN
RMIVACTNUMSTvarchar(75)No Inventory Account IN
RMTAKACTNUMSTvarchar(75)No Terms Discount Taken Account IN
RMAVACTNUMSTvarchar(75)No Terms Discount Available Account IN
RMFCGACTNUMSTvarchar(75)No Finance Charges Account IN
RMWRACTNUMSTvarchar(75)No Writeoffs Account IN
RMSORACTNUMSTvarchar(75)No Sales Order Returns Account IN
RMOvrpymtWrtoffACTNUMSTvarchar(75)No Overpayment Writeoffs Account IN
GPSFOINTEGRATIONIDchar(30)No Front Office Integration ID IN
INTEGRATIONSOURCEsmallintNo Integration Source IN
INTEGRATIONIDchar(30)No Integration ID IN
UseCustomerClasstinyintNo Flag to have class setting roll down to parameters that are not passed in. Uses the @I_vCUSTCLAS class IN
CreateAddresstinyintNo Flag to allow a primary address code to be created on the fly: 0=Do not create address; 1=create address 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
site