Lawson Insight Technical Documentation |
|
ICRECEIPTS
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 IC44.1 DR100 IC141
IC142 IC182 IC190 IC222 IC233 IC26.1
IC26.2 IC83.1 IC90.1 RQ11.1 RQ500 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQIJ.1 WO30.1 WO40.1
WOEX.1 WOSP.1 IC120 IC170 IC227 IC228
IC530
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 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 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE810 OE830 OE90.1 OE90.2
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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICR-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP25.1
resource type = V. Identifies the HR AP25.2 AP26.1
company if the resource type = E. It is AP27.1 AP30.4
blank for type A, P or Q resources. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field identifies the document from AP131 AP25.1
which this transaction record was AP25.2 AP26.1
created. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-DOC-TYPE Alpha 2 AP125 AP126
Element: Document Type This field contains the type of AP131 AP25.1
transaction. AP25.2 AP26.1
AJ = Adjustment AP27.1 AP30.4
CR = Customer Return BL120 BL122
PI = Physical Inventory Adjustment BL130 BL20.1
PO = PO Receiving BL20.3 BL21.2
RC = Receipt BL21.5 BL29.1
RT = Receiving Transfer BL29.2 BL520
SH = Shipment BL820 BL92.1
RR = Requisition Return 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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Code This field indicates the originating AP131 AP25.1
system of the transaction. AP25.2 AP26.1
IC = Inventory Control AP27.1 AP30.4
PO = Purchase Order BL120 BL122
OE = Order Entry BL130 BL20.1
RQ = Requisitions BL20.3 BL21.2
WO = Work Order BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field displays the system-assigned AP131 AP25.1
transaction number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-COMPONENT-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeThis field contains the component AP131 AP25.1
sequence number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
...
ICR-RECEIVED-QTY Signed 13.4 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-USED-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity that AP131 AP25.1
has been used by outgoing transactions. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
ICR-UNIT-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the actual unit AP131 AP25.1
cost for this incoming transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-RECEIVED-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Received Date This field contains the date when this AP131 AP25.1
transaction record was created. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
ICR-RECEIVED-TIME Numeric 6 (hhmmss) AP125 AP126
Element: Sys Time This field contains the actual time AP131 AP25.1
this receipt took place. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
ICR-LAST-ACT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Activity 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 AP30.4
defaults. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
...
ICR-HOLD-QTY Signed 13.4 AP125 AP126
Element: Quantity This is the quantity of the receipt that AP131 AP25.1
is waiting inspection or it is the AP25.2 AP26.1
quantity that was rejected by an AP27.1 AP30.4
inspection for which a PO vendor return BL120 BL122
was automatically built and is now BL130 BL20.1
waiting for the ship function against BL20.3 BL21.2
the PO vendor return. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
...
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 AP30.4
DOC-TYPE BL120 BL122
SYSTEM-CD BL130 BL20.1
LINE-NBR BL20.3 BL21.2
COMPONENT-SEQ BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
...
ICRSET2 COMPANY IC234 IC300
LOCATION IC44.1 IC47.1
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 AP30.4
RECEIVED-TIME BL120 BL122
DOCUMENT BL130 BL20.1
DOC-TYPE BL20.3 BL21.2
SYSTEM-CD BL21.5 BL29.1
LINE-NBR BL29.2 BL520
COMPONENT-SEQ BL820 BL92.1
DR100 IC141
IC142 IC175
IC182 IC190
IC20.1 IC20.2
IC21.1 IC21.2
...
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 AP30.4
RECEIVED-TIME* BL120 BL122
DOCUMENT BL130 BL20.1
DOC-TYPE BL20.3 BL21.2
SYSTEM-CD BL21.5 BL29.1
LINE-NBR BL29.2 BL520
COMPONENT-SEQ BL820 BL92.1
DR100 IC120
IC141 IC142
IC170 IC175
IC182 IC20.1
IC20.2 IC21.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
|