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 AR10.1 AR501 AR550 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 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 IC598
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 PO15.1 PO15.2 PO204 PO220 PO223
PO230 PO231 PO233 PO25.2 PO25.4 PO25.6
PO25.7 PO25.8 PO254 PO26.1 PO27.3 PO274
PO275 PO276 PO277 PO280 PO330 PO54.1
PO54.2 PO54.3 PO54.4 PO67.1 PO68.1 PO81.1
PO85.1 PO94.1 POA2.4 POA3.1 POAO.1 POCP.1
POI7.1 POIF.1 POIG.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 RQIA.1 RQIB.1
RQIC.1 RQID.1 RQIG.1 SEA2.1 WH120 WH126
WH131 WH132 WH140 WH21.1 WH21.2 WH21.3
WH21.4 WH210 WH221 WH222 WH224 WH226
WH330 WH38.1 WH520 WH830 IC281
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP32.2 API1.1 API2.1
DR100 IC02.1 IC12.2 IC141 IC142 IC143
IC243 IC26.1 IC26.2 IC262 IC263 IC28.1
IC283 IC330 IC531 IC62.1 IC62.2 IC63.1
IC68.1 IC68.2 IC68.3 IC81.1 IC83.1 IC840
MA180 MA41.2 MA43.2 MA43.9 MA530 MA531
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO228 PO23.1 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO64.1
POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ35.1 RQ500 RQIF.1 TX140
TX40.1 WH02.1 WH110 WH130 WH190 WH20.1
WH20.2 WH20.3 WH20.4 WH20.5 WH20.6 WH20.7
WH220 WH25.1 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH33.2 WH33.3 WH33.4 WH34.1
WH34.2 WH34.3 WH34.4 WH34.5 WH40.1 WH40.2
WH52.1 WH52.2 WH52.3 WH52.4 WH80.1 WH80.3
WH80.4 WH81.1
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) IC02.1 IC81.1
Name This field contains the location's name RQ01.1 RQ810
defined in IC02.1 (Location). WH126 WH131
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 PO30.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 AP125 AP126
Last Batch Number This field is used to assign batch AP131 AP20.1
numbers to the pick list in the AP20.2 AP20.3
Warehouse system. This field is AP20.4 AP20.5
incremented by one every time the pick AP20.7 AP23.1
list program (WH130) is run for this AP25.1 AP25.2
location. AP26.1 AP27.1
AP30.2 AP32.2
API1.1 API2.1
DR100 IC12.2
IC141 IC142
IC243 IC262
IC263 IC28.1
IC330 IC531
IC62.1 IC62.2
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
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 TX140
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) AP125 AP126
Last Bin Transfer This field contains the last date of a AP131 AP20.1
Date bin transfer. This date is used for AP20.2 AP20.3
automatically assigning document numbers AP20.4 AP20.5
in IC26.1 (Detail Transfers) and IC138 AP20.7 AP23.1
(Bin Replenishment Report). AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP32.2
API1.1 API2.1
DR100 IC12.2
IC141 IC142
IC243 IC26.1
IC26.2 IC262
IC263 IC28.1
IC330 IC531
IC62.1 IC62.2
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
...
ICL-LAST-BT-LINE Numeric 6 AP125 AP126
Last Bin Transfer This field contains the last line AP131 AP20.1
Line number used on a bin transfer. This AP20.2 AP20.3
number is used when IC26.1 (Detail AP20.4 AP20.5
Transfers) and IC138 (Bin Replenishment AP20.7 AP23.1
Report) automatically create lines for a AP25.1 AP25.2
document. AP26.1 AP27.1
AP30.2 AP32.2
API1.1 API2.1
DR100 IC12.2
IC141 IC142
IC243 IC26.1
IC26.2 IC262
IC263 IC28.1
IC330 IC531
IC62.1 IC62.2
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
...
ICL-LAST-SHIP-NBR Numeric 10 AP125 AP126
Last Ship Nbr This field is used to determine the AP131 AP20.1
shipment number on the pick list in the AP20.2 AP20.3
Warehouse system. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP32.2
API1.1 API2.1
DR100 IC12.2
IC141 IC142
IC243 IC262
IC263 IC28.1
IC330 IC531
IC62.1 IC62.2
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
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 AP125 AP126
LOCATION AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP32.2
API1.1 API2.1
AR08.1 AR10.1
AR501 AR550
CXCP.1 DR100
DR25.1 DR40.1
DR42.1 IC01.1
IC01.3 IC02.1
...
ICLSET2 COMPANY Subset IC281 IC81.1
LOCATION Where LOCATION-TYPE = "E" IC82.1 IC83.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 WH20.7
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
|
