ITEMLOC – Item Location

System: Inventory Control (IC)
Prefix: ITL
Primary key: COMPANY, LOCATION, ITEM
Fields: 137
Updated by: 335 programs
Referenced by: 101 programs

ITEMLOC is the Item Location table in Lawson Inventory Control (prefix ITL). It is indexed by COMPANY, LOCATION, ITEM (ITLSET1); alternate indexes: ITLSET2, ITLSET5, ITLSET7, ITLSET8 and ITLSET9. It is related 1:1 to APCOMPANY, BINGRPDTL, CNTBOD, ICCOMPANY, GLSYSTEM, ICCATEGORY, ICITLUF, ITEMMAST and 7 more and 1:M to ICFORECAST, ICAUDIT, ICHISTORY, ICPLANORD, ICTRANS, ITCOMMENT, ITEMSRC, ITEMLOC and 5 more. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 327 more and referenced by DR25.1, DR40.1, DR42.1, IC110, IC138, IC143, IC15.2, IC19.1 and 93 more. The table has 137 fields, 6 indexes and 32 documented relations.

About ITEMLOC

The Item Location file contains the dynamic information for an inventoried item at a stock location. The quantities, costs, and reordering information are contained in this file.

Fields (137)

Column = COBOL field name without the ITL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ITL-COMPANY` PK 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.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LOCATION` PK LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ITEM` PK ITEM	Alpha 32	This field contains the item identifier.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-GL-CATEGORY` GL_CATEGORY	Alpha 4	This field is used to extract appropriate account numbers for any inventory movement.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-BUYER-CODE` BUYER_CODE	Alpha 3	This field contains a code representing the person responsible for the item at this location.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-UOM` UOM	Alpha 4	This is the default transaction unit of measure for this item at this location. The unit of measure must be set up as a valid unit of measure defined in IC11.1 (Item Master) and be valid for transaction use.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-PURCH-TAX-FL` PURCH_TAX_FL	Alpha 1	This field indicates whether this item is taxable (Yes) or nontaxable (No) when it is purchased for this location. " " = Blank Defaults to Next Level `Y` Yes `N` No	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-PURCH-TAX-CD` PURCH_TAX_CD	Alpha 10	This field contains the code used to determine if this item is taxable when purchased at this location. This code is also used to extract tax data from the tax file based on this tax code.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SELL-TAX-FL` SELL_TAX_FL	Alpha 1	This field indicates whether this item is nontaxable (No) or taxable (Yes) when sold from this location. `Y` Taxable When Sold `N` Not Taxable When Sold	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SELL-TAX-CD` SELL_TAX_CD	Alpha 10	This code determines tax rates when this item is sold from this location. Valid sell tax codes are defined in the Tax system. The sell tax code determines the tax table from which to extract tax data.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-STD-COST` STD_COST	Signed 18.5	This field contains the standard unit cost of this item at this location. This field is required for standard cost companies.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-FUT-STD-COST` FUT_STD_COST	Signed 18.5	This field contains the future standard cost for the item. Update Variances (IC175) updates this into the standard cost field and creates the appropriate general ledger transaction for this field.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SOH-QTY` SOH_QTY	Signed 13.4	This field indicates the quantity that is currently on hand in the inventory.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SECONDARY-QTY` SECONDARY_QTY	Signed 13.4	This field contains the secondary quantity, which is tracked if the item is a catch weight item. This quantity is a memo quantity only. It is not used for valuation.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ALLOC-QTY` ALLOC_QTY	Signed 13.4	This field contains the quantity allocated to orders for this item. This quantity is maintained by Warehouse.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-UNALLOC-QTY` UNALLOC_QTY	Signed 13.4	This field contains the quantity of future customer orders that have not yet been allocated. This field is maintained by Warehouse.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-BACKORD-QTY` BACKORD_QTY	Signed 13.4	This field contains the quantity of orders that should have been allocated, but were not because there was not enough available inventory. This field is maintained by Warehouse.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-IN-PROC-QTY` IN_PROC_QTY	Signed 13.4	This field contains the desired quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ONORDER-QTY` ONORDER_QTY	Signed 13.4	This field contains the on-order quantity for the item location. It is the total of all open supply orders. It is maintained by Purchase Order and Requisitions.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-INTRANS-QTY` INTRANS_QTY	Signed 13.4	This field contains the quantity intransit to the item location. This is maintained by Inventory Control.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-WIP-QTY` WIP_QTY	Signed 13.4	This field represents the work-in- process quantity. It is used by Production Order to indicate the quantity of finished goods that are in the process of being produced.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-HOLD-QTY` HOLD_QTY	Signed 13.4	This field contains the quantity of items on hold for inspection at the location. This field is maintained by Purchase Order.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MOVE-CLASS` MOVE_CLASS	Alpha 1	This field contains the designated movement class. `1` Movement Class 1 `2` Movement Class 2 `3` Movement Class 3	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MOVE-RANK` MOVE_RANK	Numeric 5	This field contains the ranking within the movement class.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-STORAGE-CODE` STORAGE_CODE	Alpha 5	This field contains the code assigned to describe the physical characteristics of a bin.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-PREFER-BIN` PREFER_BIN	Alpha 7	This field contains the designated preferred bin for the item at this location. This is the default bin number used on transactions if the item is bin tracked.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MIN-ORDER` MIN_ORDER	Signed 13.4	This field contains the minimum order quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MAX-ORDER` MAX_ORDER	Signed 13.4	This field contains the maximum order quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ORDER-POLICY` ORDER_POLICY	Alpha 3	This field contains the method of reordering. `FOP` Fixed Order Point `TPO` Time Phased Order Point	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-REORD-DOC-CD` REORD_DOC_CD	Alpha 1	This field contains a code that indicates the manner in which this item is reordered. `N` No document created, only plan `P` Purchaser Order `R` Requisition `X` Intransit Document `T` Transfer Document `I` Issue Document `W` Work Order	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-REORD-QTY-CD` REORD_QTY_CD	Alpha 1	This field contains the reorder quantity code that indicates how to determine the quantity ordered. `D` Difference Quantity `E` Economic Order Quantity `F` Fixed Reorder Quantity `M` Order up to Maximum Level	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-REORD-PT-CD` REORD_PT_CD	Alpha 1	This field contains the reorder point code that indicates how the reorder point quantity is determined. `F` Fixed Reorder Point `V` Variable Reorder Point	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-REORDER-QTY` REORDER_QTY	Signed 13.4	This field contains the normal reorder quantity for the item at this location. This field is maintained by the user or the system, based on the reorder quantity code.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-REORDER-POINT` REORDER_POINT	Signed 13.4	This field contains the reorder point. Reordering for this item is triggered to occur when the item available quantity falls below this reorder point.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SUGG-REORD-PT` SUGG_REORD_PT	Signed 13.4	This is the calculated suggested par value or stock level quantity. This quantity is calculated by IC182 - Par Location Utilization report.	IC10.2, IC182, IC81.1, IC812, IC840
`ITL-LEAD-CTRL-CD` LEAD_CTRL_CD	Alpha 1	This field contains the code that determines how the leadtime number of days is maintained. `M` Manually Entered `R` Needs Review `S` System Calculates	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LEADTIME-DAYS` LEADTIME_DAYS	Numeric 3	This field contains the average leadtime days. It is the average of the last and previous leadtime days if this field is system calculated.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-LEADTIME` LAST_LEADTIME	Numeric 3	This field contains the difference between the received date and the purchase order date. This field is updated by the Purchase Order system.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-PREV-LEADTIME` PREV_LEADTIME	Numeric 3	This field is maintained by the Purchase Order system. The last leadtime value is moved to the previous leadtime field when a new purchase order is received.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-AUTO-PO` AUTO_PO	Alpha 1	This field indicates whether a purchase order is to be automatically created for this item. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ORDER-MULT` ORDER_MULT	Numeric 4	This field contains the order multiple. The reorder quantity should be a multiple of this quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-EOQ` EOQ	Signed 13.4	This field contains the EOQ (Economic Order Quantity). This is a calculation that checks the cost of ordering the item against the cost of carrying the item in inventory to determine the ideal quantity to be ordered.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SAFETY-STOCK` SAFETY_STOCK	Signed 13.4	This field contains the quantity of stock planned to be in inventory to protect against the fluctuations in supply and demand.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MANUF-CODE` MANUF_CODE	Alpha 4	This field contains a user defined code that indicates the manufacturer of an item.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MANUF-DIVISION` MANUF_DIVISION	Alpha 4	This is a user defined code that indicates which division of a manufacturer is tied to an item.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MANUF-NBR` MANUF_NBR	Alpha 35	This is the identifier that the manufacturer has assigned to an item.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-SP-CYCLE-CNT` SP_CYCLE_CNT	Alpha 1	This field contains the special cycle count designator, which is used to select this item for cycle counting regardless of the item's movement class. `X` Selected for Special Cycle Cnt	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-COUNT-DT` LAST_COUNT_DT	Numeric 8 (yyyymmdd)	This field contains the date this item was last counted in the physical inventory process.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-FORECAST-NBR` FORECAST_NBR	Numeric 4	This number identifies which forecast record is to be used for this item.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-CHARGEABLE-FL` CHARGEABLE_FL	Alpha 1	This flag indicates that this item is a patient chargeable item. `Y` Yes `N` No	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-TRACKING-FL` TRACKING_FL	Alpha 1	This flag specifies if quantities are to be tracked at this location for this item. `Y` Yes `N` No	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-BIN-TRACK-FL` BIN_TRACK_FL	Alpha 1	This field indicates whether this item is to be tracked by bin at this location. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ALLOW-REC-FL` ALLOW_REC_FL	Alpha 1	This field indicates whether receipts are allowed. If set to No, the Purchase Order system cannot order the item. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ALLOW-ISS-FL` ALLOW_ISS_FL	Alpha 1	This field indicates whether issues of this item are allowed. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-INSP-REQ-FL` INSP_REQ_FL	Alpha 1	This field specifies if the item is inspected when it is received. This field defaults to the Purchase Order and Case Carts systems. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ACTIVITY-FL` ACTIVITY_FL	Alpha 1	This field indicates whether this record has been updated by any transaction since Stock Status Report (IC145), Item Mass Update (IC116) or Distribution Requirements Report (DR100) has been run. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-FREEZE-FL` FREEZE_FL	Alpha 1	This field indicates this record has been selected to be counted in the physical inventory process. `N` No `Y` Yes	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-FREEZE-DT` FREEZE_DT	Numeric 8 (yyyymmdd)	This field indicates the date this record was selected for physical inventory counting.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-ISSUE-DT` LAST_ISSUE_DT	Numeric 8 (yyyymmdd)	This field contains the date of the last issue of this item at this location.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-UPD-DT` LAST_UPD_DT	Numeric 8 (yyyymmdd)	This field contains the date the transaction was released for an item record or the last date an item record was maintained.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-UPDATE-TIME` UPDATE_TIME	Numeric 6	This field contains the system time when the record was updated.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-TRAN-COUNTER` TRAN_COUNTER	Numeric 6	This field contains a transaction object number used to determine the sequence of updating of the Item Location file.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-REC-DT` LAST_REC_DT	Numeric 8 (yyyymmdd)	This field contains the date of the last receiving.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-TURN-DT` LAST_TURN_DT	Numeric 8 (yyyymmdd)	This field contains the date the turnover rate was last calculated.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MSDS-DT` MSDS_DT	Numeric 8 (yyyymmdd)	This field contains the date a new Material Safety Data Sheet (MSDS) should be sent from the vendor.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MSDS-ORDER-FL` MSDS_ORDER_FL	Alpha 1	This field is used by the Purchase Order system to indicate if the Material Safety Data Sheet (MSDS) for this item has been sent to this location.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MSDS-DOCUMENT` MSDS_DOCUMENT	Alpha 30	The document number from the most recent MSDS that was received.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-MSDS-VERSION` MSDS_VERSION	Alpha 4	The version number of the most recent MSDS that was received.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-AVG-SOH-QTY` AVG_SOH_QTY	Signed 13.4	This field contains the average stock-on-hand quantity of the item for the last year.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-TURN-RATE` TURN_RATE	Signed 6.1	This field contains the rate of turnover, which is calculated by dividing the annual sales quantity by the average stock-on-hand quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-REC-COST` LAST_REC_COST	Signed 18.5	This field contains the last received or invoiced unit cost.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-LAST-ISS-COST` LAST_ISS_COST	Signed 18.5	This field contains the unit cost of the last issue.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-AVG-ADD-ON-CST` AVG_ADD_ON_CST	Signed 18.5	—	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-AVERAGE-COST` AVERAGE_COST	Signed 18.5	This field contains the moving average unit cost of an item. This figure is always calculated regardless of the company costing method.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-OVERHEAD-UCOST` OVERHEAD_UCOST	Signed 18.5	—	IC12.1, IC330, IC812
`ITL-MARKET-PRICE` MARKET_PRICE	Signed 18.5	—	IC12.1, IC330, IC812
`ITL-TRANS-COUNT` TRANS_COUNT	Numeric 5	This field contains the number of inventory transactions involving this item at this location since the last update run of Update Variances (IC175).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-CNT-ACCURACY` CNT_ACCURACY	Signed 5.1	This field contains the count accuracy for this item at this location from the last physical inventory count.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ADDED-DATE` ADDED_DATE	Numeric 8 (yyyymmdd)	This field contains the date the Item Location record was originally added in IC12.1 (Item Location) or IC10.1 (Formats). It defaults to the system date when the record is added.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ACTIVE-STATUS` ACTIVE_STATUS	Alpha 1	This status indicates whether the item is active or inactive at this location. If the item is inactive, no transactions can be entered for this item at this location, but transactions in process can be completed. `A` Active `I` Inactive	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-USER-FIELD1` USER_FIELD1	Alpha 30	This field contains the first user-defined field for the Item Location file. It can be used to enter any data the user wants. This field's name is defined in Company (IC01.1).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-USER-FIELD2` USER_FIELD2	Alpha 30	This field contains the second user-defined field for the Item Location record. It can be used to enter any data the user wants. This field's name is defined in Company (IC01.1).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-USER-FIELD3` USER_FIELD3	Alpha 30	This field contains the third user-defined field for the Item Location record. It can be used to enter any data the user wants. This field's name is defined in Company (IC01.1).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-USER-FIELD-N1` USER_FIELD_N1	Signed 18.5	This field contains the first user-defined numeric field for the Item Location record. It can be used to enter any data the user wants. This field's name is defined in Company (IC01.1).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-USER-FIELD-N2` USER_FIELD_N2	Signed 18.5	This field contains the second user-defined numeric field for the Item Location record. It can be used to enter any data the user wants. This field's name is defined in Company (IC01.1).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-USER-FIELD-N3` USER_FIELD_N3	Signed 18.5	This field contains the third user-defined numeric field for the Item Location record. It can be used to enter any data the user wants. This field's name is defined in Company (IC01.1).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-PROC-DAYS` PROC_DAYS	Numeric 3	The number of days it takes to process receivings until they are ready to be shipped.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-CONSIGNMENT-FL` CONSIGNMENT_FL	Alpha 1	The flag designates that this item is a consignment item at this location. Consignment items are not part of the owned inventory. This field defualts from the ITEMMAST Consignment Fl field. `Y` Yes `N` No	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-NO-CHARGE-FL` NO_CHARGE_FL	Alpha 1	This field indicates the item's price is zero. This defaults to (N)o. If (Y)es, this field prevents the system from pricing the item. No charge invoices are not be passed to the Lawson Accounts Receivable system for collection. `Y` Yes `N` No	IC10.2, IC12.1, IC330, IC331, IC81.1, IC812, IC82.1, IC840
`ITL-LOT-TRACK-FL` LOT_TRACK_FL	Alpha 1	— `I` Issues `N` Not tracked `R` Receipts	IC10.2, IC12.1, IC330, IC81.1, IC812, IC82.1, WH130
`ITL-SER-TRACK-FL` SER_TRACK_FL	Alpha 1	— `I` Issues `N` Not tracked `R` Receipts	IC10.2, IC12.1, IC330, IC81.1, IC812, IC82.1, WH130
`ITL-OE-DROPSHIP-FL` OE_DROPSHIP_FL	Alpha 1	—	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-OE-CREATEPO-FL` OE_CREATEPO_FL	Alpha 1	—	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-OE-MAX-SALEQTY` OE_MAX_SALEQTY	Signed 13.4	This field contains the desired quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-OE-MIN-SALEQTY` OE_MIN_SALEQTY	Signed 13.4	This field contains the desired quantity.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`ITL-ACCT-UNIT-INV` ACCT_UNIT_INV	Derived	This field is derived from the inventory accounting unit on the General Ledger Account Category file.	—
`ITL-ACCOUNT-INV` ACCOUNT_INV	Derived	This field is derived from the inventory account field on the General Ledger Account Category file.	—
`ITL-SUB-ACCT-INV` SUB_ACCT_INV	Derived	This field is derived from the inventory subaccount field on the General Ledger Account Category file.	—
`ITL-MANUF-NBR-DER` MANUF_NBR_DER	Derived	This field is the manufacturer's number based on where it is set up in the Item Location or Item Master file.	—
`ITL-MANUF-CODE-DER` MANUF_CODE_DER	Derived	This field is the manufacturer's code based on where it is set up in the Item Master or Item Location file.	—
`ITL-MANUF-DIV-DER` MANUF_DIV_DER	Derived	This field is the manufacturer's division based on where it is set up in the Item Master or Item Location file.	—
`ITL-NEG-ALLOC` NEG_ALLOC	Derived	This field is allocated quantity set to negative for use in the allocatable and sellable calculations.	—
`ITL-NEG-BACKORD` NEG_BACKORD	Derived	This field is the backorder quantity set to negative for use in the allocable and sellable calculations.	—
`ITL-NEG-INPROC` NEG_INPROC	Derived	This field is the in-process quantity set to negative for use in the available-to-allocate and available-to-sell calculations.	—
`ITL-NEG-ONORD` NEG_ONORD	Derived	This field contains the on-order quantity set to negative for use in the available-to-allocate and available-to-sell calculations.	—
`ITL-NEG-INTRANS` NEG_INTRANS	Derived	This field is the intransit quantity set to negative for use in the available-to-allocate and available-to-sell calculations.	—
`ITL-NEG-WIP` NEG_WIP	Derived	This field is the Work In Process quantity set to negative for use in the allocatable and sellable calculations.	—
`ITL-NEG-HOLD` NEG_HOLD	Derived	This field is the Hold quantity set to negative for use in the allocatable and sellable calculations.	—
`ITL-SELL-ALLOC` SELL_ALLOC	Derived	This field is the allocated quantity with its sign set to match the option on the available-to-sell calculation.	—
`ITL-SELL-INPROC` SELL_INPROC	Derived	This field is the in-process quantity with its sign set to match the option selected on the available-to-sell calculation.	—
`ITL-SELL-BACKORD` SELL_BACKORD	Derived	This field is the backorder quantity with its sign set to match the option selected on the available-to-sell calculation.	—
`ITL-SELL-ONORD` SELL_ONORD	Derived	This field is the on-order quantity with its sign set to match the option selected on the available-to-sell calculation.	—
`ITL-SELL-INTRAN` SELL_INTRAN	Derived	This field is the intransit quantity with its sign set to match the option selected in the available-to-sell calculation.	—
`ITL-SELL-WIP` SELL_WIP	Derived	This field is the work-in-process quantity with its sign set to match the option selected in the available-to-sell calculation.	—
`ITL-SELL-HOLD` SELL_HOLD	Derived	This field is the hold quantity with its sign set to match the option selected in the available-to-sell calculation.	—
`ITL-ALC-ALLOC` ALC_ALLOC	Derived	This field is the Allocated quantity with it's sign set to match the option selected in the allocatable calculation.	—
`ITL-ALC-INPROC` ALC_INPROC	Derived	This field is the In Process quantity with it's sign set to match the option selected in the allocatable calculation.	—
`ITL-ALC-BACKORD` ALC_BACKORD	Derived	This field is the Backorder quantity with it's sign set to match the option selected in the allocatable calculation.	—
`ITL-ALC-ONORD` ALC_ONORD	Derived	This field is the On Order quantity with it's sign set to match the option selected in the allocatable calculation.	—
`ITL-ALC-INTRAN` ALC_INTRAN	Derived	This field is the Intransit quantity with it's sign set to match the option selected in the allocatable calculation.	—
`ITL-ALC-WIP` ALC_WIP	Derived	This field is the work-in-process quantity with its sign set to match the option selected in the available-to-allocate calculation.	—
`ITL-ALC-HOLD` ALC_HOLD	Derived	This field is the Hold quantity with it's sign set to match the option selected in the allocatable calculation.	—
`ITL-SELLABLE` SELLABLE	Derived	This field is the calculated quantity that is available to sell for those customers that do not allow backorders.	—
`ITL-ALLOCATABLE` ALLOCATABLE	Derived	This field is the quantity that is available to allocate to an order, so that the picking document can be printed.	—
`ITL-CWT-ALLOCATABL` CWT_ALLOCATABL	Derived	This field is the quantity in terms of the catch weight that can be allocated for orders.	—
`ITL-ITEM-CODE-USED` ITEM_CODE_USED	Derived	—	—
`ITL-OE-ALLOW-RTN` OE_ALLOW_RTN	Alpha 1	" " `Y` Yes `N` No `L` Limit	IC10.2, IC12.1, IC812
`ITL-OE-RTN-DATE` OE_RTN_DATE	Numeric 8 (yyyymmdd)	—	IC10.2, IC12.1, IC812
`ITL-SOURCE-UOM` SOURCE_UOM	Alpha 4	A unit-of-measure that will default for replenishment and transfer purposes for the item at this location. It must be a valid buy and tran UOM for the item.	IC10.2, IC12.1, IC330, IC812
`ITL-GEO-TYPE` GEO_TYPE	Alpha 4	—	—
`ITL-GEO-LATITUDE` GEO_LATITUDE	Signed 12.6	—	—
`ITL-GEO-LONGITUDE` GEO_LONGITUDE	Signed 12.6	—	—
`ITL-GEO-ALTITUDE` GEO_ALTITUDE	Signed 12.6	—	—
`ITL-GEO-DATE` GEO_DATE	Numeric 8 (yyyymmdd)	—	—
`ITL-GEO-TIME` GEO_TIME	Numeric 8	—	—
`ITL-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	IC12.1
`ITL-CHARGE-NBR` CHARGE_NBR	Alpha 80	—	IC12.1, IC812

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`ITLSET1`	`COMPANY`, `LOCATION`, `ITEM`	Primary	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
`ITLSET2`	`COMPANY`, `ITEM`, `LOCATION`		AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
`ITLSET5`	`COMPANY`, `LOCATION`, `BUYER-CODE`, `ITEM`	KeyChange	DR42.1, IC223, IC225, IC590
`ITLSET7`	`COMPANY`, `LOCATION`, `LAST-COUNT-DT`, `ITEM`	KeyChange	IC170, IC295
`ITLSET8`	`COMPANY`, `LOCATION`, `PREFER-BIN`, `ITEM`	KeyChange	IC170, IC281, IC598, IC66.1, IC81.1, IC83.1
`ITLSET9`	`COMPANY`, `LOCATION`, `CONSIGNMENT-FL`, `ITEM`	KeyChange	IC140, IC233, IC234, IC247, IC46.1, IC70.1

Relations

One to one (18) — lookups and parents

Relation	Table	Rules	Condition	Field map
Apcompany	APCOMPANY	Required		`ITL-COMPANY` → `CPY-COMPANY`
Bingrpdtl	BINGRPDTL	Not Required	Valid When ITL-PREFER-BIN != Spaces And ITL-BIN-TRACK-FL = "Y"	`ITL-COMPANY` → `BGD-COMPANY`, `ITL-LOCATION` → `BGD-LOCATION`, `ITL-LOCATION` → `BGD-BIN-GROUP`, `ITL-PREFER-BIN` → `BGD-BIN`
Cntbod	CNTBOD	Not Required, Delete Cascades		`ITL-COMPANY` → `IBG-COMPANY`, `ITL-LOCATION` → `IBG-LOCATION`, `ITL-ITEM` → `IBG-ITEM`
Company	ICCOMPANY	Required		`ITL-COMPANY` → `ICC-COMPANY`
Gl Company	GLSYSTEM	Required		`ITL-COMPANY` → `GLS-COMPANY`
Iccategory	ICCATEGORY	Required		`ITL-COMPANY` → `ICA-COMPANY`, `ITL-LOCATION` → `ICA-LOCATION`, `ITL-GL-CATEGORY` → `ICA-GL-CATEGORY`
Icitluf	ICITLUF	Not Required, Delete Cascades		`ITL-COMPANY` → `UFL-COMPANY`, `ITL-LOCATION` → `UFL-LOCATION`, `ITL-ITEM` → `UFL-ITEM`
Itemmast	ITEMMAST	Required		`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `ITL-ITEM` → `ITE-ITEM`
Itlbod	ITLBOD	Not Required, Delete Cascades		`ITL-COMPANY` → `IBB-COMPANY`, `ITL-LOCATION` → `IBB-LOCATION`, `ITL-ITEM` → `IBB-ITEM`
Location	ICLOCATION	Required		`ITL-COMPANY` → `ICL-COMPANY`, `ITL-LOCATION` → `ICL-LOCATION`
Preferred Bin	ICBIN	Required	When ITL-PREFER-BIN != Spaces And ITL-BIN-TRACK-FL = "Y"	`ITL-COMPANY` → `ICB-COMPANY`, `ITL-LOCATION` → `ICB-LOCATION`, `ITL-PREFER-BIN` → `ICB-BIN`
Repl From Bin	ICBIN	Required		`ITL-COMPANY` → `ICB-COMPANY`, `ITL-LOCATION` → `ICB-LOCATION`, `ITL-PREFER-BIN` → `ICB-BIN`
Repl Itemloc	ITEMLOC	Not Required		`ITL-COMPANY` → `ITL-COMPANY`, `ITL-LOCATION` → `ITL-LOCATION`, `ITL-ITEM` → `ITL-ITEM`
Rrpl Itemloc	ITEMLOC	Not Required		`ITL-COMPANY` → `ITL-COMPANY`, `ITL-LOCATION` → `ITL-LOCATION`, `ITL-ITEM` → `ITL-ITEM`
Storage Code	BINSTORAGE	Required	When ITL-STORAGE-CODE != Spaces	`ITL-COMPANY` → `BST-COMPANY`, `ITL-LOCATION` → `BST-LOCATION`, `ITL-STORAGE-CODE` → `BST-STORAGE-CODE`
Tax Code Purch	TXTAXCODE	Required	When ITL-PURCH-TAX-CD != Spaces	`ITL-COMPANY` → `TAC-COMPANY`, `ITL-PURCH-TAX-CD` → `TAC-TAX-CODE`
Tax Code Sell	TXTAXCODE	Required	When ITL-SELL-TAX-CD != Spaces	`ITL-COMPANY` → `TAC-COMPANY`, `ITL-SELL-TAX-CD` → `TAC-TAX-CODE`
Vendorgroup	APVENGROUP	Required		`CPY-VENDOR-GROUP` → `VGP-VENDOR-GROUP`

One to many (14) — child tables

Relation	Table	Rules	Field map
Forecast	ICFORECAST		`ITL-COMPANY` → `IFO-COMPANY`, `ITL-LOCATION` → `IFO-LOCATION`, `ITL-ITEM` → `IFO-ITEM`, → `IFO-FORECAST-YEAR`, → `IFO-FORECAST-NBR`, → `IFO-QUARTER`
Icaudit	ICAUDIT		`Spaces` → `IAU-ITEM-GROUP`, `ITL-COMPANY` → `IAU-COMPANY`, `ITL-LOCATION` → `IAU-LOCATION`, `ITL-ITEM` → `IAU-ITEM`, `Spaces` → `IAU-GL-CATEGORY`, → `IAU-DATE`, → `IAU-TIME`, → `IAU-FLD-NBR`
Ichistory	ICHISTORY		`ITL-COMPANY` → `ICH-COMPANY`, `ITL-LOCATION` → `ICH-LOCATION`, `ITL-ITEM` → `ICH-ITEM`, → `ICH-YEAR`, → `ICH-QUARTER`
Icplanord	ICPLANORD		`ITL-COMPANY` → `IPL-COMPANY`, `ITL-LOCATION` → `IPL-LOCATION`, `ITL-ITEM` → `IPL-ITEM`, → `IPL-PERIOD-DT`
Ict By Date	ICTRANS		`ITL-COMPANY` → `ICT-COMPANY`, `ITL-LOCATION` → `ICT-LOCATION`, `ITL-ITEM` → `ICT-ITEM`, → `ICT-UPDATE-DATE`, → `ICT-UPDATE-TIME`, → `ICT-TRAN-COUNTER`
Itcomment	ITCOMMENT		`ITE-ITEM-GROUP` → `ICO-ITEM-GROUP`, `ITL-ITEM` → `ICO-ITEM`, → `ICO-LANGUAGE-CODE`, → `ICO-SEQ`
Itemsrc	ITEMSRC		`ITL-COMPANY` → `ITM-COMPANY`, `ITL-LOCATION` → `ITM-LOCATION`, `ITL-ITEM` → `ITM-ITEM`, → `ITM-REPLENISH-PRI`
Itlset2	ITEMLOC		`ITL-COMPANY` → `ITL-COMPANY`, `ITL-ITEM` → `ITL-ITEM`, → `ITL-LOCATION`
Itserial	ITSERIAL	Delete Cascades	`ITL-COMPANY` → `SER-COMPANY`, `ITL-ITEM` → `SER-ITEM`, → `SER-SERIAL`
Poline	POLINE		`ITL-COMPANY` → `PLI-COMPANY`, `ITL-ITEM` → `PLI-ITEM`, `ITL-LOCATION` → `PLI-LOCATION`, → `PLI-EARLY-DL-DATE`, → `PLI-PO-NUMBER`, → `PLI-PO-RELEASE`, → `PLI-PO-CODE`, → `PLI-LINE-NBR`
Porecline	PORECLINE		`ITL-COMPANY` → `PRL-COMPANY`, `ITL-LOCATION` → `PRL-LOCATION`, `ITL-ITEM` → `PRL-ITEM`, → `PRL-UPDATE-DATE`, → `PRL-UPDATE-TIME`, → `PRL-REC-NUMBER`, → `PRL-LINE-NBR`
Soh Det Path 3	SOHDETAIL		`ITL-COMPANY` → `SDT-COMPANY`, `ITL-LOCATION` → `SDT-LOCATION`, `ITL-ITEM` → `SDT-ITEM`, → `SDT-BIN`, → `SDT-UOM`, → `SDT-LOT`, → `SDT-SUBLOT`
Sohdetail	SOHDETAIL		`ITL-COMPANY` → `SDT-COMPANY`, `ITL-LOCATION` → `SDT-LOCATION`, `ITL-ITEM` → `SDT-ITEM`, → `SDT-UOM`, → `SDT-LOT`, → `SDT-SUBLOT`, → `SDT-BIN`
Whdemand	WHDEMAND		`ITL-COMPANY` → `WDM-COMPANY`, `ITL-LOCATION` → `WDM-LOCATION`, `ITL-ITEM` → `WDM-ITEM`, → `WDM-EST-TRAN-DT`, → `WDM-DOC-TYPE`, → `WDM-SYSTEM-CD`, → `WDM-DOC-NBR`, → `WDM-LINE-NBR`, → `WDM-COMPONENT-SEQ`

Programs

Updated by (335)

AP125 Batch Release
AP126 Mass Invoice Release
AP131 Chargeback
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.4 Invoice Cancel
AP510 Vendor Conversion
API1.1 Add Invoice
API2.1 Add Invoice
CX05.1 Preference Template
CX05.2 Preference Template Diagnostics
CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX205 Preference Template Items
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CX805 Template Card Conversion
CXCP.1 Copy preference to case
DR100 Distribution Requirements Report
IC01.1 Company
IC02.1 Location
IC10.2 Item Master and Location
IC11.1 Item Master
IC12.1 Item Location
IC12.2 Replenishment Setup
IC120 Economic Order Quantity and Reorder Calculation
IC125 Standard Cost Valuation
IC130 General Ledger Interface
IC134 Inventory Turnover
IC135 Inventory Turnover by Issues
IC14.1 Manufacturer Code
IC140 Vendor Reorder Advice
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC145 Stock Status Report
IC150 Movement Analysis - Cost
IC151 Movement Analysis - Sales
IC152 Movement Analysis - GMROI
IC170 Freeze Selected Items
IC175 Update Variances
IC179 Delete Freeze Records
IC182 Par Location Utilization
IC183 Par Level Load
IC190 Closing
IC20.1 Receipts
IC20.2 Detail Receipts
IC21.1 Issues
IC21.2 Detail Issues
IC216 Open Transaction Report
IC22.1 Transfers
IC22.2 Detail Transfer
IC223 Availability Report
IC225 Inventory Reorder Advice
IC226 Leadtime Review Report
IC23.1 Intransit Receiving
IC23.2 Detail Intransit Receiving
IC24.1 Adjustments
IC24.2 Detail Adjustments
IC243 Killed Item Report
IC25.1 Document Release
IC26.1 Detail Transfers
IC26.2 Bin Transfer by Serial
IC262 Finished Good Listing
IC270 Count Sheets
IC28.1 Cost Adjustments
IC281 Par Inventory Worksheet
IC282 Requesting Location Usage
IC285 Detail Par Loc Utilization
IC31.1 Item Location Balances
IC320 Mass Item Location Copy
IC330 Item Mass Change
IC331 Par Cart Mass Changes
IC36.1 User Defined Item Inquiry
IC40.1 Availability by Location
IC40.2 Secondary Quantity Availability
IC44.1 Inventory Stock Status
IC45.1 Stock Status
IC500 Transaction Interface
IC520 Handheld Item Master Interface
IC521 Bar Code Item Master Interface
IC522 HL7 Item Master - Atwork
IC523 HL7 Item Master - OmniCell
IC524 CSV Item Master
IC525 HL7 Item Master Interface
IC526 HL7 Item Master - McKesson
IC527 HL7 Item Master - DeRoyal
IC598 Bin Label Export
IC61.1 Kit Component Replacement
IC62.1 Finished Goods
IC62.2 Finished Good Byproducts
IC62.4 Component Finished Goods
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC66.1 Replenishment PO Worksheet
IC67.1 Kit Availability
IC68.1 Finished Good Component Availability
IC68.2 Finished Good Component Availability
IC68.3 Finished Good Component Sub Location Availability
IC73.1 Count Detail
IC81.1 Cart, Par Location
IC812 Item Location Load
IC82.1 Par Location Item Mass Change
IC820 Beginning Balance Load
IC83.1 Par Location Counts
IC84.1 Detail Par Location Utilization by Month
IC84.2 Detail Par Location Utilization by Month
IC840 Cart Par Location Conversion
IC850 Transaction Load
IC90.1 Bin Transfers
MA180 Open Receipt Archive
MA278 Cost Variance Analysis
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA43.7 GL Distribution
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA53.1 Receipt Interface
MA530 ERS Invoice Creation
MA531 Receipt Interface
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.5 Receipt Match Reference Adjustment
MA61.1 Match Invoice Approval
MA63.1 Invoice Line Match
MA66.2 Invoice Message - Details
MA67.2 Invoice Match from frontend
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.3 Detail Level Match - Prepaid
MA68.5 Receipt Match Reference Adjustment
MA69.1 AOC Level Detail Match
MA69.2 AOC Level Selections
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MA80.1 Receipt Archive
MAI1.1 Invoke for MAMATCH Object
PC120 Price Calculation
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD570 P-Card Charge Import
PO04.1 Buyer
PO04.2 Buyer Purchasing Class
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO100 Purchase Order Interface from Lawson Applications
PO101 Create Standing PO Release
PO115 Procurement Template Mass Changes
PO120 Mass PO Issue
PO122 Transmitted PO Acknowledgement
PO131 Receiving Log
PO132 Print Vendor Return Material Authorization
PO136 Matched, Not Received Report
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.4 Procurement Template Line Detail
PO150 Bid Load to Contract or Catalog
PO16.1 Bid
PO17.1 Purchase Order Approval Review
PO190 Close Purchase Order Header
PO20.1 Purchase Order Entry
PO20.6 Substitute Vendor Items
PO20.9 Multiple Lines
PO204 Buyer Master Listing
PO21.1 Select and Copy
PO21.2 Add-On Cost Spread
PO21.3 Account Distribution
PO21.4 Miscellaneous Add-On Cost
PO21.5 Item Add-On Cost
PO22.1 Authorization, Release
PO22.3 Mass Cancel or Delete Purchase Orders
PO22.4 Mass Cancel or Delete Purchase Order Lines
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO224 PO Revision Report
PO225 Vendor Agreement Listing
PO228 Consolidated Demand Report
PO229 Vendor Agreement Format Print
PO23.1 Purchase Order Worksheet
PO230 Unreleased Receivings Listing
PO234 PO Interface Listing Report
PO24.1 Purchase Order Direct Approval
PO25.1 Vendor Agreements
PO25.5 Vendor Agreement Item Add-On Cost
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO251 PO Buyer Message Listing
PO253 Item Receipt Volume Report
PO26.3 Vendor Agreement Commitments Spread
PO26.7 Mass Release of Vendor Agreements
PO26.9 Vendor Agreement Release
PO27.2 Select Blanket Lines
PO27.3 Create PO From Procurement Template
PO27.4 Select and Copy Template
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO28.2 Vendor Agreement Line Detail List
PO280 Purchases By Class
PO29.1 Copy Purchase Order
PO30.1 PO Receiving
PO30.2 Substitute Item
PO30.3 Additional Tracking Numbers
PO30.4 PO Receiving Line Detail List
PO300 PO and Receipt Purge
PO31.1 Vendor Return
PO31.2 Vendor Return Item Selection
PO32.2 Item Detail
PO32.4 Cancel Detail
PO33.1 Receiving Adjustment
PO34.1 Inspection Accept or Reject
PO35.1 Receiving Approval and Release
PO36.1 Identify Lawson Items by Vendor Agreement Line
PO36.2 Vendor Agreement Import Manual Input
PO38.1 Invoice AOC
PO39.1 Additional Receiving Entry
PO39.2 Additional Adjustment/Rejection Entry
PO44.1 PO Line Source
PO50.1 Buyer Message Entry
PO52.1 Buyer Message - Receiving
PO520 Purchase Order Interface from Non Lawson
PO536 Vendor Price Agreement Load
PO54.5 PO Line Detail List
PO64.1 PO Line Item History
POCP.1 POC Comments Copy
POI3.1 Invoke for POPI70PD
POID.1 PO Delivery Ticket Select
POII.1 Invoke for POPCRUPD
POIJ.1 Invoke for POPLIUPD
POIM.1 GL Budget Ck for PO and RQ
RQ01.1 Requesting Locations
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ11.5 Item AOC
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ270 RQ Fill Rate Analysis
RQ35.1 Requisition Returns
RQ44.1 Requisition Inquiry
RQ500 Requisition Interface
RQ810 Request Location Load
RQIB.1 RQRQHUPD Invoke Object
RQIC.1 Get Item List Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIG.1 Get Shopping List Invoke Object
RQIH.1 Invoke Determine Express Data
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy
WH110 Batch Allocation
WH120 Route Creation
WH126 POD Print
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.1 Inventoried Allocation
WH20.2 Nonstock and Special Allocation
WH20.3 Bin Allocation
WH20.4 Lot Allocation
WH20.5 Serial Allocation
WH20.6 UOM Allocation
WH20.7 Substitute Location
WH22.1 Kit Options
WH220 Ready to Allocate
WH222 Shipments In Process
WH224 Packing List Print
WH226 Items on Backorder Report
WH25.1 Cancellation By Item
WH25.2 Cancellation By Document
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.1 Bins
WH33.2 Lots
WH33.3 Serials
WH33.4 UOMs
WH33.5 Additional Shipment Information
WH33.6 Catch Weight
WH33.8 Preassembled Kits
WH33.9 Line Options
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH34.5 Catch Weight
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program
WHD2.1 WH-IC Integrity Check
WHD3.1 WH-IC Detail Integrity Check

Referenced by (101)

DR25.1 Planned Orders
DR40.1 Time Phased Order Point
DR42.1 Time Phased Order Point by Buyer
IC110 Intransit Shipping
IC138 Bin Replenishment Report
IC143 Finished Good Replenishment
IC15.2 Bins
IC19.1 Forecasts
IC211 Item Location Listing
IC220 Transaction History Report
IC222 Unreleased Documents
IC224 Gross Margin Return on Investment
IC227 Potential Obsolete
IC228 Potential Overstock
IC230 Lot Status Report
IC231 Issue Summary Report
IC232 Serial Status Report
IC233 Inventory Valuation
IC234 Period End Valuation
IC235 Market Inventory Valuation
IC237 Unapproved Bin Report
IC238 Bin Stock on Hand Report
IC239 Forecast Variance
IC242 Transaction Audit Report
IC244 Inventory Issue Document
IC247 IFRS FIFO Period End Valuation
IC250 Released Document Report
IC266 Replenishment PO Worksheet Rpt
IC27.1 Lot Hold Control
IC280 Distribution History Report
IC283 Par Location Valuation
IC29.1 Lots
IC29.2 Serials
IC29.3 Bins
IC295 Count Control Status
IC38.1 Bin Reorder Policy
IC42.1 Stock by Detail
IC42.2 Stock by Lot
IC42.3 Serial Numbers
IC42.4 Secondary Detail
IC46.1 Inventory Status
IC47.1 Cost History
IC49.1 Usage History
IC50.1 Transaction History
IC50.2 Detail Transaction History
IC503 IC Valid UOM CSV Create
IC51.1 Available Bin Space
IC511 Item Master-Item Location Extr
IC512 Item Audit Extract
IC52.1 Serial or Lot History
IC55.1 Transaction History Inquiry
IC55.2 Transaction History Inquiry
IC550 Overallocated Items
IC574 Physical Inventory Interface
IC58.1 Global Location Numbers
IC589 Forecast Transfer
IC59.1 Create Label Entry
IC590 Out of Stock Extract
IC60.1 Kit Assembly
IC60.2 Options
IC70.1 Select IDs
IC72.1 Counts by Page
IC74.1 Random Counts
IC76.1 Variance Reasons
IC811 Item Master Load
IC851 History Load
IC91.2 Item Location and Item Source Audit Inquiry
IC95.1 Catch Weight
IC95.2 Catch Weight
IC95.3 Catch Weight
ICBD.1 IC BOD Maintenance
ICBD.2 IC BOD Inquiry
ICBL.4 Populate Sort File from Matrix List
ICI1.1 Unit Of Measure Routines
ICIA.1 Keyword Search INVOKED Object
ICLC.1 Item Location Lookup
MA236 Invoiced, Not Received Report
MA540 Invoice Interface
MA65.1 Invoice Line Adjustment
PC20.1 Patient Charges
PC210 Patient Charge Reconciliation
PC540 Patient Charge Upload
PO130 Receiving Document
PO133 Receiving Adjustment Log
PO135 Received, Not Invoiced Report
PO139 Standard Cost Calculation
POIE.1 Delivery Ticket Report
POIH.1 Invokeable Unit Cost Default
RQ111 Print Requisitions
RQ140 Requisition Status Report
RQ235 Issues Audit List
RQ39.1 Serial Feedback
RQ39.2 Lot Feedback
RQ39.3 Bin Feedback
RQD0.1 Invoke for RQ Orphan Check
RQD1.1 Invoke for RQ Integrity Check
WH21.1 Routes
WH21.2 Stops
WH21.3 Stop Transfer
WH21.4 Document Transfer
WH210 Route File Listing