===== 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|