AP_OpenInvoiceByJobWrk AP Open Invoice By Job Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_OpenInvoiceByJobReport_rpt SQL Def: N SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_OpenInvoiceByJobWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 3 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 4 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 5 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 6 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 7 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 8 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 9 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 10 JobDesc . . . . . . . . . . . 30 SNN Job Description . . . . . . . . 11 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 12 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 13 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 14 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . . 15 RetentionBalance. . . . . . . 13.2 NNN Retention Balance . . . . . . . 16 Balance . . . . . . . . . . . 13.2 NNN Balance . . . . . . . . . . . . 17 AmountAppliedToday. . . . . . 13.2 NNN Amount Applied Today. . . . . .