Item Location
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.
REFERENCED BY
ICI1.1 | MA540 | PO15.1 | PO15.2 | PO15.4 | POIH.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
ITL-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. |
||
ITL-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
||
ITL-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
||
ITL-GL-CATEGORY Element: Gl Category | Alpha 4 This field is used to extract appropriate account numbers for any inventory movement. |
||
ITL-BUYER-CODE Element: Buyer | Alpha 3 This field contains a code representing the person responsible for the item at this location. |
||
ITL-UOM Element: 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. |
||
ITL-PURCH-TAX-FL Element: 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 |
||
ITL-PURCH-TAX-CD Element: Tax Code | 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. |
||
ITL-SELL-TAX-FL Element: 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 |
||
ITL-SELL-TAX-CD Element: Tax Code | 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. |
||
ITL-STD-COST Element: Intl 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. |
||
ITL-FUT-STD-COST Element: Intl 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. |
||
ITL-SOH-QTY Element: Quantity | Signed 13.4 This field indicates the quantity that is currently on hand in the inventory. |
||
ITL-SECONDARY-QTY Element: 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. |
||
ITL-ALLOC-QTY Element: Quantity | Signed 13.4 This field contains the quantity allocated to orders for this item. This quantity is maintained by Warehouse. |
||
ITL-UNALLOC-QTY Element: Quantity | Signed 13.4 This field contains the quantity of future customer orders that have not yet been allocated. This field is maintained by Warehouse. |
||
ITL-BACKORD-QTY Element: Quantity | 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. |
||
ITL-IN-PROC-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
||
ITL-ONORDER-QTY Element: Quantity | 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. |
||
ITL-INTRANS-QTY Element: Quantity | Signed 13.4 This field contains the quantity intransit to the item location. This is maintained by Inventory Control. |
||
ITL-WIP-QTY Element: Quantity | 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. |
||
ITL-HOLD-QTY Element: Quantity | Signed 13.4 This field contains the quantity of items on hold for inspection at the location. This field is maintained by Purchase Order. |
||
ITL-MOVE-CLASS Element: Move Class | Alpha 1 This field contains the designated movement class. 1 = Movement Class 1 2 = Movement Class 2 3 = Movement Class 3 |
||
ITL-MOVE-RANK Element: Move Rank | Numeric 5 This field contains the ranking within the movement class. |
||
ITL-STORAGE-CODE Element: Storage Code | Alpha 5 This field contains the code assigned to describe the physical characteristics of a bin. |
||
ITL-PREFER-BIN Element: 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. |
||
ITL-MIN-ORDER Element: Min Order | Signed 13.4 This field contains the minimum order quantity. |
||
ITL-MAX-ORDER Element: Max Order | Signed 13.4 This field contains the maximum order quantity. |
||
ITL-ORDER-POLICY Element: Order Policy | Alpha 3 This field contains the method of reordering. FOP = Fixed Order Point TPO = Time Phased Order Point |
||
ITL-REORD-DOC-CD Element: 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 |
||
ITL-REORD-QTY-CD Element: 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 |
||
ITL-REORD-PT-CD Element: 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 |
||
ITL-REORDER-QTY Element: Quantity | 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. |
||
ITL-REORDER-POINT Element: 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. |
||
ITL-SUGG-REORD-PT Element: 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. |
|
|
ITL-LEAD-CTRL-CD Element: 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 |
||
ITL-LEADTIME-DAYS Element: 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. |
||
ITL-LAST-LEADTIME Element: Leadtime Days | 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. |
||
ITL-PREV-LEADTIME Element: Leadtime Days | 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. |
||
ITL-AUTO-PO Element: All Flag | Alpha 1 This field indicates whether a purchase order is to be automatically created for this item. N = No Y = Yes |
||
ITL-ORDER-MULT Element: Order Mult | Numeric 4 This field contains the order multiple. The reorder quantity should be a multiple of this quantity. |
||
ITL-EOQ Element: 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. |
||
ITL-SAFETY-STOCK Element: 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. |
||
ITL-MANUF-CODE Element: Manuf Code | Alpha 4 This field contains a user defined code that indicates the manufacturer of an item. |
||
ITL-MANUF-DIVISION Element: Manuf Division | Alpha 4 This is a user defined code that indicates which division of a manufacturer is tied to an item. |
||
ITL-MANUF-NBR Element: Manuf Nbr | Alpha 35 This is the identifier that the manufacturer has assigned to an item. |
||
ITL-SP-CYCLE-CNT Element: 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 |
||
ITL-LAST-COUNT-DT Element: Last Count Dt | Numeric 8 (yyyymmdd) This field contains the date this item was last counted in the physical inventory process. |
||
ITL-FORECAST-NBR Element: Forecast Nbr | Numeric 4 This number identifies which forecast record is to be used for this item. |
||
ITL-CHARGEABLE-FL Element: All Flag | Alpha 1 This flag indicates that this item is a patient chargeable item. Y = Yes N = No |
||
ITL-TRACKING-FL Element: All Flag | Alpha 1 This flag specifies if quantities are to be tracked at this location for this item. Y = Yes N = No |
||
ITL-BIN-TRACK-FL Element: All Flag | Alpha 1 This field indicates whether this item is to be tracked by bin at this location. N = No Y = Yes |
||
ITL-ALLOW-REC-FL Element: All Flag | 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 |
||
ITL-ALLOW-ISS-FL Element: All Flag | Alpha 1 This field indicates whether issues of this item are allowed. N = No Y = Yes |
||
ITL-INSP-REQ-FL Element: All Flag | 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 |
||
ITL-ACTIVITY-FL Element: All Flag | 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 |
||
ITL-FREEZE-FL Element: All Flag | Alpha 1 This field indicates this record has been selected to be counted in the physical inventory process. N = No Y = Yes |
||
ITL-FREEZE-DT Element: Freeze Dt | Numeric 8 (yyyymmdd) This field indicates the date this record was selected for physical inventory counting. |
||
ITL-LAST-ISSUE-DT Element: Last Issue Dt | Numeric 8 (yyyymmdd) This field contains the date of the last issue of this item at this location. |
||
ITL-LAST-UPD-DT Element: 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. |
||
ITL-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time when the record was updated. |
||
ITL-TRAN-COUNTER Element: Tran Counter | Numeric 6 This field contains a transaction object number used to determine the sequence of updating of the Item Location file. |
||
ITL-LAST-REC-DT Element: Last Rec Dt | Numeric 8 (yyyymmdd) This field contains the date of the last receiving. |
||
ITL-LAST-TURN-DT Element: Last Turn Dt | Numeric 8 (yyyymmdd) This field contains the date the turnover rate was last calculated. |
||
ITL-MSDS-DT Element: Msds Dt | Numeric 8 (yyyymmdd) This field contains the date a new Material Safety Data Sheet (MSDS) should be sent from the vendor. |
||
ITL-MSDS-ORDER-FL Element: 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. |
||
ITL-MSDS-DOCUMENT Element: Msds Document | Alpha 30 The document number from the most recent MSDS that was received. |
||
ITL-MSDS-VERSION Element: Msds Version | Alpha 4 The version number of the most recent MSDS that was received. |
||
ITL-AVG-SOH-QTY Element: Quantity | Signed 13.4 This field contains the average stock-on-hand quantity of the item for the last year. |
||
ITL-TURN-RATE Element: 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. |
||
ITL-LAST-REC-COST Element: Intl Cost | Signed 18.5 This field contains the last received or invoiced unit cost. |
||
ITL-LAST-ISS-COST Element: Intl Cost | Signed 18.5 This field contains the unit cost of the last issue. |
||
ITL-AVG-ADD-ON-CST Element: Intl Cost | Signed 18.5 |
||
ITL-AVERAGE-COST Element: Intl 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. |
||
ITL-OVERHEAD-UCOST Element: Intl Cost | Signed 18.5 |
|
|
ITL-MARKET-PRICE Element: Intl Cost | Signed 18.5 |
|
|
ITL-TRANS-COUNT Element: 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). |
||
ITL-CNT-ACCURACY Element: Accuracy 1 | Signed 5.1 This field contains the count accuracy for this item at this location from the last physical inventory count. |
||
ITL-ADDED-DATE Element: 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. |
||
ITL-ACTIVE-STATUS Element: 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 |
||
ITL-USER-FIELD1 Element: 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). |
||
ITL-USER-FIELD2 Element: 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). |
||
ITL-USER-FIELD3 Element: User Field2 | 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). |
||
ITL-USER-FIELD-N1 Element: Intl Cost | 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). |
||
ITL-USER-FIELD-N2 Element: Intl Cost | 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). |
||
ITL-USER-FIELD-N3 Element: Intl Cost | 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). |
||
ITL-PROC-DAYS Element: Proc Days | Numeric 3 The number of days it takes to process receivings until they are ready to be shipped. |
||
ITL-CONSIGNMENT-FL Element: 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 |
||
ITL-NO-CHARGE-FL Element: 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 |
|
|
ITL-LOT-TRACK-FL Element: All Flag | Alpha 1 I = Issues N = Not tracked R = Receipts |
|
|
ITL-SER-TRACK-FL Element: Ser Track Fl | Alpha 1 I = Issues N = Not tracked R = Receipts |
|
|
ITL-OE-DROPSHIP-FL Element: All Flag | Alpha 1 |
||
ITL-OE-CREATEPO-FL Element: All Flag | Alpha 1 |
||
ITL-OE-MAX-SALEQTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
||
ITL-OE-MIN-SALEQTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
||
ITL-ACCT-UNIT-INV Element: Acct Unit Inv | Derived This field is derived from the inventory accounting unit on the General Ledger Account Category file. |
|
|
ITL-ACCOUNT-INV Element: Account Inv | Derived This field is derived from the inventory account field on the General Ledger Account Category file. |
|
|
ITL-SUB-ACCT-INV Element: Sub Acct Inv | Derived This field is derived from the inventory subaccount field on the General Ledger Account Category file. |
|
|
ITL-MANUF-NBR-DER Element: 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 Element: 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 Element: 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 Element: Neg Alloc | Derived This field is allocated quantity set to negative for use in the allocatable and sellable calculations. |
|
|
ITL-NEG-BACKORD Element: Neg Backord | Derived This field is the backorder quantity set to negative for use in the allocable and sellable calculations. |
|
|
ITL-NEG-INPROC Element: 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 Element: 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 Element: 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 Element: 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 Element: Neg Hold | Derived This field is the Hold quantity set to negative for use in the allocatable and sellable calculations. |
|
|
ITL-SELL-ALLOC Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Sellable | Derived This field is the calculated quantity that is available to sell for those customers that do not allow backorders. |
|
|
ITL-ALLOCATABLE Element: 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 Element: Cwt Allocatabl | Derived This field is the quantity in terms of the catch weight that can be allocated for orders. |
|
|
ITL-ITEM-CODE-USED Element: Item Code Used | Derived |
|
|
ITL-OE-ALLOW-RTN Element: All Flag | Alpha 1 " " Y = Yes N = No L = Limit |
|
|
ITL-OE-RTN-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
|
ITL-SOURCE-UOM Element: 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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||
---|---|---|---|---|---|---|---|---|---|---|
ITLSET1 |
COMPANY LOCATION ITEM |
|
||||||||
ITLSET2 |
COMPANY ITEM LOCATION |
|
||||||||
ITLSET5 |
COMPANY LOCATION BUYER-CODE ITEM |
|
||||||||
ITLSET7 |
COMPANY LOCATION LAST-COUNT-DT ITEM |
|
||||||||
ITLSET8 |
COMPANY LOCATION PREFER-BIN ITEM |
|
||||||||
ITLSET9 |
COMPANY LOCATION CONSIGNMENT-FL ITEM |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| |||||||||||||||||||||
Company | ICCOMPANY |
Required
| |||||||||||||||||||||
Gl Company | GLSYSTEM |
Required
| |||||||||||||||||||||
Iccategory | ICCATEGORY |
Required
| |||||||||||||||||||||
Itemmast | ITEMMAST |
Required
| |||||||||||||||||||||
Location | ICLOCATION |
Required
| |||||||||||||||||||||
Preferred Bin | ICBIN |
Required
| |||||||||||||||||||||
Repl From Bin | ICBIN |
Required
| |||||||||||||||||||||
Repl Itemloc | ITEMLOC |
Not Required
| |||||||||||||||||||||
Rrpl Itemloc | ITEMLOC |
Not Required
| |||||||||||||||||||||
Tax Code Purch | TXTAXCODE |
Required
| |||||||||||||||||||||
Tax Code Sell | TXTAXCODE |
Required
| |||||||||||||||||||||
Vendorgroup | APVENGROUP |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ichistory | ICHISTORY |
| |||||||||||||||||||||||||||
Ict By Date | ICTRANS |
| |||||||||||||||||||||||||||
Itcomment | ITCOMMENT |
| |||||||||||||||||||||||||||
Itemsrc | ITEMSRC |
| |||||||||||||||||||||||||||
Itlset2 | ITEMLOC |
| |||||||||||||||||||||||||||
Itserial | ITSERIAL |
Delete Cascades
| |||||||||||||||||||||||||||
Poline | POLINE |
| |||||||||||||||||||||||||||
Porecline | PORECLINE |
| |||||||||||||||||||||||||||
Soh Det Path 3 | SOHDETAIL |
| |||||||||||||||||||||||||||
Sohdetail | SOHDETAIL |
| |||||||||||||||||||||||||||
Whdemand | WHDEMAND |
|
All trademarks and registered trademarks are the property of their
respective owners.