AP_AgedInvoiceWrk AP Aged Invoice Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_AgedInvoiceReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_AgedInvoiceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 4 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 5 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 7 VendorHoldPayment . . . . . . 1 SNN Vendor Hold Payment . . . . . . 8 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 9 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 10 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 11 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 12 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 13 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 14 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 15 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE 16 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . . 17 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 18 Balance . . . . . . . . . . . 13.2 NNN Balance . . . . . . . . . . . . 19 CurrentAmt. . . . . . . . . . 14.2 NNN Current Amount. . . . . . . . . 20 AgingAmt1 . . . . . . . . . . 14.2 NNN Aging Amount 1 . . . . . . . . 21 AgingAmt2 . . . . . . . . . . 14.2 NNN Aging Amount 2 . . . . . . . . 22 AgingAmt3 . . . . . . . . . . 14.2 NNN Aging Amount 3 . . . . . . . . 23 AgingAmt4 . . . . . . . . . . 14.2 NNN Aging Amount 4 . . . . . . . . 24 RetentionBalance. . . . . . . 13.2 NNN Retention Balance . . . . . . .