File
Contents: Contains information for each order entered into the
system. Each record in this file corresponds to a separate
order.
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
|
ORDERNO
|
Numeric
|
N/A
|
10
|
0
|
The order number.
|
|
2
|
CUSTNUM
|
Numeric
|
N/A
|
10
|
0
|
The billing customer number.
|
|
3
|
CL_KEY
|
Char
|
9
|
N/A
|
N/A
|
The source key for the order.
|
|
4
|
ODR_DATE
|
Datetime
|
N/A
|
23
|
3
|
The entry date of the order.
|
|
5
|
HOLD_TYPE
|
Char
|
1
|
N/A
|
N/A
|
Type of hold on order.
|
|
6
|
PERM_HOLD
|
Bit
|
N/A
|
1
|
0
|
Order is on permanent hold.
|
|
7
|
SYS_HOLD
|
Bit
|
N/A
|
1
|
0
|
M.O.M. has placed a hold on this order.
|
|
8
|
HOLD_DATE
|
Datetime
|
N/A
|
23
|
3
|
Order Hold. If a date is entered
|
|
9
|
REL_DATE
|
Datetime
|
N/A
|
23
|
3
|
Next release date of line items on hold.
|
|
10
|
CLEAR_DATE
|
Datetime
|
N/A
|
23
|
3
|
Check clearing date.
|
|
11
|
SHIP_DATE
|
Datetime
|
N/A
|
23
|
23
|
System assigned date to indicate
|
|
12
|
CCHECK
|
Char
|
1
|
N/A
|
N/A
|
Payment control field for check and credit
|
|
13
|
PAYMETHOD
|
Char
|
2
|
N/A
|
N/A
|
Method of payment.
|
|
14
|
CASHONLY
|
Bit
|
N/A
|
1
|
0
|
Designates COD cash only request.
|
|
15
|
CARDNUM
|
Char
|
60
|
N/A
|
N/A
|
Credit Card Number.
|
|
16
|
CARDTYPE
|
Char
|
2
|
N/A
|
P
|
Credit Card type.
|
|
17
|
EXP
|
Char
|
5
|
N/A
|
N/A
|
Credit card Expiration date - 'mm/yy'.
|
|
18
|
APPROVAL
|
Char
|
10
|
N/A
|
N/A
|
Last approval number for credit card.
|
|
19
|
CCCORR
|
Bit
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
20
|
SHIPLIST
|
Char
|
3
|
N/A
|
N/A
|
Designated shipping method for order.
|
|
21
|
TAX
|
Numeric
|
N/A
|
9
|
2
|
Tax total on order.
|
|
22
|
SHIPPING
|
Numeric
|
N/A
|
8
|
2
|
Shipping total on order.
|
|
23
|
OTHERCOST
|
Numeric
|
N/A
|
8
|
2
|
Total Finance Charges on order.
|
|
24
|
CHECKAMOUN
|
Numeric
|
N/A
|
9
|
2
|
Total Payments made to date.
|
|
25
|
ORD_TOTAL
|
Numeric
|
N/A
|
9
|
2
|
Total amount of order including all merchandise.
|
|
26
|
CHARGED
|
Numeric
|
N/A
|
9
|
2
|
RESERVED.
|
|
27
|
CORRECTIN
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
28
|
CORRECTLC
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
29
|
INVOICED
|
Bit
|
N/A
|
1
|
0
|
Set to True after first invoice
|
|
30
|
LASTINV
|
Char
|
1
|
N/A
|
N/A
|
Last Invoice Part Code
|
|
31
|
VCOUNT
|
Numeric
|
N/A
|
2
|
0
|
Total # of Credit card vouchers generated.
|
|
32
|
LABELED
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
33
|
LABELS
|
Numeric
|
N/A
|
1
|
0
|
Number of extra Box labels to generate.
|
|
34
|
DLABELS
|
Numeric
|
N/A
|
2
|
0
|
RESERVED.
|
|
35
|
COMPLETED
|
Bit
|
N/A
|
1
|
0
|
Set to True only when an order
|
|
36
|
CAN_ORD
|
Bit
|
N/A
|
1
|
0
|
Set to True when an order is cancelled.
|
|
37
|
MULTISHIP
|
Bit
|
N/A
|
1
|
0
|
Set to True when a ship ahead
|
|
38
|
NINV
|
Numeric
|
N/A
|
9
|
2
|
Number of items invoiced.
|
|
39
|
NFILL
|
Numeric
|
N/A
|
9
|
2
|
Number of items in a filled state.
|
|
40
|
NPACK
|
Numeric
|
N/A
|
9
|
2
|
Number of items in a packed state.
|
|
41
|
NSHIP
|
Numeric
|
N/A
|
9
|
2
|
Number of items shipped.
|
|
42
|
NBOR
|
Numeric
|
N/A
|
9
|
2
|
Number of items back ordered.
|
|
43
|
VBOR
|
Numeric
|
N/A
|
9
|
2
|
Value (in $) of back ordered merchandise.
|
|
44
|
VDSB
|
Numeric
|
N/A
|
9
|
2
|
Value (in $) of drop shipped merchandise.
|
|
45
|
VITEMHOLDS
|
Numeric
|
N/A
|
9
|
2
|
Value (in $) of items on hold.
|
|
46
|
NALL
|
Numeric
|
N/A
|
9
|
2
|
Total number of items on the order.
|
|
47
|
NITEMHOLDS
|
Numeric
|
N/A
|
9
|
2
|
Number of items on hold.
|
|
48
|
EXTRA
|
Numeric
|
N/A
|
3
|
0
|
RESERVED.
|
|
49
|
SHIPNUM
|
Numeric
|
N/A
|
10
|
0
|
The shipping address customer number.
|
|
50
|
DORD
|
Numeric
|
N/A
|
9
|
2
|
Number of drop ship items ordered.
|
|
51
|
DBOR
|
Numeric
|
N/A
|
9
|
2
|
Number of drop ship items not yet
|
|
52
|
DFILL
|
Numeric
|
N/A
|
9
|
2
|
Number of drop ship items verified.
|
|
53
|
DPACK
|
Numeric
|
N/A
|
9
|
2
|
Number of drop ship items packed.
|
|
54
|
DSHIP
|
Numeric
|
N/A
|
9
|
2
|
Number of drop ship items shipped.
|
|
55
|
DALL
|
Numeric
|
N/A
|
9
|
2
|
Total number of drop ship items.
|
|
56
|
PROCSSD
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
57
|
USERID
|
Char
|
3
|
N/A
|
N/A
|
Operator ID.
|
|
58
|
LAST_USER
|
Char
|
3
|
N/A
|
N/A
|
Last operator ID to access
|
|
59
|
EXTRA2
|
Char
|
3
|
N/A
|
N/A
|
RESERVED.
|
|
60
|
CHECKNUM
|
Char
|
20
|
N/A
|
N/A
|
Check Number which accompanied the
|
|
61
|
PREVORD
|
Numeric
|
N/A
|
8
|
0
|
The number of the previous order placed
|
|
62
|
CZONE
|
Char
|
3
|
N/A
|
N/A
|
System determined Zone.
|
|
63
|
C_TABLE
|
Char
|
1
|
N/A
|
N/A
|
System determined Cost Table.
|
|
64
|
PICKED
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
65
|
VNTM
|
Numeric
|
N/A
|
9
|
2
|
Value (in $) of Tax Exempt merchandise.
|
|
66
|
SHIPTYPE
|
Char
|
1
|
N/A
|
N/A
|
Determines the type of shipping address.
|
|
67
|
NTAXRATE
|
Numeric
|
N/A
|
7
|
4
|
National Tax Rate.
|
|
68
|
STAXRATE
|
Numeric
|
N/A
|
7
|
4
|
State/Province Tax Rate.
|
|
69
|
CTAXRATE
|
Numeric
|
N/A
|
7
|
4
|
County Tax Rate.
|
|
70
|
ITAXRATE
|
Numeric
|
N/A
|
7
|
4
|
City Tax Rate.
|
|
71
|
TAXSHIP
|
Bit
|
N/A
|
1
|
0
|
Determines whether tax is charged on
|
|
72
|
DUE_DAYS
|
Numeric
|
N/A
|
3
|
0
|
RESERVED.
|
|
73
|
TB_MERCH
|
Numeric
|
N/A
|
10
|
2
|
Total $ of Billed Merchandise.
|
|
74
|
SALES_ID
|
Char
|
3
|
N/A
|
N/A
|
Salesperson ID code for this order.
|
|
75
|
TB_SHIP
|
Numeric
|
N/A
|
8
|
2
|
Total $ of Billed Shipping charges.
|
|
76
|
NOTYETUSED
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
77
|
TB_TAX
|
Numeric
|
N/A
|
8
|
2
|
Total $ of Billed Taxes.
|
|
78
|
TB_NONTAX
|
Numeric
|
N/A
|
10
|
2
|
Total $ of Billed Non-Taxable Merchandise.
|
|
79
|
SHIPMODIFY
|
Bit
|
N/A
|
1
|
0
|
Set to Yes if shipping charges are modified
|
|
80
|
CATCODE
|
Char
|
6
|
N/A
|
N/A
|
The Catalog Code for this order.
|
|
81
|
NEEDWEIGHT
|
Bit
|
N/A
|
1
|
0
|
Used to determine if the order needs
|
|
82
|
TAXMODIFY
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
83
|
ORDER_ST2
|
Char
|
2
|
N/A
|
N/A
|
RESERVED.
|
|
84
|
TELE_CODE
|
Numeric
|
N/A
|
1
|
0
|
Interest level for telemarketing call.
|
|
85
|
TELEDONE
|
Bit
|
N/A
|
1
|
0
|
Telemarketing call made for this order
|
|
86
|
OVERPAY
|
Numeric
|
N/A
|
10
|
2
|
$
amount of over payment.
|
|
87
|
ACC_STATE
|
Char
|
2
|
N/A
|
N/A
|
Accounting state of order.
|
|
88
|
NEXT_PAY
|
Numeric
|
N/A
|
10
|
2
|
$
amount of next payment.
|
|
89
|
TB_FINCHAR
|
Numeric
|
N/A
|
9
|
2
|
Total $ of billed finance charges.
|
|
90
|
ALT_ORDER
|
Char
|
25
|
N/A
|
N/A
|
An order id number that can be assigned.
|
|
91
|
NTAXSHIP
|
Bit
|
N/A
|
1
|
0
|
Designates shipping charges will not be taxed at the national
level.
|
|
92
|
QUOTATION
|
Bit
|
N/A
|
1
|
0
|
Order is currently a quotation.
|
|
93
|
INTERNETID
|
Char
|
32
|
N/A
|
N/A
|
Order number assigned by SiteLINK.
|
|
94
|
POPENTRY
|
Bit
|
N/A
|
1
|
0
|
Designates a point of sale order.
|
|
95
|
CARDINLIST
|
Bit
|
N/A
|
1
|
0
|
Indicates credit card is in customer's card list..
|
|
96
|
DISCT_PCT
|
Numeric
|
N/A
|
4
|
1
|
RESERVED.
|
|
97
|
DISCT_DAYS
|
Numeric
|
N/A
|
3
|
0
|
RESERVED.
|
|
98
|
MULTIPAY
|
Bit
|
N/A
|
1
|
0
|
Order has multiple payment methods.
|
|
99
|
CC_CID
|
Char
|
4
|
N/A
|
N/A
|
RESERVED.
|
|
100
|
POINTS_USD
|
Numeric
|
N/A
|
8
|
0
|
Points used on order.
|
|
101
|
ORDERTYPE
|
Char
|
6
|
N/A
|
N/A
|
User defined order type.
|
|
102
|
PONUMBER
|
Char
|
17
|
N/A
|
N/A
|
Purchase order number.
|
|
103
|
CARDHOLDER
|
Char
|
30
|
N/A
|
N/A
|
RESERVED.
|
|
104
|
NEEDSCAN
|
Bit
|
N/A
|
1
|
0
|
Used to determine if order needs scanning
|
|
105
|
NEED_GC
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
106
|
BILLED
|
Bit
|
N/A
|
1
|
0
|
Order has been billed.
|
|
107
|
R_MERCH
|
Numeric
|
N/A
|
10
|
2
|
Dollar amount of merchandise ready to bill.
|
|
108
|
R_TAX
|
Numeric
|
N/A
|
8
|
2
|
Dollar amount of taxes ready to bill.
|
|
109
|
NR_MERCH
|
Numeric
|
N/A
|
10
|
2
|
Dollar amount of merchandise not ready to bill.
|
|
110
|
NR_TAX
|
Numeric
|
N/A
|
8
|
2
|
Dollar amount of taxes not ready to bill.
|
|
111
|
P_MERCH
|
Numeric
|
N/A
|
10
|
2
|
Dollar amount of merchandise already packed.
|
|
112
|
P_TAX
|
Numeric
|
N/A
|
8
|
2
|
Dollar amount of taxes on packed merchandise.
|
|
113
|
P_SHIP
|
Numeric
|
N/A
|
8
|
2
|
Dollar amount of shipping on packed merchandise.
|
|
114
|
HOLDNOTE
|
Char
|
50
|
N/A
|
N/A
|
Notes for why order
|
|
115
|
SOLDNUM
|
Numeric
|
N/A
|
8
|
0
|
The sold-to customer number.
|
|
116
|
TPSHIPTYPE
|
Numeric
|
N/A
|
1
|
0
|
RESERVED.
|
|
117
|
TPSHIPWHAT
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
118
|
TPSHIPACCT
|
Char
|
14
|
N/A
|
N/A
|
RESERVED.
|
|
119
|
TPSHIPCC
|
Char
|
19
|
N/A
|
N/A
|
RESERVED.
|
|
120
|
TPSHIPEXP
|
Char
|
5
|
N/A
|
N/A
|
RESERVED.
|
|
121
|
ENTRYTIME
|
Datetime
|
N/A
|
23
|
3
|
Date and time order was created.
|
|
122
|
FREIGHTCOL
|
Bit
|
N/A
|
1
|
0
|
Freight collect flag for UPS 3rd Party Billing.
|
|
123
|
INTERNET
|
Bit
|
N/A
|
1
|
0
|
Indicates order was placed over the Internet
|
|
124
|
PROCSSBY
|
Char
|
3
|
N/A
|
N/A
|
User ID that processed the order.
|
|
125
|
CCINQ-REQ
|
Bit
|
N/A
|
1
|
0
|
Used by Authorize.net
|
|
126
|
REMOVECC
|
Bit
|
N/A
|
1
|
0
|
Indicates the credit card was removed from the customer's card
list.
|
|
127
|
ITEM_ID
|
Numeric
|
N/A
|
12
|
0
|
Additional item added from order promotion.
|
|
128
|
NO_PROMO
|
Bit
|
N/A
|
1
|
0
|
Indicates if an order promotion has not been applied
|
|
129
|
PRIORITY
|
Char
|
1
|
N/A
|
N/A
|
Order Priority.
|
|
130
|
CHARGE_ALL
|
Bit
|
N/A
|
1
|
0
|
Charges entire order, includes backorder items.
|
|
131
|
ISSUE_NUM
|
Char
|
2
|
N/A
|
N/A
|
UK Only.
|
|
132
|
FRDATE
|
Char
|
5
|
N/A
|
N/A
|
UK Only.
|
|
133
|
ORDPROMO
|
Char
|
10
|
N/A
|
N/A
|
Order promotion code.
|
|
134
|
ORDERSET
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
135
|
ROUTINGNUM
|
Char
|
30
|
N/A
|
N/A
|
Bank's Routing Number for eCheck Payment.
|
|
136
|
ACCOUNTNUM
|
Char
|
60
|
N/A
|
N/A
|
Account Number for eCheck Payment.
|
|
137
|
ACCTTYPE
|
Char
|
10
|
N/A
|
N/A
|
Account Type for eCheck Payment.
|
|
138
|
BANKNAME
|
Char
|
30
|
N/A
|
N/A
|
Bank's Name for eCheck Payment.
|
|
139
|
PAYPALID
|
Char
|
90
|
N/A
|
N/A
|
Paypal Account ID
|
|
140
|
ENCTYPE
|
Int
|
N/A
|
10
|
0
|
RESERVED.
|
|
141
|
PINENTRY
|
Bit
|
N/A
|
1
|
0
|
UK Only.
|
|
142
|
BADLABEL
|
Bit
|
N/A
|
1
|
0
|
For orders paid by Invoice, indicates the date the order will be
due for payment.
|
|
143
|
HOLDCODE
|
Char
|
10
|
N/A
|
N/A
|
Order Hold Reason Code selected.
|
|
144
|
DUE_ONDATE
|
Datetime
|
N/A
|
23
|
3
|
For orders paid by Invoice, indicates the date the order will be
due for payment.
|
|
145
|
URL_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
