File Structure - Stock Item Selling Price
File Name:
PRICE
File
Contents: Contains the information about the selling prices for
each stock item setup in the system.
Table Legend
The column
headings in the table include the following.
-
Position - The ordinal
position of the field in the table.
-
Field Name - The column
name used in programming the information transferred. It serves to
classify data kept in this field.
-
Type - Can be one of 6
types:
Char - Text type data
Text- a field with a large character limit.
Numeric - numbers
Int- a whole number
Datetime - a date
Bit- a logical
field. 0=False, 1=True
-
Character Length- For
Character fields only. The maximum number of character that the
field element can occupy.
-
Numeric Precision - For
numeric fields only. The maximum length for a numeric value before
the radix point.
-
Numeric Scale- For
numeric fields only. The maximum length for a decimal value after
the radix point.
-
Description of Field - A
definition of the field's contents. RESERVED signifies for M.O.M.
use only. FUTURE USE signifies that the field may be used in a
future release. UK Only signifies a field used for the UK edition
of M.O.M.
|
POSITION
|
FIELD NAME
|
TYPE
|
CHARACTER LENGTH
|
NUMERIC PRECISION
|
NUMERIC SCALE
|
DESCRIPTION
|
|
1
|
NUMBER
|
Char
|
20
|
N/A
|
I
|
Stock number for this entry.
|
|
2
|
NPOSITION
|
Numeric
|
N/A
|
2
|
0
|
RESERVED.
|
|
3
|
PRICE
|
Numeric
|
N/A
|
12
|
3
|
Selling price.
|
|
4
|
DISCOUNT
|
Numeric
|
N/A
|
3
|
0
|
Discount off normal retail.
|
|
5
|
COSTPLUS
|
Numeric
|
N/A
|
3
|
0
|
RESERVED.
|
|
6
|
QTY
|
Numeric
|
N/A
|
8
|
2
|
Minimum quantity.
|
|
7
|
CL_KEY
|
Char
|
9
|
N/A
|
N/A
|
Source key qualifier.
|
|
8
|
TOTAL_DOL
|
Numeric
|
N/A
|
10
|
2
|
Total dollars ordered qualifier.
|
|
9
|
CATCODE
|
Char
|
6
|
N/A
|
P
|
Catalog qualifier.
|
|
10
|
SQIN
|
Numeric
|
N/A
|
6
|
2
|
Square inches occupied in catalog.
|
|
11
|
PAGE
|
Numeric
|
N/A
|
3
|
0
|
Page number in catalog.
|
|
12
|
CTYPE
|
Char
|
1
|
N/A
|
N/A
|
Customer type 1 qualifier.
|
|
13
|
CTYPE2
|
Char
|
2
|
N/A
|
N/A
|
Customer type 2 qualifier.
|
|
14
|
CTYPE3
|
Char
|
4
|
N/A
|
N/A
|
Customer type 3 qualifier.
|
|
15
|
DATE_START
|
Datetime
|
N/A
|
23
|
3
|
Starting date qualifier.
|
|
16
|
DATE_END
|
Datetime
|
N/A
|
23
|
3
|
Ending date qualifier.
|
|
17
|
CUSTNUM
|
Numeric
|
N/A
|
8
|
0
|
Customer number qualifier.
|
|
18
|
RFM
|
Numeric
|
N/A
|
5
|
0
|
RFM value qualifier.
|
|
19
|
ORDERTYPE
|
Char
|
6
|
N/A
|
N/A
|
Order type code qualifier.
|
|
20
|
COSTMETHOD
|
Char
|
1
|
N/A
|
N/A
|
Method to base cost on for this price.
|
|
21
|
PLEVEL
|
Char
|
1
|
N/A
|
N/A
|
Pricing level designating MOM, SiteLINK or both..
|
|
22
|
PRICE_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
