AP_MonthlyPurchaseWrk AP Monthly Purchase Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_MonthlyPurchaseReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_MonthlyPurchaseWrk"+%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 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 4 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 5 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 6 VendorHoldPayment . . . . . . 1 SNN Hold Payment. . . . . . . . . . 7 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 8 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 9 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 10 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 11 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 12 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . 13 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 14 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 15 TransactionType . . . . . . . 1 SNN Transaction Type. . . . . . . . 16 ApplyToInvoiceNo. . . . . . . 10 SNN Apply To Invoice Number . . . . 17 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . .