|
|
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 BL00.1 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 IC153 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
IC235 IC237 IC238 IC239 IC24.1 IC24.2
IC241 IC242 IC244 IC25.1 IC260 IC27.1
IC270 IC280 IC282 IC284 IC286 IC287
IC29.1 IC29.2 IC29.3 IC295 IC31.1 IC320
IC33.1 IC331 IC34.1 IC36.1 IC37.1 IC38.1
IC41.1 IC42.1 IC42.2 IC42.3 IC42.4 IC43.1
IC44.1 IC45.1 IC46.1 IC46.2 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 IC55.1
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 OE112
OE16.1 OE229 OE260 OE270 OE271 OE287
OE53.1 OE60.1 OE86.1 PO04.3 PO115 PO120
PO130 PO132 PO133 PO134 PO135 PO15.1
PO15.2 PO204 PO220 PO223 PO230 PO231
PO233 PO25.1 PO25.3 PO25.5 PO25.6 PO25.7
PO254 PO258 PO26.1 PO27.2 PO274 PO275
PO276 PO277 PO280 PO285 PO330 PO36.1
PO36.2 PO53.1 PO53.2 PO53.3 PO53.4 PO53.8
PO536 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 POID.1 POIF.1
POIG.1 POIH.1 POIM.1 POIT.1 RQ01.1 RQ111
RQ12.1 RQ13.1 RQ13.2 RQ140 RQ201 RQ230
RQ235 RQ240 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 RQIH.1
RQII.1 RQIJ.1 SA04.1 SA80.3 SA90.3 SALO.1
WH120 WH126 WH131 WH132 WH140 WH21.1
WH21.2 WH21.3 WH21.4 WH210 WH221 WH222
WH224 WH226 WH330 WH38.1 WH520 WH830
WOOR.1 IC281
UPDATED BY
AP125 AP126 AP131 AP170 AP193 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 DR100
IC02.1 IC12.2 IC141 IC142 IC143 IC243
IC26.1 IC26.2 IC262 IC263 IC28.1 IC283
IC330 IC531 IC62.1 IC62.2 IC62.4 IC63.1
IC68.1 IC68.2 IC68.3 IC81.1 IC83.1 IC840
MA180 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA65.1 MA66.2 MA66.3 MA67.1
MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.4 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE56.1 OE80.1 OE81.1
OE81.3 OE810 OE830 OE85.2 OE88.1 OE90.1
OE90.2 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 WO10.1 WO120
WO130 WO131 WO132 WO133 WO140 WO20.1
WO20.2 WO215 WO220 WO232 WO235 WO250
WO251 WO252 WO255 WO256 WO280 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 IC02.1 IC81.1
Element: Company Identifies the AP company if the IC840
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 IC81.1 IC840
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 IC138
Element: 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
Element: 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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE114
OE30.1 OE30.3
OE53.1 RQ01.1
RQ810 WH126
WH131 WH221
WH224 WH226
ICL-REPL-FROM-LOC Alpha 5 IC81.1 IC840
Element: Location Code This is the default location from which
the location gets replenished. This is
used in the par cart replenishment
process.
ICL-ADDR1 Alpha 30 (Lower Case) IC02.1 OE114
Element: Address 1 This field contains the first line of WH126 WH224
address information.
ICL-ADDR2 Alpha 30 (Lower Case) IC02.1 OE114
Element: Address 1 This field contains the second line of WH126 WH224
address information.
ICL-ADDR3 Alpha 30 (Lower Case) IC02.1 OE114
Element: Address 1 This field contains the third line of WH126 WH224
address information.
ICL-ADDR4 Alpha 30 (Lower Case) IC02.1 OE114
Element: Address 1 This field contains the fourth line of WH126 WH224
address information.
ICL-CITY-ADDR5 Alpha 18 (Lower Case) IC02.1 OE114
Element: City This field contains the fifth line WH126 WH224
and/or the city of the address.
ICL-STATE-PROV Alpha 2 IC02.1 OE114
Element: State or ProviThis field contains the state or WH126 WH224
province of the address.
ICL-POSTAL-CODE Alpha 10 (Lower Case) IC02.1 OE114
Element: Postal Code This field contains the postal code of WH126 WH224
the address.
ICL-COUNTRY Alpha 30 (Lower Case) IC02.1 OE114
Element: Country or OthThis field contains the country of the WH126 WH224
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: Contact This field contains the name of the
main contact.
ICL-PO-NAME Alpha 30 (Lower Case) IC02.1 IC81.1
Element: Name This field contains the name of the PO30.1 PO63.1
ship to address. This information prints
on purchase orders.
ICL-PO-ADDR1 Alpha 30 (Lower Case) IC02.1
Element: Address 1 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: Address 1 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: Address 1 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: Address 1 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 or ProviThis 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) IC02.1
Element: Country or OthThis 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
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 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
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: Allocation PurThis 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 NumThis field is used to assign batch AP131 AP170
numbers to the pick list in the AP193 AP25.1
Warehouse system. This field is AP25.2 AP26.1
incremented by one every time the pick AP27.1 AP30.2
list program (WH130) is run for this AP30.4 API1.1
location. API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
EE135 EE35.1
EE35.2 EE520
IC12.2 IC141
IC142 IC243
IC262 IC263
IC28.1 IC330
IC531 IC62.1
IC62.2 IC62.4
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 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
Last Bin Transfer This field contains the last date of a AP131 AP170
Date bin transfer. This date is used for AP193 AP25.1
automatically assigning document numbers AP25.2 AP26.1
in IC26.1 (Detail Transfers) and IC138 AP27.1 AP30.2
(Bin Replenishment Report). 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 DR100
EE135 EE35.1
EE35.2 EE520
IC12.2 IC141
IC142 IC243
IC26.1 IC26.2
IC262 IC263
IC28.1 IC330
IC531 IC62.1
IC62.2 IC62.4
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
...
ICL-LAST-BT-LINE Numeric 6 AP125 AP126
Element: Line Number This field contains the last line AP131 AP170
number used on a bin transfer. This AP193 AP25.1
number is used when IC26.1 (Detail AP25.2 AP26.1
Transfers) and IC138 (Bin Replenishment AP27.1 AP30.2
Report) automatically create lines for a AP30.4 API1.1
document. API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
EE135 EE35.1
EE35.2 EE520
IC12.2 IC141
IC142 IC243
IC26.1 IC26.2
IC262 IC263
IC28.1 IC330
IC531 IC62.1
IC62.2 IC62.4
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
...
ICL-LAST-SHIP-NBR Numeric 10 AP125 AP126
Element: Shipment NumbeThis field is used to determine the AP131 AP170
shipment number on the pick list in the AP193 AP25.1
Warehouse system. 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 DR100
EE135 EE35.1
EE35.2 EE520
IC12.2 IC141
IC142 IC243
IC262 IC263
IC28.1 IC330
IC531 IC62.1
IC62.2 IC62.4
IC63.1 IC68.1
IC68.2 IC68.3
IC83.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.1 MA67.2
...
ICL-SUSP-ACCT-UNIT Alpha 15 IC02.1
Element: Accounting UniThe accounting unit 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-ACCOUNT Numeric 6 IC02.1
Element: 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
Element: 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
Element: Accounting UniThis is the accounting unit that will
default to returns for freight credit
allowed by the vendor.
ICL-FRT-ACCOUNT Numeric 6 IC02.1
Element: Account This is the account that will default
to returns for freight credit allowed by
the vendor.
ICL-FRT-SUB-ACCT Numeric 4 IC02.1
Element: Subaccount This is the sub account that will
default to returns for freight credit
allowed by the vendor.
ICL-HDLG-ACCT-UNIT Alpha 15 IC02.1
Element: Accounting UniThis is the accounting unit that will
default to returns for handling charged
by the vendor.
ICL-HDLG-ACCOUNT Numeric 6 IC02.1
Element: Account This is the account that will default
to returns for handling charged by the
vendor.
ICL-HDLG-SUB-ACCT Numeric 4 IC02.1
Element: Subaccount This is the sub account that will
default to returns for handling charged
by the vendor.
ICL-SCRP-ACCT-UNIT Alpha 15 IC02.1
Element: Accounting UniThis is the accounting unit that will
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
Element: 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
Element: 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
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 Indicates whether the vendor location
can process Evaluated Receipt Settlement
(ERS).
Y = Yes
N = No
ICL-PAR-VALUE Signed 18.2 IC283
Element: Intl Amt The value of the inventory stored at
the par location.
ICL-WST-ACCT-UNIT Alpha 15 IC02.1
Element: Accounting UniThe 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: Subaccount 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: Accounting UniThe 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: Subaccount 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: Accounting UniThe 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: Subaccount 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 Work 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 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
Element: Customer NumbeThis field contains the number that
represents a customer.
ICL-SHIP-TO Numeric 4 IC02.1
Element: Ship-to Code 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 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
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)
Element: Name
ICL-POB-ADDR1 Alpha 30 (Lower Case)
Element: Address 1
ICL-POB-ADDR2 Alpha 30 (Lower Case)
Element: Address 1
ICL-POB-ADDR3 Alpha 30 (Lower Case)
Element: Address 1
ICL-POB-ADDR4 Alpha 30 (Lower Case)
Element: Address 1
ICL-POB-CITY-ADDR5 Alpha 18 (Lower Case)
Element: City
ICL-POB-STATE-PROV Alpha 2
Element: State or Province
ICL-POB-POSTAL-CD Alpha 10 (Lower Case)
Element: Postal Code
ICL-POB-COUNTRY-CD Alpha 2
Element: Country Code
ICL-POB-COUNTY Alpha 25 (Lower Case)
Element: County
ICL-POB-CONTACT Alpha 30 (Lower Case)
Element: Contact
ICL-GLN-NBR Numeric 13
Element: Gln Nbr
ICLOCATION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICLSET1 COMPANY AP125 AP126
LOCATION AP131 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 AR08.1
AR10.1 AR501
AR550 BL00.1
BL01.1 BL02.1
BL120 BL122
BL130 BL140
BL141 BL20.1
BL20.3 BL201
BL202 BL208
...
ICLSET2 COMPANY Subset IC281 IC331
LOCATION Where LOCATION-TYPE = "E" IC81.1 IC82.1
Or LOCATION-TYPE = "P" IC83.1 RQ01.1
ICLSET3 COMPANY Subset IC01.1
LOCATION Where WO-LOC-TYPE != "N"
ICLSET4 VENDOR KeyChange, Subset IC02.1 OE13.6
PURCH-FR-LOC Where VENDOR != Spaces OE229 OE88.1
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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
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
|
