Lawson Insight Technical Documentation |
|
ICACTIVITY
ICACTIVITY FILE
Pre-Released Document Header
The Pre-Released Document Header file is a temporary record created at the
time a document is added by any of the transaction entry forms. It is deleted
when the document is released.
REFERENCED BY
IC190 IC199 IC222 IC29.1 IC29.2 IC29.3
POI4.1 POI6.1 IC221 IC48.1
UPDATED BY
BL92.1 DR100 IC110 IC138 IC141 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC23.1
IC23.2 IC24.1 IC24.2 IC25.1 IC500 IC90.1
OE114 WH130 WH132 WH190 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
IAC-COMPANY Numeric 4 BL92.1 DR100
Element: Company Identifies the AP company if the IC138 IC141
resource type = V. Identifies the HR IC20.1 IC20.2
company if the resource type = E. It is IC21.1 IC21.2
blank for type A, P or Q resources. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
IC90.1 OE114
WH130 WH132
WH190 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
IAC-LOCATION Alpha 5 BL92.1 DR100
Element: Location Code This field contains a valid stocking IC138 IC141
location within the company inventory. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
IC90.1 OE114
WH130 WH132
WH190 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
IAC-DOC-TYPE Alpha 2 BL92.1 DR100
Element: Document Type This field indicates the type of IC138 IC141
transaction. IC20.1 IC20.2
AJ = Adjustment IC21.1 IC21.2
BT = Bin Transfer IC22.1 IC22.2
IR = Intransit Receiving IC23.1 IC23.2
IS = Issue IC24.1 IC24.2
IT = Issue Transfer IC25.1 IC500
RC = Receipt IC90.1 OE114
WH130 WH132
WH190 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
IAC-DOCUMENT Alpha 10 (Right Justified) BL92.1 DR100
Element: Document ID This field contains the document ID, IC138 IC141
which is used as a reference number to IC20.1 IC20.2
identify transaction(s). IC21.1 IC21.2
IC22.1 IC22.2
Transactions are released (updated) to IC23.1 IC23.2
the Inventory Control system by the IC24.1 IC24.2
document ID. IC500 IC90.1
OE114 WH130
WH132 WH190
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
IAC-TRANS-DATE Numeric 8 (yyyymmdd) BL92.1 DR100
Element: Transaction DaThis field contains the date the IC138 IC141
transaction was created. This date can IC20.1 IC20.2
be earlier than or equal to the current IC21.1 IC21.2
system date. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
IC90.1 OE114
WH130 WH132
WH190 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
IAC-GL-DATE Numeric 8 (yyyymmdd) BL92.1 DR100
Element: General LedgerThis field contains the general ledger IC138 IC141
posting date. This date indicates which IC20.1 IC20.2
general ledger period to post IC21.1 IC21.2
transactions. IC22.1 IC22.2
IC23.1 IC23.2
Transactions can be posted to any open IC24.1 IC24.2
general ledger period if this date is IC25.1 IC500
within 35 days (before or after) the OE114 WH130
current inventory period defined in WH132 WH190
IC01.2 (Dates). Also, If the subsystem WH30.1 WH30.2
is used, the general ledger posting date WH30.3 WH30.4
can be controlled using a date range WH31.1 WH31.2
defined for the General Ledger system. WH31.3 WH31.4
WH32.1 WH32.2
Transactions are passed to the General WH32.3 WH32.4
Ledger system by running IC130 (General WH33.1 WH33.2
Ledger Interface) or another system's WH33.3 WH33.4
general ledger interface form. WH33.5 WH33.6
WH33.8 WH33.9
If this date is earlier than the WH34.1 WH34.2
current general ledger period, WH34.3 WH34.4
transactions are backposted if the WH40.1 WH40.2
appropriate general ledger period is WH520 WH830
open. Otherwise, transactions post to
the current period.
If this date is later than the current
general ledger period, transactions
remain on the General Ledger file until
the appropriate general ledger period
becomes current.
IAC-EST-DEL-DATE Numeric 8 (yyyymmdd) BL92.1 DR100
Estimated Delivery This field is used for intransit IC138 IC141
Date transfers to indicate the estimated date IC22.1 IC22.2
of delivery. IC500 OE114
WH130 WH132
WH190 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
IAC-DOC-TOTAL Signed 13.4 BL92.1 DR100
Element: Document TotalThis field contains the sum of all the IC138 IC141
item quantities for a document. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
IC90.1 OE114
WH130 WH132
WH190 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
IAC-FROM-TO-LOC Alpha 5 BL92.1 DR100
Element: Location Code This field contains either the from or IC138 IC141
to location code for a transfer IC21.1 IC21.2
document. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
OE114 WH130
WH132 WH190
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
IAC-INTRANSIT-FL Alpha 1 BL92.1 DR100
Element: Intransit FlagThis field indicates whether the IC138 IC141
transfer is immediate or intransit. IC20.1 IC20.2
Y = Yes IC22.1 IC22.2
N = No IC23.1 IC23.2
IC24.2 IC500
OE114 WH130
WH132 WH190
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
IAC-RT-DOCUMENT Alpha 10 (Right Justified) BL92.1 DR100
Element: Document ID This field contains the name of the IC138 IC141
document at the receiving side of the IC23.1 IC23.2
transfer. IC25.1 IC500
OE114 WH130
WH132 WH190
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
IAC-REPRINT-FL Alpha 1 BL92.1 DR100
Element: All Flag This field indicates whether the IC110 IC138
document is to be included (adjusted by IC141 IC23.1
any receivings) on the next run of IC23.2 IC500
Intransit Shipping (IC110). OE114 WH130
N = No WH132 WH190
Y = Yes 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
IAC-CARTONS Numeric 6 BL92.1 DR100
Element: Number of CartThis field contains the number of IC138 IC141
cartons included in a transfer. This IC22.1 IC22.2
helps in verifying receipt of intransit IC500 OE114
items. WH130 WH132
WH190 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
IAC-LINE-NBR Numeric 6 BL92.1 DR100
Element: Line Number This field contains the number assigned IC138 IC141
to the last detail transaction line of IC20.1 IC20.2
this document. IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC500 IC90.1
OE114 WH130
WH132 WH190
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
IAC-ACTUAL-TIME Numeric 4 BL92.1 DR100
Element: Actual Time This field contains the actual time the IC138 IC141
transaction was created. If left blank, IC20.1 IC20.2
this field defaults to the current IC21.1 IC21.2
system time. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
OE114 WH130
WH132 WH190
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
IAC-FROM-TO-CMPY Numeric 4 BL92.1 DR100
Element: Company This field contains the from or to IC138 IC141
company for an inter-company transfer IC20.1 IC20.2
document. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
OE114 WH130
WH132 WH190
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
ICACTIVITY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IACSET1 COMPANY BL92.1 DR100
LOCATION IC138 IC141
DOC-TYPE IC190 IC199
DOCUMENT IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC222 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC25.1 IC29.1
IC29.2 IC29.3
IC500 IC90.1
OE114 POI4.1
POI6.1 WH130
...
IACSET2 COMPANY Subset IC110 IC22.2
LOCATION Where (DOC-TYPE = "IR" ) IC221 IC23.1
DOCUMENT IC23.2 IC48.1
ICACTIVITY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
IAC-COMPANY -> ICC-COMPANY
Location ICLOCATION Not Required
IAC-COMPANY -> ICL-COMPANY
IAC-LOCATION -> ICL-LOCATION
ICACTIVITY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ictrans ICTRANS
IAC-COMPANY -> ICT-COMPANY
IAC-LOCATION -> ICT-LOCATION
IAC-DOC-TYPE -> ICT-DOC-TYPE
"IC" -> ICT-SYSTEM-CD
IAC-DOCUMENT -> ICT-DOCUMENT
Zeroes -> ICT-SHIPMENT-NBR
ICT-LINE-NBR
ICT-COMPONENT-SEQ
|