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