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
WHD1.1 WHD2.1 IC221 IC48.1
UPDATED BY
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 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 DR100 IC138
Element: Company The company number represents an IC141 IC20.1
established company and is entered on IC20.2 IC21.1
all function codes. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC90.1
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 DR100 IC138
Element: Location Code This field contains a valid stocking IC141 IC20.1
location within the company inventory. IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC90.1
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 DR100 IC138
Element: Document Type This field indicates the type of IC141 IC20.1
transaction. IC20.2 IC21.1
AJ = Adjustment IC21.2 IC22.1
BT = Bin Transfer IC22.2 IC23.1
IR = Intransit Receiving IC23.2 IC24.1
IS = Issue IC24.2 IC25.1
IT = Issue Transfer IC500 IC90.1
RC = Receipt 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) DR100 IC138
Element: Document ID This field contains the document ID, IC141 IC20.1
which is used as a reference number to IC20.2 IC21.1
identify transaction(s). IC21.2 IC22.1
IC22.2 IC23.1
Transactions are released (updated) to IC23.2 IC24.1
the Inventory Control system by the IC24.2 IC500
document ID. IC90.1 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) DR100 IC138
Element: Date This field contains the date the IC141 IC20.1
transaction was created. This date can IC20.2 IC21.1
be earlier than or equal to the current IC21.2 IC22.1
system date. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC90.1
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) DR100 IC138
Element: Date This field contains the general ledger IC141 IC20.1
posting date. This date indicates which IC20.2 IC21.1
general ledger period to post IC21.2 IC22.1
transactions. IC22.2 IC23.1
IC23.2 IC24.1
Transactions can be posted to any open IC24.2 IC25.1
general ledger period if this date is IC500 WH130
within 35 days (before or after) the WH132 WH190
current inventory period defined in WH30.1 WH30.2
IC01.2 (Dates). Also, If the subsystem WH30.3 WH30.4
is used, the general ledger posting date WH31.1 WH31.2
can be controlled using a date range WH31.3 WH31.4
defined for the General Ledger system. WH32.1 WH32.2
WH32.3 WH32.4
Transactions are passed to the General WH33.1 WH33.2
Ledger system by running IC130 (General WH33.3 WH33.4
Ledger Interface) or another system's WH33.5 WH33.6
general ledger interface form. WH33.8 WH33.9
WH34.1 WH34.2
If this date is earlier than the WH34.3 WH34.4
current general ledger period, WH40.1 WH40.2
transactions are backposted if the WH520 WH830
appropriate general ledger period is
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) DR100 IC138
Element: Date This field is used for intransit IC141 IC22.1
transfers to indicate the estimated date IC22.2 IC500
of delivery. 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 DR100 IC138
Element: Document TotalThis field contains the sum of all the IC141 IC20.1
item quantities for a document. IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC90.1
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 DR100 IC138
Element: Location Code This field contains either the from or IC141 IC21.1
to location code for a transfer IC21.2 IC22.1
document. IC22.2 IC23.1
IC23.2 IC25.1
IC500 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 DR100 IC138
Element: Intransit FlagThis field indicates whether the IC141 IC20.1
transfer is immediate or intransit. IC20.2 IC22.1
Y = Yes IC22.2 IC23.1
N = No IC23.2 IC24.2
IC500 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) DR100 IC138
Element: Document ID This field contains the name of the IC141 IC23.1
document at the receiving side of the IC23.2 IC25.1
transfer. IC500 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 DR100 IC110
Element: All Flag This field indicates whether the IC138 IC141
document is to be included (adjusted by IC23.1 IC23.2
any receivings) on the next run of IC500 WH130
Intransit Shipping (IC110). WH132 WH190
N = No WH30.1 WH30.2
Y = Yes 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 DR100 IC138
Element: Number of CartThis field contains the number of IC141 IC22.1
cartons included in a transfer. This IC22.2 IC500
helps in verifying receipt of intransit WH130 WH132
items. 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 DR100 IC138
Element: Line Number This field contains the number assigned IC141 IC20.1
to the last detail transaction line of IC20.2 IC21.1
this document. IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC500
IC90.1 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 DR100 IC138
Element: Actual Time This field contains the actual time the IC141 IC20.1
transaction was created. If left blank, IC20.2 IC21.1
this field defaults to the current IC21.2 IC22.1
system time. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 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 DR100 IC138
Element: Company This field contains the from or to IC141 IC20.1
company for an inter-company transfer IC20.2 IC21.1
document. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 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 DR100 IC138
LOCATION IC141 IC190
DOC-TYPE IC199 IC20.1
DOCUMENT 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 WH130
WH132 WH190
WH30.1 WH30.2
...
IACSET2 COMPANY Subset IC110 IC22.2
LOCATION Where (DOC-TYPE = "IR" ) IC221 IC23.1
DOCUMENT IC23.2 IC48.1
IC90.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
|