AR_TrialBalanceWrk                    AR Trial Balance Work           Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_TrialBalance_rpt
 SQL Def: Y  SysDB: N                             "MAS_"+%C$+"/AR"+%C$+"/AR_TrialBalanceWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SYY  Sort Field. . . . . . . . . . .
   2  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 FmtType:ZEROFILL
   3  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
   4  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
   5  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
   6  InvoiceNo . . . . . . . . . .     7 SYN  Invoice Number. . . . . . . . .INVOICE
   7  InvoiceType . . . . . . . . .     2 SYN  Invoice Type. . . . . . . . . .
   8  SequenceNo. . . . . . . . . .     6 SNN  Sequence Number . . . . . . . .
                                                Mask:000000 FmtType:ZEROFILL
   9  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
  10  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
  11  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
  12  TransactionType . . . . . . .     1 SYN  Transaction Type. . . . . . . .
  13  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
  14  CheckNo . . . . . . . . . . .    10 SNN  Check Number. . . . . . . . . .CHECKNO
  15  PaymentReference. . . . . . .    10 SNN  Payment Reference . . . . . . .
  16  PaymentDate . . . . . . . . .     8 SNN  Payment Date. . . . . . . . . .DATE
  17  PaymentType . . . . . . . . .     5 SYN  Payment Type. . . . . . . . . .
  18  OpenItemCustomer. . . . . . .     1 SNN  Open Item Customer. . . . . . .
  19  CreditLimitExceeded . . . . .     1 SYN  Credit Limit Exceeded . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  20  CreditHold. . . . . . . . . .     1 SNN  Credit Hold . . . . . . . . . .
  21  InvoiceAmt. . . . . . . . . . 14.2  NNN  Invoice Amount. . . . . . . . .
  22  DiscountAmt . . . . . . . . . 14.2  NNN  Discount Amount . . . . . . . .
  23  Balance . . . . . . . . . . . 14.2  NNN  Balance . . . . . . . . . . . .
  24  RetentionBalance. . . . . . . 14.2  NNN  Retention Balance . . . . . . .
  25  TransactionAmt. . . . . . . . 13.2  NNN  Transaction Amount. . . . . . .TRANSACTIONAMT
                                                Mask:###,###,###.00-