<taUpdateCreateCustomerRcd>*
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
CUSTNMBR |
string |
15 |
Y |
Not applicable |
Customer number |
HOLD |
i4 |
1 |
N |
Default from setup |
Hold status: 0=Not on hold; 1=On hold Default is zero on new record |
INACTIVE |
i4 |
1 |
N |
Default from setup |
Inactive: 0=Active; 1=Inactive Default is zero on new record |
CUSTNAME |
string |
64 |
N |
Default from setup |
Customer name |
SHRTNAME |
string |
15 |
N |
Default from setup |
Short name; if not passed in, default is CUSTNAME |
STMTNAME |
string |
64 |
N |
Default from setup |
Statement name; if not passed in, default is CUSTNAME |
CUSTCLAS |
string |
15 |
N |
Default from setup |
Customer class ID |
CUSTPRIORITY |
i4 |
2 |
N |
Default from setup |
Customer priority; valid input values 1 (none) to 100 Default is one on new record |
ADRSCODE |
string |
15 |
N |
Default from setup |
Primary address ID |
CNTCPRSN |
string |
60 |
N |
Default from setup |
Contact person |
ADDRESS1 |
string |
60 |
N |
Default from setup |
Customer address one |
ADDRESS2 |
string |
60 |
N |
Default from setup |
Customer address two |
ADDRESS3 |
string |
60 |
N |
Default from setup |
Customer address three |
CITY |
string |
35 |
N |
Default from setup |
City |
STATE |
string |
29 |
N |
Default from setup |
State |
ZIPCODE |
string |
10 |
N |
Default from setup |
Zip code |
CCode |
string |
6 |
N |
Default from setup |
Country code |
COUNTRY |
string |
60 |
N |
Default from setup |
Country |
PHNUMBR1 |
string |
21 |
N |
Default from setup |
Phone one |
PHNUMBR2 |
string |
21 |
N |
Default from setup |
Phone two |
PHNUMBR3 |
string |
21 |
N |
Default from setup |
Phone three |
FAX |
string |
21 |
N |
Default from setup |
Fax |
UPSZONE |
string |
3 |
N |
Default from setup |
UPS zone |
SHIPMTHD |
string |
15 |
N |
Default from setup |
Shipping method |
TAXSCHID |
string |
15 |
N |
Default from setup |
Tax schedule ID |
SHIPCOMPLETE |
i4 |
1 |
N |
Default from setup |
Ship complete documents: 0=False; 1=True Default is zero on new record |
PRSTADCD |
string |
15 |
N |
Default from setup |
Primary ship to address code |
PRBTADCD |
string |
15 |
N |
Default from setup |
Primary bill to address code |
STADDRCD |
string |
15 |
N |
Default from setup |
Statement to address code |
SLPRSNID |
string |
15 |
N |
Default from setup |
Salesperson ID |
SALSTERR |
string |
15 |
N |
Default from setup |
Sales territory |
USERDEF1 |
string |
20 |
N |
Default from setup |
User-defined one |
USERDEF2 |
string |
20 |
N |
Default from setup |
User-defined two |
COMMENT1 |
string |
30 |
N |
Default from setup |
Comment one |
COMMENT2 |
string |
30 |
N |
Default from setup |
Comment two |
CUSTDISC |
number |
21 |
N |
Default from setup |
Trade discount |
PYMTRMID |
string |
20 |
N |
Default from setup |
Payment terms ID |
DISGRPER |
i4 |
2 |
N |
Default from setup |
Discount grace period |
DUEGRPER |
i4 |
2 |
N |
Default from setup |
Due date grace period |
PRCLEVEL |
string |
10 |
N |
Default from setup |
Price level |
NOTETEXT |
string |
8000 |
N |
Default from setup |
Note text |
BALNCTYP |
i4 |
1 |
N |
Default from setup |
Balance type: 0=Open item; 1=Balance forward Default is zero on new record |
FNCHATYP |
i4 |
2 |
N |
Default from setup |
Finance charge type: 0=None; 1=Percent; 2=Amount Default is zero for new record |
FNCHPCNT |
number |
21 |
N |
Default from setup |
Finance charge percent; used if FNCHATYP=1 |
FINCHDLR |
number |
21 |
N |
Default from setup |
Finance charge dollar; used if FNCHATYP=2 |
MINPYTYP |
i4 |
2 |
N |
Default from setup |
Minimum payment type: 0=No minimum; 1=Percent; 2=Amount Default is zero for new record |
MINPYPCT |
number |
21 |
N |
Default from setup |
Minimum payment percent; used if MINPYTYP=1 |
MINPYDLR |
number |
21 |
N |
Default from setup |
Minimum payment dollar amount; used if MINPYTYP=2 |
CRLMTTYP |
i4 |
2 |
N |
Default from setup |
Credit limit type: 0=No credit; 1=Unlimited; 2=Amount Default is zero on new record |
CRLMTAMT |
number |
21 |
N |
Default from setup |
Credit limit amount; used if CRLMTTYP=2 |
CRLMTPER |
i4 |
2 |
N |
Default from setup |
Credit limit period; used if CRLMTTYP=2 and the credit limit warning is used in Microsoft Dynamics GP application |
CRLMTPAM |
number |
21 |
N |
Default from setup |
Credit limit period amount; used if CRLMTTYP=2 and the credit limit warning is used in Microsoft Dynamics GP application |
MXWOFTYP |
i4 |
2 |
N |
Default from setup |
Maximum write-off type: 0=Not allowed; 1=Unlimited; 2=Maximum Default is zero for new record |
MXWROFAM |
number |
21 |
N |
Default from setup |
Maximum write-off amount; used if MXWOFTYP=2 |
Revalue_Customer |
i4 |
1 |
N |
Default from setup |
Revalue customer: 0=Do not revalue; 1=Revalue Default is one for new record |
Post_Results_To |
i4 |
2 |
N |
Default from setup |
Post results to: 0=Receivables/Discount Account; 1=Sales offset Default is zero on new records |
ORDERFULFILLDEFAULT |
i4 |
1 |
N |
Default from setup |
Order fulfillment shortage: 1=None; 2=Back order remaining; 3=Cancel remaining Default is one on new record |
INCLUDEINDP |
i4 |
1 |
N |
Default from setup |
Include in demand planning: 0=Do not include; 1=Include Default is one on new record |
CRCARDID |
string |
15 |
N |
Default from setup |
Credit card ID |
CRCRDNUM |
string |
20 |
N |
Default from setup |
Credit card number |
CCRDXPDT |
datetime |
8 bytes (19 to 23 chars) |
N |
Default from setup |
Credit card expiration date |
BANKNAME |
string |
30 |
N |
Default from setup |
Bank name |
BNKBRNCH |
string |
20 |
N |
Default from setup |
Bank branch |
USERLANG |
i4 |
2 |
N |
Default from setup |
User language; default is zero on new record |
TAXEXMT1 |
string |
25 |
N |
Default from setup |
Tax exempt one |
TAXEXMT2 |
string |
25 |
N |
Default from setup |
Tax exempt two |
TXRGNNUM |
string |
25 |
N |
Default from setup |
Tax registration number |
CURNCYID |
string |
15 |
N |
Default from setup |
Currency ID |
RATETPID |
string |
15 |
N |
Default from setup |
Rate type ID |
STMTCYCL |
i4 |
2 |
N |
Default from setup |
Statement Cycle: 1=No Statement; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Bimonthly; 7=Quarterly |
KPCALHST |
i4 |
1 |
N |
Default from setup |
Maintain history--calendar year: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
KPERHIST |
i4 |
1 |
N |
Default from setup |
Maintain history--fiscal year: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
KPTRXHST |
i4 |
1 |
N |
Default from setup |
Maintain history--transaction: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
KPDSTHST |
i4 |
1 |
N |
Default from setup |
Maintain history--distribution: 0=Do not maintain history; 1=Maintain history Default is 1 on new record |
Send_Email_Statements |
i4 |
1 |
N |
Default from setup |
Send e-mail statements: 0=Do not sent statements; 1=Send statements Default is zero on new record |
ToEmail_Recipient |
string |
80 |
N |
Default from setup |
To email recipient; separate each recipient with a semicolon |
CcEmail_Recipient |
string |
80 |
N |
Default from setup |
Carbon copy email recipient; separate each recipient with a semicolon |
BccEmail_Recipient |
string |
80 |
N |
Default from setup |
Blind carbon copy email recipient; separate each recipient with a semicolon |
CHEKBKID |
string |
15 |
N |
Default from setup |
Checkbook ID |
DEFCACTY |
i4 |
2 |
N |
Default from setup |
Cash account from: 0=Checkbook; 1=Customer Default is zero on new record |
RMCSHACTNUMST |
string |
75 |
N |
Default from setup |
Cash account; only valid if DEFCACTY=1 |
RMARACTNUMST |
string |
75 |
N |
Default from setup |
Accounts receivable account |
RMSLSACTNUMST |
string |
75 |
N |
Default from setup |
Sales account |
RMCOSACTNUMST |
string |
75 |
N |
Default from setup |
Cost of sales account |
RMIVACTNUMST |
string |
75 |
N |
Default from setup |
Inventory account |
RMTAKACTNUMST |
string |
75 |
N |
Default from setup |
Terms discount taken account |
RMAVACTNUMST |
string |
75 |
N |
Default from setup |
Terms discount available account |
RMFCGACTNUMST |
string |
75 |
N |
Default from setup |
Finance charges account |
RMWRACTNUMST |
string |
75 |
N |
Default from setup |
Write-offs account |
RMSORACTNUMST |
string |
75 |
N |
Default from setup |
Sales order returns account |
RMOvrpymtWrtoffACTNUMST |
string |
75 |
N |
Default from setup |
Overpayment write-offs account |
GPSFOINTEGRATIONID |
string |
30 |
N |
<blank> |
Front office integration ID |
INTEGRATIONSOURCE |
i4 |
2 |
N |
0 |
Integration source |
INTEGRATIONID |
string |
30 |
N |
<blank> |
Integration ID |
UseCustomerClass |
i4 |
1 |
N |
0 |
Flag to have class setting roll down to elements not passed in; uses the CUSTCLAS class to roll down |
CreateAddress |
i4 |
1 |
N |
1 |
Flag to allow a primary address code to be created on the fly: 0=Do not create address code; 1=Create address code |
UpdateIfExists |
i4 |
1 |
N |
1 |
Flag to allow customer data to be updated if it exists: 0=Do not update; 1=Update if record exists; 2=Create if record does not exist and exits without error if record does exist |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, it populates the requester shadow table) |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
* The <taUpdateCreateCustomerRcd> node uses field level updates to provide update functionality.