AR_RepetitiveInvoiceDetail AR Repetitive Invoice Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_RepetitiveInvoiceDetail_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_RepetitiveInvoiceDetail.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ReferenceNo+LineKey
KITEMCODE: ItemCode+ARDivisionNo+CustomerNo+ReferenceNo+LineKey
KDISPLAY: ARDivisionNo+CustomerNo+ReferenceNo+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Read Only:Y Mask:00
FmtType:ZEROFILL ValGroup:ARD
ivisionRequired
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
Read Only:Y FmtType:MASTERNUM
C ChngTag:Replace1/ARDivision
No$
3 ReferenceNo . . . . . . . . . 4 SYY Reference Number. . . . . . . .
Read Only:Y FmtType:CHARNUM
4 LineKey . . . . . . . . . . . 6 SNY LineKey . . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL
5 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
00 FmtType:ZEROFILL
6 ItemCode. . . . . . . . . . . 30 SYY AR Item Code. . . . . . . . . .ARITEMCODE
7 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Valid:3,4,5 Notes: 3=Charge
Item, 4=Comment Item,
5=Miscellaneous Item
8 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
9 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT
DepVal:REQUIRED ValGroup:Comm
ent
10 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT
ValGroup:Charge,Comment
11 InventoryAcctKey. . . . . . . 9 SYN Inventory Account Key . . . . .ACCOUNT
ValGroup:Charge,Comment
12 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
ValGroup:Charge,Comment
13 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:ARSalesTax,Comment
14 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:SalespersonReporting
,Comment
15 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
DepVal:REQUIRED ValGroup:ARSa
lesTax,Comment
16 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
17 Quantity. . . . . . . . . . . 12.3 NNN Quantity. . . . . . . . . . . .ARQUANTITY
Mask:#,###,###.000-
ValGroup:Charge,Comment
18 Price . . . . . . . . . . . . 12.3 NNN Price . . . . . . . . . . . . .ARPRICE
Mask:#,###,###.000-
ValGroup:Charge,Comment
19 Cost. . . . . . . . . . . . . 12.3 NNN Cost. . . . . . . . . . . . . .ARCOST
Mask:#,###,###.000-
ValGroup:Charge,Comment
20 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
Mask:##,###,###.00-
ValGroup:Comment ChngTag:Sum