AP_InvoiceDetail AP Invoice Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_InvoiceDetail_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceDetail.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+LineKey
KDISPLAY: APDivisionNo+VendorNo+InvoiceNo+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Read Only:Y Mask:00
FmtType:ZEROFILL
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
Read Only:Y FmtType:MASTERNUM
3 InvoiceNo . . . . . . . . . . 10 SNY Invoice Number. . . . . . . . .APINVOICE
Read Only:Y
4 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL
5 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
00 FmtType:ZEROFILL
6 AccountKey. . . . . . . . . . 9 SYN Account Key . . . . . . . . . .ACCOUNT
DepVal:REQUIRED
7 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:JCIntegrated
8 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
DepVal:REQUIRED ValGroup:JCIn
tegrated,JobNo
9 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
DepVal:REQUIRED ValGroup:JCIn
tegrated,JobNo
10 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
DepVal:REQUIRED ValGroup:JCIn
tegrated,JobNo
11 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
12 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . .APDIVISION
Mask:00 ValGroup:NotJobNo
13 TransferVendorNo. . . . . . . 7 SYN Transfer Vendor Number. . . . .VENDORNO
DepVal:REQUIRED ValGroup:NotJ
obNo
14 TransferInvoiceNo . . . . . . 10 SNN Transfer Invoice Number . . . .APINVOICE
DepVal:REQUIRED ValGroup:NotJ
obNo
15 TransferForm1099. . . . . . . 1 SNN Transfer 1099 Form. . . . . . .FORM1099
16 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 Box . . . . . . .BOX1099
17 AssetTemplate . . . . . . . . 25 SNN Asset Template. . . . . . . . .ASSETTEMPLATE
DepVal:REQUIRED ValGroup:FAIn
tegration
18 QuantityDistributed . . . . . 16.6 NNN Quantity Distributed. . . . . .QUANTITY
Mask:##,###,###.000000-
DepVal:REQUIRED ValGroup:JCIn
tegrated,JobNo
19 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . .
Mask:##,###,###.00-
20 RetentionRate . . . . . . . . 8.2 NNN Retention Rate. . . . . . . . .RATE
Mask:###.00-% DepVal:REQUIRED
ValGroup:JCIntegrated,JobNo
21 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
DepVal:REQUIRED ValGroup:JCIn
tegrated,JobNo
22 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00-
DepVal:REQUIRED ValGroup:JCIn
tegrated,JobNo
23 TransferDiscount. . . . . . . 13.2 NNN Transfer Discount . . . . . . .AMOUNT
Mask:###,###,###.00-