Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICLOCATION


                            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     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     IC237     IC238     IC239     IC24.1    IC24.2
IC241     IC242     IC244     IC25.1    IC260     IC27.1
IC270     IC280     IC281     IC282     IC284     IC285
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     IC84.1    IC84.2    IC841     IC850
IC851     IC90.1    ICLC.1    PC120     PC20.1    PC540
SEA1.1    MA278     MA53.1    MA54.1    PHI3.1    PO04.3
PO115     PO120     PO130     PO132     PO133     PO134
PO135     PO15.1    PO15.2    PO16.1    PO204     PO220
PO223     PO230     PO231     PO233     PO254     PO258
PO26.1    PO274     PO275     PO276     PO277     PO280
PO285     PO330     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
POIE.1    POIF.1    POIG.1    POIH.1    POIM.1    POIT.1
RQ01.1    RQ111     RQ140     RQ201     RQ230     RQ235
RQ240     RQ300     RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    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    SEA2.1    SEA3.1    SEA4.1
WH120     WH126     WH131     WH132     WH140     WH21.1
WH21.2    WH21.3    WH21.4    WH210     WH221     WH222
WH224     WH226     WH330     WH38.1    WH420     WH422
WH423     WH520     WH830     WOOR.1

UPDATED BY

AP125     AP126     AP131     AP170     AP193     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP32.2    API1.1    API2.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
IC63.1    IC68.1    IC68.2    IC68.3    IC81.1    IC83.1
IC840     MA180     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    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
PO100     PO101     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO228
PO23.1    PO25.1    PO25.5    PO25.6    PO25.7    PO27.2
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    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    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ35.1    RQ500     RQIE.1    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
WH440     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       The company number represents an          IC840
                       established company and is entered on
                       all function codes.

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)                    IC02.1  IC81.1
Element: 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
Element: Location Code

ICL-ADDR1              Alpha 30  (Lower Case)                    IC02.1  WH126
Element: Address 1     This field contains the first line of     WH224
                       address information.

ICL-ADDR2              Alpha 30  (Lower Case)                    IC02.1  WH126
Element: Address 1                                               WH224

ICL-ADDR3              Alpha 30  (Lower Case)                    IC02.1  WH126
Element: Address 1     This field contains the third line of     WH224
                       address information.

ICL-ADDR4              Alpha 30  (Lower Case)                    IC02.1  WH126
Element: Address 1     This field contains the fourth line of    WH224
                       address information.

ICL-CITY-ADDR5         Alpha 18  (Lower Case)                    IC02.1  WH126
Element: City          This field contains the fifth line        WH224
                       and/or the city of the address.

ICL-STATE-PROV         Alpha 2                                   IC02.1  WH126
Element: State or ProviThis field contains the state or          WH224
                       province of the address.

ICL-POSTAL-CODE        Alpha 10  (Lower Case)                    IC02.1  WH126
Element: Postal Code   This field contains the postal code of    WH224
                       the address.

ICL-COUNTRY            Alpha 30  (Lower Case)                    IC02.1  WH126
Element: Country or OthThis 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
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: Order Type CodThis 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   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  AP23.1
                       location.                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  API1.1
                                                                 API2.1  DR100
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 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
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA540
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

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: 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  API1.1
                                                                 API2.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  IC63.1
                                                                 IC68.1  IC68.2
                                                                 IC68.3  IC83.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA540
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA65.1  MA66.2
                                                                 ...

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   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  AP23.1
                       document.                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  API1.1
                                                                 API2.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  IC63.1
                                                                 IC68.1  IC68.2
                                                                 IC68.3  IC83.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA540
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA65.1  MA66.2
                                                                 ...

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   AP20.1
                       Warehouse system.                         AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  API1.1
                                                                 API2.1  DR100
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 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
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA540
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

ICL-SUSP-ACCT-UNIT     Alpha 15                                  IC02.1
Element: Accounting Unit

ICL-SUSP-ACCOUNT       Numeric 6                                 IC02.1
Element: Account

ICL-SUSP-SUB-ACCT      Numeric 4                                 IC02.1
Element: Subaccount

ICL-FRT-ACCT-UNIT      Alpha 15                                  IC02.1
Element: Accounting Unit

ICL-FRT-ACCOUNT        Numeric 6                                 IC02.1
Element: Account

ICL-FRT-SUB-ACCT       Numeric 4                                 IC02.1
Element: Subaccount

ICL-HDLG-ACCT-UNIT     Alpha 15                                  IC02.1
Element: Accounting Unit

ICL-HDLG-ACCOUNT       Numeric 6                                 IC02.1
Element: Account

ICL-HDLG-SUB-ACCT      Numeric 4                                 IC02.1
Element: Subaccount

ICL-SCRP-ACCT-UNIT     Alpha 15                                  IC02.1
Element: Accounting Unit

ICL-SCRP-ACCOUNT       Numeric 6                                 IC02.1
Element: Account

ICL-SCRP-SUB-ACCT      Numeric 4                                 IC02.1
Element: Subaccount

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 13.2                               IC283
Element: Par Value     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

                         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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  API1.1
                                                                 API2.1  AR08.1
                                                                 AR10.1  AR501
                                                                 AR550   CXCP.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 ...

ICLSET2   COMPANY       Subset                                   IC281   IC331
          LOCATION      Where LOCATION-TYPE = "E"                IC81.1  IC82.1
                        Or    LOCATION-TYPE = "P"                IC83.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1

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