Sage Data Exchange Sales Order Table [Documentation]

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