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