ICLOCATION FILE Company Location The Company Location file stores valid locations within a company. The locations establish the identification of stock locations. REFERENCED BY AP125 AP126 AP225 AP226 AP25.1 AP25.2 AP26.1 AR08.1 AR10.1 AR501 AR550 BL01.1 BL02.1 BL120 BL122 BL130 BL140 BL141 BL20.1 BL20.3 BL201 BL202 BL208 BL21.2 BL21.5 BL240 BL241 BL29.1 BL29.2 BL30.1 BL30.2 BL30.3 BL30.5 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.1 BL32.2 BL32.3 BL32.4 BL340 BL341 BL40.1 BL40.2 BL40.3 BL41.1 BL42.1 BL48.1 BL520 BL802 BL820 BL85.1 BL85.2 BL90.1 BL902 BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX207 CX220 CX30.1 CX300 CX506 CX805 CXA2.1 CXCP.1 DR25.1 DR40.1 DR42.1 IC01.1 IC01.3 IC03.1 IC04.1 IC10.1 IC10.2 IC110 IC116 IC12.1 IC120 IC125 IC130 IC134 IC135 IC138 IC140 IC145 IC15.1 IC15.2 IC15.3 IC150 IC151 IC152 IC16.1 IC16.3 IC16.4 IC175 IC182 IC183 IC19.1 IC192 IC199 IC20.1 IC20.2 IC202 IC203 IC204 IC21.1 IC21.2 IC211 IC215 IC219 IC22.1 IC22.2 IC220 IC221 IC222 IC223 IC224 IC225 IC226 IC227 IC228 IC229 IC23.1 IC23.2 IC23.3 IC23.4 IC23.5 IC230 IC232 IC233 IC234 IC237 IC238 IC239 IC24.1 IC24.2 IC241 IC242 IC25.1 IC260 IC27.1 IC270 IC28.1 IC280 IC284 IC286 IC29.1 IC29.2 IC29.3 IC295 IC31.1 IC36.1 IC38.1 IC41.1 IC42.1 IC42.2 IC42.3 IC42.4 IC43.1 IC45.1 IC47.1 IC48.1 IC49.1 IC50.1 IC50.2 IC50.3 IC500 IC51.1 IC519 IC52.1 IC520 IC521 IC522 IC523 IC524 IC525 IC526 IC527 IC53.1 IC530 IC550 IC574 IC589 IC59.1 IC590 IC60.1 IC60.2 IC60.3 IC61.1 IC65.1 IC67.1 IC70.1 IC73.1 IC74.1 IC812 IC82.1 IC820 IC841 IC850 IC851 IC90.1 PC120 PC20.1 PC540 IN20.1 MA04.1 MA204 MA278 MA300 MA40.1 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.4 MA52.1 MA520 MA530 MA540 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE112 OE113 OE129 OE13.1 OE14.1 OE14.2 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE260 OE270 OE271 OE287 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE53.1 OE60.1 OE810 OE830 OE85.1 OE920 OE950 PO100 PO115 PO120 PO121 PO122 PO123 PO130 PO131 PO132 PO133 PO135 PO14.1 PO15.1 PO150 PO180 PO20.1 PO21.1 PO21.2 PO21.5 PO21.6 PO214 PO22.1 PO22.2 PO22.3 PO220 PO221 PO223 PO224 PO225 PO23.1 PO230 PO231 PO233 PO25.1 PO25.2 PO25.3 PO25.4 PO26.1 PO274 PO275 PO276 PO277 PO28.3 PO28.4 PO28.5 PO28.7 PO28.8 PO280 PO30.1 PO33.1 PO34.1 PO35.1 PO37.1 PO53.1 PO530 PO61.1 PO62.1 PO63.1 PO64.1 PO67.1 PO68.1 PO69.1 PO72.2 PO81.1 PO820 PO821 PO85.1 PO94.1 POA2.1 RQ01.1 RQ111 RQ120 RQ125 RQ201 RQ230 RQ235 RQ240 RQ41.1 RQ50.1 RQ510 RQ513 RQ810 RQ963 SEA2.1 SA04.1 SA80.3 SA90.3 SAA2.1 WH120 WH126 WH131 WH132 WH140 WH21.1 WH21.2 WH21.3 WH21.4 WH210 WH220 WH221 WH222 WH224 WH226 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 WH330 WH34.1 WH34.2 WH34.3 WH34.4 WH34.5 WH38.1 WH520 WH830 WOA2.1 IC281 UPDATED BY BL08.1 DR100 IC02.1 IC141 IC142 IC143 IC243 IC26.1 IC26.2 IC262 IC263 IC283 IC62.1 IC62.2 IC63.1 IC68.1 IC68.2 IC68.3 IC81.1 IC83.1 IC840 IC961 IC990 OE10.5 OE114 OE80.1 OE81.1 OE81.3 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ15.1 RQ20.1 RQ35.1 RQ500 TX140 TX40.1 WH02.1 WH110 WH130 WH190 WH20.7 WH40.1 WH40.2 WH52.1 WH80.1 WH80.3 WH80.4 WH81.1 WH965 WH966 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO20.2 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO293 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 WO82.1 WOEX.1 WOSP.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ICL-COMPANY Numeric 4 BL08.1 IC02.1 Company The company number represents an IC81.1 IC840 established company and is entered on IC961 all function codes. ICL-LOCATION-TYPE Alpha 1 IC81.1 IC840 Location Type This field specifies whether this IC961 location is a standard inventory location or an exchange cart or a par location. This is used in the par location replenishment. E = Exchange Cart P = Par Location ICL-LOCATION Alpha 5 BL08.1 IC02.1 Location Code This field contains a valid stock IC138 IC81.1 location within the company inventory. IC840 IC961 ICL-NAME Alpha 30 (Lower Case) BL02.1 BL140 Name This field contains the location's name BL141 BL240 defined in IC02.1 (Location). BL241 BL340 BL341 BL41.1 BL42.1 BL48.1 IC02.1 IC81.1 IC961 OE10.1 OE10.2 OE10.3 OE10.4 OE10.6 OE10.7 OE114 OE30.1 OE30.3 OE53.1 RQ01.1 RQ810 WH126 WH131 WH220 WH221 WH224 WH226 ICL-REPL-FROM-LOC Alpha 5 IC81.1 IC840 Replenishment From This is the default location from which IC961 Location the location gets replenished. This is used in the par cart replenishment process. ICL-ADDR1 Alpha 30 (Lower Case) IC02.1 IC961 Address 1 This field contains the first line of OE114 WH126 address information. WH224 ICL-ADDR2 Alpha 30 (Lower Case) IC02.1 IC961 Address 2 This field contains the second line of OE114 WH126 address information. WH224 ICL-ADDR3 Alpha 30 (Lower Case) IC02.1 IC961 Address 3 This field contains the third line of OE114 WH126 address information. WH224 ICL-ADDR4 Alpha 30 (Lower Case) IC02.1 IC961 Address 4 This field contains the fourth line of OE114 WH126 address information. WH224 ICL-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1 IC961 City or Address 5 This field contains the fifth line OE114 WH126 and/or the city of the address. WH224 ICL-STATE-PROV Alpha 2 IC02.1 IC961 State or Province This field contains the state or OE114 WH126 province of the address. WH224 ICL-POSTAL-CODE Alpha 10 (Lower Case) IC02.1 IC961 Postal Code This field contains the postal code of OE114 WH126 the address. WH224 ICL-COUNTRY Alpha 30 (Lower Case) IC02.1 IC961 Country or Other This field contains the country of the OE114 WH126 address, or it can contain additional WH224 information such as an attention name. ICL-ADDR-CONTACT Alpha 30 (Lower Case) IC02.1 IC961 Contact This field contains the name of the main contact. ICL-PO-NAME Alpha 30 (Lower Case) IC02.1 IC81.1 Purchase Order Name This field contains the name of the IC961 PO15.1 ship to address. This information prints PO30.1 PO63.1 on purchase orders. PO64.1 ICL-PO-ADDR1 Alpha 30 (Lower Case) IC02.1 IC961 Purchase Order This field contains the first line of Address 1 ship-to address. This information prints on purchase orders. ICL-PO-ADDR2 Alpha 30 (Lower Case) IC02.1 IC961 Purchase Order This field contains the second line of Address 2 the ship-to address. This information prints on purchase orders. ICL-PO-ADDR3 Alpha 30 (Lower Case) IC02.1 IC961 Purchase Order This field contains the third line of Address 3 the ship-to address. This information prints on purchase orders. ICL-PO-ADDR4 Alpha 30 (Lower Case) IC02.1 IC961 Purchase Order This field contains the fourth line of Address 4 the ship-to address. This information prints on purchase orders. ICL-PO-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1 IC961 Purchase Order City This field contains the fifth line or or Addr 5 city of the ship-to address. This information is printed on purchase orders. ICL-PO-STATE-PROV Alpha 2 IC02.1 IC961 Purchase Order This field contains the state or State/Province province of the ship-to address. This information prints on purchase orders. ICL-PO-POSTAL-CD Alpha 10 (Lower Case) IC02.1 IC961 Purchase Order This field contains the postal code of Postal Code the ship-to address. This information prints on purchase orders. ICL-PO-COUNTRY Alpha 30 (Lower Case) IC02.1 IC961 Purchase Order This field contains the country of the Country ship-to address. This information prints on purchase orders. ICL-HIN-NBR Alpha 9 IC02.1 IC961 Hin Nbr The Health Industry Number is a unique number assigned to any company or facility doing business in the health industry. This number is assigned by the Health Industry Business Communications Council (HIBCC). ICL-OE-RUN-STS Numeric 1 BL08.1 DR100 Order Entry Run This field indicates which processing IC141 IC142 Status form is currently running or has been IC143 IC961 run. WH110 WH130 0 = No Processing In Progress 1 = Allocation Feedback Running 2 = Pick List Print Running 3 = Picking Feedback Running 4 = Packing Feedback Running 5 = Shipping Feedback Running ICL-PROCESS-TYPE Alpha 2 IC02.1 Process Type This field is the process type to be used for orders and requisitions. The process type determines which steps (pick, pack, and ship) are to be used in the Warehouse system. ICL-ALLOC-PURP Alpha 1 IC02.1 IC961 Allocation Purpose This field determines the allocation method to be used when allocating bin tracked items. Consolidated allocating allocates the bin with the smallest quantity first. Speed picking allocates the bin with the largest quantity first. C = Consolidate Bins S = Speed Picking ICL-LAST-BATCH-NBR Numeric 8 DR100 IC141 Last Batch Number This field is used to assign batch IC142 IC243 numbers to the pick list in the IC262 IC263 Warehouse system. This field is IC62.1 IC62.2 incremented by one every time the pick IC63.1 IC68.1 list program (WH130) is run for this IC68.2 IC68.3 location. IC83.1 IC961 OE10.5 OE114 OE80.1 OE81.1 OE81.3 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ15.1 RQ20.1 RQ35.1 RQ500 TX40.1 WH02.1 WH130 WH190 WH20.7 WH40.1 WH40.2 WH52.1 WH80.1 WH80.3 WH80.4 WH81.1 WH965 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO20.2 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO293 WO30.1 ... ICL-TAX-CODE Alpha 10 BL08.1 IC02.1 Tax Code This field contains a code representing IC961 TX140 specific tax information. This must be valid Tax Code. ICL-LAST-BT-DATE Numeric 8 (yyyymmdd) DR100 IC141 Last Bin Transfer This field contains the last date of a IC142 IC243 Date bin transfer. This date is used for IC26.1 IC26.2 automatically assigning document numbers IC262 IC263 in IC26.1 (Detail Transfers) and IC138 IC62.1 IC62.2 (Bin Replenishment Report). IC63.1 IC68.1 IC68.2 IC68.3 IC83.1 IC961 OE10.5 OE80.1 OE81.1 OE81.3 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ15.1 RQ20.1 RQ35.1 RQ500 TX40.1 WH02.1 WH130 WH190 WH20.7 WH40.1 WH40.2 WH52.1 WH80.1 WH80.3 WH80.4 WH81.1 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO20.2 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO293 WO30.1 ... ICL-LAST-BT-LINE Numeric 6 DR100 IC141 Last Bin Transfer This field contains the last line IC142 IC243 Line number used on a bin transfer. This IC26.1 IC26.2 number is used when IC26.1 (Detail IC262 IC263 Transfers) and IC138 (Bin Replenishment IC62.1 IC62.2 Report) automatically create lines for a IC63.1 IC68.1 document. IC68.2 IC68.3 IC83.1 IC961 OE10.5 OE80.1 OE81.1 OE81.3 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ15.1 RQ20.1 RQ35.1 RQ500 TX40.1 WH02.1 WH130 WH190 WH20.7 WH40.1 WH40.2 WH52.1 WH80.1 WH80.3 WH80.4 WH81.1 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO20.2 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO293 WO30.1 ... ICL-LAST-SHIP-NBR Numeric 10 DR100 IC141 Last Ship Nbr This field is used to determine the IC142 IC243 shipment number on the pick list in the IC262 IC263 Warehouse system. IC62.1 IC62.2 IC63.1 IC68.1 IC68.2 IC68.3 IC83.1 IC961 OE10.5 OE114 OE80.1 OE81.1 OE81.3 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ15.1 RQ20.1 RQ35.1 RQ500 TX40.1 WH02.1 WH130 WH190 WH20.7 WH40.1 WH40.2 WH52.1 WH80.1 WH80.3 WH80.4 WH81.1 WH966 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO20.2 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO293 WO30.1 ... ICL-SUSP-ACCT-UNIT Alpha 15 IC02.1 IC961 Suspense Accounting The accounting unit that will be posted Unit to the general ledger when inventory items being returned to vendors are in process in the warehouse. This is commonly known as a suspense account. ICL-SUSP-ACCOUNT Numeric 6 IC02.1 IC961 Suspense Account The account that will be posted to the general ledger when inventory items being returned to vendors are in process in the warehouse. This is commonly known as a suspense account. ICL-SUSP-SUB-ACCT Numeric 4 IC02.1 IC961 Suspense Subaccount The sub account that will be posted to the general ledger when inventory items being returned to vendors are in process in the warehouse. This is commonly known as a suspense account. ICL-FRT-ACCT-UNIT Alpha 15 IC02.1 IC961 Default Freight This is the accounting unit that will Acct. Unit default to returns for freight credit allowed by the vendor. ICL-FRT-ACCOUNT Numeric 6 IC02.1 IC961 Default Freight This is the account that will default Account to returns for freight credit allowed by the vendor. ICL-FRT-SUB-ACCT Numeric 4 IC02.1 IC961 Default Freight Sub This is the sub account that will Account default to returns for freight credit allowed by the vendor. ICL-HDLG-ACCT-UNIT Alpha 15 IC02.1 IC961 Default Handling This is the accounting unit that will Account Unit default to returns for handling charged by the vendor. ICL-HDLG-ACCOUNT Numeric 6 IC02.1 IC961 Default Handling This is the account that will default Account to returns for handling charged by the vendor. ICL-HDLG-SUB-ACCT Numeric 4 IC02.1 IC961 Default Handling This is the sub account that will Subaccount default to returns for handling charged by the vendor. ICL-SCRP-ACCT-UNIT Alpha 15 IC02.1 IC961 Scrap Accounting This is the accounting unit that will Unit be posted to the general ledger for this location when items reflected upon inspection are scrapped. It is also the accounting unit that will be used if an inventory item that has been returned is adjusted off the return. ICL-SCRP-ACCOUNT Numeric 6 IC02.1 IC961 Scrap Account This is the account that will be posted to the general ledger for this location when items rejected upon inspection are scrapped. This is also the account that will be used if an inventory item that has been returned is adjusted off the return. ICL-SCRP-SUB-ACCT Numeric 4 IC02.1 IC961 Scrap Subaccount This is the sub account that will be posted to the general ledger for this location when items rejected upon inspection are scrapped. This is also the sub account that will be used if an inventory item that has been returned is adjusted off the return. ICL-ERS-CAPABLE Alpha 1 IC02.1 IC961 ERS Capable Indicates whether the vendor location can process Evaluated Receipt Settlement (ERS). Y = Yes N = No ICL-PAR-VALUE Signed 13.2 IC283 IC961 Par Value The value of the inventory stored at the par location. ICL-PRT-DELIV-FL Alpha 1 IC02.1 IC961 Print Deliver This flag specifies whether delivery IC990 Ticket Flag tickets are to be printed in RQ120 (Delivery Ticket) for this company. ICL-WST-ACCT-UNIT Alpha 15 IC02.1 Wst Acct Unit The waste account unit is used to default to components added to finished goods templates or added to work orders when no account information is entered. ICL-WST-ACCOUNT Numeric 6 IC02.1 Wst Account The waste account is used to default to components added to finished goods templates or added to work orders when no account information is entered. ICL-WST-SUB-ACCT Numeric 4 IC02.1 Wst Sub Acct The waste subaccount is used to default to components added to finished goods templates or added to work orders when no account information is entered. ICL-LAST-WO Numeric 8 DR100 IC141 Last Wo The last work order number assigned to IC142 IC243 a work order for the production facility IC262 IC263 when automatic work order numbering is IC62.1 IC62.2 used. IC63.1 IC68.1 IC68.2 IC68.3 IC83.1 OE10.5 OE80.1 OE81.1 OE81.3 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ15.1 RQ20.1 RQ35.1 RQ500 TX40.1 WH02.1 WH130 WH190 WH20.7 WH40.1 WH40.2 WH52.1 WH80.1 WH80.3 WH80.4 WH81.1 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO20.2 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO293 WO30.1 WO30.2 WO300 WO32.1 ... ICL-CALENDAR Alpha 15 IC02.1 Calendar This is the name of the calendar used in the production scheduling process for work orders. ICL-WO-NBR-TYPE Alpha 1 IC02.1 Wo Nbr Type This field is the work order numbering type used at the production facility to indicate if work order numbers are manually or automatically assigned. A = Auto assign work order number M = Manually assign work order nbr " " = Not using Work Orders ICL-DEMAND-SOURCE Numeric 1 IC02.1 Demand Source This is the source of demand that is gathered for use in production scheduling for work orders. 1 = Document Demand 2 = Forecast Demand 3 = Document and Forecast Demand ICL-WO-NBR-START Numeric 8 IC02.1 Wo Nbr Start The work order start number is the first number that can be assigned if work order numbers are automatically assigned. ICL-WO-NBR-END Numeric 8 IC02.1 Wo Nbr End The work order ending number is the last number that can be assigned if work order numbers are automatically assigned. ICL-WIP-ACCT-UNIT Alpha 15 IC02.1 Wip Acct Unit The work-in-process account unit is used to post component costs of a work order to a WIP account when the components are pulled out of inventory in a work order feedback process. ICL-WIP-ACCOUNT Numeric 6 IC02.1 Wip Account The work-in-process account is used to post component costs of a work order to a WIP account when the components are pulled out of inventory in a work order feedback process. ICL-WIP-SUB-ACCT Numeric 4 IC02.1 Wip Sub Acct The work-in-process subaccount is used to post component costs of a work order to a WIP account when the components are pulled out of inventory in a work order feedback process. ICL-OFFSITE-FL Alpha 1 IC02.1 Offsite Fl The offsite flag indicates the inventory location is an offsite facility for the Work Order system. Y = Yes N = No ICL-FGV-ACCT-UNIT Alpha 15 IC02.1 Fgv Acct Unit The finished good variance accounting unit is used to post variances in finished good cost when there is a difference between the cost from an original work order and the cost returned from inventory for a reversed work order. ICL-FGV-ACCOUNT Numeric 6 IC02.1 Fgv Account The finished good variance account is used to post variances in finished good cost when there is a difference between the cost from the original work order and the cost returned from inventory for a reversed work order. ICL-FGV-SUB-ACCT Numeric 4 IC02.1 Fgv Sub Acct The finished good variance subaccount is used to post variances in finished good cost when there is a difference between the cost from the original work order and the cost returned from inventory for a reversed work order. ICL-CAPACITY Numeric 8 IC02.1 Capacity This is the maximum quantity of a finished good that can be scheduled to a single work order. The capacity in this file is used to default to the capacity field on the build process of the work order production scheduling process. ICL-SCHED-INCR Numeric 2 IC02.1 Sched Incr Schedule increment is used with schedule frequency to indicate the length of a scheduling period for work orders. The increment is the number of days, weeks or months in a period. ICL-SCHED-FREQ Alpha 1 IC02.1 Sched Freq Schedule frequency is used with schedule increment to indicate the length of a scheduling period for work orders. The frequency defines whether the period is in days, weeks or months. D = Days W = Weeks M = Months ICL-WO-STATUS Numeric 1 IC02.1 Wo Status This field contains the default status that you want the work order to be created in during production scheduling. 1 = Unreleased 2 = Released 3 = Exploded 4 = In Production ICL-WO-ACCOUNT-FL Alpha 1 IC02.1 Wo Account Fl This indicates if you are using income statement accounts in Work Order Y = Yes " " = Not Applicable N = No ICL-COUNTRY-CODE Alpha 2 IC02.1 Country Code The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). ICL-REGION Alpha 2 IC02.1 Region Code The region code, if applicable for the country. Used only by Intrastat. Must be defined in IN02.1 (Region Maintenance). ICL-PO-COUNTRY-CD Alpha 2 IC02.1 Po Country Cd The PO Ship To country code. Must be defined in IN01.1 (Country Maintenance). ICL-PO-REGION Alpha 2 IC02.1 Po Region The PO Ship To region code. Must be defined in IN02.1 (Region Maintenance). ICL-PRINT-LABELS Alpha 1 IC02.1 Print Labels ICLOCATION FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ICLSET1 COMPANY AP125 AP126 LOCATION AP225 AP226 AP25.1 AP25.2 AP26.1 AR08.1 AR10.1 AR501 AR550 BL01.1 BL02.1 BL08.1 BL120 BL122 BL130 BL140 BL141 BL20.1 BL20.3 BL201 BL202 BL208 BL21.2 BL21.5 BL240 BL241 BL29.1 BL29.2 ... ICLSET2 COMPANY Subset IC281 IC81.1 LOCATION Where LOCATION-TYPE = "E" IC82.1 Or LOCATION-TYPE = "P" ICLOCATION FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Company ICCOMPANY Required ICL-COMPANY -> ICC-COMPANY Fgv Account GLMASTER Not Required ICL-COMPANY -> GLM-COMPANY ICL-FGV-ACCT-UNIT -> GLM-ACCT-UNIT ICL-FGV-ACCOUNT -> GLM-ACCOUNT ICL-FGV-SUB-ACCT -> GLM-SUB-ACCOUNT Frt Account GLMASTER Required When ICL-FRT-ACCT-UNIT != Spaces Or ICL-FRT-ACCOUNT != Zeroes Or ICL-FRT-SUB-ACCT != Zeroes ICL-COMPANY -> GLM-COMPANY ICL-FRT-ACCT-UNIT -> GLM-ACCT-UNIT ICL-FRT-ACCOUNT -> GLM-ACCOUNT ICL-FRT-SUB-ACCT -> GLM-SUB-ACCOUNT Hdlg Account GLMASTER Required When ICL-HDLG-ACCT-UNIT != Spaces Or ICL-HDLG-ACCOUNT != Zeroes Or ICL-HDLG-SUB-ACCT != Zeroes ICL-COMPANY -> GLM-COMPANY ICL-HDLG-ACCT-UNIT -> GLM-ACCT-UNIT ICL-HDLG-ACCOUNT -> GLM-ACCOUNT ICL-HDLG-SUB-ACCT -> GLM-SUB-ACCOUNT Repl From Loc ICLOCATION Not Required Valid When ICL-REPL-FROM-LOC != Spaces ICL-COMPANY -> ICL-COMPANY ICL-REPL-FROM-LOC -> ICL-LOCATION Scrap Account GLMASTER Required When ICL-SCRP-ACCT-UNIT != Spaces Or ICL-SCRP-ACCOUNT != Zeroes Or ICL-SCRP-SUB-ACCT != Zeroes ICL-COMPANY -> GLM-COMPANY ICL-SCRP-ACCT-UNIT -> GLM-ACCT-UNIT ICL-SCRP-ACCOUNT -> GLM-ACCOUNT ICL-SCRP-SUB-ACCT -> GLM-SUB-ACCOUNT Suspense Acct GLMASTER Not Required Valid When ICL-SUSP-ACCT-UNIT != Spaces Or ICL-SUSP-ACCOUNT != Zeroes Or ICL-SUSP-SUB-ACCT != Zeroes ICL-COMPANY -> GLM-COMPANY ICL-SCRP-ACCT-UNIT -> GLM-ACCT-UNIT ICL-SUSP-ACCOUNT -> GLM-ACCOUNT ICL-SUSP-SUB-ACCT -> GLM-SUB-ACCOUNT Waste Account GLMASTER Not Required ICL-COMPANY -> GLM-COMPANY ICL-WST-ACCT-UNIT -> GLM-ACCT-UNIT ICL-WST-ACCOUNT -> GLM-ACCOUNT ICL-WST-SUB-ACCT -> GLM-SUB-ACCOUNT Wip Account GLMASTER Not Required ICL-COMPANY -> GLM-COMPANY ICL-WIP-ACCT-UNIT -> GLM-ACCT-UNIT ICL-WIP-ACCOUNT -> GLM-ACCOUNT ICL-WIP-SUB-ACCT -> GLM-SUB-ACCOUNT ICLOCATION FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Icbin ICBIN Delete Restricted ICL-COMPANY -> ICB-COMPANY ICL-LOCATION -> ICB-LOCATION ICB-BIN Iccategory ICCATEGORY Delete Restricted ICL-COMPANY -> ICA-COMPANY ICL-LOCATION -> ICA-LOCATION ICA-GL-CATEGORY Iclocgrp ICLOCGRP ICL-COMPANY -> ILG-COMPANY ICL-LOCATION -> ILG-LOCATION ILG-SYSTEM-CD ILG-SEQ Itemloc ITEMLOC Delete Restricted ICL-COMPANY -> ITL-COMPANY ICL-LOCATION -> ITL-LOCATION ITL-ITEM |