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

16

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