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$