AR_CustomerListingWrk                 AR Customer Listing Work        Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_CustomerListing_rpt
 SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerListingWrk"+%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  ReportSection . . . . . . . .     1 SNN  Report Section. . . . . . . . .
   6  SequenceNo. . . . . . . . . .    14 SNN  Sequence Number . . . . . . . .
   7  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
   8  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .
   9  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .
  10  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .
  11  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .
  12  State . . . . . . . . . . . .     2 SNN  State . . . . . . . . . . . . .
  13  ZipCode . . . . . . . . . . .    10 SNN  ZipCode . . . . . . . . . . . .
  14  CountryCode . . . . . . . . .     3 SNN  Country Code. . . . . . . . . .
  15  CountryName . . . . . . . . .    30 SNN  Country Name. . . . . . . . . .
  16  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
  17  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .
  18  TelephoneNo2. . . . . . . . .    17 SNN  Telephone Number 2. . . . . . .
  19  TelephoneExt2 . . . . . . . .     5 SNN  Telephone Extension 2 . . . . .
  20  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .
  21  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .
  22  URLAddress. . . . . . . . . .    50 SNN  URL Address . . . . . . . . . .
  23  BatchFax. . . . . . . . . . .     1 SNN  Batch Fax . . . . . . . . . . .
  24  ContactCode . . . . . . . . .    10 SNN  Contact Code. . . . . . . . . .
  25  ShipMethod. . . . . . . . . .    15 SNN  Ship Method . . . . . . . . . .
  26  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
  27  TaxScheduleDesc . . . . . . .    30 SNN  Tax Schedule Description. . . .
  28  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
  29  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
  30  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
  31  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
  32  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
  33  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
  34  CustomerSortField . . . . . .    10 SNN  Customer Sort Field . . . . . .
  35  TemporaryCustomer . . . . . .     1 SNN  Temporary Customer. . . . . . .
  36  OpenItemCustomer. . . . . . .     1 SNN  Open Item Customer. . . . . . .
  37  ResidentialAddress. . . . . .     1 SNN  Residential Address . . . . . .
  38  StatementCycle. . . . . . . .     1 SNN  Statement Cycle . . . . . . . .
  39  PrintDunningMessage . . . . .     1 SNN  Print Dunning Message . . . . .
  40  CustomerType. . . . . . . . .     4 SNN  CustomerType. . . . . . . . . .
  41  PriceLevel. . . . . . . . . .     1 SNN  Price Level . . . . . . . . . .
  42  DefaultItemCode . . . . . . .    30 SNN  Default Item Code . . . . . . .
  43  DefaultItemCodeDesc . . . . .    30 SNN  Default Item Code Description .
  44  CreditHold. . . . . . . . . .     1 SNN  Credit Hold . . . . . . . . . .
  45  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .
  46  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
  47  CRMAddressID. . . . . . . . .    11 SNN  CRM Address ID. . . . . . . . .
  48  CRMAddress1 . . . . . . . . .    80 SNN  CRM Address 1 . . . . . . . . .
  49  DefaultPaymentType. . . . . .    11 SNN  Default Payment Type. . . . . .
  50  PaymentDesc . . . . . . . . .    30 SNN  Payment Description . . . . . .
  51  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
  52  CRMName . . . . . . . . . . .   120 SNN  CRM Name. . . . . . . . . . . .
  53  TaxCode . . . . . . . . . . .    15 SNN  Tax Code. . . . . . . . . . . .
  54  TaxExemptionNo. . . . . . . .    20 SNN  Tax Exempt Number . . . . . . .
  55  MemoCode. . . . . . . . . . .    10 SNN  Memo Code . . . . . . . . . . .
  56  MemoDate. . . . . . . . . . .     8 SNN  Memo Date . . . . . . . . . . .DATE
  57  MemoDesc. . . . . . . . . . .    30 SNN  Memo Description. . . . . . . .
  58  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
  59  ReminderStartDate . . . . . .     8 SNN  Reminder Start Date . . . . . .DATE
  60  ReminderEndDate . . . . . . .     8 SNN  Reminder End Date . . . . . . .DATE
  61  AutoDisplaySetting. . . . . .     1 SNN  Auto Display Setting. . . . . .
  62  MemoText. . . . . . . . . . .  7168 SNN  Memo Text . . . . . . . . . . .
  63  Attachment. . . . . . . . . .   128 SNN  Attachment. . . . . . . . . . .
  64  PrimaryLocation . . . . . . .     1 SNN  Primary Location. . . . . . . .
  65  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
  66  WarehouseDesc . . . . . . . .    30 SNN  Warehouse Description . . . . .
  67  PrimaryContact. . . . . . . .     1 SNN  Primary Contact . . . . . . . .
  68  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
  69  Salutation. . . . . . . . . .    10 SNN  Salutation. . . . . . . . . . .
  70  ContactTitle. . . . . . . . .    15 SNN  Contact Title . . . . . . . . .
  71  ContactNotes. . . . . . . . .   256 SNN  Contact Notes . . . . . . . . .
  72  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
  73  CRMFirstName. . . . . . . . .    60 SNN  CRM First Name. . . . . . . . .
  74  CRMLastName . . . . . . . . .    80 SNN  CRM Last Name . . . . . . . . .
  75  EBMEnabled. . . . . . . . . .     1 SNN  e-Business Manager Enabled. . .
  76  RequireAcceptOfCustChange . .     1 SNN  Require Acceptance of Customer
  77  RequireAcceptOfUIDChange. . .     1 SNN  Require Acceptance of UID Chang
  78  RequireAcceptOfSOSubmits. . .     1 SNN  Require Acceptance of SO Submit
  79  PrimaryCardNo . . . . . . . .     1 SNN  Primary Card Number . . . . . .
  80  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
  81  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .
  82  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .
  83  CorporateCustIDPurchOrder . .    25 SNN  Corporate Customer ID / Purchas
  84  CardholderName. . . . . . . .    30 SNN  Cardholder Name . . . . . . . .
  85  EBMUserID . . . . . . . . . .    15 SNN  E-Business Manager User ID. . .
  86  UserName. . . . . . . . . . .    30 SNN  User Name . . . . . . . . . . .
  87  EmailStatements . . . . . . .     1 SNN  Obsolete 4.30 . . . . . . . . .
  88  FullCreditCardNo. . . . . . .    24 SNN  Full Credit Card Number . . . .
  89  Document. . . . . . . . . . .    30 SNN  Document Name . . . . . . . . .
  90  PrintDocument . . . . . . . .     1 SNN  Print Document. . . . . . . . .
  91  EmailDocument . . . . . . . .     1 SNN  Email Document. . . . . . . . .
  92  FaxDocument . . . . . . . . .     1 SNN  Fax Document. . . . . . . . . .
  93  UseEmailAddressInDataEntry. .     1 SNN  Use Email Address In Data Entry
  94  UseFaxNoInDataEntry . . . . .     1 SNN  Use Fax Number In Data Entry. .
  95  UseCustomerEmailAddress . . .     1 SNN  Use Customer Email Address. . .
  96  UseCustomerFaxNo. . . . . . .     1 SNN  Use Customer Fax Number . . . .
  97  RecordType. . . . . . . . . .     1 SNN  Record Type . . . . . . . . . .
  98  ToContactCode . . . . . . . .    10 SNN  To Contact Code . . . . . . . .
  99  ContactEmailAddress . . . . .    50 SNN  Contact Email Address . . . . .
 100  ContactFaxNo. . . . . . . . .    17 SNN  Contact Fax Number. . . . . . .
 101  ToAdditionalEmailAddress. . .    50 SNN  To Additional Email Address . .
 102  ToAdditionalFaxNo . . . . . .    17 SNN  To Additional Fax Number. . . .
 103  ToAdditionalFaxRecipientName.    30 SNN  To Additional Fax Recipient Nam
 104  CustomerDiscountRate. . . . . 13.3  NNN  Customer Discount Rate. . . . .
 105  ServiceChargeRate . . . . . . 13.3  NNN  Service Charge Rate / Finance C
 106  CreditLimit . . . . . . . . . 14.2  NNN  Credit Limit. . . . . . . . . .