AR_AgedInvoiceReportWrk               AR Aged Invoice Report Work     Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_AgedInvoiceReport_rpt
 SQL Def: Y  SysDB: N                        "MAS_"+%C$+"/AR"+%C$+"/AR_AgedInvoiceReportWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
   3  GroupFieldDesc. . . . . . . .    30 SNN  Group Field Description . . . .
   4  GroupField2 . . . . . . . . .     6 SNN  Group Field 2 . . . . . . . . .
   5  GroupFieldDesc2 . . . . . . .    30 SNN  Group Field Description 2 . . .
   6  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
                                                Mask:00
   7  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
   8  Type. . . . . . . . . . . . .     1 SNN  Type. . . . . . . . . . . . . .
   9  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
  10  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
  11  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
  12  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
  13  SequenceNo. . . . . . . . . .     6 SNN  Sequence Number . . . . . . . .
  14  TransactionType . . . . . . .     1 SNN  Transaction Type. . . . . . . .
  15  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
  16  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
  17  PaymentReference. . . . . . .    10 SNN  Payment Reference . . . . . . .
  18  PaymentDate . . . . . . . . .     8 SNN  Payment Date. . . . . . . . . .DATE
  19  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .JOBNO
  20  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
  21  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
  22  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .NAME
  23  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
  24  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
  25  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .
  26  ZipCode . . . . . . . . . . .    10 SNN  Zip Code. . . . . . . . . . . .
  27  CustomerType. . . . . . . . .     4 SNN  Customer Type . . . . . . . . .
  28  CustomerPoNo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
  29  CustomerSortField . . . . . .    10 SNN  Customer Sort Field . . . . . .
  30  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
  31  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
  32  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .NAME
  33  OpenItemCustomer. . . . . . .     1 SYN  Open Item Customer. . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  34  CreditLimitExceeded . . . . .     1 SYN  Credit Limit Exceeded . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  35  CreditHold. . . . . . . . . .     1 SYN  Credit Hold . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  36  DaysDelinquent. . . . . . . .     4 SNN  Days Delinquent . . . . . . . .
  37  SplitCommissionFlag . . . . .     1 SNN  Split Commission Flag . . . . .
  38  TransactionAmt. . . . . . . . 13.2  NNN  Transaction Amount. . . . . . .
  39  DiscountAmt . . . . . . . . . 14.2  NNN  Discount Amount . . . . . . . .
  40  Balance . . . . . . . . . . . 14.2  NNN  Balance . . . . . . . . . . . .
  41  CurrentAmt. . . . . . . . . . 14.2  NNN  Current Amount. . . . . . . . .
  42  AgingAmt1 . . . . . . . . . . 14.2  NNN  Aging Amount 1. . . . . . . . .
  43  AgingAmt2 . . . . . . . . . . 14.2  NNN  Aging Amount 2. . . . . . . . .
  44  AgingAmt3 . . . . . . . . . . 14.2  NNN  Aging Amount 3. . . . . . . . .
  45  AgingAmt4 . . . . . . . . . . 14.2  NNN  Aging Amount 4. . . . . . . . .
  46  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .
  47  CreditLimit . . . . . . . . . 14.2  NNN  Credit Limit. . . . . . . . . .