Key

CustomerKey

N/A

N/A

The customer key object that uniquely identifies the customer.

IsOnHold

boolean

N/A

False

The customer’s hold status. True indicates on hold. False indicates not on hold.

IsActive

boolean

N/A

True

Indicates whether the customer is active. True indicates active. False indicates inactive.

ShipCompleteOnly

boolean

N/A

False

Indicates whether the customer accepts partial shipments of Sales Order Processing documents. True indicates they accept only complete shipments. False indicates they accept partial shipments.

Name

string

64

Empty

The customer name.

Shortname

string

15

A shortened version of the value supplied for the Name property

A shortened version of the customer’s name.

StatementName

string

64

The same value supplied for the Name property

The customer’s name, as it should appear on statements.

ClassKey

CustomerClassKey

N/A

Empty

The customer class key object that specifies the customer class.

Priority

int

N/A

1

The priority assigned to the customer, used when allocating items for sales order documents. The value 1 indicates no priority has been assigned. The values 2 through 100 correspond to values 1 (highest priority) to 99 (lowest priority) in Dynamics GP.

DefaultAddressKey

CustomerAddressKey

N/A

N/A

The customer address key that specifies the primary address for the customer.

ShipToAddressKey

CustomerAddressKey

N/A

N/A

The customer address key that specifies the address to ship items to the customer.

BillToAddressKey

CustomerAddressKey

N/A

N/A

The customer address key that specifies the address to bill the customer.

StatementToAddressKey

CustomerAddressKey

N/A

N/A

The address key that specifies the address to send statements to the customer.

Comment1

string

30

Empty

Comment field 1.

Comment2

string

30

Empty

Comment field 2.

TradeDiscountPercent

Percent

N/A

0

A percent object that specifies the discount percentage to extend to the customer.

PaymentTermsKey

PaymentTermsKey

N/A

Empty

The payment terms key object that specifies the set of payment terms to use for the customer.

DiscountGracePeriod

int

N/A

0

The grace period (in days) for payment terms that use discounts.

DueDateGracePeriod

int

N/A

0

The grace period (in days) for payment terms that use due dates

PriceLevelKey

PriceLevelKey

N/A

Empty

The price level key object that specifies the price level used most often when selling to this customer.

Notes

string

8000

Empty

Text for the record-level note for the customer.

BalanceType

BalanceType

N/A

Open Item

The type of account the customer has.

FinanceCharge

MoneyPercentChoice

N/A

No finance charge

The type and amount of the finance charge for the customer. The finance chanrge can be a money amount or a percent.

MinimumPayment

MoneyPercentChoice

N/A

No minimum payment

The type and amount of the minimum payment for the customer. The minimum payment amount can be a money amount or a percent.

CreditLimit

CustomerCreditLimit

N/A

No credit

The customer credit limit object that specifies the credit limit.

MaximumWriteoff

MaximumWriteoff

N/A

Not allowed

Specifies whether writeoffs are allowed for the customer, and what the maximum amount of the writeoff can be.

AllowRevaluation

boolean

N/A

True

Specifies whether the customer is included in a sales revaluation. True specifies the customer will be included. False specifies the customer will not be included.

PostResultsTo

ReceivablesPostResultsTo

N/A

Receivables/Discount Account

Specifies where to post the sales revaluation results.

OrderFullfillment
ShortageDefault

OrderFullfillmentShortage

N/A

None - Shortages handled manually

Specifies how to handle a shortage when filling an order for the customer.

IncludeInDemand
Planning

boolean

N/A

True

Specifies whether the customer will be included in demand planning. True specifies the customer will be included. False specifies the customer will not.

PaymentCardAccount

PaymentCardAccount

N/A

Empty

The payment card account object that specifies the credit card used by the customer.

BankName

string

30

Empty

The name of the customer’s bank.

BankBranch

string

20

Empty

The name of the branch for the customer’s bank.

UserLanguageKey

LanguageKey

N/A

Empty

The language to use for this customer. Applies only if languages were set up using Language Maintenance in Microsoft Dynamics GP.

TaxExemptNumbers

ArrayOfString

25

Empty

The customer’s tax exemption numbers. The array can contain two elements.

TaxRegistrationNumber

string

25

Empty

The customer’s tax registration number.

CurrencyKey

CurrencyKey

N/A

Empty

The currency key object that specifies the ISO code of the currency typically used for the customer.

RateTypeKey

RateTypeKey

N/A

Empty

The rate type key object that specifies the rate type typically used for the customer.

StatementCycle

StatementCycle

N/A

Monthly

Specifies the statement cycle frequency for the customer.

HistoryOptions

HistoryOptions

N/A

Maintain history for all types

The history options object that specifies which types of history are maintained for the customer.

SendEmailStatements

boolean

N/A

False

Specifies whether statements can be sent to the customer through e-mail. True specifies e-mail can be used. False specifies it cannot. The StatementRecipients property specifies the e-mail address for the customer.

BankAccountKey

BankAccountKey

N/A

Empty

The bank account key object that specifies the ID of the bank account (checkbook) to use for cash transactions.

DefaultCashAccountType

ReceivablesCashAccountType

N/A

Checkbook

Specifies which Cash GL account to use for the customer's transactions. Customer specifies that the GL account in the CashGLAccount field will be used. Checkbook specifies the Cash GL account assigned to the BankAccount (checkbook) associated with the customer will be used.

CashGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which cash amounts for the customer will be posted.

AccountsReceivableGL
AccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which receivable amounts for the customer will be posted.

SalesGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which sale amounts for the customer will be posted.

CostOfGoodsSoldGL
AccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which cost of sales amounts for this customer will be posted.

InventoryGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which inventory amounts for this customer will be posted.

PaymentTermsDiscount
TakenGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which terms discounts taken amounts for this customer will be posted.

PaymentTermsDiscount
AvailableGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which terms discounts available amounts for this customer will be posted.

FinanceChargesGL
AccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which finance charge amounts for this customer will be posted.

WriteoffGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which written-off amounts for underpayments for this customer will be posted.

SalesOrderReturnsGL
AccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which sales order returns amounts for this customer will be posted.

OverpaymentWriteoff
GLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which writeoffs for overpayments from this customer will be posted.

StatementRecipients

EmailRecipients

N/A

N/A

An e-mail recipients object that specifies the e-mail addresses to which to send statements for the customer.

CreatedDate

dateTime

N/A

Current system date

The date the customer was created. This property is read-only.

ModifiedDate

dateTime

N/A

Current system date

The date the customer was modified. The value is in Coordinated Universal Time (UTC). This property is read-only.

LastModifiedDate

dateTime

N/A

Current system date

The date the customer was modified. The value is in Coordinated Universal Time (UTC). This property is read-only.

CorporateAccountKey

CustomerKey

N/A

Empty

If the customer is part of a corporate (national) account, the customer key that specifies the parent account. This property is read-only.

UserDefined1

string

50

Empty

A user-defined field.

UserDefined2

string

50

Empty

A user-defined field.

Addresses

ArrayOfCustomerAddress

N/A

Empty

An array containing the customer’s various addresses.