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
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 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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
Company The company number represents an IC138 IC141
established company and is entered on IC20.1 IC20.2
all functions codes. 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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
Location Code This field contains a valid stock 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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
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
CA = Cost Adjustment IC23.1 IC23.2
IR = Intransit Receiving IC24.1 IC24.2
IS = Issue IC25.1 IC500
IT = Transfer Issue IC90.1 OE114
RC = Receipt WH130 WH132
RT = Transfer Receipt WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
Transaction Date This 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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
General Ledger Date This 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 WH31.1
can be controlled using a date range WH31.2 WH31.3
defined for the General Ledger system. WH32.1 WH32.2
WH32.3 WH33.1
Transactions are passed to the General WH33.2 WH33.3
Ledger system by running IC130 (General WH33.4 WH33.5
Ledger Interface) or another system's WH33.6 WH33.8
general ledger interface form. WH33.9 WH34.1
WH34.2 WH34.3
If this date is earlier than the WH34.4 WH40.1
current general ledger period, WH40.2 WH520
transactions are backposted if the 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) 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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
Document Total This 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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
From or To Location 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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
Intransit Flag This field indicates whether the IC138 IC141
transfer is immediate or intransit. IC20.1 IC20.2
Y = Yes IC22.1 IC22.2
IC23.1 IC23.2
IC24.2 IC500
OE114 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
Intransit Receiving This field contains the name of the IC138 IC141
Document 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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
Reprint 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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
Number of Cartons This 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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
From or To 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 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WH130
WH132 WH190
...
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
Mmuaval MMUAVAL Not Required
IAC-COMPANY -> MUA-COMPANY
"IC" -> MUA-SYSTEM-CD
IAC-LOCATION -> MUA-LOCATION
IAC-DOC-TYPE -> MUA-DOC-TYPE
IAC-DOCUMENT -> MUA-DOC-NBR
Zeroes -> MUA-DOC-NBR-NUM
Zeroes -> MUA-LINE-NBR
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
|