 |
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
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.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 IC280 IC283 IC29.1 IC29.2 IC29.3
IC38.1 IC47.1 IC49.1 IC50.1 IC50.2 IC51.1
IC550 IC574 IC589 IC59.1 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 MA41.2 MA53.5 MA540 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 RQIB.1
SEA4.1 WH224 WH226 IC11.1 IC42.1 IC42.2
IC42.3 IC42.4 DR42.1 IC590 IC295 IC233
IC234
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 API1.1 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 IC598 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 MA180 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1
PO100 PO101 PO122 PO131 PO16.1 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO228
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO54.4 PO64.1 POI3.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1
RQIG.1 SEA3.1 WH110 WH120 WH126 WH130
WH132 WH190 WH20.1 WH20.2 WH20.3 WH20.4
WH20.5 WH20.6 WH20.7 WH22.1 WH220 WH222
WH25.1 WH25.2 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 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 WH40.1 WH40.2 WH520
WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITL-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-GL-CATEGORY Alpha 4 AP125 AP126
General Ledger This field is used to extract AP131 AP25.1
Category appropriate account numbers for any AP25.2 AP26.1
inventory movement. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-BUYER-CODE Alpha 3 AP125 AP126
Buyer Code This field contains a code representing AP131 AP25.1
the person responsible for the item at AP25.2 AP26.1
this location. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-UOM Alpha 4 AP125 AP126
Unit of Measure This is the default transaction unit of AP131 AP25.1
measure for this item at this location. AP25.2 AP26.1
The unit of measure must be set up as a AP27.1 CXCP.1
valid unit of measure defined in IC11.1 DR100 IC10.2
(Item Master) and be valid for IC12.1 IC12.2
transaction use. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-PURCH-TAX-FL Alpha 1 AP125 AP126
Purchasing Tax Flag This field indicates whether this item AP131 AP25.1
is taxable (Yes) or nontaxable (No) when AP25.2 AP26.1
it is purchased for this location. AP27.1 CXCP.1
" " = Blank Defaults to Next Level DR100 IC10.2
Y = Yes IC12.1 IC12.2
N = No 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-PURCH-TAX-CD Alpha 10 AP125 AP126
Purchasing Tax This field contains the code used to AP131 AP25.1
Table Code determine if this item is taxable when AP25.2 AP26.1
purchased at this location. This code is AP27.1 CXCP.1
also used to extract tax data from the DR100 IC10.2
tax file based on this tax code. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-SELL-TAX-FL Alpha 1 AP125 AP126
Selling Tax Flag This field indicates whether this item AP131 AP25.1
is nontaxable (No) or taxable (Yes) when AP25.2 AP26.1
sold from this location. AP27.1 CXCP.1
Y = Taxable When Sold DR100 IC10.2
N = Not Taxable When Sold 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-SELL-TAX-CD Alpha 10 AP125 AP126
Selling Tax Code This code determines tax rates when AP131 AP25.1
this item is sold from this location. AP25.2 AP26.1
Valid sell tax codes are defined in the AP27.1 CXCP.1
Tax system. The sell tax code determines DR100 IC10.2
the tax table from which to extract tax IC12.1 IC12.2
data. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-STD-COST Signed 13.5 AP125 AP126
Standard Cost This field contains the standard unit AP131 AP25.1
cost of this item at this location. This AP25.2 AP26.1
field is required for standard cost AP27.1 CXCP.1
companies. DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-FUT-STD-COST Signed 13.5 AP125 AP126
Future Standard Cost This field contains the future standard AP131 AP25.1
cost for the item. Update Variances AP25.2 AP26.1
(IC175) updates this into the standard AP27.1 CXCP.1
cost field and creates the appropriate DR100 IC10.2
general ledger transaction for this IC12.1 IC12.2
field. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-SOH-QTY Signed 13.4 AP125 AP126
Stock On Hand This field indicates the quantity that AP131 AP25.1
Quantity is currently on hand in the inventory. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-SECONDARY-QTY Signed 13.4 AP125 AP126
Secondary Quantity This field contains the secondary AP131 AP25.1
quantity, which is tracked if the item AP25.2 AP26.1
is a catch weight item. This quantity AP27.1 CXCP.1
is a memo quantity only. It is not used DR100 IC10.2
for valuation. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ALLOC-QTY Signed 13.4 AP125 AP126
Allocated Quantity This field contains the quantity AP131 AP25.1
allocated to orders for this item. This AP25.2 AP26.1
quantity is maintained by the Warehouse AP27.1 CXCP.1
system. DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
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 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 IC598
IC61.1 IC62.1
...
ITL-UNALLOC-QTY Signed 13.4 AP125 AP126
Unallocated Quantity This field contains the quantity of AP131 AP25.1
future customer orders that have not yet AP25.2 AP26.1
been allocated. This field is maintained AP27.1 CXCP.1
by the Warehouse system. DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-BACKORD-QTY Signed 13.4 AP125 AP126
Backordered Quantity This field contains the quantity of AP131 AP25.1
orders that should have been allocated, AP25.2 AP26.1
but were not because there was not AP27.1 CXCP.1
enough available inventory. This field DR100 IC10.2
is maintained by the Warehouse system. IC12.1 IC12.2
IC125 IC130
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 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 IC598
IC61.1 IC62.1
...
ITL-IN-PROC-QTY Signed 13.4 AP125 AP126
In Proc Qty This is the quantity that is in process AP131 AP25.1
in the warehouse which means that this AP25.2 AP26.1
quantity has been printed on a pick AP27.1 CXCP.1
list, but it has not been shipped yet. DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
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 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 IC598
IC61.1 IC62.1
...
ITL-ONORDER-QTY Signed 13.4 AP125 AP126
On Order Quantity This field contains the on-order AP131 AP25.1
quantity for the item location. It is AP25.2 AP26.1
the total of all open supply orders. It AP27.1 CXCP.1
is maintained by the Purchase Order and DR100 IC10.2
Requisitions systems. IC12.1 IC12.2
IC125 IC130
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 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 IC598
IC61.1 IC62.1
...
ITL-INTRANS-QTY Signed 13.4 AP125 AP126
Intransit Quantity This field contains the quantity AP131 AP25.1
intransit to the item location. This is AP25.2 AP26.1
maintained by the Inventory Control AP27.1 CXCP.1
system. DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
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 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 IC598
IC61.1 IC62.1
...
ITL-WIP-QTY Signed 13.4 AP125 AP126
Wip Qty This field represents the work-in- AP131 AP25.1
process quantity. It is used by the AP25.2 AP26.1
Work Order system to indicate the AP27.1 CXCP.1
quantity of finished goods that are in DR100 IC12.1
the process of being produced. 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 IC598
IC61.1 IC62.1
IC62.2 IC67.1
...
ITL-HOLD-QTY Signed 13.4 AP125 AP126
Hold Quantity This field contains the quantity of AP131 AP25.1
items on hold for inspection at the AP25.2 AP26.1
location. This field is maintained by AP27.1 CXCP.1
the Purchase Order system. DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MOVE-CLASS Alpha 1 AP125 AP126
Movement Class This field contains the designated AP131 AP25.1
movement class. AP25.2 AP26.1
1 = Movement Class 1 AP27.1 CXCP.1
2 = Movement Class 2 DR100 IC10.2
3 = Movement Class 3 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 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 IC598
...
ITL-MOVE-RANK Numeric 5 AP125 AP126
Movement Rank This field contains the ranking within AP131 AP25.1
the movement class. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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 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 IC598
...
ITL-STORAGE-CODE Alpha 5 AP125 AP126
Bin Storage Code This field contains the code assigned AP131 AP25.1
to describe the physical characteristics AP25.2 AP26.1
of a bin. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-PREFER-BIN Alpha 7 AP125 AP126
Preferred Bin This field contains the designated AP131 AP25.1
preferred bin for the item at this AP25.2 AP26.1
location. This is the default bin number AP27.1 CXCP.1
used on transactions if the item is bin DR100 IC10.2
tracked. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MIN-ORDER Signed 13.4 AP125 AP126
Minimum Order This field contains the minimum order AP131 AP25.1
Quantity quantity. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MAX-ORDER Signed 13.4 AP125 AP126
Maximum Order This field contains the maximum order AP131 AP25.1
Quantity quantity. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ORDER-POLICY Alpha 3 AP125 AP126
Ordering Policy This field contains the method of AP131 AP25.1
reordering. AP25.2 AP26.1
FOP = Fixed Order Point AP27.1 CXCP.1
TPO = Time Phased Order Point DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-REORD-DOC-CD Alpha 1 AP125 AP126
Reorder Document This field contains a code that AP131 AP25.1
Code indicates the manner in which this item AP25.2 AP26.1
is reordered. AP27.1 CXCP.1
N = No document created, only plan DR100 IC10.2
P = Purchaser Order IC12.1 IC12.2
R = Requisition IC125 IC130
X = Intransit Document IC140 IC141
T = Transfer Document IC142 IC145
I = Issue Document IC170 IC175
W = Work Order 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-REORD-QTY-CD Alpha 1 AP125 AP126
Reorder Quantity This field contains the reorder AP131 AP25.1
Code quantity code that indicates how to AP25.2 AP26.1
determine the quantity ordered. AP27.1 CXCP.1
D = Difference Quantity DR100 IC10.2
E = Economic Order Quantity IC12.1 IC12.2
F = Fixed Reorder Quantity IC125 IC130
M = Order up to Maximum Level 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-REORD-PT-CD Alpha 1 AP125 AP126
Reorder Point Code This field contains the reorder point AP131 AP25.1
code that indicates how the reorder AP25.2 AP26.1
point quantity is determined. AP27.1 CXCP.1
F = Fixed Reorder Point DR100 IC10.2
V = Variable Reorder Point 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-REORDER-QTY Signed 13.4 AP125 AP126
Reorder Quantity This field contains the normal reorder AP131 AP25.1
quantity for the item at this location. AP25.2 AP26.1
This field is maintained by the user or AP27.1 CXCP.1
the system, based on the reorder DR100 IC10.2
quantity code. IC12.1 IC12.2
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 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 IC598
IC61.1 IC62.1
...
ITL-REORDER-POINT Signed 13.4 AP125 AP126
Reorder Point This field contains the reorder point. AP131 AP25.1
Reordering for this item is triggered to AP25.2 AP26.1
occur when the item available quantity AP27.1 CXCP.1
falls below this reorder point. DR100 IC10.2
IC12.1 IC12.2
IC120 IC125
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
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
IC598 IC61.1
...
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 AP125 AP126
Leadtime Control This field contains the code that AP131 AP25.1
Code determines how the leadtime number of AP25.2 AP26.1
days is maintained. AP27.1 CXCP.1
M = Manually Entered DR100 IC10.2
R = Needs Review IC12.1 IC12.2
S = System Calculates 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-LEADTIME-DAYS Numeric 3 AP125 AP126
Leadtime Number of This field contains the average AP131 AP25.1
Days leadtime days. It is the average of the AP25.2 AP26.1
last and previous leadtime days if this AP27.1 CXCP.1
field is system calculated. DR100 IC10.2
IC12.1 IC12.2
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 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 IC598
IC61.1 IC62.1
...
ITL-LAST-LEADTIME Numeric 3 AP125 AP126
Last Lead Time This field contains the difference AP131 AP25.1
between the received date and the AP25.2 AP26.1
purchase order date. This field is AP27.1 CXCP.1
updated by the Purchase Order system. DR100 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 IC598
IC61.1 IC62.1
IC62.2 IC67.1
...
ITL-PREV-LEADTIME Numeric 3 AP125 AP126
Previous Leadtime This field is maintained by the AP131 AP25.1
Purchase Order system. The last leadtime AP25.2 AP26.1
value is moved to the previous leadtime AP27.1 CXCP.1
field when a new purchase order is DR100 IC12.1
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 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 IC598
IC61.1 IC62.1
IC62.2 IC67.1
...
ITL-AUTO-PO Alpha 1 AP125 AP126
Auto Create This field indicates whether a purchase AP131 AP25.1
Purchase Orders order is to be automatically created for AP25.2 AP26.1
this item. AP27.1 CXCP.1
N = No DR100 IC10.2
Y = Yes 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ORDER-MULT Numeric 4 AP125 AP126
Order Multiple This field contains the order multiple. AP131 AP25.1
The reorder quantity should be a AP25.2 AP26.1
multiple of this quantity. AP27.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
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 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 IC598
IC61.1 IC62.1
...
ITL-EOQ Signed 13.4 AP125 AP126
Economic Order This field contains the EOQ (Economic AP131 AP25.1
Quantity Order Quantity). This is a calculation AP25.2 AP26.1
that checks the cost of ordering the AP27.1 CXCP.1
item against the cost of carrying the DR100 IC10.2
item in inventory to determine the ideal IC12.1 IC12.2
quantity to be ordered. 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 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 IC598
IC61.1 IC62.1
...
ITL-SAFETY-STOCK Signed 13.4 AP125 AP126
Safety Stock This field contains the quantity of AP131 AP25.1
stock planned to be in inventory to AP25.2 AP26.1
protect against the fluctuations in AP27.1 CXCP.1
supply and demand. DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MANUF-CODE Alpha 4 AP125 AP126
Manufacturer's Code This field contains a user defined code AP131 AP25.1
that indicates the manufacturer of an AP25.2 AP26.1
item. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
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 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP25.1
Number manufacturer has assigned to an item. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-SP-CYCLE-CNT Alpha 1 AP125 AP126
Special Cycle Count This field contains the special cycle AP131 AP25.1
Flag count designator, which is used to AP25.2 AP26.1
select this item for cycle counting AP27.1 CXCP.1
regardless of the item's movement class. DR100 IC10.2
X = Selected for Special Cycle Cnt 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-LAST-COUNT-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Count Date This field contains the date this item AP131 AP25.1
was last counted in the physical AP25.2 AP26.1
inventory process. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-FORECAST-NBR Numeric 4 AP125 AP126
Forecast Number This number identifies which forecast AP131 AP25.1
record is to be used for this item. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-CHARGEABLE-FL Alpha 1 AP125 AP126
Chargeable Fl This flag indicates that this item is a AP131 AP25.1
patient chargeable item. AP25.2 AP26.1
Y = Yes AP27.1 CXCP.1
N = No DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-TRACKING-FL Alpha 1 AP125 AP126
Tracking Flag This flag specifies if quantities are AP131 AP25.1
to be tracked at this location for this AP25.2 AP26.1
item. AP27.1 CXCP.1
Y = Yes DR100 IC10.2
N = No 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-BIN-TRACK-FL Alpha 1 AP125 AP126
Bin Tracking Flag This field indicates whether this item AP131 AP25.1
is to be tracked by bin at this AP25.2 AP26.1
location. AP27.1 CXCP.1
N = No DR100 IC10.2
Y = Yes 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ALLOW-REC-FL Alpha 1 AP125 AP126
Allow Receipts Flag This field indicates whether receipts AP131 AP25.1
are allowed. If set to No, the Purchase AP25.2 AP26.1
Order system cannot order the item. AP27.1 CXCP.1
N = No DR100 IC10.2
Y = Yes 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ALLOW-ISS-FL Alpha 1 AP125 AP126
Allow Issues Flag This field indicates whether issues of AP131 AP25.1
this item are allowed. AP25.2 AP26.1
N = No AP27.1 CXCP.1
Y = Yes DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-INSP-REQ-FL Alpha 1 AP125 AP126
Inspection Required This field specifies if the item is AP131 AP25.1
Flag inspected when it is received. This AP25.2 AP26.1
field defaults to the Purchase Order and AP27.1 CXCP.1
Case Carts systems. DR100 IC10.2
N = No IC12.1 IC12.2
Y = Yes 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ACTIVITY-FL Alpha 1 AP125 AP126
Activity Flag This field indicates whether this AP131 AP25.1
record has been updated by any AP25.2 AP26.1
transaction since Stock Status Report AP27.1 CXCP.1
(IC145), Item Mass Update (IC116) or DR100 IC10.2
Distribution Requirements Report (DR100) IC12.1 IC12.2
has been run. 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
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-FREEZE-FL Alpha 1 AP125 AP126
Freeze Flag This field indicates this record has AP131 AP25.1
been selected to be counted in the AP25.2 AP26.1
physical inventory process. AP27.1 CXCP.1
N = No DR100 IC10.2
Y = Yes IC12.1 IC12.2
IC125 IC130
IC140 IC141
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 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 IC574
IC598 IC61.1
...
ITL-FREEZE-DT Numeric 8 (yyyymmdd) AP125 AP126
Freeze Date This field indicates the date this AP131 AP25.1
record was selected for physical AP25.2 AP26.1
inventory counting. AP27.1 CXCP.1
DR100 IC10.2
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
IC574 IC598
IC61.1 IC62.1
...
ITL-LAST-ISSUE-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Issue Date This field contains the date of the AP131 AP25.1
last issue of this item at this AP25.2 AP26.1
location. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-LAST-UPD-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Update Date This field contains the date the AP131 AP25.1
transaction was released for an item AP25.2 AP26.1
record or the last date an item record AP27.1 CXCP.1
was maintained. DR100 IC10.2
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 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 IC598
IC61.1 IC62.1
...
ITL-UPDATE-TIME Numeric 6 AP125 AP126
Update Time This field contains the system time AP131 AP25.1
when the record was updated. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 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
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-TRAN-COUNTER Numeric 6 AP125 AP126
Tran Counter This field contains a transaction AP131 AP25.1
object number used to determine the AP25.2 AP26.1
sequence of updating of the Item AP27.1 CXCP.1
Location file. DR100 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
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-LAST-REC-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Received Date This field contains the date of the AP131 AP25.1
last receiving. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-LAST-TURN-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Turnover Date This field contains the date the AP131 AP25.1
turnover rate was last calculated. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MSDS-DT Numeric 8 (yyyymmdd) AP125 AP126
Material Safety This field contains the date a new AP131 AP25.1
DataSheet Date Material Safety Data Sheet (MSDS) should AP25.2 AP26.1
be sent from the vendor. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MSDS-ORDER-FL Alpha 1 AP125 AP126
MSDS Ordered Flag This field is used by the Purchase AP131 AP25.1
Order system to indicate if the Material AP25.2 AP26.1
Safety Data Sheet (MSDS) for this item AP27.1 CXCP.1
has been sent to this location. DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-MSDS-DOCUMENT Alpha 30 AP125 AP126
Msds Document The document number from the most AP131 AP25.1
recent MSDS that was received. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 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 IC598
IC61.1 IC62.1
IC62.2 IC67.1
...
ITL-MSDS-VERSION Alpha 4 AP125 AP126
Msds Version The version number of the most recent AP131 AP25.1
MSDS that was received. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 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 IC598
IC61.1 IC62.1
IC62.2 IC67.1
...
ITL-AVG-SOH-QTY Signed 13.4 AP125 AP126
Average Stock On This field contains the average AP131 AP25.1
Hand Quantity stock-on-hand quantity of the item for AP25.2 AP26.1
the last year. AP27.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
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 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 IC598
IC61.1 IC62.1
...
ITL-TURN-RATE Signed 6.1 AP125 AP126
Turnover Rate This field contains the rate of AP131 AP25.1
turnover, which is calculated by AP25.2 AP26.1
dividing the annual sales quantity by AP27.1 CXCP.1
the average stock-on-hand quantity. DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
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
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
IC598 IC61.1
...
ITL-LAST-REC-COST Signed 13.5 AP125 AP126
Last Received Cost This field contains the last received AP131 AP25.1
or invoiced unit cost. AP25.2 AP26.1
AP27.1 API1.1
CXCP.1 DR100
IC10.2 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 IC598
IC61.1 IC62.1
...
ITL-LAST-ISS-COST Signed 13.5 AP125 AP126
Last Issue Cost This field contains the unit cost of AP131 AP25.1
the last issue. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-AVERAGE-COST Signed 13.5 AP125 AP126
Average Cost This field contains the moving average AP131 AP25.1
unit cost of an item. This figure is AP25.2 AP26.1
always calculated regardless of the AP27.1 CXCP.1
company costing method. DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-TRANS-COUNT Numeric 5 AP125 AP126
Nbr Transaction This field contains the number of AP131 AP25.1
Since Last Cnt inventory transactions involving this AP25.2 AP26.1
item at this location since the last AP27.1 CXCP.1
update run of Update Variances (IC175). DR100 IC10.2
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 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
IC598 IC61.1
...
ITL-CNT-ACCURACY Signed 5.1 AP125 AP126
Count Accuracy This field contains the count accuracy AP131 AP25.1
Percent for this item at this location from the AP25.2 AP26.1
last physical inventory count. AP27.1 CXCP.1
DR100 IC10.2
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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ADDED-DATE Numeric 8 (yyyymmdd) AP125 AP126
Date Item was Added This field contains the date the Item AP131 AP25.1
Location record was originally added in AP25.2 AP26.1
IC12.1 (Item Location) or IC10.1 AP27.1 CXCP.1
(Formats). It defaults to the system DR100 IC10.2
date when the record is added. 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-ACTIVE-STATUS Alpha 1 AP125 AP126
Status This status indicates whether the item AP131 AP25.1
is active or inactive at this location. AP25.2 AP26.1
If the item is inactive, no transactions AP27.1 CXCP.1
can be entered for this item at this DR100 IC10.2
location, but transactions in process IC12.1 IC12.2
can be completed. IC125 IC130
A = Active IC140 IC141
I = Inactive 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-USER-FIELD1 Alpha 30 AP125 AP126
Item Mster User This field contains the first AP131 AP25.1
Defined Field1 user-defined field for the Item Location AP25.2 AP26.1
file. It can be used to enter any data AP27.1 CXCP.1
the user wants. This field's name is DR100 IC10.2
defined in IC01.1 (Company). 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-USER-FIELD2 Alpha 10 (Lower Case) AP125 AP126
Item Mster User This field contains the second AP131 AP25.1
Defined Field2 user-defined field for the Item Location AP25.2 AP26.1
record. It can be used to enter any data AP27.1 CXCP.1
the user wants. This field's name is DR100 IC10.2
defined in IC01.1 (Company). 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-USER-FIELD3 Alpha 10 (Lower Case) AP125 AP126
Item Mster User This field contains the third AP131 AP25.1
Defined Field3 user-defined field for the Item Location AP25.2 AP26.1
record. It can be used to enter any data AP27.1 CXCP.1
the user wants. This field's name is DR100 IC10.2
defined in IC01.1 (Company). 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-USER-FIELD-N1 Signed 13.5 AP125 AP126
User Defined This field contains the first AP131 AP25.1
Numeric Field 1 user-defined numeric field for the Item AP25.2 AP26.1
Location record. It can be used to enter AP27.1 CXCP.1
any data the user wants. This field's DR100 IC10.2
name is defined in IC01.1 (Company). 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-USER-FIELD-N2 Signed 13.5 AP125 AP126
User Defined This field contains the second AP131 AP25.1
Numeric Field 2 user-defined numeric field for the Item AP25.2 AP26.1
Location record. It can be used to enter AP27.1 CXCP.1
any data the user wants. This field's DR100 IC10.2
name is defined in IC01.1 (Company). 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
IC598 IC61.1
IC62.1 IC62.2
...
ITL-USER-FIELD-N3 Signed 13.5 AP125 AP126
User Defined This field contains the third AP131 AP25.1
Numeric Field 3 user-defined numeric field for the Item AP25.2 AP26.1
Location record. It can be used to enter AP27.1 CXCP.1
any data the user wants. This field's DR100 IC10.2
name is defined in IC01.1 (Company). 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
IC598 IC61.1
IC62.1 IC62.2
...
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 AP125 AP126
Proc Days The number of days it takes to process AP131 AP25.1
receivings until they are ready to be AP25.2 AP26.1
shipped. AP27.1 CXCP.1
DR100 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 IC598
IC61.1 IC62.1
IC62.2 IC67.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 AP125 AP126
LOCATION AP131 AP20.1
ITEM AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.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
...
ITLSET2 COMPANY IC10.1 IC10.2
ITEM IC11.1 IC170
LOCATION IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC42.1 IC42.2
IC42.3 IC42.4
IC60.1 IC81.1
IC82.1 WH20.7
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 IC598 IC81.1
PREFER-BIN IC83.1
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
PHI-UPC
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
|