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.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
NUMBER
|
Character
|
20
|
N/A
|
Your stock item number.
|
|
2
|
LEVEL
|
Numeric
|
3
|
N/A
|
Buying level.
|
|
3
|
SUPPLIER
|
Character
|
6
|
N/A
|
Supplier code this level is associated with
|
|
4
|
QUANTITY
|
Numeric
|
11
|
2
|
Quantity to purchase at this level.
|
|
5
|
BUYDESC
|
Character
|
40
|
N/A
|
Suppliers description of item 1.
|
|
6
|
EQUIV
|
Numeric
|
8
|
2
|
Equivalent units based on the quantity
|
|
7
|
UNIT_PRICE
|
Numeric
|
12
|
4
|
Price per unit at this level.
|
|
8
|
DISCOUNT
|
Numeric
|
3
|
N/A
|
Discount the supplier gives at this level.
|
|
9
|
DROP
|
Logical
|
1
|
N/A
|
Indicates product is drop shipped by supplier.
|
|
10
|
MIXGROUP
|
Character
|
10
|
N/A
|
M.O.M. mix and match code.
|
|
11
|
BUYDESC2
|
Character
|
40
|
N/A
|
Suppliers description of item 2.
|
|
12
|
LEAD_AVG
|
Numeric
|
7
|
2
|
For AIM.
|
|
13
|
LEAD_COUNT
|
Numeric
|
6
|
N/A
|
For AIM.
|
|
14
|
CHANGED_BY
|
Character
|
3
|
N/A
|
User ID that changed the item buy price.
|
|
15
|
BUYPRICE_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESERVED.
|
|
16
|
INSTRUCT1
|
Character
|
40
|
N/A
|
Special Supplier Instructions to print on a Purchase Order
|
|
17
|
INSTRUCT2
|
Character
|
40
|
N/A
|
Special Supplier Instructions to print on a
Purchase Order
|
|
18
|
INSTRUCT3
|
Character
|
40
|
N/A
|
Special Supplier Instructions to print on a Purchase Order
|
|
19
|
VOLUME
|
Numeric
|
10
|
3
|
Volume of the
Buy Quantity Entered.
|
|
20
|
WEIGHT
|
Numeric
|
10
|
3
|
Weight of the Buy Quantity Entered.
|
