File
Contents: Contains all of the customer information in the
system.
The column
headings in the table include the following.
Text- a field with a large character limit.
Bit- a logical
field. 0=False, 1=True
|
POSITION
|
FIELD NAME
|
TYPE
|
CHARACTER LENGTH
|
NUMERIC PRECISION
|
NUMERIC SCALE
|
DESCRIPTION
|
|
1
|
CUSTNUM
|
Numeric
|
N/A
|
10
|
0
|
The system assigned customer number.
|
|
2
|
ALTNUM
|
Char
|
15
|
N/A
|
N/A
|
The user assigned customer number.
|
|
3
|
CUSTTYPE
|
Char
|
1
|
N/A
|
N/A
|
System Assigned Customer Status.
|
|
4
|
LASTNAME
|
Char
|
20
|
N/A
|
N/A
|
Last Name.
|
|
5
|
FIRSTNAME
|
Char
|
15
|
N/A
|
N/A
|
First Name.
|
|
6
|
COMPANY
|
Char
|
40
|
N/A
|
N/A
|
Company Name.
|
|
7
|
ADDR
|
Char
|
40
|
N/A
|
N/A
|
First Address Line.
|
|
8
|
ADDR2
|
Char
|
40
|
N/A
|
N/A
|
Second Address Line.
|
|
9
|
CITY
|
Char
|
20
|
N/A
|
N/A
|
City.
|
|
10
|
COUNTY
|
Char
|
3
|
N/A
|
N/A
|
County code.
|
|
11
|
STATE
|
Char
|
3
|
N/A
|
N/A
|
State/Province
|
|
12
|
ZIPCODE
|
Char
|
10
|
N/A
|
N/A
|
ZIP Code/Postal Code
|
|
13
|
COUNTRY
|
Char
|
3
|
N/A
|
N/A
|
Country code.
|
|
14
|
PHONE
|
Char
|
14
|
N/A
|
N/A
|
Format (xxx) xxx-xxxx
|
|
15
|
PHONE2
|
Char
|
14
|
N/A
|
N/A
|
Format (xxx) xxx-xxxx
|
|
16
|
ORIG_AD
|
Char
|
9
|
N/A
|
N/A
|
Original Source key designator.
|
|
17
|
CTYPE
|
Char
|
1
|
N/A
|
N/A
|
User defined Customer type.
|
|
18
|
LAST_AD
|
Char
|
9
|
N/A
|
N/A
|
Last source key designator.
|
|
19
|
CATCOUNT
|
Numeric
|
N/A
|
3
|
0
|
Total count of catalogs mailed.
|
|
20
|
ODR_DATE
|
Datetime
|
N/A
|
23
|
3
|
Last date of activity.
|
|
21
|
PAYMETHOD
|
Char
|
2
|
N/A
|
N/A
|
Last method of payment used.
|
|
22
|
CARDNUM
|
Char
|
60
|
N/A
|
N/A
|
Last credit card used.
|
|
23
|
CARDTYPE
|
Char
|
2
|
N/A
|
N/A
|
RESERVED.
|
|
24
|
EXP
|
Char
|
5
|
N/A
|
N/A
|
RESERVED.
|
|
25
|
SHIPLIST
|
Char
|
3
|
N/A
|
N/A
|
Last method of shipment used.
|
|
26
|
EXPIRED
|
Bit
|
N/A
|
1
|
0
|
Expired flag. A deleted customer is marked as true.
|
|
27
|
BADCHECK
|
Bit
|
N/A
|
1
|
0
|
Bad Credit Flag.
|
|
28
|
ORDERREC
|
Numeric
|
N/A
|
8
|
0
|
The most recent order placed by this
|
|
29
|
NET
|
Numeric
|
N/A
|
10
|
2
|
The total net sales from this customer.
|
|
30
|
GROSS
|
Numeric
|
N/A
|
10
|
2
|
The total gross sales from this customer.
|
|
31
|
ORD_FREQ
|
Numeric
|
N/A
|
6
|
0
|
The total number of orders placed by this customer
|
|
32
|
COMMENT
|
Char
|
60
|
N/A
|
N/A
|
Customer comment Area
|
|
33
|
CUSTBAL
|
Numeric
|
N/A
|
9
|
2
|
Misc credit/debit amount owed/due from
|
|
34
|
CUSTREF
|
Numeric
|
N/A
|
8
|
0
|
RESERVED.
|
|
35
|
DISCOUNT
|
Numeric
|
N/A
|
3
|
0
|
Standard discount applied to this customer
|
|
36
|
EXEMPT
|
Bit
|
N/A
|
1
|
0
|
Tax exempt status.
|
|
37
|
AR_BALANCE
|
Numeric
|
N/A
|
11
|
2
|
Current open A/R balance controlled
|
|
38
|
CREDIT_LIM
|
Numeric
|
N/A
|
9
|
0
|
Current credit limit
|
|
39
|
DISCT_DAYS
|
Numeric
|
N/A
|
3
|
0
|
RESERVED.
|
|
40
|
DUE_DAYS
|
Numeric
|
N/A
|
3
|
0
|
Customer terms (if established).
|
|
41
|
DISCT_PCT
|
Numeric
|
N/A
|
4
|
1
|
Discount Percentage.
|
|
42
|
PROMO_BAL
|
Numeric
|
N/A
|
6
|
2
|
Current Promotional Credit.
|
|
43
|
COMMENT2
|
Char
|
60
|
N/A
|
N/A
|
Second Comment Line.
|
|
44
|
SALES_ID
|
Char
|
3
|
N/A
|
N/A
|
Sales ID Code.
|
|
45
|
NOMAIL
|
Bit
|
N/A
|
1
|
0
|
No Mail requested indicator.
|
|
46
|
BELONGNUM
|
Numeric
|
N/A
|
10
|
0
|
This name belongs to this customer
|
|
47
|
CTYPE2
|
Char
|
2
|
N/A
|
N/A
|
Second customer type field.
|
|
48
|
CTYPE3
|
Char
|
4
|
N/A
|
N/A
|
Third customer type field.
|
|
49
|
CARROUTE
|
Char
|
4
|
N/A
|
N/A
|
Postal carrier route.
|
|
50
|
DELPOINT
|
Char
|
3
|
N/A
|
N/A
|
Postal delivery point.
|
|
51
|
NCOACHANGE
|
Char
|
3
|
N/A
|
N/A
|
FUTURE USE.
|
|
52
|
ENTRYDATE
|
Datetime
|
N/A
|
23
|
3
|
The date the customer was first entered.
|
|
53
|
SEARCHCOMP
|
Char
|
15
|
N/A
|
N/A
|
Abbreviated form of company name.
|
|
54
|
EMAIL
|
Char
|
50
|
N/A
|
N/A
|
Person's e-mail address.
|
|
55
|
N_EXEMPT
|
Bit
|
N/A
|
1
|
0
|
Indicates nationally tax exempt.
|
|
56
|
TAX_ID
|
Char
|
15
|
N/A
|
N/A
|
Tax exemption number.
|
|
57
|
CASHONLY
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
58
|
SALU
|
Char
|
6
|
N/A
|
N/A
|
Salutation of customer.
|
|
59
|
HONO
|
Char
|
6
|
N/A
|
N/A
|
Honorific of customer.
|
|
60
|
TITLE
|
Char
|
40
|
N/A
|
N/A
|
Title of customer.
|
|
61
|
NOEMAIL
|
Bit
|
N/A
|
1
|
0
|
No email requested indicator.
|
|
62
|
PASSWORD
|
Char
|
20
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
63
|
RFM
|
Numeric
|
N/A
|
5
|
0
|
RFM value.
|
|
64
|
POINTS
|
Numeric
|
N/A
|
8
|
0
|
Points accumulated.
|
|
65
|
NORENT
|
Bit
|
N/A
|
1
|
0
|
Do not rent name indicator.
|
|
66
|
ADDR_TYPE
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
67
|
WEB
|
Char
|
50
|
N/A
|
N/A
|
Web site address.
|
|
68
|
EXTENSION
|
Char
|
5
|
N/A
|
N/A
|
Phone extension.
|
|
69
|
EXTENSION2
|
Char
|
5
|
N/A
|
N/A
|
Fax extension.
|
|
70
|
DATE_LIMIT
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
71
|
START_DATE
|
Datetime
|
N/A
|
23
|
3
|
RESERVED.
|
|
72
|
END_DATE
|
Datetime
|
N/A
|
23
|
3
|
RESERVED.
|
|
73
|
FROM_MONTH
|
Numeric
|
N/A
|
2
|
0
|
RESERVED.
|
|
74
|
FROM_DAY
|
Numeric
|
N/A
|
2
|
0
|
RESERVED.
|
|
75
|
TO_MONTH
|
Numeric
|
N/A
|
2
|
0
|
RESERVED.
|
|
76
|
TO_DAY
|
Numeric
|
N/A
|
2
|
0
|
RESERVED.
|
|
77
|
ADDRISSAME
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
78
|
LASTUSER
|
Char
|
3
|
N/A
|
N/A
|
User ID of last operator to view customer.
|
|
79
|
NOPOINTS
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
80
|
UPSCOMDELV
|
Bit
|
N/A
|
1
|
0
|
UPS Commercial Delivery Indicator.
|
|
81
|
PREF_SHIP
|
Char
|
3
|
N/A
|
N/A
|
Customer preferred shipping method.
|
|
82
|
PREF_PAY
|
Char
|
2
|
N/A
|
N/A
|
Customer preferred payment method.
|
|
83
|
ADDR3
|
Char
|
40
|
N/A
|
N/A
|
UK Only
|
|
84
|
VALADDR
|
Char
|
2
|
N/A
|
N/A
|
UPS address validation.
|
|
85
|
VALDATE
|
Datetime
|
N/A
|
23
|
3
|
UPS address validation date.
|
|
86
|
SOUNDLNAME
|
Char
|
4
|
N/A
|
N/A
|
RESERVED.
|
|
87
|
ADDREXPIRE
|
Datetime
|
N/A
|
23
|
3
|
RESERVED.
|
|
88
|
ACVMEDATE
|
Datetime
|
N/A
|
23
|
3
|
RESERVED.
|
|
89
|
MODI_USER
|
Char
|
3
|
N/A
|
N/A
|
User ID of Record Modifier
|
|
90
|
MODI_DATE
|
Datetime
|
N/A
|
23
|
3
|
Last Modified Date
|
|
91
|
ACT_DATE
|
Datetime
|
N/A
|
23
|
3
|
Customer's Last Activity Date.
|
|
92
|
DSCTSTDATE
|
Datetime
|
N/A
|
23
|
3
|
Customer Discount Percentage Start Date
|
|
93
|
DSCTENDATE
|
Datetime
|
N/A
|
23
|
3
|
Customer Discount Percentage End Date
|
|
94
|
PREFWARE
|
Char
|
6
|
N/A
|
N/A
|
Preferred Warehouse Location for Order Fulfillment
|
|
95
|
BESTTTC
|
Char
|
13
|
N/A
|
N/A
|
Best Time to Call
|
|
96
|
FRAUD
|
Bit
|
N/A
|
1
|
0
|
Fraudulent Customer Indicator
|
|
97
|
NOCALL
|
Bit
|
N/A
|
1
|
0
|
Do Not Call Request Indicator
|
|
98
|
TAXID2
|
Char
|
15
|
N/A
|
N/A
|
Alternate Tax ID
|
|
99
|
EMAILDEF
|
Char
|
8
|
N/A
|
N/A
|
Preferred Email Format
|
|
100
|
EMAIL PREF
|
Char
|
5
|
N/A
|
N/A
|
Customer Contact Type Preference
|
|
101
|
NOFAX
|
Bit
|
N/A
|
1
|
0
|
Do Not Fax Request Indicator
|
