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