File Structure - Composite Items
File Name:
NEW.DBF
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 numeric
position of the field in the table.
-
Field Name - The XBASE
field name used in programming the information transferred. It
serves to classify data kept in this field.
-
Type - Can be one of 5
types:
Character - Text type data
Numeric - numbers
Integer - a whole number
Datetime - a date
Logical - True or False
-
Width - The maximum number
of spaces that the field element can occupy.
-
Dec. - For numeric fields
only. The number of decimal places reserved for the numeric value.
This field is not applicable in Comma Delimited format.
-
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 that the field is used for the UK
Edition of M.O.M.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
PROD
|
Character
|
20
|
N/A
|
Stock number of Composite item.
|
|
2
|
Q
|
Numeric
|
11
|
2
|
Equivalent quantity of component item.
|
|
3
|
INV
|
Character
|
20
|
N/A
|
Stock number of Component item.
|
|
4
|
SHIP_DAYS
|
Numeric
|
3
|
N/A
|
#
of days from order date to ship item.
|
|
5
|
WAIT_DATE
|
Date
|
8
|
N/A
|
Date to ship item.
|
|
6
|
NEW_ID
|
Integer
(Auto Increment)
|
18
|
0
|
RESERVED.
|
|
