ITEMFORMAT – User-Defined Item Format
- System
- Inventory Control (IC)
- Prefix
ITF- Primary key
COMPANY,FORMAT-ID- Fields
- 11
- Updated by
- 2 programs
- Referenced by
- 3 programs
ITEMFORMAT is the User-Defined Item Format table in Lawson Inventory Control (prefix ITF). It is indexed by COMPANY, FORMAT-ID (ITFSET1). It is related 1:1 to ICCOMPANY and ITEMGROUP and 1:M to ITFLINE. It is updated by IC10.1 and IC35.1 and referenced by IC01.1, IC290 and IC36.1. The table has 11 fields, 1 index and 3 documented relations.
About ITEMFORMAT
The User-Defined Item Format file stores format names that define the user-defined item maintenance and inquiry forms.
Fields (11)
Column = COBOL field name without the ITF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ITF-COMPANY PKCOMPANY | 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 PKFORMAT_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-FLMAINT_ITE_FL | Alpha 1 | This field indicates whether the format is for maintaining Item Master data.
| IC10.1, IC35.1 |
ITF-MAINT-ITL-FLMAINT_ITL_FL | Alpha 1 | This field indicates whether the format is for maintaining Item Location data.
| IC10.1, IC35.1 |
ITF-STOCK-UOMSTOCK_UOM | Alpha 4 | This field contains the stock unit of measure for the item. | IC10.1, IC35.1 |
ITF-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC10.1, IC35.1 |
ITF-GL-CATEGORYGL_CATEGORY | Alpha 4 | This field is used to extract the appropriate account numbers for any inventory movement. | IC10.1, IC35.1 |
ITF-INV-TRACK-FLINV_TRACK_FL | 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.
| IC10.1, IC35.1 |
ITF-NBR-FLDSNBR_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-TYPEFORMAT_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).
| IC10.1, IC35.1 |
ITF-MAINT-ITM-FLMAINT_ITM_FL | Alpha 1 | This field indicates whether the format is for maintaining ITEMSRC data. | IC10.1, IC35.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ITFSET1 | COMPANY, FORMAT-ID | Primary | IC01.1, IC10.1, IC10.2, IC290, IC35.1, IC36.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | ICCOMPANY | Required | ITF-COMPANY → ICC-COMPANY | |
| Itemgroup | ITEMGROUP | Required | ICC-ITEM-GROUP → ITG-ITEM-GROUP |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Itfline | ITFLINE | ITF-COMPANY → IFL-COMPANY, ITF-FORMAT-ID → IFL-FORMAT-ID, IFL-FLD-NBR |