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-