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 BL120 BL121 BL122 BL123 BL130 BL140 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL290 BL520 BL80.1 BL85.2 BL85.1 BL90.1 CX205 DR25.1 DR40.1 IC01.1 IC02.1 IC130 IC138 IC140 IC143 IC16.1 IC16.2 IC16.4 IC19.1 IC211 IC220 IC222 IC224 IC226 IC227 IC228 IC232 IC233 IC234 IC237 IC238 IC239 IC240 IC242 IC27.1 IC281 IC283 IC29.1 IC29.2 IC29.3 IC36.1 IC38.1 IC47.1 IC49.1 IC50.1 IC50.2 IC50.3 IC51.1 IC520 IC521 IC522 IC523 IC524 IC525 IC526 IC527 IC530 IC550 IC574 IC589 IC60.1 IC60.2 IC70.1 IC72.1 IC74.1 IC851 IC95.1 IC95.2 IC95.3 PC120 PC20.1 PC540 MA278 OE130 OE283 OE288 OE289 OE290 OE330 PO115 PO120 PO123 PO130 PO135 PO14.1 PO16.1 PO180 PO214 PO216 PO220 PO225 PO236 PO25.1 PO25.2 PO28.3 PO28.4 PO28.8 PO32.2 PO39.1 PO52.1 PO529 PO53.3 RQ111 RQ125 RQ235 RQ240 RQ39.1 RQ39.2 RQ39.3 RQ42.1 RQ50.1 WH126 WH224 WH226 IC11.1 IC42.1 IC42.2 IC42.3 IC42.4 DR42.1 IC225 IC590 IC295 UPDATED BY AP125 AP126 AP225 AP226 AP25.1 AP25.2 AP26.1 BL820 BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC120 IC125 IC134 IC135 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 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC73.1 IC81.1 IC812 IC82.1 IC820 IC83.1 IC840 IC850 IC90.1 IC962 IC963 IC965 IC991 SEA1.1 IN20.1 MA530 MA540 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 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE81.1 OE81.3 OE810 OE830 OE90.1 OE920 OE950 PO100 PO150 PO20.1 PO21.1 PO21.6 PO22.2 PO22.3 PO30.1 PO31.1 PO33.1 PO34.1 PO35.1 PO530 PO821 PO963 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ15.1 RQ20.1 RQ20.2 RQ20.4 RQ35.1 RQ500 RQ961 SEA3.1 WH110 WH130 WH132 WH190 WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6 WH20.7 WH22.1 WH220 WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WH961 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 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 BL820 BL92.1 Company The company number represents an BL940 CX05.1 established company and is entered on CX05.2 CX100 all function codes. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-LOCATION Alpha 5 BL820 BL92.1 Location Code This field contains a valid stock BL940 CX05.1 location within the company inventory. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-ITEM Alpha 32 BL820 BL92.1 Item Number This field contains the item BL940 CX05.1 identifier. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-GL-CATEGORY Alpha 4 BL820 BL92.1 General Ledger This field is used to extract BL940 CX05.1 Category appropriate account numbers for any CX05.2 CX100 inventory movement. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-BUYER-CODE Alpha 3 BL820 BL92.1 Buyer Code This field contains a code representing BL940 CX05.1 the person responsible for the item at CX05.2 CX100 this location. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-UOM Alpha 4 BL820 BL92.1 Unit of Measure This is the default transaction unit of BL940 CX05.1 measure for this item at this location. CX05.2 CX100 The unit of measure must be set up as a CX20.1 CX20.2 valid unit of measure defined in IC11.1 CX20.4 CX20.5 (Item Master) and be valid for CX220 CX30.1 transaction use. CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-PURCH-TAX-FL Alpha 1 BL820 BL92.1 Purchasing Tax Flag This field indicates whether this item BL940 CX05.1 is taxable (Yes) or nontaxable (No) when CX05.2 CX100 it is purchased for this location. CX20.1 CX20.2 " " = Default to next level CX20.4 CX20.5 Y = Yes CX220 CX30.1 N = No CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-PURCH-TAX-CD Alpha 10 BL820 BL92.1 Purchasing Tax This field contains the code used to BL940 CX05.1 Table Code determine if this item is taxable when CX05.2 CX100 purchased at this location. This code is CX20.1 CX20.2 also used to extract tax data from the CX20.4 CX20.5 tax file based on this tax code. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-SELL-TAX-FL Alpha 1 BL820 BL92.1 Selling Tax Flag This field indicates whether this item BL940 CX05.1 is nontaxable (No) or taxable (Yes) when CX05.2 CX100 sold from this location. CX20.1 CX20.2 Y = Taxable When Sold CX20.4 CX20.5 N = Not Taxable When Sold CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-SELL-TAX-CD Alpha 10 BL820 BL92.1 Selling Tax Code This code determines tax rates when BL940 CX05.1 this item is sold from this location. CX05.2 CX100 Valid sell tax codes are defined in the CX20.1 CX20.2 Tax system. The sell tax code determines CX20.4 CX20.5 the tax table from which to extract tax CX220 CX30.1 data. CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-STD-COST Signed 13.5 BL820 BL92.1 Standard Cost This field contains the standard unit BL940 CX05.1 cost of this item at this location. This CX05.2 CX100 field is required for standard cost CX20.1 CX20.2 companies. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC125 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-FUT-STD-COST Signed 13.5 BL820 BL92.1 Future Standard Cost This field contains the future standard BL940 CX05.1 cost for the item. Update Variances CX05.2 CX100 (IC175) updates this into the standard CX20.1 CX20.2 cost field and creates the appropriate CX20.4 CX20.5 general ledger transaction for this CX220 CX30.1 field. CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC125 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-SOH-QTY Signed 13.4 BL820 BL92.1 Stock On Hand This field indicates the quantity that BL940 CX05.1 Quantity is currently on hand in the inventory. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC820 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-SECONDARY-QTY Signed 13.4 BL820 BL92.1 Secondary Quantity This field contains the secondary BL940 CX05.1 quantity, which is tracked if the item CX05.2 CX100 is a catch weight item. This quantity is CX20.1 CX20.2 a memo quantity only. It is not used for CX20.4 CX20.5 valuation. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC820 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-ALLOC-QTY Signed 13.4 BL820 BL92.1 Allocated Quantity This field contains the quantity BL940 CX05.1 allocated to orders for this item. This CX05.2 CX100 quantity is maintained by the Warehouse CX20.1 CX20.2 system. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC138 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-UNALLOC-QTY Signed 13.4 BL820 BL92.1 Unallocated Quantity This field contains the quantity of BL940 CX05.1 future customer orders that have not yet CX05.2 CX100 been allocated. This field is maintained CX20.1 CX20.2 by the Warehouse system. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 ... ITL-BACKORD-QTY Signed 13.4 BL820 BL92.1 Backordered Quantity This field contains the quantity of BL940 CX05.1 orders that should have been allocated, CX05.2 CX100 but were not because there was not CX20.1 CX20.2 enough available inventory. This field CX20.4 CX20.5 is maintained by the Warehouse system. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC138 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-IN-PROC-QTY Signed 13.4 BL820 BL92.1 In Proc Qty This is the quantity that is in process BL940 CX05.1 in the warehouse which means that this CX05.2 CX100 quantity has been printed on a pick CX20.1 CX20.2 list, but it has not been shipped yet. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC138 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-ONORDER-QTY Signed 13.4 BL820 BL92.1 On Order Quantity This field contains the on-order BL940 CX05.1 quantity for the item location. It is CX05.2 CX100 the total of all open supply orders. It CX20.1 CX20.2 is maintained by the Purchase Order and CX20.4 CX20.5 Requisitions systems. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC138 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 IN20.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-INTRANS-QTY Signed 13.4 BL820 BL92.1 Intransit Quantity This field contains the quantity BL940 CX05.1 intransit to the item location. This is CX05.2 CX100 maintained by the Inventory Control CX20.1 CX20.2 system. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC138 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-WIP-QTY Signed 13.4 BL820 BL92.1 Wip Qty This field represents the work-in- BL940 CX05.1 process quantity. It is used by the CX05.2 CX100 Work Order system to indicate the CX20.1 CX20.2 quantity of finished goods that are in CX20.4 CX20.5 the process of being produced. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 ... ITL-HOLD-QTY Signed 13.4 BL820 BL92.1 Hold Quantity This field contains the quantity of BL940 CX05.1 items on hold for inspection at the CX05.2 CX100 location. This field is maintained by CX20.1 CX20.2 the Purchase Order system. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 ... ITL-MOVE-CLASS Alpha 1 BL820 BL92.1 Movement Class This field contains the designated BL940 CX05.1 movement class. CX05.2 CX100 1 = Movement Class 1 CX20.1 CX20.2 2 = Movement Class 2 CX20.4 CX20.5 3 = Movement Class 3 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC150 IC151 IC152 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 ... ITL-MOVE-RANK Numeric 5 BL820 BL92.1 Movement Rank This field contains the ranking within BL940 CX05.1 the movement class. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC150 IC151 IC152 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-STORAGE-CODE Alpha 5 BL820 BL92.1 Bin Storage Code This field contains the code assigned BL940 CX05.1 to describe the physical characteristics CX05.2 CX100 of a bin. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-PREFER-BIN Alpha 7 BL820 BL92.1 Preferred Bin This field contains the designated BL940 CX05.1 preferred bin for the item at this CX05.2 CX100 location. This is the default bin number CX20.1 CX20.2 used on transactions if the item is bin CX20.4 CX20.5 tracked. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-MIN-ORDER Signed 13.4 BL820 BL92.1 Minimum Order This field contains the minimum order BL940 CX05.1 Quantity quantity. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-MAX-ORDER Signed 13.4 BL820 BL92.1 Maximum Order This field contains the maximum order BL940 CX05.1 Quantity quantity. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-ORDER-POLICY Alpha 3 BL820 BL92.1 Ordering Policy This field contains the method of BL940 CX05.1 reordering. CX05.2 CX100 FOP = Fixed Order Point CX20.1 CX20.2 TPO = Time Phased Order Point CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-REORD-DOC-CD Alpha 1 BL820 BL92.1 Reorder Document This field contains a code that BL940 CX05.1 Code indicates the manner in which this item CX05.2 CX100 is reordered. CX20.1 CX20.2 N = No document created only plan CX20.4 CX20.5 P = Purchaser Order CX220 CX30.1 R = Requisition CX300 CX506 X = Intransit Document CX805 CXCP.1 T = Transfer Document DR100 IC10.2 I = Issue Document IC12.1 IC141 W = Work Order IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-REORD-QTY-CD Alpha 1 BL820 BL92.1 Reorder Quantity This field contains the reorder BL940 CX05.1 Code quantity code that indicates how to CX05.2 CX100 determine the quantity ordered. CX20.1 CX20.2 D = Difference CX20.4 CX20.5 E = Economic Order Quantity CX220 CX30.1 F = Fixed CX300 CX506 M = Order up to Maximum Level CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-REORD-PT-CD Alpha 1 BL820 BL92.1 Reorder Point Code This field contains the reorder point BL940 CX05.1 code that indicates how the reorder CX05.2 CX100 point quantity is determined. CX20.1 CX20.2 F = Fixed CX20.4 CX20.5 V = Variable CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-REORDER-QTY Signed 13.4 BL820 BL92.1 Reorder Quantity This field contains the normal reorder BL940 CX05.1 quantity for the item at this location. CX05.2 CX100 This field is maintained by the user or CX20.1 CX20.2 the system, based on the reorder CX20.4 CX20.5 quantity code. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC120 IC140 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC225 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-REORDER-POINT Signed 13.4 BL820 BL92.1 Reorder Point This field contains the reorder point. BL940 CX05.1 Reordering for this item is triggered to CX05.2 CX100 occur when the item available quantity CX20.1 CX20.2 falls below this reorder point. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC120 IC141 IC142 IC145 IC170 IC175 IC183 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 ... ITL-SUGG-REORD-PT Signed 13.4 IC182 IC81.1 Sugg Reord Pt This is the calculated suggested par IC812 IC840 value or stock level quantity. This IC962 quantity is calculated by IC182 (Par Location Utilization). ITL-LEAD-CTRL-CD Alpha 1 BL820 BL92.1 Leadtime Control This field contains the code that BL940 CX05.1 Code determines how the leadtime number of CX05.2 CX100 days is maintained. CX20.1 CX20.2 M = Manually Entered CX20.4 CX20.5 R = Needs Review CX220 CX30.1 S = System Calculates CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-LEADTIME-DAYS Numeric 3 BL820 BL92.1 Leadtime Number of This field contains the average BL940 CX05.1 Days leadtime days. It is the average of the CX05.2 CX100 last and previous leadtime days if this CX20.1 CX20.2 field is system calculated. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC120 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-LAST-LEADTIME Numeric 3 BL820 BL92.1 Last Lead Time This field contains the difference BL940 CX05.1 between the received date and the CX05.2 CX100 purchase order date. This field is CX20.1 CX20.2 updated by the Purchase Order system. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 ... ITL-PREV-LEADTIME Numeric 3 BL820 BL92.1 Previous Leadtime This field is maintained by the BL940 CX05.1 Purchase Order system. The last leadtime CX05.2 CX100 value is moved to the previous leadtime CX20.1 CX20.2 field when a new purchase order is CX20.4 CX20.5 received. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 ... ITL-AUTO-PO Alpha 1 BL820 BL92.1 Auto Create This field indicates whether a purchase BL940 CX05.1 Purchase Orders order is to be automatically created for CX05.2 CX100 this item. CX20.1 CX20.2 N = No CX20.4 CX20.5 Y = Yes CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-ORDER-MULT Numeric 4 BL820 BL92.1 Order Multiple This field contains the order multiple. BL940 CX05.1 The reorder quantity should be a CX05.2 CX100 multiple of this quantity. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC120 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-EOQ Signed 13.4 BL820 BL92.1 Economic Order This field contains the EOQ (Economic BL940 CX05.1 Quantity Order Quantity). This is a calculation CX05.2 CX100 that checks the cost of ordering the CX20.1 CX20.2 item against the cost of carrying the CX20.4 CX20.5 item in inventory to determine the ideal CX220 CX30.1 quantity to be ordered. CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC120 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-SAFETY-STOCK Signed 13.4 BL820 BL92.1 Safety Stock This field contains the quantity of BL940 CX05.1 stock planned to be in inventory to CX05.2 CX100 protect against the fluctuations in CX20.1 CX20.2 supply and demand. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-PRIME-VENDOR Alpha 9 BL140 BL820 Primary Vendor This field contains the primary vendor BL92.1 BL940 for the item location. CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 ... ITL-PURCH-FR-LOC Alpha 4 BL820 BL92.1 Purchase From This field contains the vendor's BL940 CX05.1 Location Code purchase from location. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-MANUF-CODE Alpha 4 CX205 IC10.2 Manufacturer's Code This field contains a user defined code IC12.1 IC281 that indicates the manufacturer of an IC521 IC522 item. IC524 IC525 IC526 IC527 IC812 IC962 PO100 PO120 PO123 PO16.1 PO20.1 PO22.3 PO31.1 RQ20.1 RQ20.4 ITL-MANUF-DIVISION Alpha 4 CX205 IC10.2 Manufacturer's This is a user defined code that IC12.1 IC281 Division indicates which division of a IC521 IC522 manufacturer is tied to an item. IC524 IC525 IC526 IC527 IC812 IC962 PO100 PO120 PO123 PO16.1 PO20.1 PO22.3 PO31.1 RQ20.1 RQ20.4 ITL-MANUF-NBR Alpha 15 CX205 IC10.2 Manufacturer's Item This is the identifier that the IC12.1 IC281 Number manufacturer has assigned to an item. IC521 IC522 IC524 IC525 IC526 IC527 IC812 IC962 PO100 PO120 PO123 PO16.1 PO20.1 PO22.3 PO31.1 RQ20.1 RQ20.4 ITL-SP-CYCLE-CNT Alpha 1 BL820 BL92.1 Special Cycle Count This field contains the special cycle BL940 CX05.1 Flag count designator, which is used to CX05.2 CX100 select this item for cycle counting CX20.1 CX20.2 regardless of the item's movement class. CX20.4 CX20.5 X = Selected for Special Cycle Cnt CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-LAST-COUNT-DT Numeric 8 (yyyymmdd) BL820 BL92.1 Last Count Date This field contains the date this item BL940 CX05.1 was last counted in the physical CX05.2 CX100 inventory process. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-REPL-FROM-CO Numeric 4 BL820 BL92.1 Repl From Co This is the source company from which BL940 CX05.1 this line will be replenished. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 ... ITL-REPL-FROM-LOC Alpha 5 BL820 BL92.1 Replenishment From This field contains the location from BL940 CX05.1 Location which this item is to be replenished. CX05.2 CX100 This field indicates that this item is CX20.1 CX20.2 normally supplied from another location, CX20.4 CX20.5 not purchased from a vendor. CX205 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC281 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC521 IC522 IC524 IC525 IC526 IC527 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 ... ITL-REPL-FROM-BIN Alpha 7 BL820 BL92.1 Replenishment From This field contains the replenishment BL940 CX05.1 Bin from bin. This bin number is in the CX05.2 CX100 replenishment from location. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-FORECAST-NBR Numeric 4 BL820 BL92.1 Forecast Number This number identifies which forecast BL940 CX05.1 record is to be used for this item. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-CHARGEABLE-FL Alpha 1 BL820 BL92.1 Chargeable Flag This flag indicates that this item is a BL940 CX05.1 patient chargeable item. CX05.2 CX100 Y = Yes CX20.1 CX20.2 N = No CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-TRACKING-FL Alpha 1 BL820 BL92.1 Tracking Flag This flag specifies if quantities are BL940 CX05.1 to be tracked at this location for this CX05.2 CX100 item. CX20.1 CX20.2 Y = Yes CX20.4 CX20.5 N = No CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 IC965 IC991 OE10.1 OE10.2 OE10.3 ... ITL-BIN-TRACK-FL Alpha 1 BL820 BL92.1 Bin Tracking Flag This field indicates whether this item BL940 CX05.1 is to be tracked by bin at this CX05.2 CX100 location. CX20.1 CX20.2 N = No CX20.4 CX20.5 Y = Yes CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-ALLOW-REC-FL Alpha 1 BL820 BL92.1 Allow Receipts Flag This field indicates whether receipts BL940 CX05.1 are allowed. If set to No, the Purchase CX05.2 CX100 Order system cannot order the item. CX20.1 CX20.2 N = No CX20.4 CX20.5 Y = Yes CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-ALLOW-ISS-FL Alpha 1 BL820 BL92.1 Allow Issues Flag This field indicates whether issues of BL940 CX05.1 this item are allowed. CX05.2 CX100 N = No CX20.1 CX20.2 Y = Yes CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-INSP-REQ-FL Alpha 1 BL820 BL92.1 Inspection Required This field specifies if the item is BL940 CX05.1 Flag inspected when it is received. This CX05.2 CX100 field defaults to the Purchase Order and CX20.1 CX20.2 Case Carts systems. CX20.4 CX20.5 N = No CX220 CX30.1 Y = Yes CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-ACTIVITY-FL Alpha 1 BL820 BL92.1 Activity Flag This field indicates whether this BL940 CX05.1 record has been updated by any CX05.2 CX100 transaction since Stock Status Report CX20.1 CX20.2 (IC145), Item Mass Update (IC116) or CX20.4 CX20.5 Distribution Requirements Report (DR100) CX220 CX30.1 has been run. CX300 CX506 N = No CX805 CXCP.1 Y = Yes DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC820 IC83.1 IC962 IN20.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-FREEZE-FL Alpha 1 BL820 BL92.1 Freeze Flag This field indicates this record has BL940 CX05.1 been selected to be counted in the CX05.2 CX100 physical inventory process. CX20.1 CX20.2 N = No CX20.4 CX20.5 Y = Yes CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC179 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC574 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC73.1 IC74.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-FREEZE-DT Numeric 8 (yyyymmdd) BL820 BL92.1 Freeze Date This field indicates the date this BL940 CX05.1 record was selected for physical CX05.2 CX100 inventory counting. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC574 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC74.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-LAST-ISSUE-DT Numeric 8 (yyyymmdd) BL820 BL92.1 Last Issue Date This field contains the date of the BL940 CX05.1 last issue of this item at this CX05.2 CX100 location. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-LAST-UPD-DT Numeric 8 (yyyymmdd) AP125 AP126 Last Update Date This field contains the date the AP225 AP226 transaction was released for an item AP25.1 AP25.2 record or the last date an item record AP26.1 BL820 was maintained. BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC26.1 IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC820 ... ITL-UPDATE-TIME Numeric 6 AP125 AP126 Update Time This field contains the system time AP225 AP226 when the record was updated. AP25.1 AP25.2 AP26.1 BL820 BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC26.1 IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 IC963 ... ITL-TRAN-COUNTER Numeric 6 AP25.1 AP25.2 Tran Counter This field contains a transaction BL820 BL92.1 object number used to determine the BL940 CX05.1 sequence of updating the Item Location CX05.2 CX100 file. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC26.1 IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC850 IC90.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 ... ITL-LAST-REC-DT Numeric 8 (yyyymmdd) BL820 BL92.1 Last Received Date This field contains the date of the BL940 CX05.1 last receiving. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC850 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-LAST-TURN-DT Numeric 8 (yyyymmdd) BL820 BL92.1 Last Turnover Date This field contains the date the BL940 CX05.1 turnover rate was last calculated. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-MSDS-DT Numeric 8 (yyyymmdd) BL820 BL92.1 Material Safety This field contains the date a new BL940 CX05.1 DataSheet Date Material Safety Data Sheet (MSDS) should CX05.2 CX100 be sent from the vendor. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-MSDS-ORDER-FL Alpha 1 BL820 BL92.1 MSDS Ordered Flag This field is used by the Purchase BL940 CX05.1 Order system to indicate if the Material CX05.2 CX100 Safety Data Sheet (MSDS) for this item CX20.1 CX20.2 has been sent to this location. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-MSDS-DOCUMENT Alpha 30 IC12.1 IC812 Msds Document The document number from the most IC962 PO30.1 recent MSDS that was received. PO530 ITL-MSDS-VERSION Alpha 4 IC12.1 IC812 Msds Version The version number of the most recent IC962 PO30.1 MSDS that was received. PO530 ITL-AVG-SOH-QTY Signed 13.4 BL820 BL92.1 Average Stock On This field contains the average BL940 CX05.1 Hand Quantity stock-on-hand quantity of the item for CX05.2 CX100 the last year. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC190 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-TURN-RATE Signed 6.1 BL820 BL92.1 Turnover Rate This field contains the rate of BL940 CX05.1 turnover, which is calculated by CX05.2 CX100 dividing the annual sales quantity by CX20.1 CX20.2 the average stock-on-hand quantity. CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC134 IC135 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 ... ITL-LAST-REC-COST Signed 13.5 AP125 AP126 Last Received Cost This field contains the last received AP225 AP226 or invoiced unit cost. AP25.1 AP25.2 AP26.1 BL820 BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 ... ITL-LAST-ISS-COST Signed 13.5 BL820 BL92.1 Last Issue Cost This field contains the unit cost of BL940 CX05.1 the last issue. CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-AVERAGE-COST Signed 13.5 AP125 AP126 Average Cost This field contains the moving average AP225 AP226 unit cost of an item. This figure is AP25.1 AP25.2 always calculated regardless of the AP26.1 BL820 company costing method. BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 ... ITL-TRANS-COUNT Numeric 5 BL820 BL92.1 Nbr Transaction This field contains the number of BL940 CX05.1 Since Last Cnt inventory transactions involving this CX05.2 CX100 item at this location since the last CX20.1 CX20.2 update run of Update Variances (IC175). CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC820 IC83.1 IC850 IC90.1 IC962 OE10.1 OE10.2 OE10.3 ... ITL-CNT-ACCURACY Signed 5.1 BL820 BL92.1 Count Accuracy This field contains the count accuracy BL940 CX05.1 Percent for this item at this location from the CX05.2 CX100 last physical inventory count. CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 ... ITL-ADDED-DATE Numeric 8 (yyyymmdd) BL820 BL92.1 Date Item was Added This field contains the date the Item BL940 CX05.1 Location record was originally added in CX05.2 CX100 IC12.1 (Item Location) or IC10.1 CX20.1 CX20.2 (Formats). It defaults to the system CX20.4 CX20.5 date when the record is added. CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC116 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-ACTIVE-STATUS Alpha 1 BL820 BL92.1 Status This status indicates whether the item BL940 CX05.1 is active or inactive at this location. CX05.2 CX100 If the item is inactive, no transactions CX20.1 CX20.2 can be entered for this item at this CX20.4 CX20.5 location, but transactions in process CX220 CX30.1 can be completed. CX300 CX506 A = Active CX805 CXCP.1 I = Inactive DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC82.1 IC83.1 IC840 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 ... ITL-USER-FIELD1 Alpha 30 BL820 BL92.1 Item Mster User This field contains the first BL940 CX05.1 Defined Field1 user-defined field for the Item Location CX05.2 CX100 file. It can be used to enter any data CX20.1 CX20.2 the user wants. This field's name is CX20.4 CX20.5 defined in IC01.1 (Company). CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-USER-FIELD2 Alpha 10 (Lower Case) BL820 BL92.1 Item Mster User This field contains the second BL940 CX05.1 Defined Field2 user-defined field for the Item Location CX05.2 CX100 record. It can be used to enter any data CX20.1 CX20.2 the user wants. This field's name is CX20.4 CX20.5 defined in IC01.1 (Company). CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-USER-FIELD3 Alpha 10 (Lower Case) BL820 BL92.1 Item Mster User This field contains the third BL940 CX05.1 Defined Field3 user-defined field for the Item Location CX05.2 CX100 record. It can be used to enter any data CX20.1 CX20.2 the user wants. This field's name is CX20.4 CX20.5 defined in IC01.1 (Company). CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-USER-FIELD-N1 Signed 13.5 BL820 BL92.1 User Defined This field contains the first BL940 CX05.1 Numeric Field 1 user-defined numeric field for the Item CX05.2 CX100 Location record. It can be used to enter CX20.1 CX20.2 any data the user wants. This field's CX20.4 CX20.5 name is defined in IC01.1 (Company). CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-USER-FIELD-N2 Signed 13.5 BL820 BL92.1 User Defined This field contains the second BL940 CX05.1 Numeric Field 2 user-defined numeric field for the Item CX05.2 CX100 Location record. It can be used to enter CX20.1 CX20.2 any data the user wants. This field's CX20.4 CX20.5 name is defined in IC01.1 (Company). CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-USER-FIELD-N3 Signed 13.5 BL820 BL92.1 User Defined This field contains the third BL940 CX05.1 Numeric Field 3 user-defined numeric field for the Item CX05.2 CX100 Location record. It can be used to enter CX20.1 CX20.2 any data the user wants. This field's CX20.4 CX20.5 name is defined in IC01.1 (Company). CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 IC10.2 IC12.1 IC141 IC142 IC145 IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1 IC262 IC31.1 IC40.1 IC40.2 IC45.1 IC500 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC81.1 IC812 IC83.1 IC962 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 ... ITL-ACCT-UNIT-INV Derived Acct Unit Inv This field is derived from the inventory accounting unit on the General Ledger Account Category file. ITL-ACCOUNT-INV Derived Account Inv This field is derived from the inventory account field on the General Ledger Account Category file. ITL-SUB-ACCT-INV Derived Sub Acct Inv This field is derived from the inventory subaccount field on the General Ledger Account Category file. ITL-MANUF-NBR-DER Derived Manufacturer's Item This field is the manufacturer's number Number based on where it is set up in the Item Location or Item Master file. ITL-MANUF-CODE-DER Derived Manufacturer's Code This field is the manufacturer's code based on where it is set up in the Item Master or Item Location file. ITL-MANUF-DIV-DER Derived Manufacturer's This field is the manufacturer's Division division based on where it is set up in the Item Master or Item Location file. ITL-NEG-ALLOC Derived Neg Alloc This field is allocated quantity set to negative for use in the allocatable and sellable calculations. ITL-NEG-BACKORD Derived Neg Backord This field is the backorder quantity set to negative for use the allocatable and sellable calculations. ITL-NEG-INPROC Derived Neg Inproc This field is the in-process quantity set to negative for use in the available-to-allocate and available-to-sell calculations. ITL-NEG-ONORD Derived Neg Onord This field contains the on-order quantity set to negative for use in the available-to-allocate and available-to-sell calculations. ITL-NEG-INTRANS Derived Neg Intrans This field is the intransit quantity set to negative for use in the available-to-allocate and available-to-sell calculations. ITL-NEG-WIP Derived Neg Wip This field is the Work In Process quantity set to negative for use in the allocatable and sellable calculations. ITL-NEG-HOLD Derived Neg Hold This field is the Hold quantity set to negative for use in the allocatable and sellable calculations. ITL-SELL-ALLOC Derived Sell Alloc This field is the allocated quantity with its sign set to match the option on the available-to-sell calculation. ITL-SELL-INPROC Derived Sell Inproc This field is the in-process quantity with its sign set to match the option selected on the available-to-sell calculation. ITL-SELL-BACKORD Derived Sell Backord This field is the backorder quantity with its sign set to match the option selected on the available-to-sell calculation. ITL-SELL-ONORD Derived Sell Onord This field is the on-order quantity with its sign set to match the option selected on the available-to-sell calculation. ITL-SELL-INTRAN Derived Sell Intran This field is the intransit quantity with its sign set to match the option selected in the available-to-sell calculation. ITL-SELL-WIP Derived Sell Wip This field is the work-in-process quantity with its sign set to match the option selected in the available-to-sell calculation. ITL-SELL-HOLD Derived Sell Hold This field is the hold quantity with its sign set to match the option selected in the available-to-sell calculation. ITL-ALC-ALLOC Derived Alc Alloc This field is the Allocated quantity with it's sign set to match the option selected in the allocatable calculation. ITL-ALC-INPROC Derived Alc Inproc This field is the In Process quantity with it's sign set to match the option selected in the allocatable calculation. ITL-ALC-BACKORD Derived Alc Backord This field is the Backorder quantity with it's sign set to match the option selected in the allocatable calculation. ITL-ALC-ONORD Derived Alc Onord This field is the On Order quantity with it's sign set to match the option selected in the allocatable calculation. ITL-ALC-INTRAN Derived Alc Intran This field is the Intransit quantity with it's sign set to match the option selected in the allocatable calculation. ITL-ALC-WIP Derived Alc Wip This field is the work-in-process quantity with its sign set to match the option selected in the available-to-allocate calculation. ITL-ALC-HOLD Derived Alc Hold This field is the Hold quantity with it's sign set to match the option selected in the allocatable calculation. ITL-SELLABLE Derived Sellable This field is the calculated quantity that is available to sell for those customers that do not allow backorders. ITL-ALLOCATABLE Derived Allocatable This field is the quantity that is available to allocate to an order, so that the picking document can be printed. ITL-CWT-ALLOCATABL Derived Cwt Allocatabl This field is the quantity in terms of the catch weight that can be allocated for orders. ITEMLOC FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ITLSET1 COMPANY AP125 AP126 LOCATION AP225 AP226 ITEM AP25.1 AP25.2 AP26.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 BL940 CX05.1 CX05.2 CX100 ... ITLSET2 COMPANY BL85.1 BL85.2 ITEM IC10.1 IC10.2 LOCATION IC11.1 IC116 IC16.2 IC16.4 IC170 IC31.1 IC36.1 IC40.1 IC40.2 IC42.1 IC42.2 IC42.3 IC42.4 IC60.1 IC82.1 IC965 IC991 PO150 WH20.7 WO30.1 ITLSET5 COMPANY KeyChange DR42.1 IC225 LOCATION IC590 BUYER-CODE ITEM ITLSET6 COMPANY KeyChange BL140 IC116 LOCATION IC140 PRIME-VENDOR ITEM ITLSET7 COMPANY KeyChange IC170 IC295 LOCATION LAST-COUNT-DT ITEM ITLSET8 COMPANY KeyChange IC170 IC281 LOCATION IC81.1 IC83.1 PREFER-BIN ITEM ITEMLOC FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Apcompany APCOMPANY Required When ITL-PRIME-VENDOR != Spaces ITL-COMPANY -> CPY-COMPANY Bingrpdtl BINGRPDTL Required ITL-COMPANY -> BGD-COMPANY ITL-LOCATION -> BGD-LOCATION ITL-LOCATION -> BGD-BIN-GROUP ITL-PREFER-BIN -> BGD-BIN Buyer BUYER Not Required ITL-COMPANY -> BUY-COMPANY ITL-BUYER-CODE -> BUY-BUYER-CODE 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 Poitemven POITEMVEN Not Required ITL-COMPANY -> PIV-COMPANY ITL-ITEM -> PIV-ITEM ITL-PRIME-VENDOR -> PIV-VENDOR 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 When ITL-REPL-FROM-BIN != Spaces ITL-COMPANY -> ICB-COMPANY ITL-LOCATION -> ICB-LOCATION ITL-PREFER-BIN -> ICB-BIN Repl From Loc ICLOCATION Required When ITL-REPL-FROM-LOC != Spaces ITL-COMPANY -> ICL-COMPANY ITL-REPL-FROM-LOC -> ICL-LOCATION Repl Itemloc ITEMLOC Not Required ITL-COMPANY -> ITL-COMPANY ITL-REPL-FROM-LOC -> ITL-LOCATION ITL-ITEM -> ITL-ITEM Rrpl Itemloc ITEMLOC Not Required ITL-COMPANY -> ITL-COMPANY ITL-REPL-FROM-LOC -> 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 Taxcode TXTAXCODE Required ITL-COMPANY -> TAC-COMPANY ITL-PURCH-TAX-CD -> TAC-TAX-CODE Vendloc APVENLOC Required When ITL-PRIME-VENDOR != Spaces CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP ITL-PRIME-VENDOR -> VLO-VENDOR ITL-PURCH-FR-LOC -> VLO-LOCATION-CODE Vendmast APVENMAST Required When ITL-PRIME-VENDOR != Spaces CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP ITL-PRIME-VENDOR -> VEN-VENDOR Vendorgroup APVENGROUP Required When ITL-PRIME-VENDOR != Spaces 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 Spaces -> ICO-LANGUAGE-CODE ICO-SEQ 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-LINE-NBR Porecline PORECLINE ITL-COMPANY -> PRL-COMPANY ITL-LOCATION -> PRL-LOCATION ITL-ITEM -> PRL-ITEM PRL-UPDATE-DATE PRL-UPDATE-TIME PRL-TRAN-COUNTER PRL-DOCUMENT 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 |