ITEMLOC

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


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 PO64.1 POCP.1 POI3.1
POII.1 POIJ.1 POIM.1 ICLC.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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-LOCATION
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-GL-CATEGORY
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-BUYER-CODE
Element: Buyer
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-SOH-QTY
Element: Quantity
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-IN-PROC-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
POIM.1
ITL-INTRANS-QTY
Element: Quantity
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MOVE-RANK
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-STORAGE-CODE
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MIN-ORDER
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MAX-ORDER
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-ORDER-POLICY
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-ORDER-MULT
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MANUF-CODE
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MANUF-NBR
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-FORECAST-NBR
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-CHARGEABLE-FL
Element: All Flag
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-ALLOW-ISS-FL
Element: All Flag
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-FREEZE-DT
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-UPDATE-TIME
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-LAST-REC-DT
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-LAST-TURN-DT
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MSDS-DOCUMENT
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-MSDS-VERSION
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-LAST-REC-COST
Element: Intl 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-LAST-ISS-COST
Element: Intl 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-AVG-ADD-ON-CST
Element: Intl Cost
Signed 18.5
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.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).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-OE-CREATEPO-FL
Element: All Flag
Alpha 1
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-OE-MAX-SALEQTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
ITL-OE-MIN-SALEQTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 PO64.1
POCP.1 POI3.1
POII.1 POIJ.1
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.


ITEMLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITLSET1 COMPANY
LOCATION
ITEM
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
ICI1.1 ICLC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
ITLSET2 COMPANY
ITEM
LOCATION
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
ITLSET5 COMPANY
LOCATION
BUYER-CODE
ITEM
KeyChange
ITLSET7 COMPANY
LOCATION
LAST-COUNT-DT
ITEM
KeyChange
ITLSET8 COMPANY
LOCATION
PREFER-BIN
ITEM
KeyChange
ITLSET9 COMPANY
LOCATION
CONSIGNMENT-FL
ITEM
KeyChange


ITEMLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
ITL-COMPANY->CPY-COMPANY (CPYSET1)
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
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
ITL-ITEM->ITE-ITEM
Location ICLOCATION Required
ITL-COMPANY->ICL-COMPANY
ITL-LOCATION->ICL-LOCATION
Preferred Bin ICBIN Required
When ITL-PREFER-BIN !=Spaces
AndITL-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
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


ITEMLOC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ichistory ICHISTORY
ITL-COMPANY->ICH-COMPANY
ITL-LOCATION->ICH-LOCATION
ITL-ITEM->ICH-ITEM
  ICH-YEAR
  ICH-QUARTER
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


File created: Wed Jun 08 20:49:40 2016

Home
Contact Us



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