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