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. . . . . . . .