     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-