     AR1    A/R Customer Master File (AR1_CustomerMaster)                            Level: 4.40
            Record Type: 1    A/R Customer Master File                               08/28/2009

     File Type: Mkeyed   Key Size: 9    Rec Len: 1064    Min Len: 560    Define: Y

     Main Key (KNO=0)Division(1,2)+CustomerNumber(3,7)
     2nd Key (KNO=1) CustomerName(10,30)+Division(1,2)+CustomerNumber(3,7)
     3rd Key (KNO=2) SortField(267,10)+Division(1,2)+CustomerNumber(3,7)
     4th Key (KNO=3) Division(1,2)+SalesPersonCode(233,4)+CustomerNumber(3,7)
     5th Key (KNO=4) CustomerType(281,4)+Division(1,2)+CustomerNumber(3,7)
     6th Key (KNO=5) ZipCode(122,10)+Division(1,2)+CustomerNumber(3,7)
     7th Key (KNO=6) PhoneNumber(132,17)+Division(1,2)+CustomerNumber(3,7)

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Division. . . . . . . . . . . . . . . . Division. . . . . . . . . . . Zero-Filled *(1,2)
     Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account     *(3,7)
     Name. . . . . . . . . . . . . . . . . . CustomerName. . . . . . . . . String      (10,30)
     Address Line 1. . . . . . . . . . . . . AddressLine1. . . . . . . . . String      (40,30)
     Address Line 2. . . . . . . . . . . . . AddressLine2. . . . . . . . . String      (70,30)
     City. . . . . . . . . . . . . . . . . . City. . . . . . . . . . . . . String      (100,20)
     State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String      (120,2)
     Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . String      (122,10)
     Telephone Number. . . . . . . . . . . . PhoneNumber . . . . . . . . . String      (132,17)
     Extension . . . . . . . . . . . . . . . Extension . . . . . . . . . . String      (149,5)
     IT Enabled. . . . . . . . . . . . . . . IT_Enabled. . . . . . . . . . Yes/No      (154,1)
     Batch Fax . . . . . . . . . . . . . . . BatchFax. . . . . . . . . . . Yes/No      (155,1)
     Default Credit Card Payment Type. . . . DefaultCreditCardPmtType. . . String      (156,5)
       e.g., VISA or MC.  A match here . . . . . . . . . . . . . . . . . . Memo
       will cause dflt Cred Crd info from AR1. . . . . . . . . . . . . . . Memo
       to fill in S/O Credit Card fields.. . . . . . . . . . . . . . . . . Memo
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (161,1)
     Contact Code. . . . . . . . . . . . . . ContactCode . . . . . . . . . Uppercase   (162,10)
     Country Code. . . . . . . . . . . . . . CountryCode . . . . . . . . . String      (172,3)
     Consumer UID. . . . . . . . . . . . . . ConsumerUID . . . . . . . . . Account     (175,15)
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (190,2)
     Ship Method . . . . . . . . . . . . . . ShipMethod. . . . . . . . . . String      (192,15)
     Tax Schedule. . . . . . . . . . . . . . TaxSchedule . . . . . . . . . Uppercase   (207,9)
     Tax Exempt Number . . . . . . . . . . . TaxExemptNumber . . . . . . . String      (216,15)
       (Only If Sales Tax Reporting = No). . . . . . . . . . . . . . . . . Memo
     Terms Code. . . . . . . . . . . . . . . TermsCode . . . . . . . . . . Zero-Filled (231,2)
     Salesperson Code. . . . . . . . . . . . SalesPersonCode . . . . . . . Uppercase   (233,4)
     Comment . . . . . . . . . . . . . . . . MasterFileComment . . . . . . String      (237,30)
     Sort Field. . . . . . . . . . . . . . . SortField . . . . . . . . . . Uppercase   (267,10)
     Temporary Customer? (Y/N) . . . . . . . TemporaryCustomer . . . . . . Yes/No      (277,1)
     Open Item Customer? (Y/N) . . . . . . . OpenItemCustomer. . . . . . . Yes/No      (278,1)
     Statement Cycle . . . . . . . . . . . . StatmentCycle . . . . . . . . Uppercase   (279,1)
     Print Dunning Message On Statement. . . PrintDunningMessage . . . . . Yes/No      (280,1)
     Customer Type . . . . . . . . . . . . . CustomerType. . . . . . . . . Uppercase   (281,4)
     Price Level . . . . . . . . . . . . . . PriceLevel. . . . . . . . . . Uppercase   (285,1)
     Date Of Last Activity . . . . . . . . . DateLastActivity. . . . . . . Date        (286,6)
     Date Of Last Payment. . . . . . . . . . DateLastPayment . . . . . . . Date        (292,6)
     Date Of Last Statement. . . . . . . . . DateLastStatement . . . . . . Date        (298,6)
     Date Of Last Finance Charge . . . . . . DateLastFinanceChrg . . . . . Date        (304,6)
     Date Of Last Aging. . . . . . . . . . . DateLastAging . . . . . . . . Date        (310,6)
     Avg Days For Payment (From Invoice Date)AveDaysPaymentInvoice . . . . Zero-Filled (316,3)
     Avg Days Overdue (Pay Date - Due Date). AveDaysOverDue. . . . . . . . Zero-Filled (319,3)
     # Of Invoices To Use In Days Calc (0-20)NoInvInDaysCalc . . . . . . . Zero-Filled (322,2)
     Default Sales Code. . . . . . . . . . . DefaultSalesCode. . . . . . . Uppercase   (324,6)
     Credit Hold? (Y/N). . . . . . . . . . . CreditHoldFlag. . . . . . . . Yes/No      (330,1)
     Primary Ship To Code. . . . . . . . . . PrimaryShipToCode . . . . . . Uppercase   (331,4)
     Date Established. . . . . . . . . . . . DateEstablished . . . . . . . Date        (335,6)
     Address Line 3. . . . . . . . . . . . . AddressLine3. . . . . . . . . String      (341,30)
     Fax Number. . . . . . . . . . . . . . . FaxNumber . . . . . . . . . . String      (371,17)
     Email Address . . . . . . . . . . . . . EmailAddress. . . . . . . . . String      (388,50)
     URL Address . . . . . . . . . . . . . . URLAddress. . . . . . . . . . String      (438,50)
     Encrypted Credit Card Number. . . . . . EncryptedCreditCardNumber . . String      (488,24)
       Default - Others are in AR_31 . . . . . . . . . . . . . . . . . . . Memo
     Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (512,34)
     Default Payment Type. . . . . . . . . . DefaultPaymentType. . . . . . Uppercase   (546,5)
       e.g., CASH or AMEX. . . . . . . . . . . . . . . . . . . . . . . . . Memo
     Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (551,10)
     Customer Discount Rate. . . . . . . . . CustomerDiscountRate. . . . . Number      [0]       8.3
     Service Charge Rate . . . . . . . . . . ServiceChargeRate . . . . . . Number      [1]       8.3
     Credit Limit. . . . . . . . . . . . . . CreditLimit . . . . . . . . . Number      [2]       9.2
     Last Payment Amount . . . . . . . . . . LastPaymentAmount . . . . . . Number      [3]       9.2
     Highest Statement Balance . . . . . . . HighStmntBalance. . . . . . . Number      [4]       9.2
     Unpaid Service Charge Y-T-D . . . . . . UnpaidServiceChrgYTD. . . . . Number      [5]       9.2
     Sales P-T-D . . . . . . . . . . . . . . SalesPTD. . . . . . . . . . . Number      [6]       9.2
     Sales Y-T-D . . . . . . . . . . . . . . SalesYTD. . . . . . . . . . . Number      [7]       9.2
     Sales L-Y . . . . . . . . . . . . . . . SalesPYR. . . . . . . . . . . Number      [8]       9.2
     Cost Of Sales P-T-D . . . . . . . . . . COGSPTD . . . . . . . . . . . Number      [9]       9.2
     Cost Of Sales Y-T-D . . . . . . . . . . COGSYTD . . . . . . . . . . . Number      [10]      9.2
     Cost Of Sales L-Y . . . . . . . . . . . COGSPYR . . . . . . . . . . . Number      [11]      9.2
     Cash Received P-T-D . . . . . . . . . . CashReceivedPTD . . . . . . . Number      [12]      9.2
     Cash Received Y-T-D . . . . . . . . . . CashReceivedYTD . . . . . . . Number      [13]      9.2
     Cash Received L-Y . . . . . . . . . . . CashReceivedPYR . . . . . . . Number      [14]      9.2
     Finance Charges P-T-D . . . . . . . . . FinanceChrgPTD. . . . . . . . Number      [15]      9.2
     Finance Charges Y-T-D . . . . . . . . . FinanceChrgYTD. . . . . . . . Number      [16]      9.2
     Finance Charges L-Y . . . . . . . . . . FinanceChrgPYR. . . . . . . . Number      [17]      9.2
     Number Of Invoices P-T-D. . . . . . . . NumberOfInvoicesPTD . . . . . Number      [18]      6.0
     Number Of Invoices Y-T-D. . . . . . . . NumberOfInvoicesYTD . . . . . Number      [19]      6.0
     Number Of Invoices L-Y. . . . . . . . . NumberOfInvoicesPYR . . . . . Number      [20]      6.0
     Number Of Finance Charges P-T-D . . . . NumberOfFinanceChargesPTD . . Number      [21]      6.0
     Number Of Finance Charges Y-T-D . . . . NumberOfFinanceChargesYTD . . Number      [22]      6.0
     Number Of Finance Charges L-Y . . . . . NumberOfFinanceChargesPYR . . Number      [23]      6.0
     Balance Forward . . . . . . . . . . . . BalanceForward. . . . . . . . Number      [24]      9.2
     Current Balance . . . . . . . . . . . . CurrentBalance. . . . . . . . Number      [25]      9.2
     Over 30 . . . . . . . . . . . . . . . . Over30Days. . . . . . . . . . Number      [26]      9.2
     Over 60 . . . . . . . . . . . . . . . . Over60Days. . . . . . . . . . Number      [27]      9.2
     Over 90 . . . . . . . . . . . . . . . . Over90Days. . . . . . . . . . Number      [28]      9.2
     Over 120. . . . . . . . . . . . . . . . Over120Days . . . . . . . . . Number      [29]      9.2
     Open Order Amount . . . . . . . . . . . OpenOrderAmount . . . . . . . Number      [30]      9.2
     Unpaid Service Chrg - Next Year . . . . UnpaidServiceChrgNextYear . . Number      [31]      9.2
     Sales - Next Period . . . . . . . . . . SalesNextPeriod . . . . . . . Number      [32]      9.2
     Cost Of Sales - Next Period . . . . . . COGSNextPeriod. . . . . . . . Number      [33]      9.2
     Cash Received - Next Period . . . . . . CashReceivedNextPeriod. . . . Number      [34]      9.2
     Finance Charges - Next Period . . . . . FinanceChargesNextPeriod. . . Number      [35]      9.2
     No. Of Invoices - Next Period . . . . . NoInvoicesNextPeriod. . . . . Number      [36]      9.2
     No. Of Finance Charges -Next Period . . NoFinanceChargesNextPeriod. . Number      [37]      9.2
                                                                                       ________
                                                                          Total Bytes  1064