Documentation - enhancements:sage100:modules:sde:api:tables

Sage Data Exchange AP Division Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T18:51:07+00:00

Sage Data Exchange AP Division Table

Element Name	Description	Type	Length
APDivisionNo	AP Division Number	String	2
APDivisionDesc	AP Division Description	String	30
AccountsPayableAcctKey	Accounts Payable Account Key	String	9
DiscountsEarnedOrTakenAcctKey	Discounts Earned Or Taken Account Key	String	9
CashAcctKey	Cash Account Key	String	9
DiscountsLostAcctKey	Discounts Lost Account Key	String	9
RetentionPayableAcctKey	Retention Payable Account Key	String	9
FreightAcctKey	Freight Account Key	String	9
SalesTaxAcctKey	Sales Tax Account Key	String	9
NonRecoverableTaxAcctKey	Non-Recoverable Tax Account Key	String	9
UseTaxAcctKey	Use Tax Account Key	String	9
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
TimeUpdated	Last Update Time	String	8
UserUpdatedKey	Last Update User ID	String	10

Sage Data Exchange AP Terms Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T18:52:15+00:00

Sage Data Exchange AP Terms Code Table

Element Name	Description	Type	Length
TermsCode	Terms Code	String	2
TermsCodeDesc	Terms Code Description	String	30
DaysBeforeDue	Days Before Due	Numeric	3
DueDateADayOfTheMonth	Day Of The Month Due Date	String	1
MinimumDaysAllowedInv	Minimum Days Allowed Before Invoice Due	Numeric	3
DaysDiscountAllowed	Days Discount Allowed	Numeric	3
DiscountDateADayOfTheMo	Day Of The Month Discount Date	String	1
MinimumDaysAllowedDisc	Minimum Days Allowed Before Discount Due	Numeric	3
DiscountRate	Discount Rate	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

Sage Data Exchange AP Vendor Contact Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T19:10:17+00:00

Sage Data Exchange AP Vendor Contact Table

Element Name	Description	Type	Length
APDivisionNo	AP Division Number	String	2
VendorNo	Vendor Number	String	7
ContactCode	Contact Code	String	10
ContactName	Contact Name	String	30
AddressLine1	Contact Address Line 1	String	30
AddressLine2	Contact Address Line 2	String	30
AddressLine3	Contact Address Line 3	String	30
City	Contact City	String	20
State	Contact State	String	2
ZipCode	Contact Zip Code	String	10
CountryCode	Contact Country Code	String	3
Salutation	Contact Salutation	String	10
ContactTitle	Contact Title	String	15
TelephoneNo1	Contact Telephone Number 1	String	17
TelephoneExt1	Contact Telephone Extension 1	String	5
TelephoneNo2	Contact Telephone Number 2	String	17
TelephoneExt2	Contact Telephone Extension 2	String	5
FaxNo	Fax Number	String	17
EmailAddress	Contact Email Address	String	50
ContactNotes	Contact Notes	String	256
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

Sage Data Exchange AP Vendor Primary Contact Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T18:53:45+00:00

Sage Data Exchange AP Vendor Primary Contact Table

Element Name	Description	Type	Length
APDivisionNo	AP Division Number	String	2
VendorNo	Vendor Number	String	7
ContactCode	Contact Code	String	10
ContactName	Contact Name	String	30
AddressLine1	Contact Address Line 1	String	30
AddressLine2	Contact Address Line 2	String	30
AddressLine3	Contact Address Line 3	String	30
City	Contact City	String	20
State	Contact State	String	2
ZipCode	Contact Zip Code	String	10
CountryCode	Contact Country Code	String	3
Salutation	Contact Salutation	String	10
ContactTitle	Contact Title	String	15
TelephoneNo1	Contact Telephone Number 1	String	17
TelephoneExt1	Contact Telephone Extension 1	String	5
TelephoneNo2	Contact Telephone Number 2	String	17
TelephoneExt2	Contact Telephone Extension 2	String	5
FaxNo	Fax Number	String	17
EmailAddress	Contact Email Address	String	50
ContactNotes	Contact Notes	String	256
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

Sage Data Exchange AP Vendor Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T18:49:59+00:00

Sage Data Exchange AP Vendor Table

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

Sage Data Exchange AR BillTo SoldTo Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:28:23+00:00

Sage Data Exchange AR BillTo SoldTo Table

Element Name	Description	Type	Length
SoldToDivisionNo	Sold To Division Number	String	2
SoldToCustomerNo	Sold To Customer Number	String	20
BillToDivisionNo	Bill To Division Number	String	2
BillToCustomerNo	Bill To Customer Number	String	20
CreditHold	Credit Hold	String	1
CreditLimit	Credit Limit	String	1
DefaultAddress	Default Address	String	1
CustomerPricing	Customer Pricing	String	1
TermsCode	Terms Code	String	1
UserCreatedKey	User Created Key	String	10
DateCreated	Date Created	String	8
TimeCreated	Time Created	String	8
UserUpdatedKey	User Updated Key	String	10
DateUpdated	Date Updated	String	8
TimeUpdated	Time Updated	String	8

Sage Data Exchange AR Customer Contact Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T17:03:15+00:00

Sage Data Exchange AR Customer Contact Table

Element Name	Description	Type	Length
ARDivisionNo	AR Division Number	String	2
CustomerNo	Customer Number	String	20
ContactCode	Contact Code	String	10
ContactName	Contact Name	String	30
AddressLine1	Contact Address Line 1	String	30
AddressLine2	Contact Address Line 2	String	30
AddressLine3	Contact Address Line 3	String	30
City	Contact City	String	20
State	Contact State	String	2
ZipCode	Contact Zip Code	String	10
CountryCode	Contact Country Code	String	3
Salutation	Contact Salutation	String	10
ContactTitle	Contact Title	String	15
TelephoneNo1	Contact Telephone Number 1	String	17
TelephoneExt1	Contact Telephone Extension 1	String	5
TelephoneNo2	Contact Telephone Number 2	String	17
TelephoneExt2	Contact Telephone Extension 2	String	5
FaxNo	Fax Number	String	17
EmailAddress	Contact Email Address	String	50
ContactNotes	Contact Notes	String	256
EBMUserID	eBusiness Manager User ID	String	15
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

Sage Data Exchange AR Customer Credit Card Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:25:23+00:00

Sage Data Exchange AR Customer Credit Card Table

Element Name	Description	Type	Length
ARDivisionNo	AR Division Number	String	2
CustomerNo	Customer Number	String	20
CreditCardGUID	Sage Exchange vault credit card identifier	String	32
PaymentType	Payment Type	String	5
CreditCardID	Credit Card ID	String	10
ExpirationDateYear	Expiration Date Year	String	4
ExpirationDateMonth	Expiration Date Month	String	2
CardType	Card Type	String	1
BankAccountType	Bank Account Type	String	1
CorporateCustIDPurchOrder	Corporate Customer ID / Purchase Order	String	17
CardholderName	Cardholder Name	String	30
BankName	Bank Name	String	30
AVSAddressLine1	AVS Address Line 1	String	30
AVSAddressLine2	AVS Address Line 2	String	30
AVSCity	AVS City	String	20
AVSState	AVS State	String	2
AVSCountryCode	AVS Country Code	String	3
EmailAddress	Credit Card Email Address	String	250
AVSZipCode	AVS Zip Code	String	10
CreditCardComment	Credit Card Comment	String	30
EBMEnabled	eBusiness Manager Enabled	String	1
Last4UnencryptedCreditCardNos	Last 4 Unencrypted Credit Card Numbers	String	4
Last4BankRoutingNos	Last 4 Bank Routing Numbers	String	4
Last4BankAccountNos	Last 4 Bank Account Numbers	String	4
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

Sage Data Exchange AR Customer Primary Contact Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:09:59+00:00

Sage Data Exchange AR Customer Primary Contact Table

Element Name	Description	Type	Length
ARDivisionNo	AR Division Number	String	2
CustomerNo	Customer Number	String	20
ContactCode	Contact Code	String	10
ContactName	Contact Name	String	30
AddressLine1	Contact Address Line 1	String	30
AddressLine2	Contact Address Line 2	String	30
AddressLine3	Contact Address Line 3	String	30
City	Contact City	String	20
State	Contact State	String	2
ZipCode	Contact Zip Code	String	10
CountryCode	Contact Country Code	String	3
Salutation	Contact Salutation	String	10
ContactTitle	Contact Title	String	15
TelephoneNo1	Contact Telephone Number 1	String	17
TelephoneExt1	Contact Telephone Extension 1	String	5
TelephoneNo2	Contact Telephone Number 2	String	17
TelephoneExt2	Contact Telephone Extension 2	String	5
FaxNo	Fax Number	String	17
EmailAddress	Contact Email Address	String	50
ContactNotes	Contact Notes	String	256
EBMUserID	eBusiness Manager User ID	String	15
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

Sage Data Exchange AR Customer Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T21:42:40+00:00

Sage Data Exchange AR Customer Table

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

Sage Data Exchange AR Division Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T21:57:24+00:00

Sage Data Exchange AR Division Table

Element Name	Description	Type	Length
TermsCode	AR Terms Code	String	2
TermsCodeDesc	Terms Code Description	String	30
DueDateADayOfTheMonth	Due Date a Day of The Month	String	1
DiscountDateADayOfTheMo	Discount Date a Day of The Month	String	1
DiscountCalculationMethod	Discount Calculation Method	String	1
DaysBeforeDue	Days Before Due	Numeric	3
MinimumDaysAllowedInv	Minimum Days Allowed Before Invoice is Due	Numeric	3
DaysBeforeDiscountDue	Days Before Discount Due	Numeric	3
MinimumDaysAllowedDisc	Minimum Days Allowed Before Discount Due	Numeric	3
DiscountRate	Discount Rate	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

Sage Data Exchange AR Payment Type Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:23:26+00:00

Sage Data Exchange AR Payment Type Table

Element Name	Description	Type	Length
PaymentType	Payment Type	String	5
PaymentDesc	Payment Description	String	30
PaymentMethod	Payment Method	String	1
AssetAcctKey	Asset Account Key	String	9
CreditCardAccrualAcctKey	Credit Card Accrual Account Key	String	9
DefaultTransaction	DefaultTransaction	String	1
EBMInternetEnabled	eBusiness Manager Internet Enabled	String	1
CreditCardSetupTested	Credit Card Setup Tested	String	1
MerchantID	Merchant ID	String	32
DisplayAVSCVVResponse	Display AVS and CVV Response	String	1
AllowCorporateCards	Allow Corporate Cards	String	1
VirtualTerminalID	Virtual Terminal ID	String	13
MerchantKey	Merchant Key	String	13
DiscountPercentage	Discount Percentage Rate	Numeric	8.3
PerTransactionFee	Per Transaction Fee Amount	Numeric	10.2
PreAuthorizationTerm	Days Authorizations Are Valid	Numeric	5
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

Sage Data Exchange AR Salesperson Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:12:51+00:00

Sage Data Exchange AR Salesperson Table

Element Name	Description	Type	Length
SalespersonDivisionNo	Salesperson Division Number	String	2
SalespersonNo	Salesperson Number	String	4
SalespersonName	Salesperson 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 Ext	String	5
EmailAddress	Email Address	String	50
SalesManagerDivisionNo	Sales Manager AR Division Number	String	2
SalesManagerNo	Sales Manager Number	String	4
CRMUserID	CRM User ID	String	11
UserKey	User Key	String	10
CommissionRate	Salesperson Commission Rate	Numeric	9.3
SalesManagerCommRate	Sales Manager Commission Rate	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

Sage Data Exchange AR Terms Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:03:10+00:00

Sage Data Exchange AR Terms Code Table

Element Name	Description	Type	Length
TermsCode	AR Terms Code	String	2
TermsCodeDesc	Terms Code Description	String	30
DueDateADayOfTheMonth	Due Date a Day of The Month	String	1
DiscountDateADayOfTheMo	Discount Date a Day of The Month	String	1
DiscountCalculationMethod	Discount Calculation Method	String	1
DaysBeforeDue	Days Before Due	Numeric	3
MinimumDaysAllowedInv	Minimum Days Allowed Before Invoice is Due	Numeric	3
DaysBeforeDiscountDue	Days Before Discount Due	Numeric	3
MinimumDaysAllowedDisc	Minimum Days Allowed Before Discount Due	Numeric	3
DiscountRate	Discount Rate	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

[tables|Sage Data Exchange API Tables]

Anonymous (anonymous@undisclosed.example.com) — 2018-07-26T13:29:15+00:00

[tables|Sage Data Exchange API Tables]

Sage Data Exchange

Table List
Table	Description
user	Sage Data Exchange User table

Sage 100

Table List
Table	Description
AR Customer	Sage 100 Customer table

Sage Data Exchange Category Detail Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:38:35+00:00

Sage Data Exchange Category Detail Table

Element Name	Description	Type	Length
categoryRID	Category Reference ID	String	8
sequence	Sequence	String	3
itemCode	Item Code	String	30
itemDescription	Item Description	String	30

Sage Data Exchange Category Tree Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:53:32+00:00

Sage Data Exchange Category Tree Table

Element Name	Description	Type	Length
categoryTree	Category Tree	String	32
categoryTreeRID	Category Tree Reference ID	String	8
categoryTreeDescription	Category Tree Description	String	64
defaultCategoryTree	Default Category Tree	Numeric	1

Sage Data Exchange Category Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T19:34:20+00:00

Sage Data Exchange Category Table

Element Name	Description	Type	Length
category	Category	String	64
categoryRID	Category Reference ID	String	8
categoryDescription	Category Description	String	64
categoryImage	Category Image	String	64
categoryShortDescription	Category Short Description	String	2048
categoryLongDescription	Category Long Description	String	4096
mainNavigation	Main Navigation	Numeric	1
categoryEnabled	Category Enabled	Numeric	1
parentCategory	Parent Category	String	64

Sage Data Exchange CI Extended Description Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T19:36:53+00:00

Sage Data Exchange CI Extended Description Table

Element Name	Description	Type	Length
ExtendedDescriptionKey	Extended Description Key	String	10
ExtendedDescriptionText	Extended Description Text	String	4096
CreationModuleCode	Creation Module Code	String	3
UpdatedModuleCode	Updated Module Code	String	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

Sage Data Exchange CI Inactive Reason Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:35:49+00:00

Sage Data Exchange CI Inactive Reason Code Table

Element Name	Description	Type	Length
InactiveReasonCode	Inactive Reason Code	String	5
InactiveReasonCodeDesc	Inactive Reason Code Description	String	30
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

Sage Data Exchange CI Item Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T19:35:42+00:00

Sage Data Exchange CI Item Table

Element Name	Description	Type	Length
ItemCode	Item Code	String	30
ItemType	Item Type	String	1
ItemCodeDesc	Item Code Description	String	30
ExtendedDescriptionKey	Extended Description Key	String	10
UseInAR	Use In AR	String	1
UseInSO	Use In SO	String	1
UseInPO	Use In PO	String	1
UseInBM	Use In BM	String	1
CalculateCommission	Calculate Commission	String	1
DropShip	Drop Ship	String	1
EBMEnabled	eBusiness Manager Enabled	String	1
AllowBackOrders	Allow Back Orders	String	1
AllowReturns	Allow Returns	String	1
PriceCode	Price Code	String	4
AllowTradeDiscount	Allow Trade Discount	String	1
PrintReceiptLabels	Print Receipt Labels	String	1
AllocateLandedCost	Allocate Landed Cost	String	1
InactiveItem	Inactive Item	String	1
ConfirmCostIncrInRcptOfGoods	Confirm Cost Increase in Receipt Of Goods	String	1
WarrantyCode	Warranty Code	String	10
SalesUnitOfMeasure	Sales Unit of Measure	String	4
PurchaseUnitOfMeasure	Purchase Unit of Measure	String	4
StandardUnitOfMeasure	Standard Unit of Measure	String	4
PostToGLByDivision	Post to G/L By Division	String	1
SalesAcctKey	Sales Account Key	String	9
CostOfGoodsSoldAcctKey	Cost Of Goods Sold Account Key	String	9
InventoryAcctKey	Inventory Account Key	String	9
PurchaseAcctKey	Purchase Account Key	String	9
ManufacturingCostAcctKey	Manufacturing Cost Account Key	String	9
TaxClass	Tax Class	String	2
PurchasesTaxClass	Purchases Tax Class	String	2
ProductLine	Product Line	String	4
ProductType	Product Type	String	1
Valuation	Valuation	String	1
DefaultWarehouseCode	Default Warehouse Code	String	3
PrimaryAPDivisionNo	Primary AP Division Number	String	2
PrimaryVendorNo	Primary Vendor Number	String	7
ImageFile	Image File	String	30
LastSoldDate	Last Sold Date	String	8
LastReceiptDate	Last Receipt Date	String	8
Category1	Category 1	String	10
Category2	Category 2	String	10
Category3	Category 3	String	10
Category4	Category 4	String	10
SalesPromotionCode	Sales Promotion Code	String	10
SaleStartingDate	Sale Starting Date	String	8
SaleEndingDate	Sale Ending Date	String	8
SaleMethod	Sale Method	String	1
ExplodeKitItems	Explode Kit Items	String	1
ShipWeight	Ship Weight	String	10
CommentText	Comment Text	String	2048
RestockingMethod	Restocking Method	String	1
NextLotSerialNo	Next Lot/Serial Number	String	15
InventoryCycle	Inventory Cycle	String	1
RoutingNo	Routing Number	String	20
ProcurementType	Procurement Type	String	1
PlannerCode	Planner Code	String	3
BuyerCode	Buyer Code	String	3
LowLevelCode	Low Level Code	String	2
PlannedByMRP	Planned By Mrp	String	1
VendorItemCode	Vendor Item Code	String	30
SetupCharge	Setup Charge	String	1
AttachmentFileName	Attachment File Name	String	30
ItemImageWidthInPixels	Item Image Width In Pixels	Numeric	4
ItemImageHeightInPixels	Item Image Height In Pixels	Numeric	4
StandardUnitCost	Standard Unit Cost	Numeric	16.6
StandardUnitPrice	Standard Unit Price	Numeric	16.6
LastTotalUnitCost	Last Total Unit Cost	Numeric	16.6
AverageUnitCost	Average Unit Cost	Numeric	16.6
SalesPromotionPrice	Sales Promotion Price	Numeric	16.6
SuggestedRetailPrice	Suggested Retail Price	Numeric	16.6
SalesPromotionDiscountPercent	Sales Promotion Discount Percentage	Numeric	12.3
TotalQuantityOnHand	Total Quantity On Hand	Numeric	16.6
AverageBackOrderFillDays	Average Back Order Fill Days	Numeric	5
LastAllocatedUnitCost	Last Allocated Unit Cost	Numeric	16.6
CommissionRate	Commission Rate	Numeric	9.3
BaseCommAmt	Base Commission Amount	Numeric	12.2
PurchaseUMConvFctr	Purchase Unit of Measure Conversion Factor	Numeric	12.4
SalesUMConvFctr	Sales Unit of Measure Conversion Factor	Numeric	12.4
Volume	Volume	Numeric	11.4
RestockingCharge	Restocking Charge	Numeric	11.3
TotalInventoryValue	Total Inventory Value	Numeric	15.2
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

Sage Data Exchange GL Account Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T18:56:52+00:00

Sage Data Exchange GL Account Table

Element Name	Description	Type	Length
AccountKey	Account Number	String	9
AccountDesc	Account Description	String	50
Account	Fully Formatted Account Number	String	41
RawAccount	Unformatted Account Number	String	32
MainAccountCode	Main Account	String	15
DateStart	Start Date	String	8
DateEnd	End Date	String	8
Status	Status	String	1
ClearBalance	Clear Balance	String	1
AccountType	Account Type	String	2
CashFlowsType	Cash Flows Type	String	1
RollupCode1	Rollup Code 1	String	20
RollupCode2	Rollup Code 2	String	20
RollupCode3	Rollup Code 3	String	20
RollupCode4	Rollup Code 4	String	20
AccountGroup	Account Group	String	15
AccountCategory	Account Category	String	1
CompanyCode	Company Code	String	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

Sage Data Exchange IM Buyer Planner Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:06:56+00:00

Sage Data Exchange IM Buyer Planner Code Table

Element Name	Description	Type	Length
BuyerPlannerCode	Buyer Planner Code	String	3
LastName	Last Name	String	30
FirstName	First Name	String	20
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

Sage Data Exchange IM Item Vendor Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:08:48+00:00

Sage Data Exchange IM Item Vendor Table

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
TimeUpdated	Last Update Time	String	8
UserUpdatedKey	Last Update User ID	String	10

Sage Data Exchange IM Price Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:05:41+00:00

Sage Data Exchange IM Price Code Table

Element Name	Description	Type	Length
PriceCodeRecord	Price Code Record	String	1
PriceCode	Price Code	String	4
ItemCode	Item Code	String	30
CustomerPriceLevel	Customer Price Level	String	1
ARDivisionNo	AR Division Number	String	2
CustomerNo	Customer Number	String	20
PriceCodeDesc	Price Code Description	String	25
PricingMethod	Pricing Method	String	1
BreakQuantity1	Break Quantity 1	Numeric	8
BreakQuantity2	Break Quantity 2	Numeric	8
BreakQuantity3	Break Quantity 3	Numeric	8
BreakQuantity4	Break Quantity 4	Numeric	8
BreakQuantity5	Break Quantity 5	Numeric	8
DiscountMarkup1	Discount Markup 1	Numeric	16.6
DiscountMarkup2	Discount Markup 2	Numeric	16.6
DiscountMarkup3	Discount Markup 3	Numeric	16.6
DiscountMarkup4	Discount Markup 4	Numeric	16.6
DiscountMarkup5	Discount Markup 5	Numeric	16.6
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

Sage Data Exchange IM Product Line Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:04:24+00:00

Sage Data Exchange IM Product Line Table

Element Name	Description	Type	Length
ProductLine	Product Line	String	4
ProductLineDesc	Product Line Description	String	25
ProductType	Product Type	String	1
Valuation	Valuation	String	1
PriceCode	Price Code	String	4
AllowBackOrders	Allow Back Orders	String	1
ExplodeKitItems	Explode Kit Items	String	1
CalculateCommission	Calculate Commission	String	1
StandardUnitOfMeasure	Standard Unit Of Measure	String	4
PurchaseUnitOfMeasure	Purchase Unit Of Measure	String	4
SalesUnitOfMeasure	Sales Unit Of Measure	String	4
ProcurementType	Procurement Type	String	1
InventoryCycle	Inventory Cycle	String	1
AllowTradeDiscount	Allow Trade Discount	String	1
InactiveItem	Inactive Item	String	1
AllocateLandedCost	Allocate Landed Cost	String	1
TaxClass	Tax Class	String	2
PurchasesTaxClass	PurchasesTax Class	String	2
PrintReceiptLabels	Print Receipt Labels	String	1
ConfirmCostIncrInRcptOfGoods	Confirm Cost Increase In Receipt Of Goods	String	1
PostInventoryByWhse	Post Inventory By Warehouse	String	1
PostCostOfGoodsSoldByWhse	Post Cost Of Goods Sold By Warehouse	String	1
PostSalesIncomeByWhse	Post Sales/Income By Warehouse	String	1
PostReturnsByWhse	Post Returns By Warehouse	String	1
PostAdjustmentByWhse	Post Adjustment By Warehouse	String	1
PostPurchaseByWhse	Post Purchases By Warehouse	String	1
PostPOVarianceByWhse	Post Po Variance By Warehouse	String	1
PostMFGVarianceByWhse	Post Manufacturing Variance By Warehouse	String	1
InventoryAcctKey	Inventory Account Key	String	9
CostOfGoodsSoldAcctKey	Cost Of Goods Sold Account Key	String	9
SalesIncomeAcctKey	Sales Income Account Key	String	9
ReturnsAcctKey	Returns Account Key	String	9
AdjustmentAcctKey	Adjustment Account Key	String	9
PurchaseAcctKey	Purchase Account Key	String	9
PurchaseOrderVarianceAcctKey	Purchase Order Variance Account Key	String	9
ManufacturingVarianceAcctKey	Manufacturing Variance Account Key	String	9
WarrantyCode	Warranty Code	String	10
AllowReturns	Allow Returns	String	1
RestockingMethod	Restocking Method	String	1
ScrapAcctKey	Scrap Account Key	String	9
RepairsInProcessAcctKey	Repairs In Process Account Key	String	9
RepairsClearingAcctKey	Repairs Clearing Account Key	String	9
PostScrapByWhse	Post Scrap by Warehouse	String	1
PostRepairsInProcessByWhse	Post Repairs In Process by Warehouse	String	1
PostRepairsClearingByWhse	Post Repairs Clearing by Warehouse	String	1
CommissionRate	Commission Rate	Numeric	9.3
BaseCommAmt	Base Commission Amount	Numeric	12.2
PurchaseUMConvFctr	Purchase Unit Of Measure Conversion Factor	Numeric	12.4
SalesUMConvFctr	Sales Unit Of Measure Conversion Factor	Numeric	12.4
RestockingCharge	Restocking Charge	Numeric	11.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

Sage Data Exchange IM Sales Promotion Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:07:58+00:00

Sage Data Exchange IM Sales Promotion Table

Element Name	Description	Type	Length
SalesPromotionCode	Sales Promotion Code	String	10
SaleStartingDate	Sale Starting Date	String	8
SaleEndingDate	Sale Ending Date	String	8
SaleMethod	Sale Method	String	1
SalePrice	Sale Price	Numeric	16.6
DiscountPercentage	Discount Percentage	Numeric	11.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

Sage Data Exchange IM Warehouse Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T19:37:48+00:00

Sage Data Exchange IM Warehouse Table

Element Name	Description	Type	Length
WarehouseCode	Warehouse Code	String	3
WarehouseDesc	Warehouse Description	String	30
WarehouseName	Warehouse Name	String	30
WarehouseAddress1	Warehouse Address Line 1	String	30
WarehouseAddress2	Warehouse Address Line 2	String	30
WarehouseAddress3	Warehouse Address Line 3	String	30
WarehouseCity	Warehouse City	String	20
WarehouseState	Warehouse State	String	2
WarehouseZipCode	Warehouse Zip Code	String	10
WarehouseCountryCode	Warehouse Country Code	String	3
TelephoneNo	Telephone Number	String	17
TelephoneExt	Telephone Extension	String	5
FaxNo	Fax Number	String	17
EmailAddress	Email Address	String	50
ContactName	Contact Name	String	30
PostToGLSubAcct	Post To G/L Sub Account	String	15
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

Sage Data Exchange IM Warranty Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T20:03:27+00:00

Sage Data Exchange IM Warranty Code Table

Element Name	Description	Type	Length
WarrantyCode	Warranty Code	String	10
WarrantyCodeDesc	Warranty Code Description	String	30
WarrantyDays	Warranty Days	Numeric	4
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

Sage Data Exchange PO Vendor Primary Purchase Address Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T18:55:31+00:00

Sage Data Exchange PO Vendor Primary Purchase Address Table

Element Name	Description	Type	Length
APDivisionNo	AP Division Number	String	2
VendorNo	Vendor Number	String	7
PurchaseAddressCode	Purchase Address Code	String	4
PurchaseName	Purchase Name	String	30
PurchaseAddress1	Purchase Address 1	String	30
PurchaseAddress2	Purchase Address 2	String	30
PurchaseAddress3	Purchase Address 3	String	30
PurchaseCity	Purchase City	String	20
PurchaseState	Purchase State	String	2
PurchaseZipCode	Purchase Zip Code	String	10
PurchaseCountryCode	Purchase Country Code	String	3
BatchFax	Batch Fax	String	1
TelephoneNo	Telephone Number	String	17
TelephoneExt	Telephone Extension	String	5
FaxNo	Fax Number	String	17
ContactCode	Contact Code	String	10
TaxSchedule	Tax Schedule	String	9
ExemptionNoOnFile	Exemption Number On File	String	1
EmailAddress	Email Address	String	50
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

Sage Data Exchange Sales Order Detail Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-07T14:54:26+00:00

Sage Data Exchange Sales Order Detail Table

Element Name	Description	Type	Length
SalesOrderNo	Sales Order Number	String	7
LineKey	Line Key	String	6
LineSeqNo	Line Sequence Number	String	14
ItemCode	Item Code	String	30
ItemType	ItemType	String	1
ItemCodeDesc	Item Code Description	String	30
ExtendedDescriptionKey	Extended Description Key	String	10
Discount	Discount	String	1
Commissionable	Commissionable	String	1
SubjectToExemption	Subject To Exemption	String	1
WarehouseCode	Warehouse Code	String	3
Valuation	Valuation	String	1
PriceLevel	Price Level	String	1
MasterOrderLineKey	Master Order Line Key	String	6
UnitOfMeasure	Unit Of Measure	String	4
DropShip	Drop Ship	String	1
LotSerialFullyDistributed	Lot/Serial Fully Distributed	String	1
PrintDropShipment	Print Drop Shipment	String	1
SalesKitLineKey	Sales Kit Line Key	String	6
CostOfGoodsSoldAcctKey	Cost of Goods Sold Account Key	String	9
SalesAcctKey	Sales Account Key	String	9
PriceOverridden	Has Price Been Overridden	String	1
ExplodedKitItem	Exploded Kit Item	String	1
StandardKitBill	Standard/Kit Bill	String	1
Revision	Bill Revision Code	String	3
BillOption1	Bill Option 1	String	2
BillOption2	Bill Option 2	String	2
BillOption3	Bill Option 3	String	2
BillOption4	Bill Option 4	String	2
BillOption5	Bill Option 5	String	2
BillOption6	Bill Option 6	String	2
BillOption7	Bill Option 7	String	2
BillOption8	Bill Option 8	String	2
BillOption9	Bill Option 9	String	2
BackorderKitCompLine	Backorder Kit Component Line	String	1
SkipPrintCompLine	Skip Printing Of This Component	String	1
PromiseDate	Promise Date	String	8
AliasItemNo	Alias Item Number	String	30
SOHistoryDetlSeqNo	Sales Order History Detail Sequence Number	String	14
TaxClass	Tax Class	String	2
CustomerAction	Customer Action	String	1
ItemAction	Item Action	String	1
WarrantyCode	Warranty Code	String	10
ExpirationDate	Expiration Date	String	8
ExpirationOverridden	Expiration Overridden	String	1
CostOverridden	Cost Overridden	String	1
CostCode	Cost Code	String	9
CostType	Cost Type	String	1
CommentText	Comment Text	String	2048
APDivisionNo	AP Division Number	String	2
VendorNo	Vendor Number	String	7
PurchaseOrderNo	Purchase Order Number	String	7
PurchaseOrderRequiredDate	Purchase Order Required Date	String	8
QuantityOrdered	Quantity Ordered	Numeric	16.6
QuantityShipped	Quantity Shipped	Numeric	16.6
QuantityBackordered	Quantity Backordered	Numeric	16.6
MasterOriginalQty	Master Original Quantity	Numeric	16.6
MasterQtyBalance	Master Quantity Balance	Numeric	16.6
MasterQtyOrderedToDate	Master Quantity Ordered To Date	Numeric	16.6
RepeatingQtyShippedToDate	Repeating Quantity Shipped To Date	Numeric	16.6
UnitPrice	Unit Price	Numeric	16.6
UnitCost	Unit Cost	Numeric	16.6
ExtensionAmt	Extension Amount	Numeric	12.2
UnitOfMeasureConvFactor	Unit Of Measure Conversion Factor	Numeric	12.4
QuantityPerBill	Quantity Per Bill	Numeric	16.6
LineDiscountPercent	Line Discount Percent	Numeric	9.3
LineWeight	Line Weight	Numeric	12.2

Sage Data Exchange Sales Order Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-07T14:53:17+00:00

Sage Data Exchange Sales Order Table

Element Name	Description	Type	Length
SalesOrderNo	Sales Order Number	String	7
OrderDate	Order Date	String	8
OrderType	Order Type	String	1
OrderStatus	Order Status	String	1
MasterRepeatingOrderNo	Master Repeating Order Number	String	7
ShipExpireDate	Ship Expire Date	String	8
ARDivisionNo	AR Division Number	String	2
CustomerNo	Customer Number	String	20
BillToDivisionNo	Bill To Division Number	String	2
BillToCustomerNo	Bill To Customer Number	String	20
BillToName	Bill To Name	String	30
BillToAddress1	Bill To Address Line 1	String	30
BillToAddress2	Bill To Address Line 2	String	30
BillToAddress3	Bill To Address Line 3	String	30
BillToCity	Bill To City	String	20
BillToState	Bill To State	String	2
BillToZipCode	Bill To Zip Code	String	10
BillToCountryCode	Bill To Country Code	String	3
ShipToCode	Ship-To Code	String	4
ShipToName	Ship To Name	String	30
ShipToAddress1	Ship To Address Line 1	String	30
ShipToAddress2	Ship To Address Line 2	String	30
ShipToAddress3	Ship To Address Line 3	String	30
ShipToCity	Ship To City	String	20
ShipToState	Ship To State	String	2
ShipToZipCode	Ship To Zip Code	String	10
ShipToCountryCode	Ship To Country Code	String	3
ShipVia	Ship Via	String	15
ShipZone	Ship Zone	String	5
ShipZoneActual	Ship Zone Actual	String	5
ShipWeight	Ship Weight	String	5
CustomerPONo	Customer PO Number	String	15
FOB	F.O.B.	String	15
WarehouseCode	Warehouse Code	String	3
ConfirmTo	Confirm To	String	30
Comment	Comment	String	30
TermsCode	Terms Code	String	2
TaxSchedule	Tax Schedule	String	9
TaxExemptNo	Tax Exempt Number	String	15
InvalidTaxCalc	Invalid Tax Calculation	String	1
PrintSalesOrders	Print Sales Orders	String	1
SalesOrderPrinted	Sales Order Printed	String	1
PrintPickingSheets	Print Picking Sheets	String	1
PickingSheetPrinted	Picking Sheet Printed	String	1
LastInvoiceOrderDate	Last Invoice Order Date	String	8
LastInvoiceOrderNo	Last Invoice Order Number	String	7
CurrentInvoiceNo	Current Invoice Number	String	7
CheckNoForDeposit	Check Number For Deposit	String	10
CycleCode	Cycle Code	String	2
FaxNo	Fax Number	String	17
BatchFax	Batch Fax	String	1
BatchEmail	Batch Email	String	1
EmailAddress	Email Address	String	250
FreightCalculationMethod	Freight Calculation Method	String	1
LotSerialLinesExist	Lot/Serial Lines Exist	String	1
SalespersonDivisionNo	Salesperson Division Number	String	2
SalespersonNo	Salesperson Number	String	4
SplitCommissions	Split Commissions	String	1
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
EBMUserType	EBM Internet User Type	String	1
EBMSubmissionType	EBM Internet Submission Type	String	1
EBMUserIDSubmittingThisOrder	EBM Internet User ID Submittting This Order	String	15
PaymentType	Payment Type	String	5
OtherPaymentTypeRefNo	Other Payment Type Reference Number	String	24
PaymentTypeCategory	Payment Type Category	String	1
CancelReasonCode	Cancellation Reason Code	String	5
RMANo	RMA Number	String	7
JobNo	Job Number	String	7
ResidentialAddress	Residential Address	String	1
CRMUserID	CRM User ID	String	11
CRMPersonID	CRM Person ID	String	11
CRMOpportunityID	CRM Opportunity ID	String	11
CRMCompanyID	CRM Company ID	String	11
CRMProspectID	CRM Prospect ID	String	11
TaxableSubjectToDiscount	Taxable Subject To Discount	Numeric	13.2
NonTaxableSubjectToDiscount	Non-Taxable Subject To Discount	Numeric	13.2
TaxSubjToDiscPrcntOfTotSubjTo	Tax-Subj-To-Disc % Of Total-Subj-To-Disc	Numeric	7.2
DiscountRate	Discount Rate	Numeric	8.3
DiscountAmt	Discount Amount	Numeric	12.2
TaxableAmt	Taxable Amount	Numeric	13.2
NonTaxableAmt	Non-Taxable Amount	Numeric	13.2
SalesTaxAmt	Sales Tax Amount	Numeric	12.2
Weight	Weight	Numeric	12.2
FreightAmt	Freight Amount	Numeric	12.2
DepositAmt	Deposit Amount	Numeric	13.2
CommissionRate	Commission Rate	Numeric	9.3
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
NumberOfShippingLabels	Number Of Shipping Labels	Numeric	2
LastNoOfShippingLabels	Last Number Of Shipping Labels	Numeric	2
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

Sage Data Exchange AR Customer Primary Ship To Address Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:33:38+00:00

Sage Data Exchange AR Customer Primary Ship To Address Table

Element Name	Description	Type	Length
ARDivisionNo	AR Division Number	String	2
CustomerNo	Customer Number	String	20
ShipToCode	Ship-To Code	String	4
ShipToName	Ship To Name	String	30
ShipToAddress1	Ship To Address Line 1	String	30
ShipToAddress2	Ship To Address Line 2	String	30
ShipToAddress3	Ship To Address Line 3	String	30
ShipToCity	Ship To City	String	20
ShipToState	Ship To State	String	2
ShipToZipCode	Ship To Zip Code	String	10
ShipToCountryCode	Ship To Country Code	String	3
TelephoneNo	Telephone Number	String	17
TelephoneExt	Telephone Extension	String	5
FaxNo	Fax Number	String	17
BatchFax	Batch Fax	String	1
BatchEmail	Batch Email	String	1
EmailAddress	Email Address	String	50
ContactCode	Contact Code	String	10
SalespersonDivisionNo	Salesperson Division Number	String	2
SalespersonNo	Salesperson Number	String	4
WarehouseCode	Warehouse Code	String	3
TaxSchedule	Tax Schedule	String	9
ResidentialAddress	Residential Address	String	1
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

Sage Data Exchange AR Shipping Rate Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:32:10+00:00

Sage Data Exchange AR Shipping Rate Table

Element Name	Description	Type	Length
ShippingCode	Shipping Code	String	15
ShippingCodeDesc	Shipping Code Description	String	30
FreightCalculationMethod	Freight Calculation Method	String	1
UseShipZone	Use Ship Zone	String	1
UseZipCodeAsShipZone	Use Zip Code As Ship Zone	String	1
UsePriorRangeOfZipCodes	Use Prior Range of Zip Codes	String	1
WeightCalculation	Weight Calculation	String	1
LineType	Line Type	String	1
EBMEnabled	eBusiness Manager Enabled	String	1
BaseAmt	Base Amount	Numeric	12.2
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

Sage Data Exchange SY Country Code Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:48:21+00:00

Sage Data Exchange SY Country Code Table

Element Name	Description	Type	Length
CountryCode	Country Code	String	3
CountryName	Country Name	String	30
PhoneCode	Phone Area Code	String	3

Sage Data Exchange SY Sales Tax Schedule Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:38:55+00:00

Sage Data Exchange SY Sales Tax Schedule Table

Element Name	Description	Type	Length
TaxSchedule	Tax Schedule	String	9
TaxScheduleDesc	Tax Schedule Description	String	30
PrintTaxCodeOnForms	Print Tax Code On Forms	String	1

Sage Data Exchange SY Sales Tax Class Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:47:18+00:00

Sage Data Exchange SY Sales Tax Class Table

Element Name	Description	Type	Length
TaxClass	Tax Class	String	2
TaxClassDesc	Tax Class Description	String	30
TaxClassType	Tax Class Type	String	1

Sage Data Exchange SY ZipCode Table

Anonymous (anonymous@undisclosed.example.com) — 2018-12-05T22:49:20+00:00

Sage Data Exchange SY ZipCode Table

Element Name	Description	Type	Length
ZipCode	Zip Code	String	10
City	City	String	20
StateCode	State Code	String	2
CountryCode	Country Code	String	3

Sage Data Exchange User Table

Anonymous (anonymous@undisclosed.example.com) — 2018-07-26T12:55:17+00:00

Sage Data Exchange User Table

Element Name	Description	Type	Length
user	User	String	32
userRID	User Reference ID	String	8
userName	User Name	String	64
emailAddress	Email Address	String	128
password	Password	String	32
userType	User Type	String	1
status	Status	String	1
ARDivisionNo	AR Division Number	String	2
customerNo	Customer Number	String	20
customerContactCode	Customer Contact Code	String	10
APDivisionNo	AP Division Number	String	2
vendorNo	Vendor Number	String	7
vendorContactCode	Vendor Contact Code	String	10