SO_SalesOrderDetail                    SO Sales Order Detail          Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: SO_SalesOrderDetail_bus,SO_SalesJournal_upd,IT_ShoppingCartMirror: SO_SalesOrderHistoryDetail
 SQL Def: N  SysDB: N                                   "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderDetail.M4T"

 KPRIMARY: SalesOrderNo+LineKey
 KDISPLAY: SalesOrderNo+LineSeqNo+LineKey
 KEXTENDEDDESC: ExtendedDescriptionKey+SalesOrderNo+LineKey
 KITEMTYPE: ItemType+ItemCode+SalesOrderNo+LineKey
 KITEMWHSE: ItemCode+WarehouseCode+SalesOrderNo+LineKey

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SalesOrderNo. . . . . . . . .     7 SYY  Sales Order Number. . . . . . .SALESORDERNO
                                                Read Only:Y FmtType:CHARNUM
   2  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
                                                Read Only:Y Mask:000000
                                                FmtType:ZEROFILL
   3  LineSeqNo . . . . . . . . . .    14 SNY  Line Sequence Number. . . . . .
                                                Read Only:Y Mask:000000000000
                                                00 FmtType:ZEROFILL
   4  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                ChngTag:Replace0
   5  ItemType. . . . . . . . . . .     1 SYY  ItemType. . . . . . . . . . . .
                                                Valid:1,2,3,4,5 Notes:
                                                1=Regular Item, 2=Special
                                                Item, 3=Charge Item,
                                                4=Comment Item, 5=Miscellaneo
                                                us Item
   6  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                ValGroup:ItemRequired,
                                                NotComment
   7  ExtendedDescriptionKey. . . .    10 SYN  Extended Description Key. . . .EXTDESCKEY
                                                Read Only:Y ValGroup:NotComme
                                                nt,ItemRequired,ItemTypes
   8  Discount. . . . . . . . . . .     1 SYN  Discount. . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment,
                                                NotComponent
   9  Commissionable. . . . . . . .     1 SYN  Commissionable. . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:SalespersonReporting
                                                ,NotComment,NotComponent
  10  SubjectToExemption. . . . . .     1 SYN  Subject To Exemption. . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ARSalesTax,
                                                NotComment
  11  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                FmtType:CHARNUM ValGroup:IMIn
                                                tegrated,ItemRequired,
                                                NotComment,MultiWarehouse,
                                                RegularItem,NotNulWarehouseCo
                                                de
  12  PriceLevel. . . . . . . . . .     1 SYN  Price Level . . . . . . . . . .
                                                DepVal:REQUIRED ValGroup:IMIn
                                                tegrated,ItemRequired,
                                                RegularItem,NotComponent
  13  MasterOrderLineKey. . . . . .     6 SNN  Master Order Line Key . . . . .
                                                Mask:000000 FmtType:ZEROFILL
  14  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                ValGroup:ItemRequired,
                                                ItemTypes
  15  DropShip. . . . . . . . . . .     1 SYN  Drop Ship . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ItemTypes
  16  PrintDropShipment . . . . . .     1 SYN  Print Drop Shipment . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment
  17  SalesKitLineKey . . . . . . .     6 SNN  Sales Kit Line Key. . . . . . .
                                                Mask:000000 FmtType:ZEROFILL
  18  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost of Goods Sold Account Key.ACCOUNT
                                                DepVal:REQUIRED ValGroup:Item
                                                Required,ItemTypes
  19  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .ACCOUNT
                                                DepVal:REQUIRED ValGroup:NotC
                                                omment,ItemRequired
  20  PriceOverridden . . . . . . .     1 SYN  Has Price Been Overridden . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment
  21  ExplodedKitItem . . . . . . .     1 SYN  Exploded Kit Item . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment
  22  StandardKitBill . . . . . . .     1 SYN  Standard/Kit Bill . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment
  23  Revision. . . . . . . . . . .     3 SNN  Bill Revision Code. . . . . . .
  24  BillOption1 . . . . . . . . .     2 SYN  Bill Option 1 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  25  BillOption2 . . . . . . . . .     2 SYN  Bill Option 2 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  26  BillOption3 . . . . . . . . .     2 SYN  Bill Option 3 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  27  BillOption4 . . . . . . . . .     2 SYN  Bill Option 4 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  28  BillOption5 . . . . . . . . .     2 SYN  Bill Option 5 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  29  BillOption6 . . . . . . . . .     2 SYN  Bill Option 6 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  30  BillOption7 . . . . . . . . .     2 SYN  Bill Option 7 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  31  BillOption8 . . . . . . . . .     2 SYN  Bill Option 8 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  32  BillOption9 . . . . . . . . .     2 SYN  Bill Option 9 . . . . . . . . .BILLOPTION
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:BMIntegrated,
                                                BillHasOptions,ItemRequired,
                                                RegularItem
  33  BackorderKitCompLine. . . . .     1 SYN  Backorder Kit Component Line. .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment Notes:
                                                Kit Bckord=0, Comp Bckord>0
                                                Flg=Y
  34  SkipPrintCompLine . . . . . .     1 SYN  Skip Printing Of This ComponentYESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                Line In S/O
  35  PromiseDate . . . . . . . . .     8 SNN  Promise Date. . . . . . . . . .DATE
                                                ValGroup:ItemRequired,
                                                NotComment
  36  AliasItemNo . . . . . . . . .    30 SYN  Alias Item Number . . . . . . .
                                                ValGroup:ItemRequired,
                                                RegularItem
  37  SOHistoryDetlSeqNo. . . . . .    14 SNN  Sales Order History Detail Sequ
                                                Mask:00000000000000
                                                FmtType:ZEROFILL
  38  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                ValGroup:ARSalesTax,
                                                NotComment
  39  CustomerAction. . . . . . . .     1 SYN  Customer Action . . . . . . . .
                                                DfltVal:N Valid:N,C,P,R
                                                ValGroup:NotComment Notes:
                                                N=None, C=Credit, P=rePlaceme
                                                nt, R=Repair
  40  ItemAction. . . . . . . . . .     1 SYN  Item Action . . . . . . . . . .
                                                DfltVal:N Valid:N,S,P,R
                                                ValGroup:NotComment Notes:
                                                N=None, S=Stock, P=scraP,
                                                R=Repair
  41  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
                                                DepVal:REQUIRED ValGroup:Item
                                                Required,RegularItem,
                                                WarrantyTracking
  42  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
                                                ValGroup:ItemRequired,
                                                RegularItem,WarrantyTracking
  43  ExpirationOverridden. . . . .     1 SYN  Expiration Overridden . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment
  44  CostOverridden. . . . . . . .     1 SYN  Cost Overridden . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:NotComment
  45  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:PostJCCosts,
                                                NotComment
  46  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                DepVal:REQUIRED ValGroup:Post
                                                JCCosts,NotComment
  47  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
  48  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  49  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                NotMasterRepeating,ItemRequir
                                                ed,ItemTypes
  50  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                NotMasterRepeating,ItemRequir
                                                ed,ItemTypes,NotQuote
  51  MasterOriginalQty . . . . . . 16.6  NNN  Master Original Quantity. . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:MasterOrder,
                                                ItemRequired,ItemTypes
  52  MasterQtyBalance. . . . . . . 16.6  NNN  Master Quantity Balance . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:MasterOrder,
                                                NotComment
  53  MasterQtyOrderedToDate. . . . 16.6  NNN  Master Quantity Ordered To DateQUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:MasterOrder,
                                                NotComment
  54  RepeatingQtyShippedToDate . . 16.6  NNN  Repeating Quantity Shipped To DQUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:RepeatingOrder
  55  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  56  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  57  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                Mask:##,###,###.00-
                                                ValGroup:NotComment,
                                                ItemRequired
  58  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                Mask:#####0.0000 ValGroup:Not
                                                Comment
  59  QuantityPerBill . . . . . . . 16.6  NNN  Quantity Per Bill . . . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:BMIntegrated,
                                                NotComment
  60  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percent . . . . .
                                                Mask:#,##0.000- ValGroup:Line
                                                Discount,ItemRequired,
                                                ItemTypes
  61  LineWeight. . . . . . . . . . 12.2  NNN  Line Weight . . . . . . . . . .MISCAMOUNT
                                                Read Only:Y Mask:##,###,
                                                ###.00-