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