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