Lawson Insight Technical Documentation |
|
ITEMLOC
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 IC211 IC220 IC222 IC224
IC227 IC228 IC232 IC235 IC237 IC238
IC239 IC242 IC244 IC27.1 IC280 IC283
IC29.1 IC29.2 IC29.3 IC38.1 IC46.1 IC47.1
IC49.1 IC50.1 IC50.2 IC51.1 IC55.1 IC55.2
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 PC210 PC540
MA236 MA278 MA53.5 MA540 MA65.1 OE130
OE283 OE288 OE289 OE290 OE330 PO130
PO135 PO220 PO27.2 PO54.4 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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 API1.1 BL120 BL122 BL130
BL140 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.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 IC22.1 IC22.2 IC223 IC225 IC226
IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC26.1
IC26.2 IC262 IC270 IC28.1 IC281 IC282
IC31.1 IC320 IC330 IC331 IC36.1 IC40.1
IC40.2 IC44.1 IC45.1 IC500 IC520 IC521
IC522 IC523 IC524 IC525 IC526 IC527
IC530 IC531 IC598 IC61.1 IC62.1 IC62.2
IC62.4 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 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.1 OE13.2 OE13.3 OE13.4
OE13.5 OE13.6 OE14.4 OE229 OE270 OE271
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE81.3
OE810 OE830 OE86.1 OE90.1 OE90.2 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
PO64.1 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIH.1 RQIJ.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 WO10.1 WO120 WO130 WO131 WO132
WO133 WO140 WO20.1 WO215 WO220 WO232
WO235 WO250 WO251 WO252 WO255 WO256
WO280 WO30.1 WO30.2 WO300 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO35.1 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO40.6 WO41.1 WO41.2
WO41.3 WO41.4 WO42.1 WO42.2 WO42.3 WO42.4
WO42.5 WO45.1 WO510 WO80.1 WO81.1 WO81.2
WO82.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITL-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP25.1
resource type = V. Identifies the HR AP25.2 AP26.1
company if the resource type = E. It is AP27.1 AP30.4
blank for type A, P or Q resources. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
ITL-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
ITL-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
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 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
ITL-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer This field contains a code representing AP131 AP25.1
the person responsible for the item at AP25.2 AP26.1
this location. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis 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 AP30.4
valid unit of measure defined in IC11.1 BL120 BL122
(Item Master) and be valid for BL130 BL140
transaction use. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
ITL-PURCH-TAX-FL Alpha 1 AP125 AP126
Element: Purchasing TaxThis 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 AP30.4
" " = Blank Defaults to Next Level BL120 BL122
Y = Yes BL130 BL140
N = No BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-PURCH-TAX-CD Alpha 10 AP125 AP126
Element: Tax Code This field contains the code used to AP131 AP25.1
determine if this item is taxable when AP25.2 AP26.1
purchased at this location. This code is AP27.1 AP30.4
also used to extract tax data from the BL120 BL122
tax file based on this tax code. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-SELL-TAX-FL Alpha 1 AP125 AP126
Element: Selling Tax FlThis 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 AP30.4
Y = Taxable When Sold BL120 BL122
N = Not Taxable When Sold BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-SELL-TAX-CD Alpha 10 AP125 AP126
Element: 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 AP30.4
Tax system. The sell tax code determines BL120 BL122
the tax table from which to extract tax BL130 BL140
data. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-STD-COST Signed 18.5 AP125 AP126
Element: Intl 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 AP30.4
companies. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-FUT-STD-COST Signed 18.5 AP125 AP126
Element: Intl 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 AP30.4
cost field and creates the appropriate BL120 BL122
general ledger transaction for this BL130 BL140
field. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-SOH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field indicates the quantity that AP131 AP25.1
is currently on hand in the inventory. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Secondary QuanThis 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 AP30.4
is a memo quantity only. It is not used BL120 BL122
for valuation. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ALLOC-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
system. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-UNALLOC-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
by the Warehouse system. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-BACKORD-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
enough available inventory. This field BL120 BL122
is maintained by the Warehouse system. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-IN-PROC-QTY Signed 13.4 AP125 AP126
Element: Quantity 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 AP30.4
list, but it has not been shipped yet. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-ONORDER-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
is maintained by the Purchase Order and BL120 BL122
Requisitions systems. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-INTRANS-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
system. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC138 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-WIP-QTY Signed 13.4 AP125 AP126
Element: Quantity 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 AP30.4
quantity of finished goods that are in BL120 BL122
the process of being produced. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-HOLD-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
the Purchase Order system. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-MOVE-CLASS Alpha 1 AP125 AP126
Element: Movement ClassThis field contains the designated AP131 AP25.1
movement class. AP25.2 AP26.1
1 = Movement Class 1 AP27.1 AP30.4
2 = Movement Class 2 BL120 BL122
3 = Movement Class 3 BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC150 IC151
IC152 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
...
ITL-MOVE-RANK Numeric 5 AP125 AP126
Element: Movement Rank This field contains the ranking within AP131 AP25.1
the movement class. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC150 IC151
IC152 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
...
ITL-STORAGE-CODE Alpha 5 AP125 AP126
Element: Bin Storage CoThis field contains the code assigned AP131 AP25.1
to describe the physical characteristics AP25.2 AP26.1
of a bin. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-PREFER-BIN Alpha 7 AP125 AP126
Element: 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 AP30.4
used on transactions if the item is bin BL120 BL122
tracked. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
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 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ORDER-POLICY Alpha 3 AP125 AP126
Element: Ordering PolicThis field contains the method of AP131 AP25.1
reordering. AP25.2 AP26.1
FOP = Fixed Order Point AP27.1 AP30.4
TPO = Time Phased Order Point BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
N = No document created, only plan BL120 BL122
P = Purchaser Order BL130 BL140
R = Requisition BL20.1 BL20.3
X = Intransit Document BL21.2 BL21.5
T = Transfer Document BL29.1 BL29.2
I = Issue Document BL520 BL820
W = Work Order BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
D = Difference Quantity BL120 BL122
E = Economic Order Quantity BL130 BL140
F = Fixed Reorder Quantity BL20.1 BL20.3
M = Order up to Maximum Level BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-REORD-PT-CD Alpha 1 AP125 AP126
Element: Reorder Point 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 AP30.4
F = Fixed Reorder Point BL120 BL122
V = Variable Reorder Point BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-REORDER-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
the system, based on the reorder BL120 BL122
quantity code. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC120 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-REORDER-POINT Signed 13.4 AP125 AP126
Element: 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 AP30.4
falls below this reorder point. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC120 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC183 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
...
ITL-SUGG-REORD-PT Signed 13.4 IC182 IC81.1
Element: 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 AP30.4
M = Manually Entered BL120 BL122
R = Needs Review BL130 BL140
S = System Calculates BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
field is system calculated. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC120 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-LAST-LEADTIME Numeric 3 AP125 AP126
Leadtime Number of This field contains the difference AP131 AP25.1
Days between the received date and the AP25.2 AP26.1
purchase order date. This field is AP27.1 AP30.4
updated by the Purchase Order system. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-PREV-LEADTIME Numeric 3 AP125 AP126
Leadtime Number of This field is maintained by the AP131 AP25.1
Days Purchase Order system. The last leadtime AP25.2 AP26.1
value is moved to the previous leadtime AP27.1 AP30.4
field when a new purchase order is BL120 BL122
received. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-AUTO-PO Alpha 1 AP125 AP126
Element: All Flag This field indicates whether a purchase AP131 AP25.1
order is to be automatically created for AP25.2 AP26.1
this item. AP27.1 AP30.4
N = No BL120 BL122
Y = Yes BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ORDER-MULT Numeric 4 AP125 AP126
Element: Order MultipleThis field contains the order multiple. AP131 AP25.1
The reorder quantity should be a AP25.2 AP26.1
multiple of this quantity. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC120 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.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 AP30.4
item against the cost of carrying the BL120 BL122
item in inventory to determine the ideal BL130 BL140
quantity to be ordered. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC120 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-SAFETY-STOCK Signed 13.4 AP125 AP126
Element: 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 AP30.4
supply and demand. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-MANUF-CODE Alpha 4 AP125 AP126
Element: Manufacturer'sThis field contains a user defined code AP131 AP25.1
that indicates the manufacturer of an AP25.2 AP26.1
item. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-MANUF-DIVISION Alpha 4 AP125 AP126
Manufacturer's This is a user defined code that AP131 AP25.1
Division indicates which division of a AP25.2 AP26.1
manufacturer is tied to an item. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
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 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
regardless of the item's movement class. BL120 BL122
X = Selected for Special Cycle Cnt BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-LAST-COUNT-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Count DatThis field contains the date this item AP131 AP25.1
was last counted in the physical AP25.2 AP26.1
inventory process. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-FORECAST-NBR Numeric 4 AP125 AP126
Element: Forecast NumbeThis number identifies which forecast AP131 AP25.1
record is to be used for this item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-CHARGEABLE-FL Alpha 1 AP125 AP126
Element: All Flag This flag indicates that this item is a AP131 AP25.1
patient chargeable item. AP25.2 AP26.1
Y = Yes AP27.1 AP30.4
N = No BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
...
ITL-TRACKING-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4
Y = Yes BL120 BL122
N = No BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-BIN-TRACK-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4
N = No BL120 BL122
Y = Yes BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ALLOW-REC-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4
N = No BL120 BL122
Y = Yes BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ALLOW-ISS-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether issues of AP131 AP25.1
this item are allowed. AP25.2 AP26.1
N = No AP27.1 AP30.4
Y = Yes BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-INSP-REQ-FL Alpha 1 AP125 AP126
Element: All Flag This field specifies if the item is AP131 AP25.1
inspected when it is received. This AP25.2 AP26.1
field defaults to the Purchase Order and AP27.1 AP30.4
Case Carts systems. BL120 BL122
N = No BL130 BL140
Y = Yes BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ACTIVITY-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4
(IC145), Item Mass Update (IC116) or BL120 BL122
Distribution Requirements Report (DR100) BL130 BL140
has been run. BL20.1 BL20.3
N = No BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-FREEZE-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4
N = No BL120 BL122
Y = Yes BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC179 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-FREEZE-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Freeze Date This field indicates the date this AP131 AP25.1
record was selected for physical AP25.2 AP26.1
inventory counting. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-LAST-ISSUE-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Issue DatThis field contains the date of the AP131 AP25.1
last issue of this item at this AP25.2 AP26.1
location. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-LAST-UPD-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Update DaThis 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 AP30.4
was maintained. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP25.1
when the record was updated. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-TRAN-COUNTER Numeric 6 AP125 AP126
Element: 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 AP30.4
Location file. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-LAST-REC-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Received This field contains the date of the AP131 AP25.1
last receiving. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-LAST-TURN-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Turnover This field contains the date the AP131 AP25.1
turnover rate was last calculated. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-MSDS-ORDER-FL Alpha 1 AP125 AP126
Element: MSDS Ordered FThis 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 AP30.4
has been sent to this location. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-MSDS-DOCUMENT Alpha 30 AP125 AP126
Element: Msds Document The document number from the most AP131 AP25.1
recent MSDS that was received. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-MSDS-VERSION Alpha 4 AP125 AP126
Element: Msds Version The version number of the most recent AP131 AP25.1
MSDS that was received. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-AVG-SOH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the average AP131 AP25.1
stock-on-hand quantity of the item for AP25.2 AP26.1
the last year. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC190
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-TURN-RATE Signed 6.1 AP125 AP126
Element: 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 AP30.4
the average stock-on-hand quantity. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC134 IC135
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
...
ITL-LAST-REC-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the last received AP131 AP25.1
or invoiced unit cost. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL140 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC10.2 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
...
ITL-LAST-ISS-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the unit cost of AP131 AP25.1
the last issue. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-AVG-ADD-ON-CST Signed 18.5 AP125 AP126
Element: Intl Cost An average cost of an inventory item AP131 AP25.1
that only includes additional or add-on AP25.2 AP26.1
costs for that item. The costs are AP27.1 AP30.4
directly and measurably related to the BL120 BL122
purchase of the item. Examples are BL130 BL140
freight, packaging, or insurance costs. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-AVERAGE-COST Signed 18.5 AP125 AP126
Element: Intl 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 AP30.4
company costing method. BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-OVERHEAD-UCOST Signed 18.5 IC12.1 IC330
Element: Intl Cost A unit cost value for an inventory item IC812
that is necessary for the cost-based
inventory valuation program. It includes
such costs as storage space rental,
storage insurance, and warehouse
utilities.
ITL-MARKET-PRICE Signed 18.5 IC12.1 IC330
Element: Intl Cost This is the market value of the item IC812
expressed as a unit cost. It represents
the price you would pay for the item.
This is the value without any additional
or add-on costs, not even taxes, that
you would see in a catalogue or on the
shelf.
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 AP30.4
update run of Update Variances (IC175). BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
...
ITL-CNT-ACCURACY Signed 5.1 AP125 AP126
Class 1 Item This field contains the count accuracy AP131 AP25.1
Accuracy Cutoff for this item at this location from the AP25.2 AP26.1
last physical inventory count. AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ADDED-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date Item was 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 AP30.4
(Formats). It defaults to the system BL120 BL122
date when the record is added. BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-ACTIVE-STATUS Alpha 1 AP125 AP126
Element: 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 AP30.4
can be entered for this item at this BL120 BL122
location, but transactions in process BL130 BL140
can be completed. BL20.1 BL20.3
A = Active BL21.2 BL21.5
I = Inactive BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.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 AP30.4
the user wants. This field's name is BL120 BL122
defined in IC01.1 (Company). BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-USER-FIELD2 Alpha 30 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 AP30.4
the user wants. This field's name is BL120 BL122
defined in IC01.1 (Company). BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-USER-FIELD3 Alpha 30 AP125 AP126
Item Mster User This field contains the third 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 AP30.4
the user wants. This field's name is BL120 BL122
defined in IC01.1 (Company). BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-USER-FIELD-N1 Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the first AP131 AP25.1
user-defined numeric field for the Item AP25.2 AP26.1
Location record. It can be used to enter AP27.1 AP30.4
any data the user wants. This field's BL120 BL122
name is defined in IC01.1 (Company). BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-USER-FIELD-N2 Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the second AP131 AP25.1
user-defined numeric field for the Item AP25.2 AP26.1
Location record. It can be used to enter AP27.1 AP30.4
any data the user wants. This field's BL120 BL122
name is defined in IC01.1 (Company). BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-USER-FIELD-N3 Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the third AP131 AP25.1
user-defined numeric field for the Item AP25.2 AP26.1
Location record. It can be used to enter AP27.1 AP30.4
any data the user wants. This field's BL120 BL122
name is defined in IC01.1 (Company). BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
IC170 IC175
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC223
IC225 IC226
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC262
IC270 IC28.1
IC281 IC282
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
...
ITL-PROC-DAYS Numeric 3 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC182
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC225
IC226 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC262 IC270
IC28.1 IC281
IC282 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-CONSIGNMENT-FL Alpha 1 IC12.1 IC330
Element: Consignment FlThe 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
ITL-NO-CHARGE-FL Alpha 1
Element: No Charge FlagThis field indicates the item's price
is zero. This defaults to (N)o. If
(Y)es, this field prevents the system
from pricing the item. No charge
invoices are not be passed to the Lawson
Accounts Receivable system for
collection.
Y = Yes
N = No
ITL-LOT-TRACK-FL Alpha 1
Element: All Flag I = Issues
N = Not tracked
R = Receipts
ITL-SER-TRACK-FL Alpha 1
Element: Serial TrackinI = Issues
N = Not tracked
R = Receipts
ITL-ACCT-UNIT-INV Derived
Element: Acct Unit Inv This field is derived from the
inventory accounting unit on the General
Ledger Account Category file.
ITL-ACCOUNT-INV Derived
Element: Account Inv This field is derived from the
inventory account field on the General
Ledger Account Category file.
ITL-SUB-ACCT-INV Derived
Element: 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
Element: Manufacturer'sThis 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
Element: Neg Alloc This field is allocated quantity set to
negative for use in the allocatable and
sellable calculations.
ITL-NEG-BACKORD Derived
Element: Neg Backord This field is the backorder quantity
set to negative for use in the allocable
and sellable calculations.
ITL-NEG-INPROC Derived
Element: 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
Element: 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
Element: 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
Element: 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
Element: Neg Hold This field is the Hold quantity set to
negative for use in the allocatable and
sellable calculations.
ITL-SELL-ALLOC Derived
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Sellable This field is the calculated quantity
that is available to sell for those
customers that do not allow backorders.
ITL-ALLOCATABLE Derived
Element: 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
Element: Cwt AllocatablThis field is the quantity in terms of
the catch weight that can be allocated
for orders.
ITL-ITEM-CODE-USED Derived
Element: Item Code Used
ITEMLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITLSET1 COMPANY AP125 AP126
LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL121 BL122
BL123 BL130
BL140 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL290
BL520 BL80.1
BL820 BL85.2
BL90.1 BL92.1
CXCP.1 DR100
...
ITLSET2 COMPANY AP125 AP126
ITEM AP131 AP25.1
LOCATION AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL85.1
BL85.2 BL92.1
CXCP.1 DR100
IC10.1 IC10.2
IC11.1 IC141
IC142 IC170
...
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 IC46.1
CONSIGNMENT-FL IC70.1
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
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
|