File
Contents: Contains the individual line items in each order in the
system.
The column
headings in the table include the following.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
ORDERNO
|
Numeric
|
8
|
N/A
|
Order number to which item belongs.
|
|
2
|
ITEM_ID
|
Integer
(Auto Increment)
|
10
|
N/A
|
Line item tracking number.
|
|
3
|
INPART
|
Character
|
1
|
N/A
|
Invoice part code on which this item
|
|
4
|
ITEM
|
Character
|
20
|
N/A
|
Stock item number.
|
|
5
|
QUANTO
|
Numeric
|
9
|
2
|
Quantity ordered.
|
|
6
|
QUANTF
|
Numeric
|
9
|
2
|
Quantity filled.
|
|
7
|
QUANTB
|
Numeric
|
9
|
2
|
Quantity back ordered.
|
|
8
|
QUANTP
|
Numeric
|
9
|
2
|
Quantity pending shipment.
|
|
9
|
QUANTS
|
Numeric
|
9
|
2
|
Quantity shipped.
|
|
10
|
ADVERT
|
Character
|
9
|
N/A
|
Source key.
|
|
11
|
IT_UNCOST
|
Numeric
|
12
|
4
|
Unit cost.
|
|
12
|
IT_UNLIST
|
Numeric
|
12
|
4
|
Unit list price.
For MOM UK, indicates price without VAT.
|
|
13
|
DROP
|
Logical
|
1
|
N/A
|
Drop ship item.
|
|
14
|
ORDERED
|
Logical
|
1
|
N/A
|
Drop ship item order status.
|
|
15
|
BILLED
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
16
|
OVERSIZED
|
Logical
|
1
|
N/A
|
Used to determine if item is oversize UPS 1.
|
|
17
|
BOX
|
Numeric
|
2
|
N/A
|
Box/package number.
|
|
18
|
DISCOUNT
|
Numeric
|
3
|
N/A
|
Discount on this item.
|
|
19
|
PICKED
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
20
|
R_CODE
|
Character
|
1
|
N/A
|
Product return code indicator.
|
|
21
|
INT_EXT
|
Logical
|
1
|
N/A
|
RESRVED.
|
|
22
|
IT_SDATE
|
Date
|
8
|
N/A
|
Ship date of this item.
|
|
23
|
DESC
|
Character
|
30
|
N/A
|
Custom description.
|
|
24
|
NONTAX
|
Logical
|
1
|
N/A
|
Tax status.
|
|
25
|
NONPRODUCT
|
Logical
|
1
|
N/A
|
Non-Product Indicator.
|
|
26
|
SALES_ID
|
Character
|
3
|
N/A
|
Sales ID on the order.
|
|
27
|
PRICECHANG
|
Logical
|
1
|
N/A
|
Price has changed indicator.
|
|
28
|
EXTENDDESC
|
Logical
|
1
|
N/A
|
Indicates the entry is an extended
|
|
29
|
CATCODE
|
Character
|
6
|
N/A
|
Catalog Code for this order.
|
|
30
|
CUSTOMINFO
|
Memo
|
4
|
N/A
|
Extended description of item.
|
|
31
|
ITEM_STATE
|
Character
|
2
|
N/A
|
State of the item in inventory.
|
|
32
|
PONUMBER
|
Numeric
|
8
|
N/A
|
Purchase ordr number for item.
|
|
33
|
N_NONTAX
|
Logical
|
1
|
N/A
|
National tax exempt flag.
|
|
34
|
TAXMODIFY
|
Logical
|
1
|
N/A
|
FUTURE USE.
|
|
35
|
INVENT_ID
|
Numeric
|
10
|
N/A
|
Inventory Lot ID.
|
|
36
|
QUOTATION
|
Logical
|
1
|
N/A
|
Quotation item indicator.
|
|
37
|
POPENTRY
|
Logical
|
1
|
N/A
|
Indicates a POP order.
|
|
38
|
SHIP_VIA
|
Character
|
3
|
N/A
|
Shipping method related to item.
|
|
39
|
SHIP_FROM
|
Character
|
6
|
N/A
|
Warehouse item is shipped from.
|
|
40
|
SHIP_TO
|
Numeric
|
10
|
N/A
|
Customer number the item is shipped to.
|
|
41
|
SHIP_WHEN
|
Date
|
8
|
N/A
|
Date the item is on hold until.
|
|
42
|
SHIP_DATE
|
Date
|
8
|
N/A
|
FUTURE USE.
|
|
43
|
CERTID
|
Numeric
|
8
|
N/A
|
Gift Cerftificate ID.
|
|
44
|
GCERTPRINT
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
45
|
PTS_RDEEMD
|
Logical
|
1
|
N/A
|
Points redeemed for this item.
|
|
46
|
TRANS_ID
|
Numeric
|
10
|
N/A
|
Transaction number.
|
|
47
|
NEEDSCAN
|
Logical
|
1
|
N/A
|
Used to determine if item needs scanning.
|
|
48
|
PACKED
|
Logical
|
1
|
N/A
|
Used to determine if item is packed.
|
|
49
|
NTAXCODE
|
Character
|
3
|
N/A
|
Country code.
|
|
50
|
STAXCODE
|
Character
|
3
|
N/A
|
State code.
|
|
51
|
CTAXCODE
|
Character
|
3
|
N/A
|
County code.
|
|
52
|
ITAXCODE
|
Character
|
5
|
N/A
|
City code.
|
|
53
|
NTAXCLASS
|
Character
|
1
|
N/A
|
Country tax class.
|
|
54
|
STAXCLASS
|
Character
|
1
|
N/A
|
State tax class.
|
|
55
|
NTAXRATE
|
Numeric
|
7
|
4
|
Country tax rate.
|
|
56
|
STAXRATE
|
Numeric
|
7
|
4
|
State tax rate.
|
|
57
|
CTAXRATE
|
Numeric
|
7
|
4
|
County tax rate.
|
|
58
|
ITAXRATE
|
Numeric
|
7
|
4
|
City tax rate.
|
|
59
|
OVERSIZE2
|
Logical
|
1
|
N/A
|
Used to determine if item is oversize UPS 2.
|
|
60
|
BIN_ID
|
Numeric
|
10
|
N/A
|
Bin ID number.
|
|
61
|
BINMODIFY
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
62
|
WAREMODIFY
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
63
|
CTAXCLASS
|
Character
|
1
|
N/A
|
County tax class.
|
|
64
|
ITAXCLASS
|
Character
|
1
|
N/A
|
City tax class.
|
|
65
|
C_NONTAX
|
Logical
|
1
|
N/A
|
County tax exempt flag.
|
|
66
|
I_NONTAX
|
Logical
|
1
|
N/A
|
City tax exempt flag.
|
|
67
|
NTAXCAP
|
Numeric
|
4
|
N/A
|
Special national tax case.
|
|
68
|
STAXCAP
|
Numeric
|
4
|
N/A
|
Special
state tax case.
|
|
69
|
CTAXCAP
|
Numeric
|
4
|
N/A
|
Special county tax case.
|
|
70
|
ITAXCAP
|
Numeric
|
4
|
N/A
|
Special zip code tax case.
|
|
71
|
NTAXTHRES
|
Numeric
|
4
|
N/A
|
Special
national tax case.
|
|
72
|
STAXTHRES
|
Numeric
|
4
|
N/A
|
Special state tax case.
|
|
73
|
CTAXTHRES
|
Numeric
|
4
|
N/A
|
Special county tax case.
|
|
74
|
ITAXTHRES
|
Numeric
|
4
|
N/A
|
Special zip code tax case.
|
|
75
|
VATINCL
|
Logical
|
1
|
N/A
|
UK Only. Indicates whether or not the normal retail selling price
of the item included VAT.
|
|
76
|
VATAMT
|
Numeric
|
9
|
N/A
|
UK Only. Value Added Tax amount.
|
|
77
|
COMMITDATE
|
Date
|
8
|
N/A
|
FUTURE USE.
|
|
78
|
OVERSIZE3
|
Logical
|
1
|
N/A
|
Used to determine if item is oversize UPS 3.
|
|
79
|
VATLIST
|
Numeric
|
12
|
4
|
UK Only. Price including VAT.
|
|
80
|
ALT_ITEMID
|
Character
|
30
|
N/A
|
Imported Item ID.
|
|
81
|
BHEIGHT
|
Numeric
|
3
|
0
|
Item Height.
|
|
82
|
BLENGTH
|
Numeric
|
3
|
0
|
Item Length.
|
|
83
|
BWIDTH
|
Numeric
|
3
|
0
|
Item Width.
|
|
84
|
NODSCT
|
Logical
|
1
|
N/A
|
Indicates if the item is exempt from discounts.
|
|
85
|
RETITEM
|
Character
|
20
|
N/A
|
SKU number that
will receive the inventory when this
item is returned.
|
|
86
|
SEQ
|
Integer
|
4
|
N/A
|
Indicates the line number in which this item will appear on an
order.
|
