ICLOCATION

Company Location

The Company Location file stores valid locations within a company. The locations establish the identification of stock locations.

REFERENCED BY
AR08.1 AR10.1 AR501 AR550 ICLC.1 MA54.1
MA54.2 PO04.3 PO15.1 PO15.2 PO15.4 PO204
PO53.1 PO53.2 PO53.3 PO53.4 PO53.8 POI7.1
POIF.1 POIG.1 POIH.1 POIM.1 RQ50.1 MX223


UPDATED BY
AP125 AP126 AP131 AP170 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP510 API1.1 API2.1 EE135 EE35.1
EE35.2 EE520 ICLM.1 MX500 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA540 MAI1.1 PO136 PO190
PO300 PO520 PO64.1 POCP.1 POI3.1 POII.1
POIJ.1 TX140 TX40.1 RQ01.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICL-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AP510
ICL-LOCATION-TYPE
Element: Location Type		Alpha 1
This field specifies whether this location is a normal inventory location or an exchange cart or a par location. This is used in the par location replenishment process.
E = Exchange Cart
P = Par Location
" " = Inventory Location
AP510
ICL-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
AP510
ICL-NAME
Element: Name		Alpha 30 (Lower Case)
This field contains the location's name defined in Location (IC02.1).
AP510 RQ01.1
ICL-REPL-FROM-LOC
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
AP510
ICL-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510
ICL-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510
ICL-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the third line of address information.
AP510
ICL-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the fourth line of address information.
AP510
ICL-CITY-ADDR5
Element: City		Alpha 18 (Lower Case)
This field contains the fifth line and/or the city of the address.
AP510
ICL-STATE-PROV
Element: State Prov		Alpha 2
This field contains the state or province of the address.
AP510
ICL-POSTAL-CODE
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code of the address.
AP510
ICL-COUNTRY
Element: Country		Alpha 30 (Lower Case)
This field contains the country of the address, or it can contain additional information such as an attention name.
AP510
ICL-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
AP510 TX140
ICL-ADDR-CONTACT
Element: Addr Contact		Alpha 30 (Lower Case)
This field contains the name of the main contact.
AP510
ICL-PO-NAME
Element: Name		Alpha 30 (Lower Case)
This field contains the name of the ship to address. This information prints on purchase orders.
AP510
ICL-PO-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of ship-to address. This information prints on purchase orders.
AP510
ICL-PO-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the second line of the ship-to address. This information prints on purchase orders.
AP510
ICL-PO-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the third line of the ship-to address. This information prints on purchase orders.
AP510
ICL-PO-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the fourth line of the ship-to address. This information prints on purchase orders.
AP510
ICL-PO-CITY-ADDR5
Element: City		Alpha 18 (Lower Case)
This field contains the fifth line or city of the ship-to address. This information is printed on purchase orders.
AP510
ICL-PO-STATE-PROV
Element: State Prov		Alpha 2
This field contains the state or province of the ship-to address. This information prints on purchase orders.
AP510
ICL-PO-POSTAL-CD
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code of the ship-to address. This information prints on purchase orders.
AP510
ICL-PO-COUNTRY
Element: Country		Alpha 30 (Lower Case)
This field contains the country of the ship-to address. This information prints on purchase orders.
ICL-PO-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
AP510 TX140
ICL-HIN-NBR
Element: Hin Nbr		Alpha 9
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).
AP510
ICL-OE-RUN-STS
Element: Oe Run Sts		Numeric 1
This field indicates which processing form is currently running or has been run.
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
6 = IC Reorder Running
AP510
ICL-PROCESS-TYPE
Element: Process Type		Alpha 2
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.
AP510
ICL-ALLOC-PURP
Element: Alloc Purp		Alpha 1
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 = Consolidated Bins
S = Speed Picking
AP510
ICL-LAST-BATCH-NBR
Element: Last Batch Nbr		Numeric 8
This field is used to assign batch numbers to the pick list in the Warehouse system. This field is incremented by one every time the pick list program (WH130) is run for this location.
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
PO64.1 POCP.1
POI3.1 POII.1
POIJ.1 TX40.1
ICL-TAX-CODE
Element: Tax Code		Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP510 TX140
ICL-PO-TAX-CODE
Element: Po Tax Code		Alpha 10
AP510 TX140
ICL-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code that will default to a purchase order from the inventory location.
AP510
ICL-LAST-BT-DATE
Element: Last Bt Date		Numeric 8 (yyyymmdd)
This field contains the last date of a bin transfer. This date is used for automatically assigning document numbers in IC26.1 (Detail Transfers) and IC138 (Bin Replenishment Report).
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
PO64.1 POCP.1
POI3.1 POII.1
POIJ.1 TX40.1
ICL-LAST-BT-LINE
Element: Line Nbr		Numeric 6
This field contains the last line number used on a bin transfer. This number is used when IC26.1 (Detail Transfers) and IC138 (Bin Replenishment Report) automatically create lines for a document.
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
PO64.1 POCP.1
POI3.1 POII.1
POIJ.1 TX40.1
ICL-LAST-SHIP-NBR
Element: Shipment Nbr		Numeric 10
This field is used to determine the shipment number on the pick list in the Warehouse system.
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA540 MAI1.1
PO136 PO190
PO300 PO520
PO64.1 POCP.1
POI3.1 POII.1
POIJ.1 TX40.1
ICL-SUSP-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AP510
ICL-SUSP-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP510
ICL-SUSP-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP510
ICL-FRT-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AP510
ICL-FRT-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP510
ICL-FRT-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP510
ICL-HDLG-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AP510
ICL-HDLG-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP510
ICL-HDLG-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP510
ICL-SCRP-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AP510
ICL-SCRP-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP510
ICL-SCRP-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP510
ICL-HOLD-ACCT-UNIT
Element: Hold Acct Unit		Alpha 15
AP510
ICL-HOLD-ACCOUNT
Element: Hold Account		Numeric 6
AP510
ICL-HOLD-SUB-ACCT
Element: Hold Sub Acct		Numeric 4
AP510
ICL-ERS-CAPABLE
Element: All Flag		Alpha 1

Y = Yes
N = No
AP510
ICL-PAR-VALUE
Element: Intl Amt		Signed 18.2
The value of the inventory stored at the par location.
AP510
ICL-WST-ACCT-UNIT
Element: Acct Unit		Alpha 15
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.
AP510
ICL-WST-ACCOUNT
Element: Account		Numeric 6
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.
AP510
ICL-WST-SUB-ACCT
Element: Sub Acct		Numeric 4
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.
AP510
ICL-WO-LOC-TYPE
Element: Wo Loc Type		Alpha 1

N = Not a Work Order Location
O = Offsite Location
P = Production Location
AP510
ICL-CALENDAR
Element: Calendar		Alpha 15
This is the name of the calendar used in the production scheduling process for work orders.
AP510
ICL-DEMAND-SOURCE
Element: Demand Source		Numeric 1
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
AP510
ICL-WIP-ACCT-UNIT
Element: Acct Unit		Alpha 15
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.
AP510
ICL-WIP-ACCOUNT
Element: Account		Numeric 6
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.
AP510
ICL-WIP-SUB-ACCT
Element: Sub Acct		Numeric 4
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.
AP510
ICL-FGV-ACCT-UNIT
Element: Acct Unit		Alpha 15
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.
AP510
ICL-FGV-ACCOUNT
Element: Account		Numeric 6
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.
AP510
ICL-FGV-SUB-ACCT
Element: Sub Acct		Numeric 4
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.
AP510
ICL-CAPACITY
Element: Capacity		Numeric 8
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.
AP510
ICL-SCHED-INCR
Element: Sched Incr		Numeric 2
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.
AP510
ICL-SCHED-FREQ
Element: Sched Freq		Alpha 1
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
AP510
ICL-WO-STATUS
Element: Wo Status		Numeric 1
This is the work order status to default to the status for the build process of the work order production scheduling process.
1 = Unreleased
2 = Released
3 = Exploded
4 = In Production
AP510
ICL-WO-ACCOUNT-FL
Element: Wo Account Fl		Alpha 1
This indicates if you are using income statement accounts in Production Order.
Y = Yes
N = No
" " = No
AP510
ICL-WO-IN-PROD-FL
Element: Wo In Prod Fl		Alpha 1

Y = In prod unrestricted by alloc
N = In prod restricted by alloc
O = No - but override allowed
AP510
ICL-PROCESS-LEVEL
Element: Process Level		Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP510
ICL-PRINT-LABELS
Element: Print Labels		Alpha 1
AP510
ICL-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP510
ICL-PURCH-FR-LOC
Element: Purch Fr Loc		Alpha 4
The vendor's purchase from location.
AP510
ICL-CUSTOMER
Element: Customer		Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AP510
ICL-SHIP-TO
Element: Ship To		Numeric 4
This field contains the number representing the ship to customer.
AP510
ICL-PROC-DAYS
Element: Proc Days		Numeric 3
AP510
ICL-REC-ALLOCATE
Element: Rec Allocate		Numeric 1
This field is used to determine if receiving allocation should be attempted and which method to use. Valid values are: 0 - No Receiving Allocation (default) 1 - PO Line Source Alloocation 2 - PO Line Source & Std Allocation
0 = No Receiving Allocation
1 = PO LIne Source Allocation
2 = PO Line Source & Std Allocatio
AP510
ICL-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP510
ICL-REGION
Element: Region		Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
AP510
ICL-PO-COUNTRY-CD
Element: Po Country Cd		Alpha 2
The PO country code. Required for VAT and Intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP510
ICL-PO-REGION
Element: Po Region		Alpha 2
The PO region code, if applicable for the country. Used only by Intrastat. Must be a valid region code for the country, defined in IN02.1 (Region Maintenance).
AP510
ICL-ISS-AU-FL
Element: Iss Au Fl		Alpha 1
This flag is used in the issue acct dflt routine to determine if this location wants the Account Unit defaulted on issues from the "From" location.
N
Y
AP510
ICL-POB-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
AP510
ICL-POB-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510
ICL-POB-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510
ICL-POB-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510
ICL-POB-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510
ICL-POB-CITY-ADDR5
Element: City		Alpha 18 (Lower Case)
This field contains the city of the address.
AP510
ICL-POB-STATE-PROV
Element: State Prov		Alpha 2
The state or province.
AP510
ICL-POB-POSTAL-CD
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code.
AP510
ICL-POB-COUNTRY-CD
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP510
ICL-POB-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
AP510
ICL-POB-CONTACT
Element: Addr Contact		Alpha 30 (Lower Case)
This is the name of the main contact.
AP510
ICL-GLN-NBR
Element: Gln Nbr		Alpha 13
AP510
ICL-REPL-REQUESTER
Element: Requester		Alpha 10 (Lower Case)
This is the person who requested this requisition.
AP510
ICL-RETAIL-LOC-FL
Element: Retail Loc Fl		Alpha 1

" " = None
S = Store
W = Warehouse
AP510
ICL-ICL-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AP510 ICLM.1
MX500
ICL-ONE-SRC-ONE-PO
Element: One Src One Po		Numeric 1

0 = No
1 = One Requisition to One PO
2 = One Sales Order to One PO
3 = Req and Sales Order to One PO
AP510
ICL-DROPSHIP-FL
Element: All Flag		Alpha 1
AP510
ICL-POB-PHONE-PREF
Element: Phone Prefix		Alpha 6
AP510
ICL-POB-PHONE
Element: Phone		Alpha 15
AP510
ICL-POB-PHONE-EXT
Element: Phone Ext		Alpha 5
AP510
ICL-POB-EMAIL-ADDR
Element: Email Address		Alpha 60 (Lower Case)
AP510
ICL-STATUS
Element: Status		Numeric 1

0 = Active
1 = Inactive
2 = Add Inactive
AP510
ICL-EAM-LOC-FL
Element: Retail Loc Fl		Alpha 1

" " = Not an EAM Location
1 = EAM Location
AP510


ICLOCATION FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICLSET1 COMPANY
LOCATION
...
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP510 API1.1
API2.1 AR08.1
AR10.1 AR501
AR550 EE135
EE35.1 EE35.2
ICLSET2 COMPANY
LOCATION
Subset
WhereLOCATION-TYPE ="E"
OrLOCATION-TYPE ="P"
ICLSET3 COMPANY
LOCATION
Subset
WhereWO-LOC-TYPE !="N"
ICLSET4 VENDOR
PURCH-FR-LOC
COMPANY
LOCATION
KeyChange, Subset
WhereVENDOR !=Spaces
ICLSET5 CUSTOMER
SHIP-TO
COMPANY
LOCATION
KeyChange, Subset
WhereCUSTOMER !=Spaces
ICLSET6 ICL-OBJ-ID
KeyChange, Subset
WhereICL-OBJ-ID !=Zeroes
ICLM.1 MX223
MX500


ICLOCATION FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
OrICL-FRT-ACCOUNT !=Zeroes
OrICL-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
Glnloc GLNLOC Not Required
Valid When ICL-GLN-NBR !=Spaces
ICC-ITEM-GROUP->GLO-ITEM-GROUP
ICL-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When ICL-GLN-NBR !=Spaces
ICC-ITEM-GROUP->GLX-ITEM-GROUP
3->GLX-GLN-TYPE
ICL-COMPANY->GLX-COMPANY
ICL-LOCATION->GLX-LOCATION
Spaces->GLX-BIN
ICL-GLN-NBR->GLX-GLN-NBR
Hdlg Account GLMASTER Required
When ICL-HDLG-ACCT-UNIT !=Spaces
OrICL-HDLG-ACCOUNT !=Zeroes
OrICL-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
OrICL-SCRP-ACCOUNT !=Zeroes
OrICL-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
OrICL-SUSP-ACCOUNT !=Zeroes
OrICL-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
NAME		 RELATED 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

File created: Wed Jun 08 20:49:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.