     AR_InvoiceDetail                       AR Invoice Detail              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_InvoiceDetail_bus
     SQL Def: N  SysDB: N                                      "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceDetail.M4T"

     KPRIMARY: InvoiceNo+InvoiceType+LineKey
     KDISPLAY: InvoiceNo+InvoiceType+LineSeqNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    Read Only:Y FmtType:MASTERNUM
       2  InvoiceType . . . . . . . . .     2 SYY  Invoice Type. . . . . . . . . .
                                                    Read Only:Y Valid:CM,DM,IN,
                                                    AD,FC,CA,XD Notes: CM=Credit
                                                    Memo, DM=Debit Memo,
                                                    IN=INvoice, AD=Adjustment.,
                                                    FC=Finance Charge, CA=CAsh,
                                                    XD=Deleted
       3  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
                                                    Read Only:Y Mask:000000
                                                    FmtType:ZEROFILL
       4  LineSeqNo . . . . . . . . . .    14 SNY  Line Sequence Number. . . . . .
                                                    Read Only:Y Mask:000000000000
                                                    00 FmtType:ZEROFILL
       5  ItemCode. . . . . . . . . . .    30 SYY  AR Item Code. . . . . . . . . .ARITEMCODE
       6  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    Valid:3,4,5 Notes: 3=miscella
                                                    neous charge, 4=comment,
                                                    5=miscellaneous item
       7  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
       8  SalesAcctKey. . . . . . . . .     9 SYN  Sales Account Key . . . . . . .ACCOUNT
                                                    DepVal:REQUIRED ValGroup:Comm
                                                    ent
       9  CostOfGoodsSoldAcctKey. . . .     9 SYN  Cost Of Goods Sold Account Key.ACCOUNT
                                                    ValGroup:Charge,Comment
      10  InventoryAcctKey. . . . . . .     9 SYN  Inventory Account Key . . . . .ACCOUNT
                                                    ValGroup:Charge,Comment
      11  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .
                                                    ValGroup:Charge,Comment
      12  SubjectToExemption. . . . . .     1 SYN  Subject To Exemption. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:ARSalesTax,Comment
      13  Commissionable. . . . . . . .     1 SYN  Commissionable. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:SalesPersonReporting
                                                    ,Comment
      14  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    DepVal:REQUIRED ValGroup:ARSa
                                                    lesTax,Comment
      15  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
      16  Quantity. . . . . . . . . . . 12.3  NNN  Quantity. . . . . . . . . . . .ARQUANTITY
                                                    Mask:#,###,###.000-
                                                    ValGroup:Charge,Comment
      17  Price . . . . . . . . . . . . 12.3  NNN  Price . . . . . . . . . . . . .ARPRICE
                                                    Mask:#,###,###.000-
                                                    ValGroup:Charge,Comment
      18  Cost. . . . . . . . . . . . . 12.3  NNN  Cost. . . . . . . . . . . . . .ARCOST
                                                    Mask:#,###,###.000-
                                                    ValGroup:Charge,Comment
      19  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                    Mask:##,###,###.00 ValGroup:C
                                                    omment