|
|
ITEMFORMAT FILE
User-Defined Item Format
The User-Defined Item Format file stores format names that define the
user-defined item maintenance and inquiry forms.
REFERENCED BY
IC01.1 IC290 IC36.1
UPDATED BY
IC10.1 IC35.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITF-COMPANY Numeric 4 IC10.1 IC35.1
Company The company number represents an
established company and is entered on
all function codes.
ITF-FORMAT-ID Alpha 10 IC10.1 IC35.1
Format Id This is the user-defined name given to
identify the form format.
ITF-MAINT-ITE-FL Alpha 1 IC10.1 IC35.1
Maintain Item This field indicates whether the format
Master File Flag is for maintaining Item Master data.
N = No
Y = Yes
ITF-MAINT-ITL-FL Alpha 1 IC10.1 IC35.1
Maintain Item Loc This field indicates whether the format
File Flag is for maintaining Item Location data.
N = No
Y = Yes
ITF-STOCK-UOM Alpha 4 IC10.1 IC35.1
Stocking Unit of This field contains the stock unit of
Measure measure for the item.
ITF-LOCATION Alpha 5 IC10.1 IC35.1
Location Code This field contains a valid stock
location within the company inventory.
ITF-GL-CATEGORY Alpha 4 IC10.1 IC35.1
General Ledger This field is used to extract the
Category appropriate account numbers for any
inventory movement.
ITF-INV-TRACK-FL Alpha 1 IC35.1
Inventory Tracking This field determines if this item is a
Flag stocked item or a nonstock item. If the
item is a stocked item, quantities can
be tracked using Item Location records.
N = No
Y = Yes
ITF-NBR-FLDS Numeric 2 IC10.1 IC35.1
Number Fields This field contains the number assigned
to a field which determines the order in
which the fields appear on the form.
This field identifies the last number
used.
ITF-FORMAT-TYPE Alpha 1 IC10.1 IC35.1
Format Type This field indicates whether the format
is a maintenance format or only an
inquiry format. An inquiry format can be
used only by IC35.1 (Inquiry Formats)
and IC36.1 (User Defined Item Inquiry).
I = Inquire
M = Maintenance
ITEMFORMAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITFSET1 COMPANY IC01.1 IC10.1
FORMAT-ID IC10.2 IC290
IC35.1 IC36.1
ITEMFORMAT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ITF-COMPANY -> ICC-COMPANY
Itemgroup ITEMGROUP Required
ICC-ITEM-GROUP -> ITG-ITEM-GROUP
ITEMFORMAT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itfline ITFLINE
ITF-COMPANY -> IFL-COMPANY
ITF-FORMAT-ID -> IFL-FORMAT-ID
IFL-FLD-NBR
|