Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ICRECEIPTS FILE

                             Costing Record

The Costing Record file is the cost history file. Every incoming inventory
update transaction creates a record in this file which is used for LIFO and
FIFO costing. Outgoing transactions consume inventory by updating the used
quantity.

REFERENCED BY

IC12.1    IC47.1    IC234     DR100     IC141     IC142
IC190     IC222     IC233     IC26.1    IC26.2    IC83.1
IC90.1    RQ11.1    RQ500     RQIC.1    RQID.1    RQIF.1
RQIG.1    IC120     IC170     IC227     IC228     IC530

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    IC175     IC20.1    IC20.2    IC21.1    IC21.2
IC22.1    IC22.2    IC23.1    IC23.2    IC24.1    IC24.2
IC25.1    IC28.1    IC300     IC500     IC812     IC820
MA180     MA43.9    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.3    MA67.1    MA67.2    MA70.1
MAI1.1    PO100     PO101     PO122     PO131     PO20.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO33.1    PO34.1    PO35.1    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
POI3.1    POIE.1    POII.1    POIJ.1    RQ10.1    RQ10.2
RQ35.1    WH130     WH132     WH190     WH20.2    WH20.7
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
WH40.1    WH40.2    WH520     WH830

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICR-COMPANY          Numeric 4                                   AP125   AP126
Company              The company number represents an            AP131   AP25.1
                     established company and is entered on       AP25.2  AP26.1
                     all function codes.                         AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-LOCATION         Alpha 5                                     AP125   AP126
Location Code        This field contains a valid stocking        AP131   AP25.1
                     location within the company inventory.      AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-ITEM             Alpha 32                                    AP125   AP126
Item Number          This field contains the item                AP131   AP25.1
                     identifier.                                 AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-DOCUMENT         Alpha 10  (Right Justified)                 AP125   AP126
Document ID          This field identifies the document from     AP131   AP25.1
                     which this transaction record was           AP25.2  AP26.1
                     created.                                    AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-DOC-TYPE         Alpha 2                                     AP125   AP126
Document Type        This field contains the type of             AP131   AP25.1
                     transaction.                                AP25.2  AP26.1
                     AJ = Adjustment                             AP27.1  IC175
                     CR = Customer Return                        IC20.1  IC20.2
                     PI = Physical Inventory Adjustment          IC21.1  IC21.2
                     PO = PO Receiving                           IC22.1  IC22.2
                     RC = Receipt                                IC23.1  IC23.2
                     RT = Receiving Transfer                     IC24.1  IC24.2
                     SH = Shipment                               IC25.1  IC28.1
                     RR = Requisition Return                     IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-SYSTEM-CD        Alpha 2                                     AP125   AP126
System Code          This field indicates the originating        AP131   AP25.1
                     system of the transaction.                  AP25.2  AP26.1
                     IC = Inventory Control                      AP27.1  IC175
                     PO = Purchase Order                         IC20.1  IC20.2
                     OE = Order Entry                            IC21.1  IC21.2
                     RQ = Requisitions                           IC22.1  IC22.2
                     WO = Work Order                             IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-LINE-NBR         Numeric 6                                   AP125   AP126
Line Number          This field displays the system-assigned     AP131   AP25.1
                     transaction number.                         AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-COMPONENT-SEQ    Numeric 3                                   AP125   AP126
Component Sequence   This field contains the component           AP131   AP25.1
Number               sequence number.                            AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 ...

ICR-RECEIVED-QTY     Signed 13.4                                 AP125   AP126
Received Quantity    This field contains the quantity of the     AP131   AP25.1
                     original transaction that is added to       AP25.2  AP26.1
                     the stock-on-hand quantity.                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-USED-QTY         Signed 13.4                                 AP125   AP126
Used Quantity        This field contains the quantity that       AP131   AP25.1
                     has been used by outgoing transactions.     AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 PO300   PO31.1
                                                                 PO31.2  PO32.2
                                                                 PO33.1  PO34.1
                                                                 PO35.1  PO38.1
                                                                 PO39.1  PO39.2
                                                                 ...

ICR-UNIT-COST        Signed 13.5                                 AP125   AP126
Unit Cost            This field contains the actual unit         AP131   AP25.1
                     cost for this incoming transaction.         AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-RECEIVED-DATE    Numeric 8  (yyyymmdd)                       AP125   AP126
Received Date        This field contains the date when this      AP131   AP25.1
                     transaction record was created.             AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 PO300   PO31.1
                                                                 PO31.2  PO32.2
                                                                 PO33.1  PO34.1
                                                                 PO35.1  PO38.1
                                                                 PO39.1  PO39.2
                                                                 ...

ICR-RECEIVED-TIME    Numeric 6  (hhmmss)                         AP125   AP126
Received Time        This field contains the actual time         AP131   AP25.1
                     this receipt took place.                    AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 PO300   PO31.1
                                                                 PO31.2  PO32.2
                                                                 PO33.1  PO34.1
                                                                 PO35.1  PO38.1
                                                                 PO39.1  PO39.2
                                                                 ...

ICR-LAST-ACT-DATE    Numeric 8  (yyyymmdd)                       AP125   AP126
Last Activity Date   This field contains the date this           AP131   AP25.1
                     record was last updated. Whenever this      AP25.2  AP26.1
                     record is updated, the system date          AP27.1  IC175
                     defaults.                                   IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC812
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 ...

ICR-HOLD-QTY         Signed 13.4                                 AP125   AP126
Hold Quantity                                                    AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 ...

                         ICRECEIPTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICRSET1   COMPANY                                                AP125   AP126
          LOCATION                                               AP131   AP25.1
          ITEM                                                   AP25.2  AP26.1
          DOCUMENT                                               AP27.1  IC12.1
          DOC-TYPE                                               IC175   IC20.1
          SYSTEM-CD                                              IC20.2  IC21.1
          LINE-NBR                                               IC21.2  IC22.1
          COMPONENT-SEQ                                          IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC300
                                                                 IC47.1  IC500
                                                                 IC820   MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 ...

ICRSET2   COMPANY                                                IC234   IC47.1
          LOCATION
          ITEM
          RECEIVED-DATE
          RECEIVED-TIME
          DOCUMENT
          DOC-TYPE
          SYSTEM-CD
          LINE-NBR
          COMPONENT-SEQ

ICRSET3   COMPANY       Subset                                   AP125   AP126
          LOCATION      Where RECEIVED-QTY != USED-QTY           AP131   AP25.1
          ITEM                                                   AP25.2  AP26.1
          RECEIVED-DATE                                          AP27.1  DR100
          RECEIVED-TIME                                          IC141   IC142
          DOCUMENT                                               IC175   IC190
          DOC-TYPE                                               IC20.1  IC20.2
          SYSTEM-CD                                              IC21.1  IC21.2
          LINE-NBR                                               IC22.1  IC22.2
          COMPONENT-SEQ                                          IC222   IC23.1
                                                                 IC23.2  IC233
                                                                 IC234   IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC47.1
                                                                 ...

ICRSET4   COMPANY       Subset                                   IC28.1  IC47.1
          LOCATION      Where RECEIVED-QTY != USED-QTY
          ITEM
          DOCUMENT
          DOC-TYPE
          SYSTEM-CD
          LINE-NBR
          COMPONENT-SEQ

ICRSET5   COMPANY       Subset                                   AP125   AP126
          LOCATION      Where RECEIVED-QTY != USED-QTY           AP131   AP25.1
          ITEM                                                   AP25.2  AP26.1
          RECEIVED-DATE*                                         AP27.1  DR100
          RECEIVED-TIME*                                         IC120   IC141
          DOCUMENT                                               IC142   IC170
          DOC-TYPE                                               IC175   IC20.1
          SYSTEM-CD                                              IC20.2  IC21.1
          LINE-NBR                                               IC21.2  IC22.1
          COMPONENT-SEQ                                          IC22.2  IC222
                                                                 IC227   IC228
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC530
                                                                 ...

                         ICRECEIPTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            ICR-COMPANY       -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            ICR-COMPANY       -> ICL-COMPANY
                            ICR-LOCATION      -> ICL-LOCATION

Itemloc        ITEMLOC      Required

                            ICR-COMPANY       -> ITL-COMPANY
                            ICR-LOCATION      -> ITL-LOCATION
                            ICR-ITEM          -> ITL-ITEM

Itemmast       ITEMMAST     Required

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