     SO_InvoiceDetail                       SO Invoice Detail              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_InvoiceDetail_bus,RA_GenerateTransactions_upd,BC_CommonImport
     SQL Def: N  SysDB: N                                      "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceDetail.M4T"

     KPRIMARY: InvoiceNo+LineKey
     KDISPLAY: InvoiceNo+LineSeqNo+LineKey
     KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+LineKey
     KITEM: ItemCode+InvoiceNo+LineKey
     KITEMWHSE: ItemCode+WarehouseCode+InvoiceNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    Read Only:Y FmtType:MASTERNUM
       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
       5  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    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:NotComment,
                                                    ItemRequired
       7  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y ValGroup:NotComme
                                                    nt,ItemRequired
       8  Discount. . . . . . . . . . .     1 SYN  Discount. . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment,
                                                    ItemRequired,NotComponent
       9  Commissionable. . . . . . . .     1 SYN  Commissionable. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment,
                                                    SalespersonReporting,
                                                    NotComponent
      10  SubjectToExemption. . . . . .     1 SYN  Subject To Exemption. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      11  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:IMIntegrated,
                                                    NotComment,MultiWarehouse,
                                                    ItemRequired,RegularItem,
                                                    NotNulWarehouseCode
      12  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    FmtType:CHARNUM ValGroup:NotC
                                                    omment
      13  Valuation . . . . . . . . . .     1 SYN  Valuation . . . . . . . . . . .
                                                    Valid:1,2,3,4,5,6 ValGroup:No
                                                    tComment Notes: 1=Standard,
                                                    2=Average, 3=Fifo, 4=Lifo,
                                                    5=Lot, 6=Serial
      14  PriceLevel. . . . . . . . . .     1 SYN  Price Level . . . . . . . . . .
                                                    DepVal:REQUIRED ValGroup:IMIn
                                                    tegrated,NotComment,
                                                    ItemRequired,RegularItem,
                                                    NotComponent
      15  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      16  DropShip. . . . . . . . . . .     1 SYN  Drop Ship . . . . . . . . . . .YESNO
                                                    DfltVal:N ValGroup:NotComment
                                                    ,ItemTypes
      17  LotSerialFullyDistributed . .     1 SYN  Lot/Serial Fully Distributed. .YESNO
                                                    DfltVal:Y Valid:Y,N
                                                    ValGroup:NotComment
      18  SalesKitLineKey . . . . . . .     6 SNN  Sales Kit Line Key. . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ValGroup:NotComment
      19  CostOfGoodsSoldAcctKey. . . .     9 SYN  Cost of Goods Sold Account Key.ACCOUNT
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired,
                                                    ItemTypes
      20  SalesAcctKey. . . . . . . . .     9 SYN  Sales Account Key . . . . . . .ACCOUNT
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired
      21  PriceOverridden . . . . . . .     1 SYN  Price Overridden. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      22  OrderWarehouse. . . . . . . .     3 SYN  Order Warehouse . . . . . . . .
                                                    FmtType:CHARNUM ValGroup:NotC
                                                    omment
      23  ExplodedKitItem . . . . . . .     1 SYN  Exploded Kit Item . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      24  OrderLineKey. . . . . . . . .     6 SNN  Order Line Key. . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ValGroup:NotComment
      25  Revision. . . . . . . . . . .     3 SNN  Bill Revision Code. . . . . . .
      26  BillOption1 . . . . . . . . .     2 SYN  Bill Option 1 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      27  BillOption2 . . . . . . . . .     2 SYN  Bill Option 2 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      28  BillOption3 . . . . . . . . .     2 SYN  Bill Option 3 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      29  BillOption4 . . . . . . . . .     2 SYN  Bill Option 4 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      30  BillOption5 . . . . . . . . .     2 SYN  Bill Option 5 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      31  BillOption6 . . . . . . . . .     2 SYN  Bill Option 6 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      32  BillOption7 . . . . . . . . .     2 SYN  Bill Option 7 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      33  BillOption8 . . . . . . . . .     2 SYN  Bill Option 8 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      34  BillOption9 . . . . . . . . .     2 SYN  Bill Option 9 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    NotComment,BillHasOptions,
                                                    ItemRequired,RegularItem
      35  BackorderKitCompLine. . . . .     1 SYN  Backorder Kit Component Line. .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment Notes:
                                                    Kit Bckord=0, Comp Bckord>0
                                                    Flg=Y
      36  StandardKitBill . . . . . . .     1 SYN  Standard/Kit Bill . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      37  SkipPrintCompLine . . . . . .     1 SYN  Skip Print Of Component Line inYESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      38  AliasItemNo . . . . . . . . .    30 SYN  Alias Item Number . . . . . . .
                                                    ValGroup:NotComment,
                                                    ItemRequired,RegularItem
      39  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    ValGroup:NotComment
      40  SOHistoryDetlSeqNo. . . . . .    14 SNN  Sales Order History Detail Sequ
                                                    Mask:00000000000000
                                                    FmtType:ZEROFILL ValGroup:Not
                                                    Comment
      41  CustomerAction. . . . . . . .     1 SYN  Customer Action . . . . . . . .
                                                    DfltVal:N Valid:N,C,P,R
                                                    ValGroup:NotComment Notes:
                                                    N=None, C=Credit, P=rePlaceme
                                                    nt, R=Repair
      42  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired,
                                                    RegularItem,WarrantyTracking
      43  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
                                                    ValGroup:NotComment,
                                                    ItemRequired,RegularItem,
                                                    WarrantyTracking
      44  ExpirationOverridden. . . . .     1 SYN  Expiration Overridden . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      45  CostOverridden. . . . . . . .     1 SYN  Cost Overridden . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      46  ItemAction. . . . . . . . . .     1 SYN  Item Action . . . . . . . . . .
                                                    DfltVal:N Valid:N,S,P,R
                                                    ValGroup:NotComment Notes:
                                                    N=None, S=Stock, P=scraP,
                                                    R=Repair
      47  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:PostJCCosts,
                                                    NotComment
      48  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    DepVal:REQUIRED ValGroup:Post
                                                    JCCosts,NotComment
      49  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                    DepVal:REQUIRED ValGroup:Item
                                                    Required
      50  PromiseDate . . . . . . . . .     8 SNN  Promise Date. . . . . . . . . .DATE
                                                    ValGroup:NotComment
      51  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      52  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      53  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      54  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes,
                                                    NotComponent
      55  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                    Mask:##,###,###.00-
                                                    ValGroup:NotComment,
                                                    ItemRequired
      56  ExtendedCost. . . . . . . . . 12.2  NNN  Extended Cost . . . . . . . . .COST
                                                    Mask:##,###,###.00-
      57  ExtendedNegQtyAdj . . . . . . 12.2  NNN  Extended Negative Quantity Adju
                                                    Mask:##,###,###.00-
      58  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: {Calc @ Pre (Unless
                                                    Ds)}
      59  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000 ValGroup:Not
                                                    Comment
      60  CommissionAmt . . . . . . . . 13.2  NNN  Commission Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
                                                    ValGroup:NotComment Notes:
                                                    (Calc @ Pre-Update)
      61  QuantityPerBill . . . . . . . 16.6  NNN  Quantity Per Bill . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment
      62  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percent . . . . .
                                                    Mask:###0.000- ValGroup:NotCo
                                                    mment,LineDiscount,ItemRequir
                                                    ed,ItemTypes
      63  LineWeight. . . . . . . . . . 12.2  NNN  Line Weight . . . . . . . . . .MISCAMOUNT
                                                    Read Only:Y Mask:##,###,
                                                    ###.00-