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     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    BL90.1    IC02.1    IC02.2
IC02.3    IC03.1    IC04.1    IC15.1    IC15.2    IC15.3
IC17.1    IC201     IC202     IC203     IC204     IC211
IC215     IC30.1    IC812     IC850     IC851     ICCP.1
ICI1.1    ICLC.1    MA236     MA278     MA53.1    MA53.5
MA53.7    MA540     MA64.6    MA65.1    MA90.2    MA90.3
MA90.4    MA90.5    PD21.1    PO01.1    PO04.1    PO04.2
PO10.1    PO10.2    PO115     PO120     PO130     PO132
PO133     PO135     PO136     PO139     PO15.1    PO15.2
PO150     PO181     PO204     PO216     PO220     PO223
PO224     PO225     PO229     PO230     PO233     PO234
PO240     PO251     PO254     PO258     PO26.1    PO274
PO275     PO276     PO277     PO278     PO280     PO295
PO420     PO421     PO529     PO53.1    PO53.2    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
POIE.1    POIF.1    POIH.1    MM280     MM80.1    MM80.2
RQ01.1    RQ01.2    RQ02.1    RQ111     RQ140     RQ201
RQ202     RQ230     RQ235     RQ240     RQ300     RQ39.1
RQ39.2    RQ39.3    RQ40.1    RQ42.1    RQ420     RQ421
RQ44.1    RQ44.2    RQ50.1    RQ510     RQ511     RQ512
RQ513     RQ810     RQD1.1    RQIA.1    TX140     WH01.1
WH11.1    WH131     WH140     WH201     WH210     WH211
WH221     WH225     WH330     WH420     WH421     WH422
WH423     WHD2.1    WHD3.1    IC00.1    IC07.1    IC11.1
IC14.1    IC200     IC811     ICBL.4

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL140     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL80.1    BL81.1
BL820     BL85.1    BL85.2    BL92.1    CXCP.1    IC01.1
IC01.2    IC01.3    IC01.4    IC12.1    IC12.2    IC130
IC190     IC320     IC330     MA180     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.7
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.2    MA67.3    MA68.2    MA68.3
MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1
PD10.2    PD130     PD20.1    PD20.2    PD20.3    PO100
PO101     PO122     PO131     PO16.1    PO190     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO228     PO23.1    PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO253     PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    RQ04.1
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1
RQ13.2    RQ204     RQ35.1    RQ41.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
WH224     WH226     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    WH440     WH52.1    WH52.2    WH52.3
WH52.4    WH520     WH80.1    WH80.2    WH80.3    WH80.4
WH81.1    WH82.1    WH830

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
                       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
                                                                 MA90.2  MA90.3
                                                                 MA90.4  MA90.5
                                                                 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: Cost Method   This 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 Pds    This 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                                 IC01.2  IC190
Element: Year          This field determines the year that is
                       updated with the summarized history.

ICC-CURR-PERIOD        Numeric 2                                 IC01.2  IC190
Element: Curr Period   This 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: Curr Year Pds This 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: Curr Year Sts This 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: Lst Yr End Dt 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 Type      This field indicates how the bin is
                       used. One example is inspection.

ICC-BIN-TYPE-DESC      Alpha 10  (Lower Case)                    IC01.3
Element: Bin Type Desc Occurs 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: Carry Pct     This 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  MA90.2
Element: Sp Dec Qty    This field contains the number of         MA90.3  MA90.4
                       decimals used for the quantity field for  MA90.5  PO115
                       special order and service items.          PO15.1  PO15.2
                       0 = 0 Decimals                            PO67.1
                       1 = 1 Decimal
                       2 = 2 Decimals
                       3 = 3 Decimals
                       4 = 4 Decimals

ICC-SP-DEC-COST-P      Numeric 1                                 IC01.1  MA90.2
Element: Sp Dec Cost P This field contains the number of         MA90.3  MA90.4
                       decimals for the unit cost for special    MA90.5
                       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
Element: Line Nbr      This field contains the line number of
                       the last record added to the PO
                       Interface file.

ICC-COMPLETE-FLAG      Alpha 1                                   IC01.1
Element: Complete Flag This field determines whether all setup
                       forms have been processed when adding a
                       new company in Company (IC01.1).
                       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
                       backorder quantity is to be added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = 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 added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-SELL-INTRNC-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-SELL-ONORD-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-SELL-WIP-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-SELL-HOLD-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-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
                       backorder quantity is to be added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = 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
                       backorder 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
                       backorder 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
                       backorder 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
                       backorder quantity is to be added to the
                       stock on hand quantity in the available
                       to allocate calculation.
                       + = Add
                       - = Subtract
                       " "

ICC-ALLOC-FL           Alpha 1                                   IC01.1
Element: Alloc Fl      This 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: Alloc Basis   This 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   X = Print Comments

ICC-REL-COM-OPT        Alpha 1 Occurs 10 Times
Element: Ack Com Opt

ICC-LAST-WO-NBR        Numeric 8
Element: Work Order    This identifies the work order and may
                       be automatically assigned or manually
                       assigned, depending on the option
                       defined for each production (inventory)
                       location.


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   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 API2.1  BL00.1
                                                                 BL04.1  BL05.1
                                                                 BL09.1  BL10.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL125   BL130
                                                                 ...

ICCSET2   ITEM-GROUP    KeyChange                                IC00.1  IC01.1
          COMPANY                                                IC07.1  IC11.1
                                                                 IC14.1  IC200
                                                                 IC330   IC811
                                                                 ICBL.4  PO150
                                                                 PO225   PO229
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQIJ.1

ICCSET3   COMPANY       KeyChange                                AP125   AP126
          ITEM-GROUP                                             AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

                         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