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 |
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. |
|
||
ITF-FORMAT-ID Element: Format Id | Alpha 10 This is the user-defined name given to identify the format that this line is for. |
|
||
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 |
|
||
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 |
|
||
ITF-STOCK-UOM Element: Uom | Alpha 4 This field contains the stock unit of measure for the item. |
|
||
ITF-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||
ITF-GL-CATEGORY Element: Gl Category | Alpha 4 This field is used to extract the appropriate account numbers for any inventory movement. |
|
||
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 |
|
||
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. |
|
||
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 |
|
||
ITF-MAINT-ITM-FL Element: Maint Itm Fl | Alpha 1 This field indicates whether the format is for maintaining ITEMSRC data. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITFSET1 |
COMPANY FORMAT-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Company | ICCOMPANY |
Required
| |||
Itemgroup | ITEMGROUP |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Itfline | ITFLINE |
|
All trademarks and registered trademarks are the property of their
respective owners.