     AR_CustomerListingBalWrk            AR Customer Listing Balance Work  Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CustomerListingBal_rpt
     SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerListingBalWrk"+%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  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       4  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
       5  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
       6  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .
       7  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .
       8  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .
       9  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .
      10  State . . . . . . . . . . . .     2 SNN  State . . . . . . . . . . . . .
      11  ZipCode . . . . . . . . . . .    10 SNN  ZipCode . . . . . . . . . . . .
      12  CountryCode . . . . . . . . .     3 SNN  Country Code. . . . . . . . . .
      13  CountryName . . . . . . . . .    30 SNN  Country Name. . . . . . . . . .
      14  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
      15  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .
      16  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .
      17  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .
      18  URLAddress. . . . . . . . . .    50 SNN  URL Address . . . . . . . . . .
      19  BatchFax. . . . . . . . . . .     1 SNN  Batch Fax . . . . . . . . . . .
      20  ContactCode . . . . . . . . .    10 SNN  Contact Code. . . . . . . . . .
      21  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
      22  ShipMethod. . . . . . . . . .    15 SNN  Ship Method . . . . . . . . . .
      23  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      24  TaxScheduleDesc . . . . . . .    30 SNN  Tax Schedule Description. . . .
      25  TaxExemptNo . . . . . . . . .    15 SNN  Tax Exempt Number . . . . . . .
      26  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      27  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
      28  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
      29  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
      30  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
      31  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      32  CustomerSortField . . . . . .    10 SNN  Customer Sort Field . . . . . .
      33  TemporaryCustomer . . . . . .     1 SNN  Temporary Customer. . . . . . .
      34  OpenItemCustomer. . . . . . .     1 SNN  Open Item Customer. . . . . . .
      35  ResidentialAddress. . . . . .     1 SNN  Residential Address . . . . . .
      36  StatementCycle. . . . . . . .     1 SNN  Statement Cycle . . . . . . . .
      37  PrintDunningMessage . . . . .     1 SNN  Print Dunning Message . . . . .
      38  CustomerType. . . . . . . . .     4 SNN  CustomerType. . . . . . . . . .
      39  EmailStatements . . . . . . .     1 SNN  Obsolete 4.30 . . . . . . . . .
      40  PriceLevel. . . . . . . . . .     1 SNN  Price Level . . . . . . . . . .
      41  DefaultItemCode . . . . . . .    30 SNN  Default Item Code . . . . . . .
      42  DefaultItemCodeDesc . . . . .    30 SNN  Default Item Code Description .
      43  CreditHold. . . . . . . . . .     1 SNN  Credit Hold . . . . . . . . . .
      44  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .
      45  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
      46  DefaultPaymentType. . . . . .    11 SNN  Default Payment Type. . . . . .
      47  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      48  CRMName . . . . . . . . . . .   120 SNN  CRM Name. . . . . . . . . . . .
      49  DateLastActivity. . . . . . .     8 SNN  Date Last Activity. . . . . . .DATE
      50  DateLastPayment . . . . . . .     8 SNN  Date Last Payment . . . . . . .DATE
      51  DateLastStatement . . . . . .     8 SNN  Date Last Statement . . . . . .DATE
      52  DateLastFinanceChrg . . . . .     8 SNN  Date Last Finance Charge. . . .DATE
      53  DateLastAging . . . . . . . .     8 SNN  Date Last Aging . . . . . . . .DATE
      54  DateEstablished . . . . . . .     8 SNN  Date Established. . . . . . . .DATE
      55  CurrentPeriod . . . . . . . .     2 SNN  Current Period. . . . . . . . .
      56  CurrentFiscalYear . . . . . .     4 SNN  Current Fiscal Year . . . . . .
      57  CreditLimit . . . . . . . . . 14.2  NNN  Credit Limit. . . . . . . . . .
      58  AvgDaysPaymentInvoice . . . .  3.0  NNN  Average Days Payment Invoice. .
      59  AvgDaysOverDue. . . . . . . .  3.0  NNN  Average Days Over Due . . . . .
      60  CustomerDiscountRate. . . . . 13.3  NNN  Customer Discount Rate. . . . .
      61  ServiceChargeRate . . . . . . 13.3  NNN  Service Charge Rate / Finance C
      62  LastPaymentAmt. . . . . . . . 14.2  NNN  Last Payment Amount . . . . . .
      63  HighestStmntBalance . . . . . 14.2  NNN  Highest Statement Balance . . .
      64  UnpaidServiceChrg . . . . . . 14.2  NNN  Unpaid Service Charge . . . . .
      65  CurrentBalance. . . . . . . . 14.2  NNN  Current Balance . . . . . . . .
      66  AgingCategory1. . . . . . . . 14.2  NNN  Aging Category 1. . . . . . . .
      67  AgingCategory2. . . . . . . . 14.2  NNN  Aging Category 2. . . . . . . .
      68  AgingCategory3. . . . . . . . 14.2  NNN  Aging Category 3. . . . . . . .
      69  AgingCategory4. . . . . . . . 14.2  NNN  Aging Category 4. . . . . . . .
      70  OpenOrderAmt. . . . . . . . . 14.2  NNN  Open Order Amount . . . . . . .
      71  ARBalance . . . . . . . . . . 14.2  NNN  AR Balance. . . . . . . . . . .
      72  DollarsSoldPTD. . . . . . . . 15.2  NNN  Dollars Sold Period to Date . .
      73  DollarsSoldYTD. . . . . . . . 16.2  NNN  Dollars Sold Year to Date . . .
      74  DollarsSoldPY . . . . . . . . 16.2  NNN  Dollars Sold Prior Year . . . .
      75  CostOfGoodsSoldPTD. . . . . . 15.2  NNN  Cost of Goods Sold Period to Da
      76  CostOfGoodsSoldYTD. . . . . . 16.2  NNN  Cost of Goods Sold Year to Date
      77  CostOfGoodsSoldPY . . . . . . 16.2  NNN  Cost of Goods Sold Prior Year .
      78  ProfitPercentPTD. . . . . . .  8.3  NNN  Profit Percent Period to Date .
      79  ProfitPercentYTD. . . . . . .  8.3  NNN  Profit Percent Year to Date . .
      80  ProfitPercentPY . . . . . . .  8.3  NNN  Profit Percent Prior Year . . .
      81  CashReceivedPTD . . . . . . . 15.2  NNN  Cash Received Period to Date. .
      82  CashReceivedYTD . . . . . . . 16.2  NNN  Cash Received Year to Date. . .
      83  CashReceivedPY. . . . . . . . 16.2  NNN  Cash Received Prior Year. . . .
      84  FinanceChargesPTD . . . . . . 15.2  NNN  Finance Charges Period to Date.
      85  FinanceChargesYTD . . . . . . 16.2  NNN  Finance Charges Year to Date. .
      86  FinanceChargesPY. . . . . . . 16.2  NNN  Finance Charges Prior Year. . .
      87  NumberOfInvoicesPTD . . . . .  7.0  NNN  Number of Invoices Period to Da
      88  NumberOfInvoicesYTD . . . . .  8.0  NNN  Number of Invoices Year to Date
      89  NumberOfInvoicesPY. . . . . .  8.0  NNN  Number of Invoices Prior Year .
      90  NumberOfFinanceChrgsPTD . . .  7.0  NNN  Number of Finance Charges Perio
      91  NumberOfFinanceChrgsYTD . . .  8.0  NNN  Number of Finance Charges Year
      92  NumberOfFinanceChrgsPY. . . .  8.0  NNN  Number of Finance Charges Prior