     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$