AP_TrialBalanceWrk AP Trial Balance Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_TrialBalance_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_TrialBalanceWrk"+%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 Division Description. . . . . . 4 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 5 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 6 VendorHoldPayment . . . . . . 1 SNN Hold Payment. . . . . . . . . . 7 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . . 8 SequenceNo. . . . . . . . . . 6 SNN Sequence 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 InvoiceHistoryHeaderSeqNo . . 6 SNN Invoice History Header Sequence 13 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 14 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . . 15 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . . 16 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 17 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 18 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 19 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . . 20 TransferVendorNo. . . . . . . 7 SNN Transfer Vendor Number. . . . . 21 TransferInvoiceNo . . . . . . 10 SNN Transfer Invoice Number . . . . 22 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 23 TransactionType . . . . . . . 1 SNN Transaction Type. . . . . . . . 24 CheckNo . . . . . . . . . . . 10 SNN AP Check Number . . . . . . . . 25 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE 26 ApplyToInvoice. . . . . . . . 10 SNN Apply To AP Invoice Number Id X 27 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . . 28 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 29 Balance . . . . . . . . . . . 13.2 NNN Invoice Balance . . . . . . . . 30 RetentionBalance. . . . . . . 13.2 NNN Retention Balance . . . . . . . 31 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . . 32 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .