File Structure - Composite Items
File Name:
NEW
File
Contents: Contains information on the association between composite
items (kits and/or aliases) and their composing items.
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
|
PROD
|
Char
|
20
|
N/A
|
|
Stock number of Composite item.
|
|
2
|
Q
|
Numeric
|
N/A
|
11
|
2
|
Equivalent quantity of component item.
|
|
3
|
INV
|
Char
|
20
|
N/A
|
N/A
|
Stock number of Component item.
|
|
4
|
SHIP_DAYS
|
Numeric
|
N/A
|
3
|
0
|
#
of days from order date to ship item.
|
|
5
|
WAIT_DATE
|
Datetime
|
N/A
|
23
|
3
|
Date to ship item.
|
|
6
|
NEW_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
