ITEMFORMAT

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
IC36.1 IC01.1 IC290


UPDATED BY
IC10.1 IC35.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITF-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
IC10.1 IC35.1
ITF-FORMAT-ID
Element: Format Id
Alpha 10
This is the user-defined name given to identify the format that this line is for.
IC10.1 IC35.1
ITF-MAINT-ITE-FL
Element: All Flag
Alpha 1
This field indicates whether the format is for maintaining Item Master data.
N = No
Y = Yes
IC10.1 IC35.1
ITF-MAINT-ITL-FL
Element: All Flag
Alpha 1
This field indicates whether the format is for maintaining Item Location data.
N = No
Y = Yes
IC10.1 IC35.1
ITF-STOCK-UOM
Element: Uom
Alpha 4
This field contains the stock unit of measure for the item.
IC10.1 IC35.1
ITF-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC10.1 IC35.1
ITF-GL-CATEGORY
Element: Gl Category
Alpha 4
This field is used to extract the appropriate account numbers for any inventory movement.
IC10.1 IC35.1
ITF-INV-TRACK-FL
Element: All Flag
Alpha 1
This field determines if this item is a 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
IC10.1 IC35.1
ITF-NBR-FLDS
Element: Nbr Flds
Numeric 2
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.
IC10.1 IC35.1
ITF-FORMAT-TYPE
Element: Format Type
Alpha 1
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
IC10.1 IC35.1
ITF-MAINT-ITM-FL
Element: Maint Itm Fl
Alpha 1
This field indicates whether the format is for maintaining ITEMSRC data.
IC10.1 IC35.1


ITEMFORMAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITFSET1 COMPANY
FORMAT-ID
IC01.1 IC10.1
IC10.2 IC290
IC35.1 IC36.1


ITEMFORMAT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itfline ITFLINE
ITF-COMPANY->IFL-COMPANY
ITF-FORMAT-ID->IFL-FORMAT-ID
  IFL-FLD-NBR


File created: Thu Jun 09 11:17:13 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.