SO_SalesOrderHistoryDetail SO Sales Order History Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesOrderHistoryInquiryDetail_bus SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHistoryDetail.M4T"
KPRIMARY: SalesOrderNo+SequenceNo KEXTENDEDDESC: ExtendedDescriptionKey+SalesOrderNo+SequenceNo KDISPLAY: SalesOrderNo+SequenceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Notes: {SO_04$(1,7)} 2 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL Notes: {SO_04$(8,10)} 3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {SO_04$(18,5)} 4 OriginalLine. . . . . . . . . 1 SYN Original Line . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(23,1)} 5 CancelledLine . . . . . . . . 1 SYN Cancelled Line. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(24,1)} 6 CancelReasonCode. . . . . . . 5 SYN Cancel Reason Code. . . . . . .CANCELREASONCODE Notes: {SO_04$(25,5)} 7 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {SO_04$(30,15)} 8 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item {SO_04$(50,1)} 9 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {SO_04$(58,30)} 10 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY Read Only:Y Notes: {SO_04$(45 ,5)} 11 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(51,1)} 12 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(52,1)} 13 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(53,1)} 14 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {SO_04$(54,3)} 15 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . Notes: {SO_04$(57,1)} 16 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(110,1)} 17 PrintDropShipment . . . . . . 1 SYN Print Drop Shipment . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(93,1)} 18 MasterOrderLineKey. . . . . . 6 SNN Master Order Line Key . . . . . Mask:000000 FmtType:ZEROFILL Notes: {SO_04$(94,5)} 19 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Notes: {SO_04$(106,4)} 20 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {SO_04$(112,5)} 21 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT Notes: {SO_04$(117,9)} 22 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT Notes: {SO_04$(126,9)} 23 PriceOverridden . . . . . . . 1 SYN Has Price Been Overridden . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(136,1)} 24 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(135,1)} 25 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(155,1)} 26 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 27 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(137,2)} 28 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(139,2)} 29 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(141,2)} 30 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(143,2)} 31 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(145,2)} 32 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(147,2)} 33 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(149,2)} 34 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(151,2)} 35 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {SO_04$(153,2)} 36 BackorderKitCompLine. . . . . 1 SYN Backorder Kit Component Line. .YESNO DfltVal:N Valid:Y,N Notes: Kit Bckord=0, Comp Bckord>0 Flg=Y {SO_04$(158,1)} 37 SkipPrintCompLine . . . . . . 1 SYN Skip Print Of Component Line. .YESNO DfltVal:N Valid:Y,N Notes: Component Line In S/O {SO_04$(159,1)} 38 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE Notes: {SO_04$(160,6)} 39 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . Notes: {SO_04$(166,30)} 40 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS Notes: {SO_04$(196,2)} 41 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:N,C,P,R Notes: N=None, C=Credit, P=rePlacement, R=Repair {SO_04$(198,1)} 42 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:N,S,P,R Notes: N=None, S=Stock, P=Scrap, R=Repair 43 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE Notes: {SO_04$(199,10)} 44 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE Notes: {SO_04$(209,6)} 45 ExpirationOverridden. . . . . 1 SYN Expiration Overridden . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_04$(215,1)} 46 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO DfltVal:N Valid:Y,N 47 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE FmtType:CHARNUM 48 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE 49 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT Notes: {SO_04$(51,100)} 50 QuantityOrderedOriginal . . . 16.6 NNN Quantity Ordered Original . . .QUANTITY Mask:##,###,###.000000- Notes: {SO_04[0]} 51 QuantityOrderedRevised. . . . 16.6 NNN Quantity Ordered Revised. . . .QUANTITY Mask:##,###,###.000000- Notes: {SO_04[1]} 52 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {SO_04[2]} 53 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- Notes: {SO_04[3]} 54 OriginalUnitPrice . . . . . . 16.6 NNN Original Unit Price . . . . . .PRICE Mask:##,###,###.000000- Notes: {SO_04[4]} 55 LastUnitPrice . . . . . . . . 16.6 NNN Last Unit Price . . . . . . . .PRICE Mask:##,###,###.000000- Notes: {SO_04[5]} 56 LastExtensionAmt. . . . . . . 12.2 NNN Last Extension Amount . . . . . Mask:##,###,###.00- Notes: {SO_04[6]} 57 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- Notes: {SO_04[7]} 58 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 Notes: {SO_04[8]} 59 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {SO_04[9]} 60 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:#,###.000- Notes: {SO_04$(99,7)} 61 LineWeight. . . . . . . . . . 12.2 NNN Miscellaneous Amount. . . . . .MISCAMOUNT Mask:##,###,###.00-