AR_Customer AR Customer Master Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_Customer_bus,AR_SalesJournal_upd,SO_SalesJournal_upd,IT_ShoppingCart_upd,IT_UIDCustomerChan SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_Customer.M4T"
KPRIMARY: ARDivisionNo+CustomerNo KNAME: CustomerName+ARDivisionNo+CustomerNo KSORT: SortField+ARDivisionNo+CustomerNo KSALESPERSON: ARDivisionNo+SalespersonNo+CustomerNo KTYPE: CustomerType+ARDivisionNo+CustomerNo KZIPCODE: ZipCode+ARDivisionNo+CustomerNo KTELEPHONE: TelephoneNo+ARDivisionNo+CustomerNo KCUSTOMERNO: CustomerNo KADDRESS1: AddressLine1+ARDivisionNo+CustomerNo KADDRESS2: AddressLine2+ARDivisionNo+CustomerNo KADDRESS3: AddressLine3+ARDivisionNo+CustomerNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR1$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC Next:Custo merNo$ ChngTag:Replace1/ARDiv isionNo$ Notes: {AR1$(3,7)} 3 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME ValGroup:CRM Notes: {AR1$(10, 30)} 4 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE ValGroup:CRM Notes: {AR1$(40, 30)} 5 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE ValGroup:CRM Notes: {AR1$(70, 30)} 6 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . .ADDRESSLINE ValGroup:CRM Notes: {AR1$(341,30)} 7 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .CITY ValGroup:CRM Notes: {AR1$(100,20)} 8 State . . . . . . . . . . . . 2 SYN State . . . . . . . . . . . . .STATE ValGroup:CRM Notes: {AR1$(120,2)} 9 ZipCode . . . . . . . . . . . 10 SYN Zip Code. . . . . . . . . . . .ZIPCODE ValGroup:CRM Notes: {AR1$(122,10)} 10 CountryCode . . . . . . . . . 3 SYN Country Code. . . . . . . . . .COUNTRY FmtType:CHARNUM ValGroup:CRM Notes: {AR1$(172,3)} 11 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .TELEPHONENO ValGroup:CRM Notes: {AR1$(132,17)} 12 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . .TELEPHONEEXT ValGroup:CRM Notes: {AR1$(149,5)} 13 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO DepVal:REQUIRED ValGroup:CRM Notes: {AR1$(371,17)} 14 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS DepVal:REQUIRED ValGroup:CRM Notes: {AR1$(388,50)} 15 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . .URLADDRESS ValGroup:CRM Notes: {AR1$(438,50)} 16 EBMEnabled. . . . . . . . . . 1 SYN e-Business Manager Enabled. . .YESNO DfltVal:N Valid:Y,N ChngTag:Copy Notes: {AR1$(154,1)} 17 EBMConsumerUserID . . . . . . 15 SNN e-Business Manager Consumer Use DepVal:REQUIRED ChngTag:Copy Notes: {AR1$(175,15)} 18 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR1$(155,1)} 19 DefaultCreditCardPmtType. . . 5 SYN Default Credit Card Payment TypPAYMENTTYPE Read Only:Y Notes: e.g., VISA or MC. A match here will cause dflt Cred Crd info from AR1 to fill in S/O Credit Card fields. {AR1$(156,5)} 20 ContactCode . . . . . . . . . 10 SYN Contact Code. . . . . . . . . .ARCONTACT ValGroup:CRM Notes: {AR1$(162,10)} 21 ShipMethod. . . . . . . . . . 15 SYN Ship Method . . . . . . . . . .SHIPCODE Notes: {AR1$(192,15)} 22 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:ARSalesTax,CRM Notes: {AR1$(207,9)} 23 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . . Notes: (Only If Sales Tax Reporting = Yes) {AR1$(216, 15)} 24 TermsCode . . . . . . . . . . 2 SNY Terms Code. . . . . . . . . . .ARTERMS DfltVal:00 Mask:00 FmtType:ZE ROFILL ValGroup:CRM Notes: {AR1$(231,2)} 25 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:CRM ChngTag:Replace2 /ARDivisionNo$/CustomerNo$ 26 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM ValGroup:Sale spersonReporting,CRM Notes: {AR1$(233,4)} 27 Comment . . . . . . . . . . . 30 SNN Customer Comment. . . . . . . .COMMENT30 Notes: {AR1$(237,30)} 28 SortField . . . . . . . . . . 10 SYN Sort Field. . . . . . . . . . . Notes: {AR1$(267,10)} 29 TemporaryCustomer . . . . . . 1 SYN Temporary Customer. . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR1$(277,1)} 30 OpenItemCustomer. . . . . . . 1 SYY Open Item Customer. . . . . . .YESNO DfltVal:Y Valid:Y,N Notes: {AR1$(278,1)} 31 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO DfltVal:N Valid:Y,N 32 StatementCycle. . . . . . . . 1 SYN Statement Cycle . . . . . . . . DfltVal:M ValGroup:PrintARSta tements Notes: {AR1$(279,1)} 33 PrintDunningMessage . . . . . 1 SYN Print Dunning Message On StatemYESNO DfltVal:Y Valid:Y,N ValGroup:PrintARStatements Notes: {AR1$(280,1)} 34 CustomerType. . . . . . . . . 4 SYN Customer Type . . . . . . . . . ValGroup:CRM Notes: {AR1$(281,4)} 35 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . ValGroup:CRM Notes: {AR1$(285,1)} 36 DateLastActivity. . . . . . . 8 SNN Date Of Last Activity . . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(286,6)} 37 DateLastPayment . . . . . . . 8 SNN Date Of Last Payment. . . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(292,6)} 38 DateLastStatement . . . . . . 8 SNN Date Of Last Statement. . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(298,6)} 39 DateLastFinanceChrg . . . . . 8 SNN Date Of Last Finance Charge . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1$(304,6)} 40 DateLastAging . . . . . . . . 8 SNN Date Of Last Aging. . . . . . .DATE Read Only:Y ChngTag:Max Notes: {AR1$(310,6)} 41 DefaultItemCode . . . . . . . 30 SYN Default Item Code . . . . . . .ITEMCODE FmtType:CHARNUM Notes: {AR1$(324,6)} 42 CreditHold. . . . . . . . . . 1 SYN Customer On Credit Hold . . . .YESNO DfltVal:N Valid:Y,N ChngTag:Max Notes: {AR1$(330, 1)} 43 PrimaryShipToCode . . . . . . 4 SYN Primary Ship To Code. . . . . .SHIPTO ValGroup:CRM Notes: {AR1$(331,4)} 44 DateEstablished . . . . . . . 8 SNN Date Established. . . . . . . .DATE ValGroup:AREditCustomerStatis tics ChngTag:Min Notes: {AR1$(335,6)} 45 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO DepVal:REQUIRED Notes: Default - Others are in AR_31 {AR1$(488,24)} 46 DefaultPaymentType. . . . . . 5 SYN Default Payment Type. . . . . .PAYMENTTYPE DfltVal:CHECK ValGroup:CRM Notes: e.g., CASH or AMEX {AR1$(546,5)} 47 EmailStatements . . . . . . . 1 SYN Obsolete 4.30 . . . . . . . . .YESNO DfltVal:N Valid:Y,N 48 NumberOfInvToUseInCalc. . . . 2.0 NNN Number Of Invoices To Use In Da Mask:00 Notes: (0-20) {AR1$(322,2)} 49 AvgDaysPaymentInvoice . . . . 3.0 NNN Avg Days For Payment From Invoi Mask:000 ValGroup:AREditCusto merStatistics ChngTag:Max Notes: {AR1$(316,3)} 50 AvgDaysOverDue. . . . . . . . 3.0 NNN Avg Days Overdue (Pay Date - Du Mask:000 ValGroup:AREditCusto merStatistics ChngTag:Max Notes: {AR1$(319,3)} 51 CustomerDiscountRate. . . . . 13.3 NNN Customer Discount Rate. . . . . Mask:##,###,###.000- Notes: {AR1[0]} 52 ServiceChargeRate . . . . . . 13.3 NNN Service Charge Rate . . . . . . Mask:##,###,###.000- Notes: {AR1[1]} 53 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Max Notes: {AR1[2]} 54 LastPaymentAmt. . . . . . . . 14.2 NNN Last Payment Amount . . . . . .BALANCEAMT Mask:#,###,###,###.00- ValGroup:AREditCustomerStatis tics ChngTag:CopyMax/DateLast Payment$ Notes: {AR1[3]} 55 HighestStmntBalance . . . . . 14.2 NNN Highest Statement Balance . . .BALANCEAMT Mask:#,###,###,###.00- ValGroup:AREditCustomerStatis tics ChngTag:Max Notes: {AR1[4]} 56 UnpaidServiceChrg . . . . . . 14.2 NNN Unpaid Service Charge . . . . .BALANCEAMT Mask:#,###,###,###.00- ValGroup:AREditCustomerStatis tics ChngTag:Sum Notes: {AR1[5]} 57 BalanceForward. . . . . . . . 14.2 NNN Balance Forward . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[24]} 58 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[25]} 59 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[26]} 60 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[27]} 61 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[28]} 62 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[29]} 63 OpenOrderAmt. . . . . . . . . 14.2 NNN Open Order Amount . . . . . . .BALANCEAMT Mask:#,###,###,###.00- ChngTag:Sum Notes: {AR1[30]} 64 RetentionCurrent. . . . . . . 14.2 NNN Retention Current . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 65 RetentionAging1 . . . . . . . 14.2 NNN Retention Aging 1 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 66 RetentionAging2 . . . . . . . 14.2 NNN Retention Aging 2 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 67 RetentionAging3 . . . . . . . 14.2 NNN Retention Aging 3 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 68 RetentionAging4 . . . . . . . 14.2 NNN Retention Aging 4 . . . . . . .BALANCEAMT Mask:#,###,###,###.00 ChngTag:Sum 69 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y ChngTag:Min Notes: YYYYMMDD 70 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y ChngTag:CopyMin/D ateCreated$ 71 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Min/DateCreated$ 72 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max 73 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 74 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$