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.
| 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.
|
|
ITL-GEO-TYPE
Element: Customer Code | Alpha 4
|
|
ITL-GEO-LATITUDE
Element: Gis Coordinate | Signed 12.6
|
|
ITL-GEO-LONGITUDE
Element: Gis Coordinate | Signed 12.6
|
|
ITL-GEO-ALTITUDE
Element: Gis Coordinate | Signed 12.6
|
|
ITL-GEO-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
ITL-GEO-TIME
Element: Time | Numeric 8
|
|
ITL-GLBL-LINE-TYPE
Element: Glbl Line Type | Alpha 15
|
|
ITL-CHARGE-NBR
Element: A4comp Name | Alpha 80
|
|
