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

taCreateCustomerClass

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
CLASSIDchar(15)Yes Class ID IN
CLASDSCRchar(30)No Class Description IN
CRLMTTYPsmallintNo Credit Limit Type - 0 = No Credit, 1 = Unlimited, & 2 = Amount IN
CRLMTAMTnumeric(19,5)No Credit Amount IN
CRLMTPERsmallintNo Credit Limit Period IN
CRLMTPAMnumeric(19,5)No Credit Limit Period Amount IN
DEFLTCLStinyintNo Default Class IN
BALNCTYPsmallintNo Balance Type - 0 = Open Item & 1 = Balance Forward IN
CHEKBKIDchar(15)No Checkbook ID IN
TAXSCHIDchar(15)No Tax Schedule ID IN
SHIPMTHDchar(15)No Shipping Method IN
PYMTRMIDchar(20)No Payment Term ID IN
CUSTDISCsmallintNo Customer Disc/Trade Discount IN
MINPYTYPsmallintNo Minimum Payment Type - 0 = No Minimum, 1 = Percent, & 2 = Amount IN
MINPYDLRnumeric(19,5)No Minimum Payment Dollar IN
MINPYPCTsmallintNo Minimum Payment Percent IN
MXWOFTYPsmallintNo Maximum Write Off Type - 0 = Not Allowed, 1 = Unlimited, & 2 = Maximum IN
MXWROFAMnumeric(19,5)No Maximum Write Off Amount IN
FNCHATYPsmallintNo Finance Charge Amount Type - 0 = None, 1 = Percent, & 2 = Amount IN
FINCHDLRnumeric(19,5)No Finance Charge Dollar IN
FNCHPCNTsmallintNo Finance Charge Percent IN
PRCLEVELchar(10)No Price Level IN
CURNCYIDchar(15)No Currency ID IN
RATETPIDchar(15)No Rate ID IN
DEFCACTYsmallintNo Cash Accont From 0 = Checkbook & 1 = Customer IN
CASHACCTchar(75)No Cash Account IN
ACCTRECACCTchar(75)No Accounts Receivable Account IN
SALESACCTchar(75)No Sales Account IN
COSTOFSALESACCTchar(75)No Cost of Sales Account IN
IVACCTchar(75)No Inventory Account IN
TERMDISCTAKENACCTchar(75)No Terms Disc. Taken Account IN
TERMDISCAVAILACCTchar(75)No Terms Disc. Avail. Account IN
FINCHRGACCTchar(75)No Finance Charges Account IN
WRITEOFFACCTchar(75)No Write Off Account IN
SALESORDERRETACCTchar(75)No Sales Order Returns Account IN
SALSTERRchar(15)No Sales Territory IN
SLPRSNIDchar(15)No Sales Person ID IN
STMTCYCLsmallintNo Statement Cycle - 1 = No Statement, 2 = Weekly, 3 = Biweekly, IN
KPCALHSTtinyintNo Keep Calendar History - 0 = False & 1 = True IN
KPDSTHSTtinyintNo Keep Distribution History - 0 = False & 1 = True IN
KPERHISTtinyintNo Keep Period History - 0 = False & 1 = True IN
KPTRXHSTtinyintNo Keep Transaction History - 0 = False & 1 = True IN
DISGRPERsmallintNo Discount Date Grace Period IN
DUEGRPERsmallintNo Due Date Grace Period IN
Revalue_CustomertinyintNo Revalue Customer - 0 = False & 1 = True IN
Post_Results_TosmallintNo Post Results To - 0 =Receivables/Discount Acct & 1 =Sales Offset Acct IN
ORDERFULFILLDEFAULTtinyintNo Order Fulfillment Shortage Default 1=none, 2=Back Order Remaining, 3=Cancel Remaining IN
CUSTPRIORITYsmallintNo Customer Priority - valid values 1 (none) to 100 IN
RMOvrpymtWrtoffAcctchar(75)No RM Overpayment Writeoff Acct IN
RequesterTrxsmallintNo Requester Trx 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