 |
Lawson Insight Technical Documentation |
|
ITEMLOC FILE
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
BL121 BL123 BL290 BL80.1 BL85.2 BL85.1
BL90.1 DR25.1 DR40.1 IC01.1 IC02.1 IC138
IC143 IC19.1 IC220 IC222 IC224 IC227
IC228 IC232 IC237 IC238 IC239 IC242
IC27.1 IC283 IC29.1 IC29.2 IC29.3 IC38.1
IC47.1 IC49.1 IC50.1 IC50.2 IC51.1 IC550
IC574 IC589 IC60.1 IC60.2 IC70.1 IC72.1
IC74.1 IC851 IC95.1 IC95.2 IC95.3 ICI1.1
ICLC.1 PC20.1 PC540 MA278 MA310 MA53.5
MA65.1 PO130 PO135 PO220 POCP.1 POID.1
POIH.1 RQ111 RQ140 RQ235 RQ300 RQ39.1
RQ39.2 RQ39.3 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 WH224 WH226 IC11.1 IC42.1 IC42.2
IC42.3 IC42.4 DR42.1 IC590 IC295 IC233
IC234
UPDATED BY
BL140 CXCP.1 DR100 IC10.2 IC12.1 IC12.2
IC120 IC125 IC130 IC134 IC135 IC140
IC141 IC142 IC145 IC150 IC151 IC152
IC170 IC175 IC179 IC182 IC183 IC190
IC20.1 IC20.2 IC21.1 IC21.2 IC211 IC22.1
IC22.2 IC223 IC225 IC226 IC23.1 IC23.2
IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC262
IC28.1 IC281 IC31.1 IC320 IC330 IC36.1
IC40.1 IC40.2 IC45.1 IC500 IC520 IC521
IC522 IC523 IC524 IC525 IC526 IC527
IC530 IC531 IC61.1 IC62.1 IC62.2 IC67.1
IC68.1 IC68.2 IC68.3 IC73.1 IC81.1 IC812
IC82.1 IC820 IC83.1 IC840 IC850 IC90.1
PC120 SEA1.1 MA63.1 PO16.1 PO228 PO64.1
POIJ.1 RQ11.1 RQ12.1 RQ13.1 SEA3.1 WH110
WH126 WH130 WH22.1 WH220 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH34.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITL-COMPANY Numeric 4 BL140 CXCP.1
Company The company number represents an DR100 IC10.2
established company and is entered on IC12.1 IC12.2
all function codes. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-LOCATION Alpha 5 BL140 CXCP.1
Location Code This field contains a valid stocking DR100 IC10.2
location within the company inventory. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ITEM Alpha 32 BL140 CXCP.1
Item Number This field contains the item DR100 IC10.2
identifier. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-GL-CATEGORY Alpha 4 BL140 CXCP.1
General Ledger This field is used to extract DR100 IC10.2
Category appropriate account numbers for any IC12.1 IC12.2
inventory movement. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-BUYER-CODE Alpha 3 BL140 CXCP.1
Buyer Code This field contains a code representing DR100 IC10.2
the person responsible for the item at IC12.1 IC12.2
this location. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-UOM Alpha 4 BL140 CXCP.1
Unit of Measure This is the default transaction unit of DR100 IC10.2
measure for this item at this location. IC12.1 IC12.2
The unit of measure must be set up as a IC125 IC130
valid unit of measure defined in IC11.1 IC140 IC141
(Item Master) and be valid for IC142 IC145
transaction use. IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-PURCH-TAX-FL Alpha 1 BL140 CXCP.1
Purchasing Tax Flag This field indicates whether this item DR100 IC10.2
is taxable (Yes) or nontaxable (No) when IC12.1 IC12.2
it is purchased for this location. IC125 IC130
" " = Blank Defaults to Next Level IC140 IC141
Y = Yes IC142 IC145
N = No IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-PURCH-TAX-CD Alpha 10 BL140 CXCP.1
Purchasing Tax This field contains the code used to DR100 IC10.2
Table Code determine if this item is taxable when IC12.1 IC12.2
purchased at this location. This code is IC125 IC130
also used to extract tax data from the IC140 IC141
tax file based on this tax code. IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-SELL-TAX-FL Alpha 1 BL140 CXCP.1
Selling Tax Flag This field indicates whether this item DR100 IC10.2
is nontaxable (No) or taxable (Yes) when IC12.1 IC12.2
sold from this location. IC125 IC130
Y = Taxable When Sold IC140 IC141
N = Not Taxable When Sold IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-SELL-TAX-CD Alpha 10 BL140 CXCP.1
Selling Tax Code This code determines tax rates when DR100 IC10.2
this item is sold from this location. IC12.1 IC12.2
Valid sell tax codes are defined in the IC125 IC130
Tax system. The sell tax code determines IC140 IC141
the tax table from which to extract tax IC142 IC145
data. IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-STD-COST Signed 13.5 BL140 CXCP.1
Standard Cost This field contains the standard unit DR100 IC10.2
cost of this item at this location. This IC12.1 IC12.2
field is required for standard cost IC125 IC130
companies. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-FUT-STD-COST Signed 13.5 BL140 CXCP.1
Future Standard Cost This field contains the future standard DR100 IC10.2
cost for the item. Update Variances IC12.1 IC12.2
(IC175) updates this into the standard IC125 IC130
cost field and creates the appropriate IC140 IC141
general ledger transaction for this IC142 IC145
field. IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-SOH-QTY Signed 13.4 BL140 CXCP.1
Stock On Hand This field indicates the quantity that DR100 IC10.2
Quantity is currently on hand in the inventory. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC82.1
IC820 IC83.1
...
ITL-SECONDARY-QTY Signed 13.4 BL140 CXCP.1
Secondary Quantity This field contains the secondary DR100 IC10.2
quantity, which is tracked if the item IC12.1 IC12.2
is a catch weight item. This quantity IC125 IC130
is a memo quantity only. It is not used IC140 IC141
for valuation. IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC820
...
ITL-ALLOC-QTY Signed 13.4 BL140 CXCP.1
Allocated Quantity This field contains the quantity DR100 IC10.2
allocated to orders for this item. This IC12.1 IC12.2
quantity is maintained by the Warehouse IC125 IC130
system. IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC82.1 IC83.1
...
ITL-UNALLOC-QTY Signed 13.4 BL140 CXCP.1
Unallocated Quantity This field contains the quantity of DR100 IC10.2
future customer orders that have not yet IC12.1 IC12.2
been allocated. This field is maintained IC125 IC130
by the Warehouse system. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC82.1
IC83.1 IC840
...
ITL-BACKORD-QTY Signed 13.4 BL140 CXCP.1
Backordered Quantity This field contains the quantity of DR100 IC10.2
orders that should have been allocated, IC12.1 IC12.2
but were not because there was not IC125 IC130
enough available inventory. This field IC138 IC140
is maintained by the Warehouse system. IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC82.1 IC83.1
...
ITL-IN-PROC-QTY Signed 13.4 BL140 CXCP.1
In Proc Qty This is the quantity that is in process DR100 IC10.2
in the warehouse which means that this IC12.1 IC12.2
quantity has been printed on a pick IC125 IC130
list, but it has not been shipped yet. IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-ONORDER-QTY Signed 13.4 BL140 CXCP.1
On Order Quantity This field contains the on-order DR100 IC10.2
quantity for the item location. It is IC12.1 IC12.2
the total of all open supply orders. It IC125 IC130
is maintained by the Purchase Order and IC138 IC140
Requisitions systems. IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-INTRANS-QTY Signed 13.4 BL140 CXCP.1
Intransit Quantity This field contains the quantity DR100 IC10.2
intransit to the item location. This is IC12.1 IC12.2
maintained by the Inventory Control IC125 IC130
system. IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-WIP-QTY Signed 13.4 BL140 CXCP.1
Wip Qty This field represents the work-in- DR100 IC12.1
process quantity. It is used by the IC12.2 IC125
Work Order system to indicate the IC130 IC140
quantity of finished goods that are in IC141 IC142
the process of being produced. IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
IC83.1 IC840
...
ITL-HOLD-QTY Signed 13.4 BL140 CXCP.1
Hold Quantity This field contains the quantity of DR100 IC10.2
items on hold for inspection at the IC12.1 IC12.2
location. This field is maintained by IC125 IC130
the Purchase Order system. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC82.1
IC83.1 IC840
...
ITL-MOVE-CLASS Alpha 1 BL140 CXCP.1
Movement Class This field contains the designated DR100 IC10.2
movement class. IC12.1 IC12.2
1 = Movement Class 1 IC125 IC130
2 = Movement Class 2 IC140 IC141
3 = Movement Class 3 IC142 IC145
IC150 IC151
IC152 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
...
ITL-MOVE-RANK Numeric 5 BL140 CXCP.1
Movement Rank This field contains the ranking within DR100 IC10.2
the movement class. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC150 IC151
IC152 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
...
ITL-STORAGE-CODE Alpha 5 BL140 CXCP.1
Bin Storage Code This field contains the code assigned DR100 IC10.2
to describe the physical characteristics IC12.1 IC12.2
of a bin. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-PREFER-BIN Alpha 7 BL140 CXCP.1
Preferred Bin This field contains the designated DR100 IC10.2
preferred bin for the item at this IC12.1 IC12.2
location. This is the default bin number IC125 IC130
used on transactions if the item is bin IC140 IC141
tracked. IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MIN-ORDER Signed 13.4 BL140 CXCP.1
Minimum Order This field contains the minimum order DR100 IC10.2
Quantity quantity. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MAX-ORDER Signed 13.4 BL140 CXCP.1
Maximum Order This field contains the maximum order DR100 IC10.2
Quantity quantity. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ORDER-POLICY Alpha 3 BL140 CXCP.1
Ordering Policy This field contains the method of DR100 IC10.2
reordering. IC12.1 IC12.2
FOP = Fixed Order Point IC125 IC130
TPO = Time Phased Order Point IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-REORD-DOC-CD Alpha 1 BL140 CXCP.1
Reorder Document This field contains a code that DR100 IC10.2
Code indicates the manner in which this item IC12.1 IC12.2
is reordered. IC125 IC130
N = No document created, only plan IC140 IC141
P = Purchaser Order IC142 IC145
R = Requisition IC170 IC175
X = Intransit Document IC20.1 IC20.2
T = Transfer Document IC21.1 IC21.2
I = Issue Document IC211 IC22.1
W = Work Order IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-REORD-QTY-CD Alpha 1 BL140 CXCP.1
Reorder Quantity This field contains the reorder DR100 IC10.2
Code quantity code that indicates how to IC12.1 IC12.2
determine the quantity ordered. IC125 IC130
D = Difference Quantity IC140 IC141
E = Economic Order Quantity IC142 IC145
F = Fixed Reorder Quantity IC170 IC175
M = Order up to Maximum Level IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-REORD-PT-CD Alpha 1 BL140 CXCP.1
Reorder Point Code This field contains the reorder point DR100 IC10.2
code that indicates how the reorder IC12.1 IC12.2
point quantity is determined. IC125 IC130
F = Fixed Reorder Point IC140 IC141
V = Variable Reorder Point IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-REORDER-QTY Signed 13.4 BL140 CXCP.1
Reorder Quantity This field contains the normal reorder DR100 IC10.2
quantity for the item at this location. IC12.1 IC12.2
This field is maintained by the user or IC120 IC125
the system, based on the reorder IC130 IC140
quantity code. IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-REORDER-POINT Signed 13.4 BL140 CXCP.1
Reorder Point This field contains the reorder point. DR100 IC10.2
Reordering for this item is triggered to IC12.1 IC12.2
occur when the item available quantity IC120 IC125
falls below this reorder point. IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC183
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
...
ITL-SUGG-REORD-PT Signed 13.4 IC182 IC81.1
Sugg Reord Pt This is the calculated suggested par IC812 IC840
value or stock level quantity. This
quantity is calculated by IC182 - Par
Location Utilization report.
ITL-LEAD-CTRL-CD Alpha 1 BL140 CXCP.1
Leadtime Control This field contains the code that DR100 IC10.2
Code determines how the leadtime number of IC12.1 IC12.2
days is maintained. IC125 IC130
M = Manually Entered IC140 IC141
R = Needs Review IC142 IC145
S = System Calculates IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-LEADTIME-DAYS Numeric 3 BL140 CXCP.1
Leadtime Number of This field contains the average DR100 IC10.2
Days leadtime days. It is the average of the IC12.1 IC12.2
last and previous leadtime days if this IC120 IC125
field is system calculated. IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-LAST-LEADTIME Numeric 3 BL140 CXCP.1
Last Lead Time This field contains the difference DR100 IC12.1
between the received date and the IC12.2 IC125
purchase order date. This field is IC130 IC140
updated by the Purchase Order system. IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
IC83.1 IC840
...
ITL-PREV-LEADTIME Numeric 3 BL140 CXCP.1
Previous Leadtime This field is maintained by the DR100 IC12.1
Purchase Order system. The last leadtime IC12.2 IC125
value is moved to the previous leadtime IC130 IC140
field when a new purchase order is IC141 IC142
received. IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
IC83.1 IC840
...
ITL-AUTO-PO Alpha 1 BL140 CXCP.1
Auto Create This field indicates whether a purchase DR100 IC10.2
Purchase Orders order is to be automatically created for IC12.1 IC12.2
this item. IC125 IC130
N = No IC140 IC141
Y = Yes IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ORDER-MULT Numeric 4 BL140 CXCP.1
Order Multiple This field contains the order multiple. DR100 IC10.2
The reorder quantity should be a IC12.1 IC12.2
multiple of this quantity. IC120 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-EOQ Signed 13.4 BL140 CXCP.1
Economic Order This field contains the EOQ (Economic DR100 IC10.2
Quantity Order Quantity). This is a calculation IC12.1 IC12.2
that checks the cost of ordering the IC120 IC125
item against the cost of carrying the IC130 IC140
item in inventory to determine the ideal IC141 IC142
quantity to be ordered. IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-SAFETY-STOCK Signed 13.4 BL140 CXCP.1
Safety Stock This field contains the quantity of DR100 IC10.2
stock planned to be in inventory to IC12.1 IC12.2
protect against the fluctuations in IC125 IC130
supply and demand. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MANUF-CODE Alpha 4 BL140 CXCP.1
Manufacturer's Code This field contains a user defined code DR100 IC10.2
that indicates the manufacturer of an IC12.1 IC12.2
item. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MANUF-DIVISION Alpha 4 IC10.2 IC12.1
Manufacturer's This is a user defined code that IC330 IC812
Division indicates which division of a
manufacturer is tied to an item.
ITL-MANUF-NBR Alpha 15 BL140 CXCP.1
Manufacturer's Item This is the identifier that the DR100 IC10.2
Number manufacturer has assigned to an item. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-SP-CYCLE-CNT Alpha 1 BL140 CXCP.1
Special Cycle Count This field contains the special cycle DR100 IC10.2
Flag count designator, which is used to IC12.1 IC12.2
select this item for cycle counting IC125 IC130
regardless of the item's movement class. IC140 IC141
X = Selected for Special Cycle Cnt IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-LAST-COUNT-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Last Count Date This field contains the date this item DR100 IC10.2
was last counted in the physical IC12.1 IC12.2
inventory process. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-FORECAST-NBR Numeric 4 BL140 CXCP.1
Forecast Number This number identifies which forecast DR100 IC10.2
record is to be used for this item. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-CHARGEABLE-FL Alpha 1 BL140 CXCP.1
Chargeable Fl This flag indicates that this item is a DR100 IC10.2
patient chargeable item. IC12.1 IC12.2
Y = Yes IC125 IC130
N = No IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-TRACKING-FL Alpha 1 BL140 CXCP.1
Tracking Flag This flag specifies if quantities are DR100 IC10.2
to be tracked at this location for this IC12.1 IC12.2
item. IC125 IC130
Y = Yes IC140 IC141
N = No IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-BIN-TRACK-FL Alpha 1 BL140 CXCP.1
Bin Tracking Flag This field indicates whether this item DR100 IC10.2
is to be tracked by bin at this IC12.1 IC12.2
location. IC125 IC130
N = No IC140 IC141
Y = Yes IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ALLOW-REC-FL Alpha 1 BL140 CXCP.1
Allow Receipts Flag This field indicates whether receipts DR100 IC10.2
are allowed. If set to No, the Purchase IC12.1 IC12.2
Order system cannot order the item. IC125 IC130
N = No IC140 IC141
Y = Yes IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ALLOW-ISS-FL Alpha 1 BL140 CXCP.1
Allow Issues Flag This field indicates whether issues of DR100 IC10.2
this item are allowed. IC12.1 IC12.2
N = No IC125 IC130
Y = Yes IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-INSP-REQ-FL Alpha 1 BL140 CXCP.1
Inspection Required This field specifies if the item is DR100 IC10.2
Flag inspected when it is received. This IC12.1 IC12.2
field defaults to the Purchase Order and IC125 IC130
Case Carts systems. IC140 IC141
N = No IC142 IC145
Y = Yes IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ACTIVITY-FL Alpha 1 BL140 CXCP.1
Activity Flag This field indicates whether this DR100 IC10.2
record has been updated by any IC12.1 IC12.2
transaction since Stock Status Report IC125 IC130
(IC145), Item Mass Update (IC116) or IC140 IC141
Distribution Requirements Report (DR100) IC142 IC145
has been run. IC170 IC175
N = No IC20.1 IC20.2
Y = Yes IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC820
...
ITL-FREEZE-FL Alpha 1 BL140 CXCP.1
Freeze Flag This field indicates this record has DR100 IC10.2
been selected to be counted in the IC12.1 IC12.2
physical inventory process. IC125 IC130
N = No IC140 IC141
Y = Yes IC142 IC145
IC170 IC175
IC179 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC574 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC73.1 IC74.1
...
ITL-FREEZE-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Freeze Date This field indicates the date this DR100 IC10.2
record was selected for physical IC12.1 IC12.2
inventory counting. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC574
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC74.1
IC81.1 IC812
...
ITL-LAST-ISSUE-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Last Issue Date This field contains the date of the DR100 IC10.2
last issue of this item at this IC12.1 IC12.2
location. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-LAST-UPD-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Last Update Date This field contains the date the DR100 IC10.2
transaction was released for an item IC12.1 IC12.2
record or the last date an item record IC125 IC130
was maintained. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC262 IC28.1
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
...
ITL-UPDATE-TIME Numeric 6 BL140 CXCP.1
Update Time This field contains the system time DR100 IC12.1
when the record was updated. IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC262
IC28.1 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-TRAN-COUNTER Numeric 6 BL140 CXCP.1
Tran Counter This field contains a transaction DR100 IC12.1
object number used to determine the IC12.2 IC125
sequence of updating of the Item IC130 IC140
Location file. IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC262
IC28.1 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-LAST-REC-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Last Received Date This field contains the date of the DR100 IC10.2
last receiving. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-LAST-TURN-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Last Turnover Date This field contains the date the DR100 IC10.2
turnover rate was last calculated. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MSDS-DT Numeric 8 (yyyymmdd) BL140 CXCP.1
Material Safety This field contains the date a new DR100 IC10.2
DataSheet Date Material Safety Data Sheet (MSDS) should IC12.1 IC12.2
be sent from the vendor. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MSDS-ORDER-FL Alpha 1 BL140 CXCP.1
MSDS Ordered Flag This field is used by the Purchase DR100 IC10.2
Order system to indicate if the Material IC12.1 IC12.2
Safety Data Sheet (MSDS) for this item IC125 IC130
has been sent to this location. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-MSDS-DOCUMENT Alpha 30 BL140 CXCP.1
Msds Document The document number from the most DR100 IC12.1
recent MSDS that was received. IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
IC83.1 IC840
...
ITL-MSDS-VERSION Alpha 4 BL140 CXCP.1
Msds Version The version number of the most recent DR100 IC12.1
MSDS that was received. IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
IC83.1 IC840
...
ITL-AVG-SOH-QTY Signed 13.4 BL140 CXCP.1
Average Stock On This field contains the average DR100 IC10.2
Hand Quantity stock-on-hand quantity of the item for IC12.1 IC12.2
the last year. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC190 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-TURN-RATE Signed 6.1 BL140 CXCP.1
Turnover Rate This field contains the rate of DR100 IC10.2
turnover, which is calculated by IC12.1 IC12.2
dividing the annual sales quantity by IC125 IC130
the average stock-on-hand quantity. IC134 IC135
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
...
ITL-LAST-REC-COST Signed 13.5 BL140 CXCP.1
Last Received Cost This field contains the last received DR100 IC10.2
or invoiced unit cost. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC28.1 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-LAST-ISS-COST Signed 13.5 BL140 CXCP.1
Last Issue Cost This field contains the unit cost of DR100 IC10.2
the last issue. IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-AVERAGE-COST Signed 13.5 BL140 CXCP.1
Average Cost This field contains the moving average DR100 IC10.2
unit cost of an item. This figure is IC12.1 IC12.2
always calculated regardless of the IC125 IC130
company costing method. IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC28.1 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC812 IC82.1
...
ITL-TRANS-COUNT Numeric 5 BL140 CXCP.1
Nbr Transaction This field contains the number of DR100 IC10.2
Since Last Cnt inventory transactions involving this IC12.1 IC12.2
item at this location since the last IC125 IC130
update run of Update Variances (IC175). IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
...
ITL-CNT-ACCURACY Signed 5.1 BL140 CXCP.1
Count Accuracy This field contains the count accuracy DR100 IC10.2
Percent for this item at this location from the IC12.1 IC12.2
last physical inventory count. IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ADDED-DATE Numeric 8 (yyyymmdd) BL140 CXCP.1
Date Item was Added This field contains the date the Item DR100 IC10.2
Location record was originally added in IC12.1 IC12.2
IC12.1 (Item Location) or IC10.1 IC125 IC130
(Formats). It defaults to the system IC140 IC141
date when the record is added. IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ACTIVE-STATUS Alpha 1 BL140 CXCP.1
Status This status indicates whether the item DR100 IC10.2
is active or inactive at this location. IC12.1 IC12.2
If the item is inactive, no transactions IC125 IC130
can be entered for this item at this IC140 IC141
location, but transactions in process IC142 IC145
can be completed. IC170 IC175
A = Active IC20.1 IC20.2
I = Inactive IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-USER-FIELD1 Alpha 30 BL140 CXCP.1
Item Mster User This field contains the first DR100 IC10.2
Defined Field1 user-defined field for the Item Location IC12.1 IC12.2
file. It can be used to enter any data IC125 IC130
the user wants. This field's name is IC140 IC141
defined in IC01.1 (Company). IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-USER-FIELD2 Alpha 10 (Lower Case) BL140 CXCP.1
Item Mster User This field contains the second DR100 IC10.2
Defined Field2 user-defined field for the Item Location IC12.1 IC12.2
record. It can be used to enter any data IC125 IC130
the user wants. This field's name is IC140 IC141
defined in IC01.1 (Company). IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-USER-FIELD3 Alpha 10 (Lower Case) BL140 CXCP.1
Item Mster User This field contains the third DR100 IC10.2
Defined Field3 user-defined field for the Item Location IC12.1 IC12.2
record. It can be used to enter any data IC125 IC130
the user wants. This field's name is IC140 IC141
defined in IC01.1 (Company). IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-USER-FIELD-N1 Signed 13.5 BL140 CXCP.1
User Defined This field contains the first DR100 IC10.2
Numeric Field 1 user-defined numeric field for the Item IC12.1 IC12.2
Location record. It can be used to enter IC125 IC130
any data the user wants. This field's IC140 IC141
name is defined in IC01.1 (Company). IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-USER-FIELD-N2 Signed 13.5 BL140 CXCP.1
User Defined This field contains the second DR100 IC10.2
Numeric Field 2 user-defined numeric field for the Item IC12.1 IC12.2
Location record. It can be used to enter IC125 IC130
any data the user wants. This field's IC140 IC141
name is defined in IC01.1 (Company). IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-USER-FIELD-N3 Signed 13.5 BL140 CXCP.1
User Defined This field contains the third DR100 IC10.2
Numeric Field 3 user-defined numeric field for the Item IC12.1 IC12.2
Location record. It can be used to enter IC125 IC130
any data the user wants. This field's IC140 IC141
name is defined in IC01.1 (Company). IC142 IC145
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC281 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC45.1
IC500 IC520
IC521 IC522
IC523 IC524
IC525 IC526
IC527 IC530
IC531 IC61.1
IC62.1 IC62.2
IC67.1 IC68.1
IC68.2 IC68.3
IC81.1 IC812
IC82.1 IC83.1
...
ITL-ACCT-UNIT-INV Derived
Acct Unit Inv This field is derived from the
inventory accounting unit on the General
Ledger Account Category file.
ITL-ACCOUNT-INV Derived
Account Inv This field is derived from the
inventory account field on the General
Ledger Account Category file.
ITL-SUB-ACCT-INV Derived
Sub Acct Inv This field is derived from the
inventory subaccount field on the
General Ledger Account Category file.
ITL-MANUF-NBR-DER Derived
Manufacturer's Item This field is the manufacturer's number
Number based on where it is set up in the Item
Location or Item Master file.
ITL-MANUF-CODE-DER Derived
Manufacturer's Code 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 Derived
Manufacturer's This field is the manufacturer's
Division division based on where it is set up in
the Item Master or Item Location file.
ITL-NEG-ALLOC Derived
Neg Alloc This field is allocated quantity set to
negative for use in the allocatable and
sellable calculations.
ITL-NEG-BACKORD Derived
Neg Backord This field is the backorder quantity
set to negative for use in the allocable
and sellable calculations.
ITL-NEG-INPROC Derived
Neg Inproc 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 Derived
Neg Onord 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 Derived
Neg Intrans This field is the intransit quantity
set to negative for use in the
available-to-allocate and
available-to-sell calculations.
ITL-NEG-WIP Derived
Neg Wip This field is the Work In Process
quantity set to negative for use in the
allocatable and sellable calculations.
ITL-NEG-HOLD Derived
Neg Hold This field is the Hold quantity set to
negative for use in the allocatable and
sellable calculations.
ITL-SELL-ALLOC Derived
Sell Alloc This field is the allocated quantity
with its sign set to match the option on
the available-to-sell calculation.
ITL-SELL-INPROC Derived
Sell Inproc 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 Derived
Sell Backord This field is the backorder quantity
with its sign set to match the option
selected on the available-to-sell
calculation.
ITL-SELL-ONORD Derived
Sell Onord 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 Derived
Sell Intran This field is the intransit quantity
with its sign set to match the option
selected in the available-to-sell
calculation.
ITL-SELL-WIP Derived
Sell Wip 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 Derived
Sell Hold This field is the hold quantity with
its sign set to match the option
selected in the available-to-sell
calculation.
ITL-ALC-ALLOC Derived
Alc Alloc This field is the Allocated quantity
with it's sign set to match the option
selected in the allocatable calculation.
ITL-ALC-INPROC Derived
Alc Inproc This field is the In Process quantity
with it's sign set to match the option
selected in the allocatable calculation.
ITL-ALC-BACKORD Derived
Alc Backord This field is the Backorder quantity
with it's sign set to match the option
selected in the allocatable calculation.
ITL-ALC-ONORD Derived
Alc Onord This field is the On Order quantity
with it's sign set to match the option
selected in the allocatable calculation.
ITL-ALC-INTRAN Derived
Alc Intran This field is the Intransit quantity
with it's sign set to match the option
selected in the allocatable calculation.
ITL-ALC-WIP Derived
Alc Wip 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 Derived
Alc Hold This field is the Hold quantity with
it's sign set to match the option
selected in the allocatable calculation.
ITL-SELLABLE Derived
Sellable This field is the calculated quantity
that is available to sell for those
customers that do not allow backorders.
ITL-ALLOCATABLE Derived
Allocatable This field is the quantity that is
available to allocate to an order, so
that the picking document can be
printed.
ITL-CWT-ALLOCATABL Derived
Cwt Allocatabl This field is the quantity in terms of
the catch weight that can be allocated
for orders.
ITL-PROC-DAYS Numeric 3 BL140 CXCP.1
Proc Days The number of days it takes to process DR100 IC12.1
receivings until they are ready to be IC12.2 IC125
shipped. IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC211
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC281
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC45.1 IC500
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC61.1 IC62.1
IC62.2 IC67.1
IC68.1 IC68.2
IC68.3 IC81.1
IC82.1 IC83.1
IC840 MA63.1
...
ITL-CONSIGNMENT-FL Alpha 1 IC12.1 IC330
Consignment Fl The flag designates that this item is a IC812
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
ITEMLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITLSET1 COMPANY BL121 BL123
LOCATION BL140 BL290
ITEM BL80.1 BL85.2
BL90.1 CXCP.1
DR100 DR25.1
DR40.1 IC01.1
IC02.1 IC10.1
IC10.2 IC12.1
IC12.2 IC120
IC125 IC130
IC134 IC135
IC138 IC140
IC141 IC142
IC143 IC145
IC150 IC151
...
ITLSET2 COMPANY BL85.1 BL85.2
ITEM IC10.1 IC10.2
LOCATION IC11.1 IC170
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC42.1 IC42.2
IC42.3 IC42.4
IC60.1 IC81.1
IC82.1
ITLSET5 COMPANY KeyChange DR42.1 IC225
LOCATION IC590
BUYER-CODE
ITEM
ITLSET7 COMPANY KeyChange IC170 IC295
LOCATION
LAST-COUNT-DT
ITEM
ITLSET8 COMPANY KeyChange IC170 IC281
LOCATION IC81.1 IC83.1
PREFER-BIN
ITEM
ITLSET9 COMPANY KeyChange IC140 IC233
LOCATION IC234 IC70.1
CONSIGNMENT-FL
ITEM
ITEMLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
ITL-COMPANY -> CPY-COMPANY
Bingrpdtl BINGRPDTL Not Required
Valid When ITL-PREFER-BIN != Spaces
And ITL-BIN-TRACK-FL = "Y"
ITL-COMPANY -> BGD-COMPANY
ITL-LOCATION -> BGD-LOCATION
ITL-LOCATION -> BGD-BIN-GROUP
ITL-PREFER-BIN -> BGD-BIN
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
And ITL-BIN-TRACK-FL = "Y"
ITL-COMPANY -> ICB-COMPANY
ITL-LOCATION -> ICB-LOCATION
ITL-PREFER-BIN -> ICB-BIN
Repl From Bin ICBIN Required
ITL-COMPANY -> ICB-COMPANY
ITL-LOCATION -> ICB-LOCATION
ITL-PREFER-BIN -> ICB-BIN
Repl Itemloc ITEMLOC Not Required
ITL-COMPANY -> ITL-COMPANY
ITL-LOCATION -> ITL-LOCATION
ITL-ITEM -> ITL-ITEM
Rrpl Itemloc ITEMLOC Not Required
ITL-COMPANY -> ITL-COMPANY
ITL-LOCATION -> ITL-LOCATION
ITL-ITEM -> ITL-ITEM
Storage Code BINSTORAGE Required
When ITL-STORAGE-CODE != Spaces
ITL-COMPANY -> BST-COMPANY
ITL-LOCATION -> BST-LOCATION
ITL-STORAGE-CODE -> BST-STORAGE-CODE
Tax Code Purch TXTAXCODE Required
When ITL-PURCH-TAX-CD != Spaces
ITL-COMPANY -> TAC-COMPANY
ITL-PURCH-TAX-CD -> TAC-TAX-CODE
Tax Code Sell TXTAXCODE Required
When ITL-SELL-TAX-CD != Spaces
ITL-COMPANY -> TAC-COMPANY
ITL-SELL-TAX-CD -> TAC-TAX-CODE
Vendorgroup APVENGROUP Required
CPY-VENDOR-GROUP -> VGP-VENDOR-GROUP
ITEMLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Forecast ICFORECAST
ITL-COMPANY -> IFO-COMPANY
ITL-LOCATION -> IFO-LOCATION
ITL-ITEM -> IFO-ITEM
IFO-FORECAST-YEAR
IFO-FORECAST-NBR
IFO-QUARTER
Ichistory ICHISTORY
ITL-COMPANY -> ICH-COMPANY
ITL-LOCATION -> ICH-LOCATION
ITL-ITEM -> ICH-ITEM
ICH-YEAR
ICH-QUARTER
Icplanord ICPLANORD
ITL-COMPANY -> IPL-COMPANY
ITL-LOCATION -> IPL-LOCATION
ITL-ITEM -> IPL-ITEM
IPL-PERIOD-DT
Ict By Date ICTRANS
ITL-COMPANY -> ICT-COMPANY
ITL-LOCATION -> ICT-LOCATION
ITL-ITEM -> ICT-ITEM
ICT-UPDATE-DATE
ICT-UPDATE-TIME
ICT-TRAN-COUNTER
Itcomment ITCOMMENT
ITE-ITEM-GROUP -> ICO-ITEM-GROUP
ITL-ITEM -> ICO-ITEM
ICO-LANGUAGE-CODE
ICO-SEQ
Itemsrc ITEMSRC
ITL-COMPANY -> ITM-COMPANY
ITL-LOCATION -> ITM-LOCATION
ITL-ITEM -> ITM-ITEM
ITM-REPLENISH-PRI
Itlset2 ITEMLOC
ITL-COMPANY -> ITL-COMPANY
ITL-ITEM -> ITL-ITEM
ITL-LOCATION
Itserial ITSERIAL Delete Cascades
ITL-COMPANY -> SER-COMPANY
ITL-ITEM -> SER-ITEM
SER-SERIAL
Pharittoitmloc PHARITEM
ITL-COMPANY -> PHI-COMPANY
ITL-LOCATION -> PHI-LOCATION
ITL-ITEM -> PHI-ITEM
PHI-NDC-NBR
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
|