File
Contents: Contains the information about the selling 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
|
Stock number for this entry.
|
|
2
|
POSITION
|
Numeric
|
2
|
N/A
|
RESERVED.
|
|
3
|
PRICE
|
Numeric
|
12
|
4
|
Selling price.
|
|
4
|
DISCOUNT
|
Numeric
|
3
|
N/A
|
Discount off normal retail.
|
|
5
|
COSTPLUS
|
Numeric
|
3
|
N/A
|
RESERVED.
|
|
6
|
QTY
|
Numeric
|
8
|
2
|
Minimum quantity.
|
|
7
|
CL_KEY
|
Character
|
9
|
N/A
|
Source key qualifier.
|
|
8
|
TOTAL_DOL
|
Numeric
|
10
|
2
|
Total dollars ordered qualifier.
|
|
9
|
CATCODE
|
Character
|
6
|
N/A
|
Catalog qualifier.
|
|
10
|
SQIN
|
Numeric
|
6
|
2
|
Square inches occupied in catalog.
|
|
11
|
PAGE
|
Numeric
|
3
|
N/A
|
Page number in catalog.
|
|
12
|
CTYPE
|
Character
|
1
|
N/A
|
Customer type 1 qualifier.
|
|
13
|
CTYPE2
|
Character
|
2
|
N/A
|
Customer type 2 qualifier.
|
|
14
|
CTYPE3
|
Character
|
4
|
N/A
|
Customer type 3 qualifier.
|
|
15
|
DATE_START
|
Date
|
8
|
N/A
|
Starting date qualifier.
|
|
16
|
DATE_END
|
Date
|
8
|
N/A
|
Ending date qualifier.
|
|
17
|
CUSTNUM
|
Numeric
|
8
|
N/A
|
Customer number qualifier.
|
|
18
|
RFM
|
Numeric
|
5
|
N/A
|
RFM value qualifier.
|
|
19
|
ORDERTYPE
|
Character
|
6
|
N/A
|
Order type code qualifier.
|
|
20
|
COSTMETHOD
|
Character
|
1
|
N/A
|
Method to base cost on for this price.
|
|
21
|
PLEVEL
|
Character
|
1
|
N/A
|
Pricing level designating MOM, SiteLINK or both..
|
|
22
|
PRICE_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESERVED.
|
