Sage Data Exchange AR Customer Table [Documentation]

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