===== Sage Data Exchange AR Customer Table =====
<datatables paging="false" searching="false" ordering="false" info="false">
^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|
</datatables>