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