===== Sage Data Exchange AP Vendor Table =====
<datatables paging="false" searching="false" ordering="false" info="false">
^Element Name^Description^Type^Length^
|APDivisionNo|AP Division Number|String|2|
|VendorNo|Vendor Number|String|7|
|VendorName|Vendor 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|
|PrimaryContact|Primary Contact Code|String|10|
|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|
|TermsCode|Terms Code|String|2|
|Reference|Vendor Reference Number|String|15|
|TemporaryVendor|Obsolete 5.00|String|1|
|VendorStatus|Vendor Status|String|1|
|InactiveReasonCode|Inactive Reason Code|String|5|
|CreditCardVendor|Credit Card Vendor|String|1|
|HoldPayment|Hold Payment|String|1|
|ElectronicPayment|Electronic Payment Vendor|String|1|
|StandardEntryClass|Standard Entry Class Code|String|3|
|ExemptionNoOnFile|Exemption Number On File|String|1|
|TaxSchedule|Tax Schedule|String|9|
|TaxClass|Tax Class|String|2|
|AccountKey|Account Key|String|9|
|SeparateCheck|Separate Check|String|1|
|Comment|Vendor Comment|String|30|
|Sort|Sort Field|String|10|
|BatchFax|Batch Fax|String|1|
|UsePOReceiptOfInvForVendor|Use PO Receipt Of Inv For Vendor|String|1|
|PrimaryPurchaseAddressCode|Purchase Address Code|String|4|
|VendorType|Vendor Type|String|1|
|Form1099|Default 1099 Form|String|1|
|TaxpayerIDSocialSecurityNo|Taxpayer ID/Social Security Number|String|9|
|Box1099|Default 1099 Box|String|3|
|MiscBox9|Mark Misc Box 9|String|1|
|LastPurchaseDate|Last Purchase Date|String|8|
|LastPaymentDate|Last Payment Date|String|8|
|LastCheckNo|Last AP Check Number|String|10|
|LastCheckAmt|Last Check Amount|Numeric|15.2|
|RetentionRate|Retention Rate|Numeric|7.2|
|AverageDaysToPay|Average Days To Pay|Numeric|3|
|AverageDaysOverDue|Average Days Over Due|Numeric|3|
|BalanceDue|Balance Due|Numeric|16.2|
|NumberOfInvToUseInCalc|Number Of Invoices To Use In Calculation|Numeric|7|
|DateCreated|Creation Date|String|8|
|TimeCreated|Creation Time|String|8|
|UserCreatedKey|Creation User ID|String|10|
|DateUpdated|Last Update Date|String|8|
</datatables>