|
|
|
|
|
|
|
|
|
|
|
|
Field
|
Field Name
|
Type
|
Length
|
Dec
|
Description
|
1
|
CUST_NO
|
NUMERIC
|
5
|
|
Customer Number
|
2
|
BILL_NO
|
NUMERIC
|
5
|
|
Billing Number - groups customers together for billings, ie, Baker & Taylor warehouses are set-up with separate customer numbers but they all will have the same billing number
|
3
|
BILL_NAME1
|
CHARACTER
|
33
|
|
Billing Name
|
4
|
ADDRESS11
|
CHARACTER
|
33
|
|
Billing Address1
|
5
|
ADDRESS21
|
CHARACTER
|
33
|
|
Billing Address2
|
6
|
CITY1
|
CHARACTER
|
16
|
|
Billing City
|
7
|
STATE1
|
CHARACTER
|
3
|
|
Billing State
|
8
|
ZIP_CODE1
|
CHARACTER
|
10
|
|
Billing Zip Code
|
9
|
ZIP_EXT1
|
CHARACTER
|
1
|
|
Zip_Ext1 is no longer - Extension is included in Zip Code above
|
10
|
COUNTRY
|
CHARACTER
|
20
|
|
Billing Country
|
11
|
SHIP_NAME1
|
CHARACTER
|
33
|
|
Shipping Name
|
12
|
ADD11
|
CHARACTER
|
33
|
|
Shipping Address1
|
13
|
ADD21
|
CHARACTER
|
33
|
|
Shipping Address2
|
14
|
CIT1
|
CHARACTER
|
16
|
|
Shipping City
|
15
|
ST1
|
CHARACTER
|
3
|
|
Shipping State
|
16
|
ZIP1
|
CHARACTER
|
10
|
|
Shipping Zip Code
|
17
|
SZIP_EXT1
|
CHARACTER
|
1
|
|
SZip_Ext1 is no longer - Extension is included in Zip Code above
|
18
|
SCOUNTRY
|
CHARACTER
|
20
|
|
Shipping Country
|
19
|
COMVENDOR
|
LOGICAL
|
1
|
|
Is this a consignment only customer?
|
20
|
SUMMARY
|
CHARACTER
|
30
|
|
Combination of the Billing Name and Shipping location used on pop-up lists
|
21
|
DISCOUNT
|
NUMERIC
|
4
|
1
|
Discount normally given to this customer
|
22
|
NETDAYS
|
NUMERIC
|
3
|
|
Number of days that this customer has to pay off the invoice
|
23
|
SHIPVIA
|
CHARACTER
|
25
|
|
Shipping method desired by this customer
|
24
|
LABELPO
|
LOGICAL
|
1
|
|
Include the customer's PO Number on the shipping label
|
25
|
SHIPPAID
|
LOGICAL
|
1
|
|
The user pays the shipping for this customer
|
26
|
CUSTNOTES
|
MEMO
|
10
|
|
A Memo field that holds the user's notes about the customer.
|
27
|
PHONE1
|
CHARACTER
|
20
|
|
Customer's phone number
|
28
|
MAINOFFICE
|
LOGICAL
|
1
|
|
Is this the main office where billing statements should be sent
|
29
|
MAINEMAIL
|
CHARACTER
|
35
|
|
Customer's main email address
|
30
|
RSELECTED
|
LOGICAL
|
1
|
|
Internal field used by the program for selection purposes
|
31
|
INVCODE
|
CHARACTER
|
3
|
|
Invoice code - if used - associated with this customer
|
32
|
REPCODE
|
CHARACTER
|
3
|
|
Sales Representative Code associated with this customer - if any
|
33
|
ADCODE
|
CHARACTER
|
3
|
|
Ad campaign code associated with this customer - if any
|
34
|
TAXABLE
|
LOGICAL
|
1
|
|
Is this customer always taxed?
|
35
|
TAXCODE
|
CHARACTER
|
3
|
|
Customer tax code if the user has different taxing rates depending upon geographic area
|
36
|
NOROYALTY
|
LOGICAL
|
1
|
|
True if the royalty holder does not receive royalties for sales to this customer
|
37
|
USERCODE
|
CHARACTER
|
1
|
|
A code that the user can have show on customer pop-up lists
|
38
|
EOMBILLING
|
LOGICAL
|
1
|
|
Does this customer have End of Month billings? If not, billings are based on DOI (Date of Invoice)
|
39
|
NO_TERMS
|
LOGICAL
|
1
|
|
Not used
|
40
|
ADDRESS31
|
CHARACTER
|
40
|
|
Billing Third address - not used unless customer turns it on
|
41
|
ADD31
|
CHARACTER
|
40
|
|
Shipping Third address - not used unless customer turns it on
|
42
|
PRICELEVEL
|
NUMERIC
|
1
|
|
Pricing Level - In the product database, customer can set-up different pricing levels for a product.
|
43
|
PREV_LTV
|
NUMERIC
|
12
|
2
|
Previous Life Time Value (of goods sold to this customer)
|
44
|
LATEST_LTV
|
NUMERIC
|
12
|
2
|
Latest Life time Value
|
45
|
TOTAL_LTV
|
NUMERIC
|
12
|
2
|
Total Life time value
|
46
|
ASOF_LTV
|
DATE
|
8
|
|
Date at which the latest life time value was calculated
|
47
|
INV_LTV
|
NUMERIC
|
6
|
|
Not used
|
48
|
CRED_LIMIT
|
NUMERIC
|
12
|
2
|
The customer's credit limit
|
49
|
OTHER_ID
|
CHARACTER
|
25
|
|
An ID number associated with this customer
|
50
|
OVER_LIMIT
|
CHARACTER
|
1
|
|
Is this customer over their credit limit
|
51
|
CONTACT
|
CHARACTER
|
33
|
|
An attention field that can be used by shipping companies if a name is need in addition to company name
|
52
|
P_OTHER_ID
|
LOGICAL
|
1
|
|
When true, print the customer's other ID on the printed invoice
|
53
|
UDF1
|
CHARACTER
|
25
|
|
User defined field
|
54
|
UDF2
|
CHARACTER
|
25
|
|
User defined field
|
55
|
UDF3
|
CHARACTER
|
20
|
|
User defined field
|
56
|
UDF4
|
CHARACTER
|
8
|
|
User defined field
|
57
|
DROPSHIP
|
LOGICAL
|
1
|
|
Orders with this customer are drop shipped elsewhere
|
58
|
MARKED
|
LOGICAL
|
1
|
|
Internal field used by the program for selection purposes
|
-------
|
-------------
|
--------------
|
-------
|
------
|
|
Total
|
|
|
741
|
|
|