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-