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$