Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICCOMPANY


                             ICCOMPANY FILE

                     Inventory Company Information

The Inventory Company Information file is a file of valid inventory companies
and their corresponding system parameters.

REFERENCED BY

AP510     API1.1    API2.1    BL00.1    BL04.1    BL05.1
BL09.1    BL10.1    BL121     BL123     BL125     BL141
BL15.1    BL16.1    BL200     BL204     BL205     BL208
BL210     BL215     BL220     BL230     BL231     BL232
BL240     BL241     BL243     BL245     BL246     BL247
BL248     BL290     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    BL33.1    BL330     BL331
BL340     BL341     BL40.1    BL40.2    BL40.3    BL41.1
BL42.1    BL42.2    BL45.2    BL45.3    BL46.2    BL46.3
BL47.2    BL47.3    BL48.2    BL48.3    BL80.1    BL90.1
DR25.1    DR40.1    DR42.1    IC02.1    IC02.2    IC03.1
IC04.1    IC10.1    IC10.2    IC110     IC120     IC134
IC135     IC138     IC143     IC15.1    IC15.2    IC15.3
IC150     IC151     IC152     IC153     IC17.1    IC179
IC183     IC19.1    IC192     IC199     IC201     IC202
IC203     IC204     IC211     IC215     IC217     IC219
IC220     IC221     IC222     IC224     IC227     IC228
IC229     IC230     IC232     IC233     IC234     IC235
IC237     IC238     IC239     IC240     IC241     IC242
IC244     IC26.1    IC26.2    IC260     IC27.1    IC271
IC280     IC283     IC284     IC286     IC287     IC29.1
IC29.2    IC29.3    IC290     IC295     IC30.1    IC300
IC311     IC33.1    IC331     IC34.1    IC34.2    IC35.1
IC37.1    IC38.1    IC41.1    IC42.1    IC42.2    IC42.3
IC42.4    IC43.1    IC46.1    IC46.2    IC47.1    IC48.1
IC49.1    IC50.1    IC50.2    IC51.1    IC519     IC52.1
IC53.1    IC55.1    IC55.2    IC550     IC574     IC589
IC59.1    IC590     IC599     IC60.1    IC60.2    IC60.3
IC61.1    IC65.1    IC70.1    IC72.1    IC73.1    IC74.1
IC76.1    IC78.1    IC812     IC820     IC841     IC850
IC851     IC90.1    IC95.1    IC95.2    IC95.3    ICCP.1
ICI1.1    ICLC.1    PC10.1    PC20.1    PC20.2    PC210
PC310     PC320     PC520     PC521     PC530     PC540
PC810     MA236     MA278     MA53.1    MA53.5    MA540
MA64.6    MA65.1    OE112     OE130     OE230     OE254
OE270     OE271     OE272     OE280     OE281     OE282
OE283     OE286     OE287     OE288     OE289     OE290
OE293     OE330     OE54.1    OE80.1    OE80.2    OE80.3
OE80.4    OE80.5    PO01.1    PO10.1    PO115     PO120
PO130     PO132     PO133     PO135     PO136     PO15.1
PO15.2    PO150     PO181     PO190     PO204     PO216
PO220     PO223     PO224     PO225     PO229     PO230
PO233     PO240     PO25.1    PO25.5    PO25.6    PO25.7
PO251     PO254     PO258     PO26.1    PO27.2    PO274
PO275     PO276     PO277     PO280     PO295     PO36.1
PO36.2    PO529     PO53.1    PO53.2    PO536     PO54.1
PO54.2    PO54.3    PO54.4    PO550     PO58.1    PO58.2
PO63.1    PO67.1    PO94.1    POA3.1    POCP.1    POI7.1
POID.1    POIF.1    POIH.1    RQ01.1    RQ02.1    RQ111
RQ140     RQ201     RQ202     RQ230     RQ235     RQ240
RQ300     RQ39.1    RQ39.2    RQ39.3    RQ40.1    RQ41.1
RQ42.1    RQ44.1    RQ44.2    RQ50.1    RQ510     RQ511
RQ512     RQ513     RQ810     RQIA.1    SA04.1    SA100
SA110     SA250     SA251     SA252     SA253     SA254
SA255     SA256     SA257     SA258     SA262     SA272
SA282     SA292     SA300     SA80.3    SA90.3    TX140
WH01.1    WH11.1    WH131     WH140     WH201     WH21.1
WH210     WH211     WH221     WH224     WH225     WH226
WH330     WOOR.1    IC00.1    IC07.1    IC11.1    IC200
IC811     WODL.1

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL140
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL81.1    BL820     BL85.1    BL85.2    BL92.1
CXCP.1    DR100     IC01.1    IC01.2    IC01.3    IC01.4
IC12.1    IC12.2    IC125     IC130     IC140     IC141
IC142     IC145     IC170     IC175     IC182     IC190
IC20.1    IC20.2    IC21.1    IC21.2    IC22.1    IC22.2
IC223     IC225     IC226     IC23.1    IC23.2    IC24.1
IC24.2    IC243     IC25.1    IC262     IC263     IC270
IC28.1    IC281     IC282     IC31.1    IC320     IC330
IC36.1    IC40.1    IC40.2    IC44.1    IC45.1    IC500
IC520     IC521     IC522     IC523     IC524     IC525
IC526     IC527     IC530     IC531     IC598     IC62.1
IC62.2    IC62.4    IC63.1    IC67.1    IC68.1    IC68.2
IC81.1    IC82.1    IC83.1    IC840     PC120     SEA1.1
MA180     MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.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.1    OE13.2    OE13.3
OE13.4    OE13.5    OE13.6    OE14.4    OE16.1    OE229
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE56.1    OE81.1
OE81.2    OE81.3    OE810     OE830     OE86.1    OE88.1
OE90.1    OE90.2    PO100     PO101     PO122     PO131
PO16.1    PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO228     PO23.1    PO24.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     POI3.1    POIE.1
POII.1    POIJ.1    RQ04.1    RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ12.1    RQ13.1    RQ13.2    RQ204     RQ35.1
RQ500     RQIB.1    RQIC.1    RQID.1    RQIF.1    RQIG.1
RQIH.1    RQII.1    RQIJ.1    WH02.1    WH110     WH120
WH126     WH130     WH132     WH190     WH20.1    WH20.2
WH20.3    WH20.4    WH20.5    WH20.6    WH20.7    WH22.1
WH220     WH222     WH25.1    WH25.2    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.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    WH34.5    WH38.1
WH40.1    WH40.2    WH52.1    WH52.2    WH52.3    WH52.4
WH520     WH80.1    WH80.2    WH80.3    WH80.4    WH81.1
WH830     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
WO81.1    WO81.2    WO82.1    WOEX.1    WOSP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICC-COMPANY            Numeric 4                                 IC01.1  IC01.2
Element: Company       Identifies the AP company if the          IC01.3  IC01.4
                       resource type = V.  Identifies the HR     IC10.2
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

ICC-ITEM-GROUP         Alpha 5                                   BL140   BL141
Element: Item Group    This field contains the identifier for    BL204   BL240
                       a group of items that can be shared by    BL241   BL243
                       one or more companies.                    BL340   BL341
                                                                 BL81.1  IC01.1
                                                                 OE14.1  OE14.2
                                                                 OE230   OE287
                                                                 OE293   WH120

ICC-NAME               Alpha 30  (Lower Case)                    IC01.1  IC01.4
Element: Name          This field contains the name or
                       description of this company.


ICC-COST-METHOD        Alpha 4                                   IC01.1
Element: Costing MethodThis field contains the selected method
                       to cost inventory transactions.
                       AVG = Average Costing
                       FIFO = First In First Out
                       LIFO = Last In First Out
                       STD = Standard Costing

ICC-NUMBER-PDS         Numeric 2                                 IC01.2
Element: Number of PeriThis field contains the number of
                       inventory periods that are used to
                       summarize history tracking and item
                       forecasts.
                       12 = 12 periods per year (monthly)
                       13 = 13 periods per year
                       52 = 52 periods per year (weekly)
                       53 = 53 periods per year

ICC-CURR-YEAR          Numeric 4                                 DR100   IC01.2
Element: Last Closed YeThis field determines the year that is    IC190
                       updated with the summarized history.

ICC-CURR-PERIOD        Numeric 2                                 IC01.2  IC190
Element: Current PeriodThis field determines the period that
                       is updated with the summarized history.

ICC-CURR-YEAR-PDS      Numeric 8  (yyyymmdd) Occurs 53 Times     IC01.2  IC190
Element: Current Year PThis field contains the ending dates
                       for each inventory period. This date
                       determines which period gets updated
                       with the summarized history.

ICC-CURR-YEAR-STS      Alpha 1 Occurs 53 Times                   IC01.2  IC190
Element: Current Year SThis field contains the status of the
                       inventory period. This status determines
                       if an inventory transaction can be
                       entered with a transaction date within
                       this period.
                       C = Closed
                       O = Open

ICC-LST-YR-END-DT      Numeric 8  (yyyymmdd)                     IC01.1  IC190
Element: Last Year End This field contains the ending date
                       from the last period of last year. This
                       date is used to determine the date range
                       for the first period of the current
                       year.

ICC-AUDIT-ITL-FL       Alpha 1                                   IC01.1
Element: All Flag      This flag indicates whether changes to
                       the Item Location file are to be
                       audited.
                       N = No
                       Y = Yes

ICC-UOM-REQ-FL         Alpha 1                                   IC01.1
Element: All Flag      This field determines if the unit of
                       measure needs entering on any inventory
                       transaction.

                       If the flag is No and the unit of
                       measure is not entered, the stock unit
                       of measure defaults.

                       If the flag is Yes, you must enter the
                       unit of measure.
                       N = No
                       Y = Yes

ICC-NEG-SOH-FL         Alpha 1                                   IC01.1
Element: All Flag      This field determines if the
                       stock-on-hand quantity can be a negative
                       value. If the company costing method is
                       standard or average, this flag can be
                       set to Yes.
                       N = No
                       Y = Yes

ICC-BIN-TYPE           Alpha 1 Occurs 9 Times                    IC01.3
Element: Bin Usage TypeThis field indicates how the bin is
                       used. One example is inspection.

ICC-BIN-TYPE-DESC      Alpha 10  (Lower Case)                    IC01.3
Element: Bin Type DescrOccurs 9 Times
                       This field contains the description of
                       the bin type code.

ICC-BIN-REC-FL         Alpha 1 Occurs 9 Times                    IC01.3
Element: All Flag      This field determines if this bin
                       allows receivings into it.

                       If this field is No, items have to be
                       adjusted or transferred into it. For
                       example, a shipping bin that should not
                       have an item put into it until the item
                       has been inspected.
                       N = No
                       Y = Yes

ICC-BIN-ISSUES-FL      Alpha 1 Occurs 9 Times                    IC01.3
Element: All Flag      This flag determines if the bin allows
                       an item to be issued out of it.

                       If this field is No, an issue is not
                       allowed out of this bin. For example,
                       items may need to be inspected before
                       they can be issued.
                       N = No
                       Y = Yes

ICC-ORDER-COST         Signed 18.2                               IC01.1
Element: Intl Amt      This field contains the average cost of
                       ordering an item. This amount is used in
                       the economic order quantity calculation.

ICC-CARRY-PCT          Percent 4.2  (Percent)                    IC01.1
Element: Carrying PerceThis field contains the percent of the
                       inventory carrying cost. This percent is
                       used in the economic order quantity
                       calculation.

ICC-SP-DEC-QTY         Numeric 1                                 IC01.1  PO115
Special Nbr            This field contains the number of         PO15.1  PO15.2
Decimals for Qty       decimals used for the quantity field for  PO67.1
                       special order and service items.
                       0 = 0 Decimals
                       1 = 1 Decimal
                       2 = 2 Decimals
                       3 = 3 Decimals
                       4 = 4 Decimals

ICC-SP-DEC-COST-P      Numeric 1                                 IC01.1
Special Nbr Decimal    This field contains the number of
Cost/Price             decimals for the unit cost for special
                       order and service items.
                       0 = 0 Decimals
                       1 = 1 Decimal
                       2 = 2 Decimals
                       3 = 3 Decimals
                       4 = 4 Decimals
                       5 = 5 Decimals

ICC-LAST-IF-LINE       Numeric 6                                 DR100   IC140
Element: Line Number   This field contains the line number of    IC531
                       the last record added to the PO
                       Interface file.

ICC-COMPLETE-FLAG      Alpha 1                                   IC01.1
Element: Company CompleThis field determines whether all setup
                       forms have been processed when adding a
                       new company in IC01.1 (Company).
                       N = No
                       Y = Yes

ICC-FUTURE-USE         Alpha 1
Element: Future Use    This field is reserved for future use.

ICC-SELL-ALLOC-FL      Alpha 1                                   IC01.1
Element: Alc Alloc Fl  This field is used to determine if the
                       allocated quantity should be subtracted
                       from the stock-on-hand quantity in the
                       available-to-sell calculation. It is
                       always set to negative.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-INPROC-FL     Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       in process quantity should be subtracted
                       from the stock on hand quantity in the
                       available to sell calculation.  It is
                       always set to negative.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-BCKORD-FL     Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       backorder quantity is to be subtracted
                       from the stock on hand quantity in the
                       available to sell calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-INTRNC-FL     Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       intransit quantity is to be added to the
                       stock on hand quantity in the available
                       to sell calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-ONORD-FL      Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       on order quantity is to be added to the
                       stock on hand quantity in the available
                       to sell calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-WIP-FL        Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       work in process quantity is to be added
                       to the stock on hand quantity in the
                       available to sell calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-HOLD-FL       Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       hold quantity is to be subtracted from
                       the stock on hand quantity in the
                       available to sell calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-ALLOC-FL       Alpha 1                                   IC01.1
Element: Alc Alloc Fl  This field is used to determine if the
                       allocated quantity is to be subtracted
                       from the available to allocate
                       calculation.  It is always set to
                       negative.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-INPROC-FL      Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       in process quantity is to be subtracted
                       from the stock on hand quantity in the
                       available to allocate calculation.  It
                       is always set to negative.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-BCKORD-FL      Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       backorder quantity is to be added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-INTRNC-FL      Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       intransit quantity is to be added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-ONORD-FL       Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       on order quantity is to be added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-WIP-FL         Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       work in process quantity is to be added
                       to the stock on hand quantity in the
                       available to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALC-HOLD-FL        Alpha 1                                   IC01.1
Element: Alc Bckord Fl This field is used to determine if the
                       hold quantity is to be subtracted from
                       the stock on hand quantity in the
                       available to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALLOC-FL           Alpha 1                                   IC01.1
Element: Allocation FlaThis field determines whether new
                       demand for an item is to be allocated
                       when the order is entered or later with
                       a batch program.
                       B = Batch
                       O = Online

ICC-ALLOC-BASIS        Alpha 1                                   IC01.1
Element: Allocation BasThis field is used to determine if the
                       batch allocation program should allocate
                       demand based on requested date or the
                       priority.
                       D = Date
                       P = Priority

ICC-CX-PRIORITY        Numeric 2                                 IC01.1
Element: Cx Priority

ICC-OE-PRIORITY        Numeric 2                                 IC01.1
Element: Oe Priority

ICC-RQ-PRIORITY        Numeric 2                                 IC01.1
Element: Rq Priority

ICC-WO-PRIORITY        Numeric 2                                 IC01.1
Element: Wo Priority

ICC-PCK-COM-OPT        Alpha 1 Occurs 10 Times                   IC01.4
Element: Ack Com Opt   These fields are used to determine which
                       item comment types are to be printed on
                       the Warehouse and Work-Order system's
                       picking list. A maximum of 10 different
                       comment types can be X'ed here. The X's
                       are mapped against
                       ITEMGROUP.com-type-desc to determine the
                       actual comment type.
                       X = Print Comments

ICC-PAK-COM-OPT        Alpha 1 Occurs 10 Times                   IC01.4
Element: Ack Com Opt   These fields are used to determine
                       which item comment types are to be
                       printed on the Warehouse system's
                       packing list.
                       X = Print Comments

ICC-REL-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt   Not currently used.

ICC-LAST-WO-NBR        Numeric 8                                 WO120   WO20.1
Element: Work Order                                              WO20.2  WO30.1
                                                                 WO45.1

ICC-WO-NBR-TYPE        Alpha 1                                   IC01.1
Element: Wo Nbr Type   Work Order Numbering Type.
                       A = Auto Assign Work Order Number
                       M = Manually Assign Work Order Nbr
                       N = Not Using Work Order

ICC-RQ-SEARCH-CAT      Numeric 1                                 IC01.1
Element: Rq Search Cat

ICC-RQ-SHOP-LIST       Numeric 1                                 IC01.1
Element: Rq Shop List

ICC-RQ-EXPRESS-ORD     Numeric 1                                 IC01.1
Element: Rq Express Ord

ICC-RQ-SPEC-SERV       Numeric 1                                 IC01.1
Element: Rq Spec Serv

ICC-RQ-GLOM            Numeric 1                                 IC01.1
Element: Rq Glom

ICC-RQ-CATEGORIES      Numeric 1                                 IC01.1
Element: Rq Categories

ICC-RQ-SELECT-ALL      Alpha 1
Element: Rq Select All D = Display
                       H = Hide

ICC-CONTRACTS-ONLY     Alpha 1                                   IC01.1
Element: Contracts Only

ICC-INTERNAL-ONLY      Alpha 1                                   IC01.1
Element: Internal Only

ICC-AUDIT-ITM-FL       Alpha 1                                   IC01.1
Element: Audit Itm Fl  This flag indicates whether changes to
                       the ITEMSRC table are to be audited.

ICC-IC-RUN-ST          Numeric 1                                 IC130
Element: Ic Run St     This flag is used to determine if a
                       IC130 Job is in the process of running
                       and to prevent more than one job to be
                       attempting to update GL at a time.

ICC-APPROVAL-TYPE      Alpha 1                                   IC01.1
Element: Approval Type The type of approval record.
                       0 = Header approval-Approval codes
                       1 = Header approval-Process Flow
                       2 = Line approval
                       3 = No approval required

ICC-AL-ALLOC-FL        Derived
Element: Al Alloc Fl   Used in the Allocatable quantity
                       calculation in Itemloc file.

ICC-AL-INPROC-FL       Derived
Element: Al Inproc Fl  Used in the Allocatable quantity
                       calculation in the Itemloc file.

ICC-AL-BCKORD-FL       Derived
Element: Al Bckord Fl  Used in the Allocatable quantity
                       calculation in the Itemloc file.

ICC-AL-INTRNC-FL       Derived
Element: Al Intrnc Fl  Used in the Allocatable quantity
                       calculation in the Itemloc file.

ICC-AL-ONORD-FL        Derived
Element: Al Onord Fl   Used in the Allocatable quantity
                       calculation in the Itemloc file.

ICC-AL-WIP-FL          Derived
Element: Al Wip Fl     Used in the Allocatable quantity
                       calculation in the Itemloc file.

ICC-AL-HOLD-FL         Derived
Element: Al Hold Fl    Used in the Allocatable quantity
                       calculation in the Itemloc file.

ICC-SL-ALLOC-FL        Derived
Element: Sl Alloc Fl   Used in the Sellable quantity
                       calculation in the Itemloc file.

ICC-SL-INPROC-FL       Derived
Element: Sl Inproc Fl  Used in the Sellable quantity
                       calculation in the Itemloc file.

ICC-SL-BCKORD-FL       Derived
Element: Sl Bckord Fl  Used in the Sellable quantity
                       calculation in the Itemloc file.

ICC-SL-INTRNC-FL       Derived
Element: Sl Intrnc Fl  Used in the Sellable quantity
                       calculation in the Itemloc file.

ICC-SL-ONORD-FL        Derived
Element: Sl Onord Fl   Used in the Sellable quantity
                       calculation in the Itemloc file.

ICC-SL-WIP-FL          Derived
Element: Sl Wip Fl     Used in the Sellable quantity
                       calculation in the Itemloc file.

ICC-SL-HOLD-FL         Derived
Element: Sl Hold Fl    Used in the Sellable quantity
                       calculation in the Itemloc file.

                         ICCOMPANY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICCSET1   COMPANY                                                AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 API2.1  BL00.1
                                                                 BL04.1  BL05.1
                                                                 BL09.1  BL10.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL125   BL130
                                                                 BL140   BL141
                                                                 BL15.1  BL16.1
                                                                 BL20.1  BL20.3
                                                                 BL200   BL204
                                                                 ...

ICCSET2   ITEM-GROUP    KeyChange                                IC00.1  IC01.1
          COMPANY                                                IC07.1  IC10.1
                                                                 IC10.2  IC11.1
                                                                 IC153   IC200
                                                                 IC33.1  IC330
                                                                 IC60.1  IC811
                                                                 PO150   PO225
                                                                 PO229   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQ10.1
                                                                 WODL.1  WOOR.1

ICCSET3   COMPANY       KeyChange                                AP125   AP126
          ITEM-GROUP                                             AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  DR100
                                                                 IC141   IC142
                                                                 IC21.1  IC21.2
                                                                 IC28.1  IC500
                                                                 IC83.1  MA180
                                                                 ...

                         ICCOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cxcompany      CXCOMPANY    Not Required

                            ICC-COMPANY       -> CXC-COMPANY

Gl Company     GLSYSTEM     Not Required

                            ICC-COMPANY       -> GLS-COMPANY

Itemgroup      ITEMGROUP    Required

                            ICC-ITEM-GROUP    -> ITG-ITEM-GROUP

                         ICCOMPANY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Custorder      CUSTORDER

                            ICC-COMPANY       -> COR-COMPANY
                                                 COR-ORDER-NBR

Itemdesc       ITEMMAST

                            ITG-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-DESCRIPTION
                                                 ITE-ITEM

Itemformat     ITEMFORMAT   Delete Restricted

                            ICC-COMPANY       -> ITF-COMPANY
                                                 ITF-FORMAT-ID

Itemgeneric    ITEMMAST

                            ITG-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-GENERIC
                                                 ITE-ITEM

Iteminven      ITEMMAST

                            ITG-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-INVEN-MAJCL
                                                 ITE-INVEN-MINCL
                                                 ITE-ITEM

Itemmast       ITEMMAST

                            ICC-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-ITEM

Itempurch      ITEMMAST

                            ITG-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-PURCH-MAJCL
                                                 ITE-PURCH-MINCL
                                                 ITE-ITEM

Itemsales      ITEMMAST

                            ITG-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-SALES-MAJCL
                                                 ITE-SALES-MINCL
                                                 ITE-ITEM

Reasoncode     REASON       Delete Restricted

                            ICC-COMPANY       -> REA-COMPANY
                                                 REA-REASON-CODE