Element Name | Description | Type | Length |
ARDivisionNo | AR Division Number | String | 2 |
CustomerNo | Customer Number | String | 20 |
CustomerName | Customer Name | String | 30 |
AddressLine1 | Address Line 1 | String | 30 |
AddressLine2 | Address Line 2 | String | 30 |
AddressLine3 | Address Line 3 | String | 30 |
City | City | String | 20 |
State | State | String | 2 |
ZipCode | Zip Code | String | 10 |
CountryCode | Country Code | String | 3 |
TelephoneNo | Telephone Number | String | 17 |
TelephoneExt | Telephone Extension | String | 5 |
FaxNo | Fax Number | String | 17 |
EmailAddress | Email Address | String | 250 |
URLAddress | URL Address | String | 50 |
EBMEnabled | eBusiness Manager Enabled | String | 1 |
EBMConsumerUserID | eBusiness Manager Consumer User ID | String | 15 |
BatchFax | Batch Fax | String | 1 |
DefaultCreditCardPmtType | Default Credit Card Payment Type | String | 5 |
ContactCode | Contact Code | String | 10 |
ShipMethod | Ship Method | String | 15 |
TaxSchedule | Tax Schedule | String | 9 |
TaxExemptNo | Tax Exempt Number | String | 15 |
TermsCode | Terms Code | String | 2 |
SalespersonDivisionNo | Salesperson Division Number | String | 2 |
SalespersonNo | Salesperson Number | String | 4 |
SalespersonDivisionNo2 | Salesperson Division Number 2 | String | 2 |
SalespersonNo2 | Salesperson Number 2 | String | 4 |
SalespersonDivisionNo3 | Salesperson Division Number 3 | String | 2 |
SalespersonNo3 | Salesperson Number 3 | String | 4 |
SalespersonDivisionNo4 | Salesperson Division Number 4 | String | 2 |
SalespersonNo4 | Salesperson Number 4 | String | 4 |
SalespersonDivisionNo5 | Salesperson Division Number 5 | String | 2 |
SalespersonNo5 | Salesperson Number 5 | String | 4 |
Comment | Customer Comment | String | 30 |
SortField | Sort Field | String | 10 |
TemporaryCustomer | Obsolete 5.00 | String | 1 |
CustomerStatus | Customer Status | String | 1 |
InactiveReasonCode | Inactive Reason Code | String | 5 |
OpenItemCustomer | Open Item Customer | String | 1 |
ResidentialAddress | Residential Address | String | 1 |
StatementCycle | Statement Cycle | String | 1 |
PrintDunningMessage | Print Dunning Message On Statement | String | 1 |
CustomerType | Customer Type | String | 4 |
PriceLevel | Price Level | String | 1 |
DateLastActivity | Date Of Last Activity | String | 8 |
DateLastPayment | Date Of Last Payment | String | 8 |
DateLastStatement | Date Of Last Statement | String | 8 |
DateLastFinanceChrg | Date Of Last Finance Charge | String | 8 |
DateLastAging | Date Of Last Aging | String | 8 |
DefaultItemCode | Default Item Code | String | 30 |
DefaultCostCode | Default Cost Code | String | 9 |
DefaultCostType | Default Cost Type | String | 1 |
CreditHold | Customer On Credit Hold | String | 1 |
PrimaryShipToCode | Primary Ship To Code | String | 4 |
DateEstablished | Date Established | String | 8 |
CreditCardGUID | Sage Exchange vault credit card identifier | String | 32 |
DefaultPaymentType | Default Payment Type | String | 5 |
EmailStatements | Obsolete 4.30 | String | 1 |
NumberOfInvToUseInCalc | Number Of Invoices To Use In Days Calc | Numeric | 2 |
AvgDaysPaymentInvoice | Avg Days For Payment From Invoice Date | Numeric | 3 |
AvgDaysOverDue | Avg Days Overdue (Pay Date - Due Date) | Numeric | 3 |
CustomerDiscountRate | Customer Discount Rate | Numeric | 13.3 |
ServiceChargeRate | Service Charge Rate | Numeric | 13.3 |
CreditLimit | Credit Limit | Numeric | 14.2 |
LastPaymentAmt | Last Payment Amount | Numeric | 14.2 |
HighestStmntBalance | Highest Statement Balance | Numeric | 14.2 |
UnpaidServiceChrg | Unpaid Service Charge | Numeric | 14.2 |
BalanceForward | Balance Forward | Numeric | 14.2 |
CurrentBalance | Current Balance | Numeric | 14.2 |
AgingCategory1 | Aging Category 1 | Numeric | 14.2 |
AgingCategory2 | Aging Category 2 | Numeric | 14.2 |
AgingCategory3 | Aging Category 3 | Numeric | 14.2 |
AgingCategory4 | Aging Category 4 | Numeric | 14.2 |
OpenOrderAmt | Open Order Amount | Numeric | 14.2 |
RetentionCurrent | Retention Current | Numeric | 14.2 |
RetentionAging1 | Retention Aging 1 | Numeric | 14.2 |
RetentionAging2 | Retention Aging 2 | Numeric | 14.2 |
RetentionAging3 | Retention Aging 3 | Numeric | 14.2 |
RetentionAging4 | Retention Aging 4 | Numeric | 14.2 |
SplitCommRate2 | Split Commission Rate 2 | Numeric | 9.3 |
SplitCommRate3 | Split Commission Rate 3 | Numeric | 9.3 |
SplitCommRate4 | Split Commission Rate 4 | Numeric | 9.3 |
SplitCommRate5 | Split Commission Rate 5 | Numeric | 9.3 |
DateCreated | Creation Date | String | 8 |
TimeCreated | Creation Time | String | 8 |
UserCreatedKey | Creation User ID | String | 10 |
DateUpdated | Last Update Date | String | 8 |
TimeUpdated | Last Update Time | String | 8 |
UserUpdatedKey | Last Update User ID | String | 10 |