|
The following is useful information for more advanced uses of AnyOrder. It describes the structure of the User Defined Fields data file.
Fields data for UserDef.dbf. Holds User Defined Fields and shipping information. It is related to Sales.dbf by Invoice Number.
UserDef.dbf
Purpose: This provides user defined fields associated with invoices. Also provides Address3 if user needs it. And it provide fields for UPS, FedEx & USPS shipping
Relation: Related to Sales.dbf (Invoice Database) by the field Invoice_No
|
|
|
|
|
|
|
|
|
|
|
|
Field
|
Field Name
|
Type
|
Length
|
Dec
|
Description
|
1
|
INVOICE_NO
|
NUMERIC
|
6
|
|
Invoice number - related to Invoice_No in Sales.dbf
|
2
|
USERDEF1
|
CHARACTER
|
40
|
|
User Defined Field
|
3
|
USERDEF2
|
CHARACTER
|
40
|
|
User Defined Field
|
4
|
USERDEF3
|
CHARACTER
|
40
|
|
User Defined Field
|
5
|
USERDEF4
|
CHARACTER
|
40
|
|
User Defined Field
|
6
|
USERDEF5
|
CHARACTER
|
40
|
|
User Defined Field
|
7
|
USERDEF6
|
LOGICAL
|
1
|
|
User Defined Field
|
8
|
USERDEF7
|
LOGICAL
|
1
|
|
User Defined Field
|
9
|
USERDEF8
|
CHARACTER
|
16
|
|
User Defined Field
|
10
|
USERDEF9
|
CHARACTER
|
16
|
|
User Defined Field
|
11
|
USERDEF10
|
CHARACTER
|
40
|
|
User Defined Field
|
12
|
USERDEF11
|
NUMERIC
|
12
|
2
|
User Defined Field
|
13
|
USERDEF12
|
NUMERIC
|
12
|
2
|
User Defined Field
|
14
|
USERDEF13
|
DATE
|
8
|
|
User Defined Field
|
15
|
SHIPPER
|
CHARACTER
|
10
|
|
Name of Shipper
|
16
|
SERVICE
|
CHARACTER
|
28
|
|
Type of Shipping Service
|
17
|
PACKAGING
|
CHARACTER
|
28
|
|
Type of Packaging
|
18
|
CONTACT
|
CHARACTER
|
33
|
|
Contact Name on the Shipping Label
|
19
|
EMAIL_ADD
|
CHARACTER
|
35
|
|
Customer's email address used by shipping company
|
20
|
PHONE_NO
|
CHARACTER
|
20
|
|
Customer's phone number used by shipping company
|
21
|
NOTIFY_RS
|
LOGICAL
|
1
|
|
Notify recipient that package has shipped
|
22
|
WEIGHT_LBS
|
NUMERIC
|
6
|
|
Weight in lbs
|
23
|
WEIGHT_OZ
|
NUMERIC
|
2
|
|
Weight in ounces
|
24
|
LBS_ONLY
|
NUMERIC
|
6
|
|
Weight rounded in lbs
|
25
|
LBS_TENTHS
|
NUMERIC
|
8
|
1
|
Weight as a decimal
|
26
|
WEIGHT_KG
|
NUMERIC
|
8
|
3
|
Weight In Kg's
|
27
|
PKG_LENGTH
|
NUMERIC
|
5
|
|
Package Length
|
28
|
PKG_WIDTH
|
NUMERIC
|
5
|
|
Package Width
|
29
|
PKG_HEIGHT
|
NUMERIC
|
5
|
|
Package Height
|
30
|
RESIDENCE
|
LOGICAL
|
1
|
|
Is the shipper sending to a residence
|
31
|
INSURE_VAL
|
NUMERIC
|
10
|
|
Insured value
|
32
|
SAME_ZIP
|
CHARACTER
|
10
|
|
For USPS - Is zip the same?
|
33
|
NEW_ZIP
|
CHARACTER
|
5
|
|
Not used
|
34
|
NO_PKGS
|
NUMERIC
|
2
|
|
Number of Packages
|
35
|
OVERSIZE
|
LOGICAL
|
1
|
|
Is this an oversized package
|
36
|
HANDLING
|
LOGICAL
|
1
|
|
Special Handling required?
|
37
|
PICK_UP
|
LOGICAL
|
1
|
|
Schedule a pickup?
|
38
|
REFERENCE1
|
CHARACTER
|
25
|
|
Reference 1
|
39
|
REFERENCE2
|
CHARACTER
|
25
|
|
Reference 2
|
40
|
FILE_EXPRT
|
LOGICAL
|
1
|
|
Internal field
|
41
|
UPS_OVERSZ
|
CHARACTER
|
2
|
|
UPS Oversized Package
|
42
|
NOTIFY_RD
|
LOGICAL
|
1
|
|
Notify recipient that package has been delivered
|
43
|
NOTIFY_SS
|
LOGICAL
|
1
|
|
Notify user (shipper) that package has been sent
|
44
|
NOTIFY_SD
|
LOGICAL
|
1
|
|
Notify user (shipper) that package has been delivered
|
45
|
COMPANY
|
CHARACTER
|
33
|
|
Ship-to business name
|
46
|
ADDRESS_1
|
CHARACTER
|
33
|
|
Ship-to Address1
|
47
|
ADDRESS_2
|
CHARACTER
|
33
|
|
Ship-to Address2
|
48
|
USELECT
|
LOGICAL
|
1
|
|
Internal field
|
49
|
COMMISSION
|
NUMERIC
|
10
|
2
|
Not used
|
50
|
UPS_PAYMNT
|
NUMERIC
|
2
|
|
Type of billing for UPS
|
|
|
|
|
|
|
|
TOTAL
|
|
712
|
|
|
| 
