AP_ExpenseByGLAccountWrk AP Expense By GL Account Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_APExpenseByGLAccount_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ExpenseByGLAccountWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 20 SNN Group Field . . . . . . . . . . 3 GroupFieldDesc. . . . . . . . 75 SNN Group Field Desc. . . . . . . . 4 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 5 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 6 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 7 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 8 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 9 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 10 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . . 11 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 12 SourceJournal . . . . . . . . 2 SNN Source Journal. . . . . . . . . 13 SourceJournalNo . . . . . . . 6 SNN Source Journal Number . . . . . 14 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 15 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 16 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . . 17 TransferVendorNo. . . . . . . 7 SNN Transfer Vendor Number. . . . . 18 LastCheckNo . . . . . . . . . 10 SNN Last Check Number . . . . . . . 19 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . .