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    IC120     IC170     IC227     IC228
IC530

UPDATED BY

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     ICI3.1
POIJ.1    WH130     WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICR-COMPANY          Numeric 4                                   IC175   IC20.1
Company              The company number represents an            IC20.2  IC21.1
                     established company and is entered on       IC21.2  IC22.1
                     all function codes.                         IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-LOCATION         Alpha 5                                     IC175   IC20.1
Location Code        This field contains a valid stocking        IC20.2  IC21.1
                     location within the company inventory.      IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-ITEM             Alpha 32                                    IC175   IC20.1
Item Number          This field contains the item                IC20.2  IC21.1
                     identifier.                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-DOCUMENT         Alpha 10  (Right Justified)                 IC175   IC20.1
Document ID          This field identifies the document from     IC20.2  IC21.1
                     which this transaction record was           IC21.2  IC22.1
                     created.                                    IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-DOC-TYPE         Alpha 2                                     IC175   IC20.1
Document Type        This field contains the type of             IC20.2  IC21.1
                     transaction.                                IC21.2  IC22.1
                     AJ = Adjustment                             IC22.2  IC23.1
                     CR = Customer Return                        IC23.2  IC24.1
                     PI = Physical Inventory Adjustment          IC24.2  IC25.1
                     PO = PO Receiving                           IC500   IC812
                     RC = Receipt                                IC820   ICI3.1
                     RT = Receiving Transfer                     POIJ.1  WH130
                     SH = Shipment                               WH33.1  WH33.2
                     RR = Requisition Return                     WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-SYSTEM-CD        Alpha 2                                     IC175   IC20.1
System Code          This field indicates the originating        IC20.2  IC21.1
                     system of the transaction.                  IC21.2  IC22.1
                     IC = Inventory Control                      IC22.2  IC23.1
                     PO = Purchase Order                         IC23.2  IC24.1
                     OE = Order Entry                            IC24.2  IC25.1
                     RQ = Requisitions                           IC500   IC812
                     WO = Work Order                             IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-LINE-NBR         Numeric 6                                   IC175   IC20.1
Line Number          This field displays the system-assigned     IC20.2  IC21.1
                     transaction number.                         IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-COMPONENT-SEQ    Numeric 3                                   IC175   IC20.1
Component Sequence   This field contains the component           IC20.2  IC21.1
Number               sequence number.                            IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-RECEIVED-QTY     Signed 13.4                                 IC175   IC20.1
Received Quantity    This field contains the quantity of the     IC20.2  IC21.1
                     original transaction that is added to       IC21.2  IC22.1
                     the stock-on-hand quantity.                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICR-USED-QTY         Signed 13.4                                 IC175   IC20.1
Used Quantity        This field contains the quantity that       IC20.2  IC21.1
                     has been used by outgoing transactions.     IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 ICI3.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICR-UNIT-COST        Signed 13.5                                 IC175   IC20.1
Unit Cost            This field contains the actual unit         IC20.2  IC21.1
                     cost for this incoming transaction.         IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC500
                                                                 IC812   IC820
                                                                 ICI3.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICR-RECEIVED-DATE    Numeric 8  (yyyymmdd)                       IC175   IC20.1
Received Date        This field contains the date when this      IC20.2  IC21.1
                     transaction record was created.             IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 ICI3.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICR-RECEIVED-TIME    Numeric 6  (hhmmss)                         IC175   IC20.1
Received Time        This field contains the actual time         IC20.2  IC21.1
                     this receipt took place.                    IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   IC812
                                                                 ICI3.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICR-LAST-ACT-DATE    Numeric 8  (yyyymmdd)                       IC175   IC20.1
Last Activity Date   This field contains the date this           IC20.2  IC21.1
                     record was last updated. Whenever this      IC21.2  IC22.1
                     record is updated, the system date          IC22.2  IC23.1
                     defaults.                                   IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC500
                                                                 IC812   IC820
                                                                 ICI3.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICR-HOLD-FLAG        Alpha 1                                     IC812   IC820
On Hold Flag         This field indicates this receipt is on     ICI3.1
                     hold for inspection by the Purchase
                     Order system.
                     Y = Yes

ICR-HOLD-QTY         Signed 13.4                                 IC175   IC20.1
Hold Quantity                                                    IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC500   POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

                         ICRECEIPTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICRSET1   COMPANY                                                IC12.1  IC175
          LOCATION                                               IC20.1  IC20.2
          ITEM                                                   IC21.1  IC21.2
          DOCUMENT                                               IC22.1  IC22.2
          DOC-TYPE                                               IC23.1  IC23.2
          SYSTEM-CD                                              IC24.1  IC24.2
          LINE-NBR                                               IC25.1  IC300
          COMPONENT-SEQ                                          IC47.1  IC500
                                                                 IC820   ICI3.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 ...

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

ICRSET3   COMPANY       Subset                                   DR100   IC141
          LOCATION      Where RECEIVED-QTY != USED-QTY           IC142   IC175
          ITEM                                                   IC190   IC20.1
          RECEIVED-DATE                                          IC20.2  IC21.1
          RECEIVED-TIME                                          IC21.2  IC22.1
          DOCUMENT                                               IC22.2  IC222
          DOC-TYPE                                               IC23.1  IC23.2
          SYSTEM-CD                                              IC233   IC234
          LINE-NBR                                               IC24.1  IC24.2
          COMPONENT-SEQ                                          IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC47.1  IC500
                                                                 IC83.1  IC90.1
                                                                 ICI3.1  POIJ.1
                                                                 RQ11.1  WH130
                                                                 ...

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                                   DR100   IC120
          LOCATION      Where RECEIVED-QTY != USED-QTY           IC141   IC142
          ITEM                                                   IC170   IC175
          RECEIVED-DATE*                                         IC20.1  IC20.2
          RECEIVED-TIME*                                         IC21.1  IC21.2
          DOCUMENT                                               IC22.1  IC22.2
          DOC-TYPE                                               IC222   IC227
          SYSTEM-CD                                              IC228   IC23.1
          LINE-NBR                                               IC23.2  IC24.1
          COMPONENT-SEQ                                          IC24.2  IC25.1
                                                                 IC28.1  IC500
                                                                 IC530   IC83.1
                                                                 IC90.1  ICI3.1
                                                                 POIJ.1  RQ11.1
                                                                 WH130   WH33.1
                                                                 ...

                         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