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