File
Contents: Contains information about the purchasing prices for 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 LENGTH
|
DESCRIPTION
|
|
1
|
NUMBER
|
Char
|
20
|
N/A
|
N/A
|
Your stock item number.
|
|
2
|
NLEVEL
|
Numeric
|
N/A
|
3
|
0
|
Buying level.
|
|
3
|
SUPPLIER
|
Char
|
6
|
N/A
|
N/A
|
Supplier code this level is associated with
|
|
4
|
QUANTITY
|
Numeric
|
N/A
|
11
|
2
|
Quantity to purchase at this level.
|
|
5
|
BUYDESC
|
Char
|
40
|
N/A
|
N/A
|
Suppliers description of item 1.
|
|
6
|
EQUIV
|
Numeric
|
N/A
|
8
|
2
|
Equivalent units based on the quantity
|
|
7
|
UNIT_PRICE
|
Numeric
|
N/A
|
12
|
4
|
Price per unit at this level.
|
|
8
|
DISCOUNT
|
Numeric
|
N/A
|
3
|
0
|
Discount the supplier gives at this level.
|
|
9
|
DROPSHIP
|
Bit
|
N/A
|
1
|
0
|
Indicates product is drop shipped by supplier.
|
|
10
|
MIXGROUP
|
Char
|
10
|
N/A
|
I
|
M.O.M. mix and match code.
|
|
11
|
BUYDESC2
|
Char
|
40
|
N/A
|
N/A
|
Suppliers description of item 2.
|
|
12
|
LEAD_AVG
|
Numeric
|
N/A
|
7
|
2
|
For AIM.
|
|
13
|
LEAD_COUNT
|
Numeric
|
N/A
|
6
|
0
|
For AIM.
|
|
14
|
CHANGED_BY
|
Char
|
3
|
N/A
|
N/A
|
User ID that changed the item buy price.
|
|
15
|
BUYPRICE_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
16
|
INSTRUCT1
|
Char
|
40
|
N/A
|
N/A
|
Special Supplier Instructions to print on a Purchase Order
|
|
17
|
INSTRUCT2
|
Char
|
40
|
N/A
|
N/A
|
Special Supplier Instructions to print on a Purchase Order
|
|
18
|
INSTRUCT3
|
Char
|
40
|
N/A
|
N/A
|
Special Supplier Instructions to print on a Purchase Order
|
|
19
|
VOLUME
|
Numeric
|
N/A
|
10
|
3
|
Volume of the
Buy Quantity Entered.
|
|
20
|
WEIGHT
|
Numeric
|
N/A
|
10
|
3
|
Weight of the Buy Quantity Entered.
|
