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
DR25.1 DR40.1 IC01.1 IC02.1 IC138 IC143
IC19.1 IC211 IC220 IC222 IC224 IC227
IC228 IC232 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 MA53.7 MA540 MA65.1 PO130 PO135
PO139 PO220 PO54.4 POCP.1 POID.1 POIE.1
POIH.1 RQ111 RQ140 RQ235 RQ300 RQ39.1
RQ39.2 RQ39.3 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQD0.1 RQD1.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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 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 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
IC285 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 IC67.1 IC68.1 IC68.2 IC68.3 IC73.1
IC81.1 IC812 IC82.1 IC820 IC83.1 IC84.1
IC84.2 IC840 IC850 IC90.1 PC120 SEA1.1
MA180 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.9 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 PO100 PO101
PO122 PO131 PO16.1 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO228 PO23.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO64.1 POI3.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ35.1 RQ500 RQIC.1 RQID.1 RQIE.1 RQIF.1
RQIG.1 RQIH.1 RQIJ.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 WHD2.1 WHD3.1 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 The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP20.1
identifier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-GL-CATEGORY Alpha 4 AP125 AP126
Element: Retain Gl Cd This field is used to extract AP131 AP20.1
appropriate account numbers for any AP20.2 AP20.3
inventory movement. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer This field contains a code representing AP131 AP20.1
the person responsible for the item at AP20.2 AP20.3
this location. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis is the default transaction unit of AP131 AP20.1
measure for this item at this location. AP20.2 AP20.3
The unit of measure must be set up as a AP20.4 AP20.5
valid unit of measure defined in IC11.1 AP20.7 AP23.1
(Item Master) and be valid for AP25.1 AP25.2
transaction use. AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-PURCH-TAX-FL Alpha 1 AP125 AP126
Element: Purchasing TaxThis field indicates whether this item AP131 AP20.1
is taxable (Yes) or nontaxable (No) when AP20.2 AP20.3
it is purchased for this location. AP20.4 AP20.5
" " = Blank Defaults to Next Level AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
N = No AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-PURCH-TAX-CD Alpha 10 AP125 AP126
Element: Tax Code This field contains the code used to AP131 AP20.1
determine if this item is taxable when AP20.2 AP20.3
purchased at this location. This code is AP20.4 AP20.5
also used to extract tax data from the AP20.7 AP23.1
tax file based on this tax code. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-SELL-TAX-FL Alpha 1 AP125 AP126
Element: Selling Tax FlThis field indicates whether this item AP131 AP20.1
is nontaxable (No) or taxable (Yes) when AP20.2 AP20.3
sold from this location. AP20.4 AP20.5
Y = Taxable When Sold AP20.7 AP23.1
N = Not Taxable When Sold AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-SELL-TAX-CD Alpha 10 AP125 AP126
Element: Tax Code This code determines tax rates when AP131 AP20.1
this item is sold from this location. AP20.2 AP20.3
Valid sell tax codes are defined in the AP20.4 AP20.5
Tax system. The sell tax code determines AP20.7 AP23.1
the tax table from which to extract tax AP25.1 AP25.2
data. AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-STD-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the standard unit AP131 AP20.1
cost of this item at this location. This AP20.2 AP20.3
field is required for standard cost AP20.4 AP20.5
companies. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-FUT-STD-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the future standard AP131 AP20.1
cost for the item. Update Variances AP20.2 AP20.3
(IC175) updates this into the standard AP20.4 AP20.5
cost field and creates the appropriate AP20.7 AP23.1
general ledger transaction for this AP25.1 AP25.2
field. AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-SOH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field indicates the quantity that AP131 AP20.1
is currently on hand in the inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Quantity AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-ALLOC-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity AP131 AP20.1
allocated to orders for this item. This AP20.2 AP20.3
quantity is maintained by the Warehouse AP20.4 AP20.5
system. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-UNALLOC-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of AP131 AP20.1
future customer orders that have not yet AP20.2 AP20.3
been allocated. This field is maintained AP20.4 AP20.5
by the Warehouse system. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-BACKORD-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of AP131 AP20.1
orders that should have been allocated, AP20.2 AP20.3
but were not because there was not AP20.4 AP20.5
enough available inventory. This field AP20.7 AP23.1
is maintained by the Warehouse system. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-IN-PROC-QTY Signed 13.4 AP125 AP126
Element: Quantity AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ONORDER-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the on-order AP131 AP20.1
quantity for the item location. It is AP20.2 AP20.3
the total of all open supply orders. It AP20.4 AP20.5
is maintained by the Purchase Order and AP20.7 AP23.1
Requisitions systems. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-INTRANS-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity AP131 AP20.1
intransit to the item location. This is AP20.2 AP20.3
maintained by the Inventory Control AP20.4 AP20.5
system. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-WIP-QTY Signed 13.4 AP125 AP126
Element: Quantity This field represents the work-in- AP131 AP20.1
process quantity. It is used by the AP20.2 AP20.3
Work Order system to indicate the AP20.4 AP20.5
quantity of finished goods that are in AP20.7 AP23.1
the process of being produced. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
IC520 IC521
...
ITL-HOLD-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of AP131 AP20.1
items on hold for inspection at the AP20.2 AP20.3
location. This field is maintained by AP20.4 AP20.5
the Purchase Order system. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MOVE-CLASS Alpha 1 AP125 AP126
Element: Movement ClassThis field contains the designated AP131 AP20.1
movement class. AP20.2 AP20.3
1 = Movement Class 1 AP20.4 AP20.5
2 = Movement Class 2 AP20.7 AP23.1
3 = Movement Class 3 AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC331 IC36.1
IC40.1 IC40.2
...
ITL-MOVE-RANK Numeric 5 AP125 AP126
Element: Movement Rank This field contains the ranking within AP131 AP20.1
the movement class. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-STORAGE-CODE Alpha 5 AP125 AP126
Element: Bin Storage CoThis field contains the code assigned AP131 AP20.1
to describe the physical characteristics AP20.2 AP20.3
of a bin. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-PREFER-BIN Alpha 7 AP125 AP126
Element: Bin This field contains the designated AP131 AP20.1
preferred bin for the item at this AP20.2 AP20.3
location. This is the default bin number AP20.4 AP20.5
used on transactions if the item is bin AP20.7 AP23.1
tracked. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-MIN-ORDER Signed 13.4 AP125 AP126
Element: Document TotalThis field contains the minimum order AP131 AP20.1
quantity. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-MAX-ORDER Signed 13.4 AP125 AP126
Element: Document TotalThis field contains the maximum order AP131 AP20.1
quantity. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-ORDER-POLICY Alpha 3 AP125 AP126
Element: Ordering PolicThis field contains the method of AP131 AP20.1
reordering. AP20.2 AP20.3
FOP = Fixed Order Point AP20.4 AP20.5
TPO = Time Phased Order Point AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-REORD-DOC-CD Alpha 1 AP125 AP126
Reorder Document This field contains a code that AP131 AP20.1
Code indicates the manner in which this item AP20.2 AP20.3
is reordered. AP20.4 AP20.5
N = No document created, only plan AP20.7 AP23.1
P = Purchaser Order AP25.1 AP25.2
R = Requisition AP26.1 AP27.1
X = Intransit Document AP30.4 API1.1
T = Transfer Document CXCP.1 DR100
I = Issue Document IC10.2 IC12.1
W = Work Order 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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-REORD-QTY-CD Alpha 1 AP125 AP126
Reorder Quantity This field contains the reorder AP131 AP20.1
Code quantity code that indicates how to AP20.2 AP20.3
determine the quantity ordered. AP20.4 AP20.5
D = Difference Quantity AP20.7 AP23.1
E = Economic Order Quantity AP25.1 AP25.2
F = Fixed Reorder Quantity AP26.1 AP27.1
M = Order up to Maximum Level AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-REORD-PT-CD Alpha 1 AP125 AP126
Element: Reorder Point This field contains the reorder point AP131 AP20.1
code that indicates how the reorder AP20.2 AP20.3
point quantity is determined. AP20.4 AP20.5
F = Fixed Reorder Point AP20.7 AP23.1
V = Variable Reorder Point AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-REORDER-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the normal reorder AP131 AP20.1
quantity for the item at this location. AP20.2 AP20.3
This field is maintained by the user or AP20.4 AP20.5
the system, based on the reorder AP20.7 AP23.1
quantity code. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-REORDER-POINT Signed 13.4 AP125 AP126
Element: Document TotalThis field contains the reorder point. AP131 AP20.1
Reordering for this item is triggered to AP20.2 AP20.3
occur when the item available quantity AP20.4 AP20.5
falls below this reorder point. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
...
ITL-SUGG-REORD-PT Signed 13.4 IC182 IC81.1
Element: Document Total IC812 IC840
ITL-LEAD-CTRL-CD Alpha 1 AP125 AP126
Leadtime Control This field contains the code that AP131 AP20.1
Code determines how the leadtime number of AP20.2 AP20.3
days is maintained. AP20.4 AP20.5
M = Manually Entered AP20.7 AP23.1
R = Needs Review AP25.1 AP25.2
S = System Calculates AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-LEADTIME-DAYS Numeric 3 AP125 AP126
Leadtime Number of This field contains the average AP131 AP20.1
Days leadtime days. It is the average of the AP20.2 AP20.3
last and previous leadtime days if this AP20.4 AP20.5
field is system calculated. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-LAST-LEADTIME Numeric 3 AP125 AP126
Leadtime Number of This field contains the difference AP131 AP20.1
Days between the received date and the AP20.2 AP20.3
purchase order date. This field is AP20.4 AP20.5
updated by the Purchase Order system. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
IC520 IC521
...
ITL-PREV-LEADTIME Numeric 3 AP125 AP126
Leadtime Number of This field is maintained by the AP131 AP20.1
Days Purchase Order system. The last leadtime AP20.2 AP20.3
value is moved to the previous leadtime AP20.4 AP20.5
field when a new purchase order is AP20.7 AP23.1
received. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
IC520 IC521
...
ITL-AUTO-PO Alpha 1 AP125 AP126
Element: All Flag This field indicates whether a purchase AP131 AP20.1
order is to be automatically created for AP20.2 AP20.3
this item. AP20.4 AP20.5
N = No AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ORDER-MULT Numeric 4 AP125 AP126
Element: Order MultipleThis field contains the order multiple. AP131 AP20.1
The reorder quantity should be a AP20.2 AP20.3
multiple of this quantity. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC331 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
...
ITL-EOQ Signed 13.4 AP125 AP126
Element: Document TotalThis field contains the EOQ (Economic AP131 AP20.1
Order Quantity). This is a calculation AP20.2 AP20.3
that checks the cost of ordering the AP20.4 AP20.5
item against the cost of carrying the AP20.7 AP23.1
item in inventory to determine the ideal AP25.1 AP25.2
quantity to be ordered. AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-SAFETY-STOCK Signed 13.4 AP125 AP126
Element: Document TotalThis field contains the quantity of AP131 AP20.1
stock planned to be in inventory to AP20.2 AP20.3
protect against the fluctuations in AP20.4 AP20.5
supply and demand. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MANUF-CODE Alpha 4 AP125 AP126
Element: Manufacturer'sThis field contains a user defined code AP131 AP20.1
that indicates the manufacturer of an AP20.2 AP20.3
item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MANUF-DIVISION Alpha 4 AP125 AP126
Manufacturer's This is a user defined code that AP131 AP20.1
Division indicates which division of a AP20.2 AP20.3
manufacturer is tied to an item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP20.1
Number manufacturer has assigned to an item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-SP-CYCLE-CNT Alpha 1 AP125 AP126
Special Cycle Count This field contains the special cycle AP131 AP20.1
Flag count designator, which is used to AP20.2 AP20.3
select this item for cycle counting AP20.4 AP20.5
regardless of the item's movement class. AP20.7 AP23.1
X = Selected for Special Cycle Cnt AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-LAST-COUNT-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date this item AP131 AP20.1
was last counted in the physical AP20.2 AP20.3
inventory process. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-FORECAST-NBR Numeric 4 AP125 AP126
Element: Number of ItemThis number identifies which forecast AP131 AP20.1
record is to be used for this item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-CHARGEABLE-FL Alpha 1 AP125 AP126
Element: All Flag This flag indicates that this item is a AP131 AP20.1
patient chargeable item. AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
N = No AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-TRACKING-FL Alpha 1 AP125 AP126
Element: All Flag This flag specifies if quantities are AP131 AP20.1
to be tracked at this location for this AP20.2 AP20.3
item. AP20.4 AP20.5
Y = Yes AP20.7 AP23.1
N = No AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-BIN-TRACK-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether this item AP131 AP20.1
is to be tracked by bin at this AP20.2 AP20.3
location. AP20.4 AP20.5
N = No AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ALLOW-REC-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether receipts AP131 AP20.1
are allowed. If set to No, the Purchase AP20.2 AP20.3
Order system cannot order the item. AP20.4 AP20.5
N = No AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ALLOW-ISS-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether issues of AP131 AP20.1
this item are allowed. AP20.2 AP20.3
N = No AP20.4 AP20.5
Y = Yes AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-INSP-REQ-FL Alpha 1 AP125 AP126
Element: All Flag This field specifies if the item is AP131 AP20.1
inspected when it is received. This AP20.2 AP20.3
field defaults to the Purchase Order and AP20.4 AP20.5
Case Carts systems. AP20.7 AP23.1
N = No AP25.1 AP25.2
Y = Yes AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ACTIVITY-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether this AP131 AP20.1
record has been updated by any AP20.2 AP20.3
transaction since Stock Status Report AP20.4 AP20.5
(IC145), Item Mass Update (IC116) or AP20.7 AP23.1
Distribution Requirements Report (DR100) AP25.1 AP25.2
has been run. AP26.1 AP27.1
N = No AP30.4 API1.1
Y = Yes 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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-FREEZE-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates this record has AP131 AP20.1
been selected to be counted in the AP20.2 AP20.3
physical inventory process. AP20.4 AP20.5
N = No AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-FREEZE-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field indicates the date this AP131 AP20.1
record was selected for physical AP20.2 AP20.3
inventory counting. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-LAST-ISSUE-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date of the AP131 AP20.1
last issue of this item at this AP20.2 AP20.3
location. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-LAST-UPD-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date the AP131 AP20.1
transaction was released for an item AP20.2 AP20.3
record or the last date an item record AP20.4 AP20.5
was maintained. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP20.1
when the record was updated. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-TRAN-COUNTER Numeric 6 AP125 AP126
Element: Item Count AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-LAST-REC-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date of the AP131 AP20.1
last receiving. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-LAST-TURN-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date the AP131 AP20.1
turnover rate was last calculated. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MSDS-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date a new AP131 AP20.1
Material Safety Data Sheet (MSDS) should AP20.2 AP20.3
be sent from the vendor. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MSDS-ORDER-FL Alpha 1 AP125 AP126
Element: Account Flag This field is used by the Purchase AP131 AP20.1
Order system to indicate if the Material AP20.2 AP20.3
Safety Data Sheet (MSDS) for this item AP20.4 AP20.5
has been sent to this location. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-MSDS-DOCUMENT Alpha 30 AP125 AP126
Element: Msds Document The document number from the most AP131 AP20.1
recent MSDS that was received. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
IC520 IC521
...
ITL-MSDS-VERSION Alpha 4 AP125 AP126
Element: Msds Version The version number of the most recent AP131 AP20.1
MSDS that was received. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
IC520 IC521
...
ITL-AVG-SOH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the average AP131 AP20.1
stock-on-hand quantity of the item for AP20.2 AP20.3
the last year. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-TURN-RATE Signed 6.1 AP125 AP126
Element: Turnover Rate This field contains the rate of AP131 AP20.1
turnover, which is calculated by AP20.2 AP20.3
dividing the annual sales quantity by AP20.4 AP20.5
the average stock-on-hand quantity. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
...
ITL-LAST-REC-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the last received AP131 AP20.1
or invoiced unit cost. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-LAST-ISS-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the unit cost of AP131 AP20.1
the last issue. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-AVERAGE-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the moving average AP131 AP20.1
unit cost of an item. This figure is AP20.2 AP20.3
always calculated regardless of the AP20.4 AP20.5
company costing method. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-TRANS-COUNT Numeric 5 AP125 AP126
Element: Count Entry This field contains the number of AP131 AP20.1
inventory transactions involving this AP20.2 AP20.3
item at this location since the last AP20.4 AP20.5
update run of Update Variances (IC175). AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
...
ITL-CNT-ACCURACY Signed 5.1 AP125 AP126
Class 1 Item This field contains the count accuracy AP131 AP20.1
Accuracy Cutoff for this item at this location from the AP20.2 AP20.3
last physical inventory count. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-ADDED-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date the Item AP131 AP20.1
Location record was originally added in AP20.2 AP20.3
IC12.1 (Item Location) or IC10.1 AP20.4 AP20.5
(Formats). It defaults to the system AP20.7 AP23.1
date when the record is added. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-ACTIVE-STATUS Alpha 1 AP125 AP126
Element: Status This status indicates whether the item AP131 AP20.1
is active or inactive at this location. AP20.2 AP20.3
If the item is inactive, no transactions AP20.4 AP20.5
can be entered for this item at this AP20.7 AP23.1
location, but transactions in process AP25.1 AP25.2
can be completed. AP26.1 AP27.1
A = Active AP30.4 API1.1
I = Inactive 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 IC285
IC31.1 IC320
IC330 IC331
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
...
ITL-USER-FIELD1 Alpha 30 AP125 AP126
Item Mster User This field contains the first AP131 AP20.1
Defined Field1 user-defined field for the Item Location AP20.2 AP20.3
file. It can be used to enter any data AP20.4 AP20.5
the user wants. This field's name is AP20.7 AP23.1
defined in IC01.1 (Company). AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-USER-FIELD2 Alpha 10 (Lower Case) AP125 AP126
Item Mster User This field contains the second AP131 AP20.1
Defined Field2 user-defined field for the Item Location AP20.2 AP20.3
record. It can be used to enter any data AP20.4 AP20.5
the user wants. This field's name is AP20.7 AP23.1
defined in IC01.1 (Company). AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-USER-FIELD3 Alpha 10 (Lower Case) AP125 AP126
Item Mster User This field contains the third AP131 AP20.1
Defined Field2 user-defined field for the Item Location AP20.2 AP20.3
record. It can be used to enter any data AP20.4 AP20.5
the user wants. This field's name is AP20.7 AP23.1
defined in IC01.1 (Company). AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-USER-FIELD-N1 Signed 13.5 AP125 AP126
User Defined This field contains the first AP131 AP20.1
Numeric Field 1 user-defined numeric field for the Item AP20.2 AP20.3
Location record. It can be used to enter AP20.4 AP20.5
any data the user wants. This field's AP20.7 AP23.1
name is defined in IC01.1 (Company). AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-USER-FIELD-N2 Signed 13.5 AP125 AP126
User Defined This field contains the second AP131 AP20.1
Numeric Field 1 user-defined numeric field for the Item AP20.2 AP20.3
Location record. It can be used to enter AP20.4 AP20.5
any data the user wants. This field's AP20.7 AP23.1
name is defined in IC01.1 (Company). AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
ITL-USER-FIELD-N3 Signed 13.5 AP125 AP126
User Defined This field contains the third AP131 AP20.1
Numeric Field 1 user-defined numeric field for the Item AP20.2 AP20.3
Location record. It can be used to enter AP20.4 AP20.5
any data the user wants. This field's AP20.7 AP23.1
name is defined in IC01.1 (Company). AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC285
IC31.1 IC320
IC330 IC36.1
IC40.1 IC40.2
IC44.1 IC45.1
IC500 IC520
...
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-PROC-DAYS Numeric 3 AP125 AP126
Element: Proc Days The number of days it takes to process AP131 AP20.1
receivings until they are ready to be AP20.2 AP20.3
shipped. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC285 IC31.1
IC320 IC330
IC36.1 IC40.1
IC40.2 IC44.1
IC45.1 IC500
IC520 IC521
...
ITL-CONSIGNMENT-FL Alpha 1 IC10.2 IC12.1
Element: Consignment FlThe flag designates that this item is a IC330 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-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 AP20.1
ITEM AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 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
...
ITLSET2 COMPANY AP125 AP126
ITEM AP131 AP20.1
LOCATION AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC10.1 IC10.2
IC11.1 IC141
IC142 IC170
IC21.1 IC21.2
IC28.1 IC31.1
IC320 IC330
...
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
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
|