|
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 AR120 AR501 AR550 BL00.1
BL01.1 BL02.1 BL140 BL141 BL201 BL202
BL208 BL240 BL241 BL248 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
IC01.1 IC01.3 IC03.1 IC04.1 IC130 IC15.1
IC15.2 IC15.3 IC202 IC203 IC204 IC211
IC215 IC320 IC812 IC850 IC851 ICLC.1
MA278 MA53.1 MA54.1 MA54.2 MA91.1 PO04.3
PO115 PO120 PO130 PO132 PO133 PO134
PO135 PO15.1 PO15.2 PO16.1 PO190 PO204
PO220 PO223 PO230 PO231 PO233 PO234
PO254 PO258 PO26.1 PO274 PO275 PO276
PO277 PO280 PO285 PO330 PO53.1 PO53.2
PO53.3 PO53.4 PO53.8 PO54.1 PO54.2 PO54.3
PO54.4 PO58.1 PO58.2 PO63.1 PO67.1 PO81.1
PO94.1 POA2.4 POA3.1 POAO.1 POCP.1 POI7.1
POIE.1 POIF.1 POIG.1 POIH.1 POIM.1 POIT.1
RQ01.1 RQ01.3 RQ111 RQ140 RQ201 RQ230
RQ235 RQ240 RQ41.1 RQ50.1 RQ510 RQ513
RQ810 RQD0.1 RQD1.1 RQIA.1 RQIB.1 RQIC.1
RQID.1 RQIG.1 RQIH.1 RQII.1 RQIJ.1 WH120
WH126 WH131 WH132 WH140 WH21.1 WH21.2
WH21.3 WH21.4 WH210 WH221 WH222 WH330
WH38.1 WH420 WH422 WH423 WH520 WH830
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 API1.1 API2.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 EE135 EE35.1 EE35.2
EE520 IC02.1 IC12.2 IC330 ICLM.1 MX500
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO228 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO64.1 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ12.1 RQ13.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 WH224 WH226 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 WH440 WH52.1 WH52.2
WH52.3 WH52.4 WH80.1 WH80.3 WH80.4 WH81.1
WH82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICL-COMPANY Numeric 4 IC02.1
Element: Company 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.
ICL-LOCATION-TYPE Alpha 1 IC02.1
Element: 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
Element: Location This field contains a valid stocking
location within the company inventory.
ICL-NAME Alpha 30 (Lower Case) BL02.1 BL140
Element: Name This field contains the location's name BL141 BL240
defined in Location (IC02.1). BL241 BL340
BL341 BL41.1
BL42.1 BL48.1
IC02.1 RQ01.1
RQ810 WH126
WH131 WH221
WH226
ICL-REPL-FROM-LOC Alpha 5 IC02.1
Element: Location This field contains a valid stocking
location within the company inventory.
ICL-ADDR1 Alpha 30 (Lower Case) IC02.1 WH126
Element: Addr1 This field contains the first line of
address information.
ICL-ADDR2 Alpha 30 (Lower Case) IC02.1 WH126
Element: Addr1 This field contains the first line of
address information.
ICL-ADDR3 Alpha 30 (Lower Case) IC02.1 WH126
Element: Addr1 This field contains the third line of
address information.
ICL-ADDR4 Alpha 30 (Lower Case) IC02.1 WH126
Element: Addr1 This field contains the fourth line of
address information.
ICL-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1 WH126
Element: City This field contains the fifth line
and/or the city of the address.
ICL-STATE-PROV Alpha 2 IC02.1 WH126
Element: State Prov This field contains the state or
province of the address.
ICL-POSTAL-CODE Alpha 10 (Lower Case) IC02.1 WH126
Element: Postal Code This field contains the postal code of
the address.
ICL-COUNTRY Alpha 30 (Lower Case) IC02.1 WH126
Element: Country This field contains the country of the
address, or it can contain additional
information such as an attention name.
ICL-COUNTY Alpha 25 (Lower Case) IC02.1 TX140
Element: County The county for the company address.
ICL-ADDR-CONTACT Alpha 30 (Lower Case) IC02.1
Element: Addr Contact This field contains the name of the
main contact.
ICL-PO-NAME Alpha 30 (Lower Case) IC02.1 PO30.1
Element: 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
Element: Addr1 This field contains the first line of
ship-to address. This information prints
on purchase orders.
ICL-PO-ADDR2 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the second line of
the ship-to address. This information
prints on purchase orders.
ICL-PO-ADDR3 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the third line of
the ship-to address. This information
prints on purchase orders.
ICL-PO-ADDR4 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the fourth line of
the ship-to address. This information
prints on purchase orders.
ICL-PO-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1
Element: City This field contains the fifth line or
city of the ship-to address. This
information is printed on purchase
orders.
ICL-PO-STATE-PROV Alpha 2 IC02.1
Element: State Prov This field contains the state or
province of the ship-to address. This
information prints on purchase orders.
ICL-PO-POSTAL-CD Alpha 10 (Lower Case) IC02.1
Element: Postal Code This field contains the postal code of
the ship-to address. This information
prints on purchase orders.
ICL-PO-COUNTRY Alpha 30 (Lower Case)
Element: Country This field contains the country of the
ship-to address. This information prints
on purchase orders.
ICL-PO-COUNTY Alpha 25 (Lower Case) IC02.1 TX140
Element: County The county for the company address.
ICL-HIN-NBR Alpha 9 IC02.1
Element: 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 IC02.1 WH110
Element: Oe Run Sts This field indicates which processing WH130
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
ICL-PROCESS-TYPE Alpha 2 IC02.1
Element: 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
Element: Alloc Purp 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
Element: Last Batch NbrThis field is used to assign batch AP131 AP170
numbers to the pick list in the AP193 AP20.1
Warehouse system. This field is AP20.2 AP20.3
incremented by one every time the pick AP20.4 AP20.5
list program (WH130) is run for this AP20.7 AP21.1
location. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC330
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.2
...
ICL-TAX-CODE Alpha 10 IC02.1 TX140
Element: 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
Element: Po Tax Code
ICL-PO-CODE Alpha 4 IC02.1
Element: 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
Element: Last Bt Date This field contains the last date of a AP131 AP170
bin transfer. This date is used for AP193 AP20.1
automatically assigning document numbers AP20.2 AP20.3
in IC26.1 (Detail Transfers) and IC138 AP20.4 AP20.5
(Bin Replenishment Report). AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC330
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.2
...
ICL-LAST-BT-LINE Numeric 6 AP125 AP126
Element: Line Nbr This field contains the last line AP131 AP170
number used on a bin transfer. This AP193 AP20.1
number is used when IC26.1 (Detail AP20.2 AP20.3
Transfers) and IC138 (Bin Replenishment AP20.4 AP20.5
Report) automatically create lines for a AP20.7 AP21.1
document. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC330
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.2
...
ICL-LAST-SHIP-NBR Numeric 10 AP125 AP126
Element: Shipment Nbr This field is used to determine the AP131 AP170
shipment number on the pick list in the AP193 AP20.1
Warehouse system. 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 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 EE135
EE35.1 EE35.2
EE520 IC02.1
IC12.2 IC330
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.2
...
ICL-SUSP-ACCT-UNIT Alpha 15 IC02.1
Element: Acct Unit 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.
ICL-SUSP-ACCOUNT Numeric 6 IC02.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ICL-SUSP-SUB-ACCT Numeric 4 IC02.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ICL-FRT-ACCT-UNIT Alpha 15 IC02.1
Element: Acct Unit 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.
ICL-FRT-ACCOUNT Numeric 6 IC02.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ICL-FRT-SUB-ACCT Numeric 4 IC02.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ICL-HDLG-ACCT-UNIT Alpha 15 IC02.1
Element: Acct Unit 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.
ICL-HDLG-ACCOUNT Numeric 6 IC02.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ICL-HDLG-SUB-ACCT Numeric 4 IC02.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ICL-SCRP-ACCT-UNIT Alpha 15 IC02.1
Element: Acct Unit 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.
ICL-SCRP-ACCOUNT Numeric 6 IC02.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ICL-SCRP-SUB-ACCT Numeric 4 IC02.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ICL-HOLD-ACCT-UNIT Alpha 15 IC02.1
Element: Hold Acct Unit
ICL-HOLD-ACCOUNT Numeric 6 IC02.1
Element: Hold Account
ICL-HOLD-SUB-ACCT Numeric 4 IC02.1
Element: Hold Sub Acct
ICL-ERS-CAPABLE Alpha 1 IC02.1
Element: All Flag Y = Yes
N = No
ICL-PAR-VALUE Signed 18.2 IC02.1
Element: Intl Amt The value of the inventory stored at
the par location.
ICL-WST-ACCT-UNIT Alpha 15 IC02.1
Element: 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
Element: 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
Element: 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
Element: Wo Loc Type N = Not a Work Order Location
O = Offsite Location
P = Production Location
ICL-CALENDAR Alpha 15 IC02.1
Element: Calendar This is the name of the calendar used
in the production scheduling process for
work orders.
ICL-DEMAND-SOURCE Numeric 1 IC02.1
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Wo Account Fl This indicates if you are using income
statement accounts in Production Order.
Y = Yes
N = No
" " = No
ICL-WO-IN-PROD-FL Alpha 1 IC02.1
Element: 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
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
ICL-PRINT-LABELS Alpha 1 IC02.1
Element: Print Labels
ICL-VENDOR Alpha 9 (Right Justified) IC02.1
Element: Vendor The vendor's identification code.
ICL-PURCH-FR-LOC Alpha 4 IC02.1
Element: Purch Fr Loc The vendor's purchase from location.
ICL-CUSTOMER Alpha 9 (Right Justified) IC02.1
Element: Customer This field contains the number that
represents a customer.
ICL-SHIP-TO Numeric 4 IC02.1
Element: Ship To This field contains the number
representing the ship to customer.
ICL-PROC-DAYS Numeric 3 IC02.1
Element: Proc Days
ICL-REC-ALLOCATE Numeric 1 IC02.1
Element: 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
Element: 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
Element: Region 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
Element: 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
Element: 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).
ICL-ISS-AU-FL Alpha 1 IC02.1
Element: Iss Au Fl 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
ICL-POB-NAME Alpha 30 (Lower Case) IC02.1
Element: Name Displays the company description.
ICL-POB-ADDR1 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the first line of
address information.
ICL-POB-ADDR2 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the first line of
address information.
ICL-POB-ADDR3 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the first line of
address information.
ICL-POB-ADDR4 Alpha 30 (Lower Case) IC02.1
Element: Addr1 This field contains the first line of
address information.
ICL-POB-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1
Element: City This field contains the city of the
address.
ICL-POB-STATE-PROV Alpha 2 IC02.1
Element: State Prov The state or province.
ICL-POB-POSTAL-CD Alpha 10 (Lower Case) IC02.1
Element: Postal Code This field contains the postal code.
ICL-POB-COUNTRY-CD Alpha 2 IC02.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
ICL-POB-COUNTY Alpha 25 (Lower Case) IC02.1
Element: County The county for the company address.
ICL-POB-CONTACT Alpha 30 (Lower Case) IC02.1
Element: Addr Contact This is the name of the main contact.
ICL-GLN-NBR Alpha 13 IC02.1
Element: Gln Nbr
ICL-REPL-REQUESTER Alpha 10 (Lower Case) IC02.1
Element: Requester This is the person who requested this
requisition.
ICL-RETAIL-LOC-FL Alpha 1 IC02.1
Element: Retail Loc Fl " " = None
S = Store
W = Warehouse
ICL-ICL-OBJ-ID Numeric 12 IC02.1 ICLM.1
Element: Obj Id This is the object identifier. It is MX500
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.
ICL-ONE-SRC-ONE-PO Numeric 1 IC02.1
Element: One Src One Po0 = No
1 = One Requisition to One PO
2 = One Sales Order to One PO
3 = Req and Sales Order to One PO
ICL-DROPSHIP-FL Alpha 1 IC02.1
Element: All Flag
ICLOCATION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICLSET1 COMPANY AP125 AP126
LOCATION 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
API1.1 API2.1
AR08.1 AR10.1
AR120 AR501
AR550 BL00.1
BL01.1 BL02.1
...
ICLSET2 COMPANY Subset
LOCATION Where LOCATION-TYPE = "E"
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 BL120 BL122
SHIP-TO Where CUSTOMER != Spaces BL130 BL20.1
COMPANY BL20.3 BL21.2
LOCATION BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC02.1 WH20.7
ICLSET6 ICL-OBJ-ID KeyChange, Subset IC02.5 IC02.6
Where ICL-OBJ-ID != Zeroes ICLM.1 MX223
MX500
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
|