ICLOCATION FILE
Company Location
The Company Location file stores valid locations within a company. The
locations establish the identification of stock locations.
REFERENCED BY
AR08.1 AR501 AR550 BL01.1 BL02.1 BL140
BL141 BL201 BL202 BL208 BL240 BL241
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 BL802 BL85.1 BL85.2
BL90.1 CXCP.1 DR25.1 DR40.1 DR42.1 IC01.1
IC01.3 IC03.1 IC04.1 IC10.1 IC10.2 IC110
IC120 IC125 IC130 IC134 IC135 IC138
IC140 IC145 IC15.1 IC15.2 IC15.3 IC150
IC151 IC152 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 IC320
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 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 ICLC.1 PC120 PC20.1 PC540 MA278
MA53.1 MA54.1 PHI3.1 PO04.3 PO120 PO130
PO132 PO133 PO134 PO135 PO204 PO220
PO223 PO224 PO230 PO231 PO233 PO26.1
PO274 PO275 PO276 PO277 PO280 PO61.1
PO62.1 PO63.1 PO67.1 PO68.1 PO81.1 PO85.1
PO94.1 POA2.4 POA3.1 POAO.1 POCP.1 POI7.1
POIF.1 POIT.1 RQ01.1 RQ111 RQ12.1 RQ13.1
RQ140 RQ201 RQ230 RQ235 RQ300 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ50.1 RQ510
RQ513 RQ810 SEA2.1 WH120 WH126 WH131
WH140 WH21.1 WH21.2 WH21.3 WH21.4 WH210
WH220 WH221 WH224 WH226 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH330 IC281
UPDATED BY
AP30.2 AP32.2 API1.1 API2.1 DR100 IC02.1
IC12.2 IC141 IC142 IC143 IC243 IC26.1
IC26.2 IC262 IC263 IC283 IC330 IC531
IC62.1 IC62.2 IC63.1 IC68.1 IC68.2 IC68.3
IC81.1 IC83.1 IC840 MA65.1 PO228 PO64.1
POIJ.1 RQ11.1 TX140 TX40.1 WH02.1 WH110
WH130 WH34.1 WH34.2 WH34.3 WH34.4 WH34.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICL-COMPANY Numeric 4 IC02.1 IC81.1
Company The company number represents an IC840
established company and is entered on
all function codes.
ICL-LOCATION-TYPE Alpha 1 IC81.1 IC840
Location Type 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
ICL-LOCATION Alpha 5 IC02.1 IC138
Location Code This field contains a valid stocking IC81.1 IC840
location within the company inventory.
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
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
Location the location gets replenished. This is
used in the par cart replenishment
process.
ICL-ADDR1 Alpha 30 (Lower Case) IC02.1 WH126
Address 1 This field contains the first line of WH224
address information.
ICL-ADDR2 Alpha 30 (Lower Case) IC02.1 WH126
Address 2 This field contains the second line of WH224
address information.
ICL-ADDR3 Alpha 30 (Lower Case) IC02.1 WH126
Address 3 This field contains the third line of WH224
address information.
ICL-ADDR4 Alpha 30 (Lower Case) IC02.1 WH126
Address 4 This field contains the fourth line of WH224
address information.
ICL-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1 WH126
City or Address 5 This field contains the fifth line WH224
and/or the city of the address.
ICL-STATE-PROV Alpha 2 IC02.1 WH126
State or Province This field contains the state or WH224
province of the address.
ICL-POSTAL-CODE Alpha 10 (Lower Case) IC02.1 WH126
Postal Code This field contains the postal code of WH224
the address.
ICL-COUNTRY Alpha 30 (Lower Case) IC02.1 WH126
Country or Other This field contains the country of the WH224
address, or it can contain additional
information such as an attention name.
ICL-COUNTY Alpha 25 (Lower Case) IC02.1 TX140
County The county for the company address.
ICL-ADDR-CONTACT Alpha 30 (Lower Case) IC02.1
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 PO63.1
ship to address. This information prints
on purchase orders.
ICL-PO-ADDR1 Alpha 30 (Lower Case) IC02.1
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
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
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
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
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
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
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
Purchase Order This field contains the country of the
Country ship-to address. This information prints
on purchase orders.
ICL-PO-COUNTY Alpha 25 (Lower Case) IC02.1
Po County
ICL-HIN-NBR Alpha 9 IC02.1
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 DR100 IC141
Order Entry Run This field indicates which processing IC142 IC143
Status form is currently running or has been WH110 WH130
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
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
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 = Consolidated Bins
S = Speed Picking
ICL-LAST-BATCH-NBR Numeric 8 AP30.2 AP32.2
Last Batch Number This field is used to assign batch API1.1 API2.1
numbers to the pick list in the DR100 IC12.2
Warehouse system. This field is IC141 IC142
incremented by one every time the pick IC243 IC262
list program (WH130) is run for this IC263 IC330
location. IC531 IC62.1
IC62.2 IC63.1
IC68.1 IC68.2
IC68.3 IC83.1
MA65.1 PO228
PO64.1 POIJ.1
RQ11.1 TX40.1
WH02.1 WH130
WH34.1 WH34.2
WH34.3 WH34.4
WH34.5
ICL-TAX-CODE Alpha 10 IC02.1 TX140
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
ICL-PO-TAX-CODE Alpha 10 IC02.1
Po Tax Code
ICL-PO-CODE Alpha 4 IC02.1
Po Code This is the purchase order code that
will default to a purchase order from
the inventory location.
ICL-LAST-BT-DATE Numeric 8 (yyyymmdd) AP30.2 AP32.2
Last Bin Transfer This field contains the last date of a API1.1 API2.1
Date bin transfer. This date is used for DR100 IC12.2
automatically assigning document numbers IC141 IC142
in IC26.1 (Detail Transfers) and IC138 IC243 IC26.1
(Bin Replenishment Report). IC26.2 IC262
IC263 IC330
IC531 IC62.1
IC62.2 IC63.1
IC68.1 IC68.2
IC68.3 IC83.1
MA65.1 PO228
PO64.1 POIJ.1
RQ11.1 TX40.1
WH02.1 WH34.1
WH34.2 WH34.3
WH34.4 WH34.5
ICL-LAST-BT-LINE Numeric 6 AP30.2 AP32.2
Last Bin Transfer This field contains the last line API1.1 API2.1
Line number used on a bin transfer. This DR100 IC12.2
number is used when IC26.1 (Detail IC141 IC142
Transfers) and IC138 (Bin Replenishment IC243 IC26.1
Report) automatically create lines for a IC26.2 IC262
document. IC263 IC330
IC531 IC62.1
IC62.2 IC63.1
IC68.1 IC68.2
IC68.3 IC83.1
MA65.1 PO228
PO64.1 POIJ.1
RQ11.1 TX40.1
WH02.1 WH34.1
WH34.2 WH34.3
WH34.4 WH34.5
ICL-LAST-SHIP-NBR Numeric 10 AP30.2 AP32.2
Last Ship Nbr This field is used to determine the API1.1 API2.1
shipment number on the pick list in the DR100 IC12.2
Warehouse system. IC141 IC142
IC243 IC262
IC263 IC330
IC531 IC62.1
IC62.2 IC63.1
IC68.1 IC68.2
IC68.3 IC83.1
MA65.1 PO228
PO64.1 POIJ.1
RQ11.1 TX40.1
WH02.1 WH130
WH34.1 WH34.2
WH34.3 WH34.4
WH34.5
ICL-SUSP-ACCT-UNIT Alpha 15 IC02.1
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
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
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
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
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
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
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
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
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
Scrap Accounting This is the accounting unit that will
Unit be posted to the general ledger for this
location when items rejected 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
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
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-HOLD-ACCT-UNIT Alpha 15 IC02.1
Hold Acct Unit
ICL-HOLD-ACCOUNT Numeric 6 IC02.1
Hold Account
ICL-HOLD-SUB-ACCT Numeric 4 IC02.1
Hold Sub Acct
ICL-ERS-CAPABLE Alpha 1 IC02.1
ERS Capable Indicates whether the vendor location
can process Evaluated Receipt Settlement
(ERS).
Y = Yes
N = No
ICL-PAR-VALUE Signed 13.2 IC283
Par Value The value of the inventory stored at
the par location.
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-WO-LOC-TYPE Alpha 1 IC02.1
Wo Loc Type N = Not a Work Order Location
O = Offsite Location
P = Production Location
ICL-CALENDAR Alpha 15 IC02.1
Calendar This is the name of the calendar used
in the production scheduling process for
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-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-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 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
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
N = No
" " = No
ICL-WO-IN-PROD-FL Alpha 1 IC02.1
Wo In Prod Fl Y = In prod unrestricted by alloc
N = In prod restricted by alloc
O = No - but override allowed
ICL-PROCESS-LEVEL Alpha 5 IC02.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
ICL-PRINT-LABELS Alpha 1 IC02.1
Print Labels
ICL-VENDOR Alpha 9 (Right Justified) IC02.1
Vendor ID The vendor's identification code.
ICL-PURCH-FR-LOC Alpha 4 IC02.1
Purchase From The vendor's purchase from location.
Location Code
ICL-CUSTOMER Alpha 9 (Right Justified) IC02.1
Customer Number This field contains the number that
represents a customer.
ICL-SHIP-TO Numeric 4 IC02.1
Ship-to Code This field contains the number
representing the ship to customer.
ICL-PROC-DAYS Numeric 3 IC02.1
Proc Days
ICL-REC-ALLOCATE Numeric 1 IC02.1
Rec Allocate 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
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 by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
ICL-PO-COUNTRY-CD Alpha 2 IC02.1
Po Country Cd The PO country code. Required for VAT
and Intrastat reporting. Must be
defined in IN01.1 (Country Maintenance).
ICL-PO-REGION Alpha 2 IC02.1
Po Region 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).
ICLOCATION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICLSET1 COMPANY AP30.2 AP32.2
LOCATION API1.1 API2.1
AR08.1 AR501
AR550 BL01.1
BL02.1 BL140
BL141 BL201
BL202 BL208
BL240 BL241
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
...
ICLSET2 COMPANY Subset IC281 IC81.1
LOCATION Where LOCATION-TYPE = "E" IC82.1
Or LOCATION-TYPE = "P"
ICLSET3 COMPANY Subset IC01.1
LOCATION Where WO-LOC-TYPE != "N"
ICLSET4 VENDOR KeyChange, Subset IC02.1
PURCH-FR-LOC Where VENDOR != Spaces
COMPANY
LOCATION
ICLSET5 CUSTOMER KeyChange, Subset IC02.1
SHIP-TO Where CUSTOMER != Spaces
COMPANY
LOCATION
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
|
