File
Contents: Contains information on each stock item setup 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
|
NUMBER
|
Char
|
20
|
N/A
|
I
|
Stock item number. If the
SIZE/COLOR field is set to T (True),
The first 10 characters will be the stock number, the following 10
will be the "Size/Color."
|
|
2
|
DESC1
|
Char
|
60
|
N/A
|
I
|
Description line 1.
|
|
3
|
DESC2
|
Char
|
60
|
N/A
|
N/A
|
Description line 2.
|
|
4
|
UNITS
|
Numeric
|
N/A
|
11
|
2
|
Number of units in stock.
|
|
5
|
LOW
|
Numeric
|
N/A
|
11
|
2
|
Reorder level threshold.
|
|
6
|
UNITWEIGHT
|
Numeric
|
N/A
|
11
|
2
|
Weight in pounds.
|
|
7
|
UNCOST
|
Numeric
|
N/A
|
12
|
5
|
Average cost value.
|
|
8
|
PRICE1
|
Numeric
|
N/A
|
9
|
3
|
Retail selling price for product.
|
|
9
|
BOUNITS
|
Numeric
|
N/A
|
11
|
2
|
Number of units back ordered.
|
|
10
|
ONORDER
|
Numeric
|
N/A
|
11
|
2
|
Number of units on order.
|
|
11
|
COMMITED
|
Numeric
|
N/A
|
11
|
2
|
Number of units sold but not shipped.
|
|
12
|
SOLD
|
Numeric
|
N/A
|
11
|
2
|
RESERVED.
|
|
13
|
RECEIVED
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
14
|
CONSTRUCT
|
Bit
|
N/A
|
1
|
0
|
Composite item flag.
|
|
15
|
BREAK_OUT
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
16
|
EXTRA
|
Char
|
2
|
N/A
|
N/A
|
RESERVED.
|
|
17
|
DROPSHIP
|
Bit
|
N/A
|
1
|
0
|
Drop ship item identifier.
|
|
18
|
CARRIER
|
Char
|
3
|
N/A
|
N/A
|
RESERVED.
|
|
19
|
POQUANT
|
Numeric
|
N/A
|
11
|
2
|
RESERVED.
|
|
20
|
REORDQUANT
|
Numeric
|
N/A
|
11
|
2
|
Current re-order quantity.
|
|
21
|
REORDPRICE
|
Numeric
|
N/A
|
9
|
3
|
Current re-order price.
|
|
22
|
ASSOC
|
Char
|
30
|
N/A
|
I
|
Product classification code.
|
|
23
|
DELDATE
|
Datetime
|
N/A
|
23
|
3
|
Expected date.
|
|
24
|
DELFLAG
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
25
|
DELUNITS
|
Numeric
|
N/A
|
11
|
2
|
RESERVED.
|
|
26
|
DELTOTAL
|
Numeric
|
N/A
|
14
|
3
|
RESERVED.
|
|
27
|
BIN
|
Char
|
16
|
N/A
|
N/A
|
Bin number.
|
|
28
|
OVERSIZE
|
Bit
|
N/A
|
1
|
0
|
Oversize UPS 1 indicator.
|
|
29
|
NOTATION
|
Char
|
60
|
N/A
|
N/A
|
Cross sell description.
|
|
30
|
INT_EXT
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
31
|
NONTAX
|
Bit
|
N/A
|
1
|
0
|
Taxable status.
|
|
32
|
SHIPCHARGE
|
Numeric
|
N/A
|
5
|
2
|
Special shipping costs.
|
|
33
|
CURSUPPLY
|
Numeric
|
N/A
|
3
|
0
|
Last used supplier level code 1-4.
|
|
34
|
DISTRIB
|
Char
|
6
|
N/A
|
P
|
Current Distributer.
|
|
35
|
DISTSTOCK
|
Char
|
30
|
N/A
|
N/A
|
Distributer Stock #.
|
|
36
|
NONPRODUCT
|
Bit
|
N/A
|
1
|
0
|
Flag to indicate that this is a service
|
|
37
|
OWN_BOX
|
Bit
|
N/A
|
1
|
0
|
Product ships in its own container.
|
|
38
|
TAX_CLASS
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
39
|
UPCCODE
|
Char
|
18
|
N/A
|
I
|
UPC code or EAN Code.
|
|
40
|
SERIAL
|
Bit
|
N/A
|
1
|
0
|
Product has serial numbers.
|
|
41
|
NEXTSER
|
Char
|
15
|
N/A
|
N/A
|
Next serial number to use.
|
|
42
|
DISCONT
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
43
|
NEEDWEIGHT
|
Bit
|
N/A
|
1
|
0
|
Product needs weighing during processing
|
|
44
|
COMMGROSS
|
Numeric
|
N/A
|
5
|
2
|
Gross $ Commission base.
|
|
45
|
COMMNET
|
Numeric
|
N/A
|
5
|
2
|
Net $ Commission base.
|
|
46
|
COMMFLAT
|
Numeric
|
N/A
|
7
|
2
|
Per unit Commission base.
|
|
47
|
SUBSPROD
|
Bit
|
N/A
|
1
|
0
|
Indicates product is a subscription
|
|
48
|
PUBLCTNCD
|
Char
|
8
|
N/A
|
N/A
|
Subscription publication code.
|
|
49
|
SUBSISUCT
|
Numeric
|
N/A
|
4
|
0
|
Subscription number of issues.
|
|
50
|
PRODXINVC
|
Bit
|
N/A
|
1
|
0
|
Subscription invoice exempt code.
|
|
51
|
ROYALTY
|
Numeric
|
N/A
|
9
|
4
|
FUTURE USE.
|
|
52
|
DISCONTINU
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
53
|
OTHER1
|
Char
|
2
|
N/A
|
N/A
|
RESERVED.
|
|
54
|
OTHER2
|
Numeric
|
N/A
|
7
|
0
|
RESERVED.
|
|
55
|
SERIALSKU
|
Char
|
20
|
N/A
|
N/A
|
Stock # to pull serial #'s from.
|
|
56
|
UNITSINBOX
|
Numeric
|
N/A
|
9
|
2
|
Not used.
|
|
57
|
LPURCHDATE
|
Datetime
|
N/A
|
23
|
3
|
Last purchase date.
|
|
58
|
LPURCHQTY
|
Numeric
|
N/A
|
13
|
2
|
Last purchase quantity.
|
|
59
|
SIZE_COLOR
|
Bit
|
N/A
|
1
|
0
|
Size color indicator.
|
|
60
|
FRACTIONS
|
Bit
|
N/A
|
1
|
0
|
Fractional quantity indicator.
|
|
61
|
INETSELL
|
Bit
|
N/A
|
1
|
0
|
For use with SiteLINK.
|
|
62
|
INETDESC
|
Char
|
120
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
63
|
INETDEP
|
Char
|
50
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
64
|
INETSUBDEP
|
Char
|
50
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
65
|
INETCSMSG
|
Char
|
70
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
66
|
INETCSPROD
|
Char
|
20
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
67
|
INETIMAGE
|
Char
|
50
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
68
|
CANTSELL
|
Bit
|
N/A
|
1
|
0
|
Product cannot be sold.
|
|
69
|
NTAXCLASS
|
Char
|
1
|
N/A
|
N/A
|
National Tax Class.
|
|
70
|
STAXCLASS
|
Char
|
1
|
N/A
|
N/A
|
State Tax Class.
|
|
71
|
N_NONTAX
|
Bit
|
N/A
|
1
|
0
|
National tax exempt flag.
|
|
72
|
SALES_DEPT
|
Char
|
2
|
N/A
|
N/A
|
GL Sales Department.
|
|
73
|
ROYSUP
|
Char
|
6
|
N/A
|
N/A
|
Supplier code for royalties.
|
|
74
|
ROYNET
|
Numeric
|
N/A
|
5
|
2
|
Net $ Royalty base.
|
|
75
|
ROYGROSS
|
Numeric
|
N/A
|
5
|
2
|
Gross $ Royalty base.
|
|
76
|
ROYFLAT
|
Numeric
|
N/A
|
7
|
2
|
Per unit Royalty base.
|
|
77
|
INETCUSTOM
|
Bit
|
N/A
|
1
|
0
|
For use with SiteLINK.
|
|
78
|
INETCPRPMT
|
Char
|
40
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
79
|
DROPMETHOD
|
Char
|
1
|
N/A
|
N/A
|
FUTURE USE
|
|
80
|
INETCPRMPT
|
Char
|
40
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
81
|
INETCPRICE
|
Numeric
|
N/A
|
9
|
3
|
For use with SiteLINK.
|
|
82
|
INETUSPROD
|
Char
|
20
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
83
|
INETUSMSG
|
Char
|
70
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
84
|
INETTHUMB
|
Char
|
50
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
85
|
SENDNOTICE
|
Char
|
6
|
N/A
|
N/A
|
Notice to send with this product.
|
|
86
|
NOTICEWHEN
|
Char
|
1
|
N/A
|
N/A
|
When to send the notice
|
|
87
|
GIFTCERT
|
Bit
|
N/A
|
1
|
0
|
Used to determine if product is a gift certificate item.
|
|
88
|
POINTS_REV
|
Numeric
|
N/A
|
8
|
0
|
Points received when this item is purchased.
|
|
89
|
POINTS_NED
|
Numeric
|
N/A
|
8
|
0
|
Points needed to purchase this item.
|
|
90
|
KIT_MAKE
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
91
|
KIT_BREAK
|
Char
|
1
|
N/A
|
N/A
|
RESERVED.
|
|
92
|
ISBN
|
Char
|
15
|
N/A
|
N/A
|
ISBN number of product.
|
|
93
|
RTNS_DEPT
|
Char
|
2
|
N/A
|
N/A
|
G/L department to use for returns.
|
|
94
|
COGS_DEPT
|
Char
|
2
|
N/A
|
N/A
|
G/L department to use for cost of goods.
|
|
95
|
OVERSIZE2
|
Bit
|
N/A
|
1
|
0
|
Oversize UPS 2 indicator.
|
|
96
|
SUBSTITUTE
|
Char
|
20
|
N/A
|
N/A
|
RESERVED.
|
|
97
|
WAREPREF
|
Char
|
6
|
N/A
|
N/A
|
Preferred warehouse for this item.
|
|
98
|
WARE_ALTOK
|
Bit
|
N/A
|
1
|
0
|
Used to determine if alternate warehouses can be used.
|
|
99
|
SINGLEBIN
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
100
|
RCOMMIT
|
Numeric
|
N/A
|
11
|
2
|
Number of units returned but not invoiced.
|
|
101
|
CANBUYITEM
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
102
|
C_NONTAX
|
Bit
|
N/A
|
1
|
0
|
County tax exempt flag.
|
|
103
|
CTAXCLASS
|
Char
|
1
|
N/A
|
N/A
|
County tax class.
|
|
104
|
I_NONTAX
|
Bit
|
N/A
|
1
|
0
|
City tax exempt flag.
|
|
105
|
ITAXCLASS
|
Char
|
1
|
N/A
|
N/A
|
City tax class.
|
|
106
|
DBOUNITS
|
Numeric
|
N/A
|
11
|
2
|
Number of drop shipped units back ordered.
|
|
107
|
DONORDER
|
Numeric
|
N/A
|
11
|
2
|
Number of drop shipped units on order.
|
|
108
|
NEEDCUSTOM
|
Bit
|
N/A
|
1
|
0
|
Item requires customization indicator.
|
|
109
|
CUSTOMTEXT
|
Char
|
40
|
N/A
|
N/A
|
Custom information question.
|
|
110
|
PREFSHIP
|
Char
|
3
|
N/A
|
N/A
|
Shipping preference for item.
|
|
111
|
ADVANCED1
|
Char
|
30
|
N/A
|
N/A
|
Advanced search field.
|
|
112
|
ADVANCED2
|
Char
|
30
|
N/A
|
N/A
|
Advanced search field.
|
|
113
|
ADVANCED3
|
Char
|
30
|
N/A
|
N/A
|
Advanced search field.
|
|
114
|
ADVANCED4
|
Char
|
30
|
N/A
|
N/A
|
Advanced search field.
|
|
115
|
PICTURE
|
Char
|
100
|
N/A
|
N/A
|
Full path and name of the picture.
|
|
116
|
CLUB_PROD
|
Bit
|
N/A
|
1
|
0
|
Indicates a trigger product for club membership.
|
|
117
|
CLUB_CODE
|
Char
|
6
|
N/A
|
N/A
|
Club code associated with the trigger item.
|
|
118
|
STOCK_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
119
|
OVERSIZE3
|
Bit
|
N/A
|
1
|
0
|
Oversize UPS 3 indicator.
|
|
120
|
AUCTSELL
|
Bit
|
N/A
|
1
|
0
|
Set to True if item is available to sell at auction.
|
|
121
|
AUCTUNIT
|
Numeric
|
N/A
|
11
|
2
|
Number of units reserved for auctions.
|
|
122
|
BLENGTH
|
Numeric
|
N/A
|
3
|
0
|
Stock Item Length in inches.
|
|
123
|
BWIDTH
|
Numeric
|
N/A
|
3
|
0
|
Stock Item Width in inches.
|
|
124
|
BHEIGHT
|
Numeric
|
N/A
|
3
|
0
|
Stock Item Height in inches.
|
|
125
|
NORETURN
|
Bit
|
N/A
|
1
|
0
|
Indicates if this product can be returned on an order.
|
|
126
|
HIDE_ITEM
|
Bit
|
N/A
|
1
|
0
|
Indicates if this item should appear in lookup screens for orders
and purchasing.
|
|
127
|
PRINTSTKID
|
Bit
|
N/A
|
1
|
0
|
Indicates if this product will trigger a Stock ID Label to print
when received on a PO. If marked as TRUE, it will NOT print an ID
Label.
|
|
128
|
NODSCT
|
Bit
|
N/A
|
1
|
0
|
Indicates if this product is exempt from discounts.
|
|
129
|
MAXDSCT
|
Bit
|
N/A
|
1
|
0
|
Maximum Discount Percentage Allowed.
|
|
130
|
THRESHTYPE
|
Numeric
|
N/A
|
5
|
0
|
Price
Threshold Type,
1=
Minimum Retail Price.
2= Minimum Markup Percentage.
3=Minimum Markup Amount.
|
|
131
|
MIN_MKUP_P
|
Numeric
|
N/A
|
7
|
2
|
Minimum Markup Amount Above the Current Unit Cost Basis.
|
|
132
|
MIN_MKUP_D
|
Numeric
|
N/A
|
14
|
4
|
Minimum Markup Percentage Above the Current Unit Cost Basis.
|
|
133
|
MIN_PRICE
|
Numeric
|
N/A
|
14
|
4
|
Minimum Retail Price.
|
|
134
|
RETITEM
|
Char
|
20
|
N/A
|
N/A
|
SKU number that
will receive the inventory when this
item is returned.
|
|
135
|
SL_IMAGE1
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
136
|
SL_IMAGE2
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
137
|
SL_IMAGE3
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
138
|
SL_IMAGE4
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
139
|
SL_IMAGE5
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
140
|
SL_IMAGE6
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
141
|
SL_IMAGE7
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
142
|
SL_IMAGE8
|
Char
|
100
|
N/A
|
N/A
|
For Use with SiteLINK.
|
|
143
|
BO_AHEAD
|
Numeric
|
N/A
|
10
|
2
|
RESERVED.
|
|
144
|
SHIPEXEMPT
|
Bit
|
N/A
|
1
|
0
|
Indicates if this product is exempt from shipping charges.
|
