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