ICACTIVITY

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
IC02.1 IC10.2 IC11.1 IC12.1 IC15.2 IC175
IC183 IC190 IC199 IC222 IC223 IC29.1
IC29.2 IC29.3 IC320 IC330 IC331 IC503
IC524 IC58.1 IC62.1 IC64.2 IC81.1 IC811
IC812 IC82.1 IC840 PO150 PO25.6 PO25.7
PO26.4 PO26.5 PO28.2 PO36.2 PO536 POI4.1
POI6.1 WHD1.1 WHD2.1 IC221 IC48.1


UPDATED BY
DR100 IC110 IC138 IC141 IC20.1 IC20.2
IC21.1 IC21.2 IC21.5 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 WH32.5 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
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
DR100 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 WH32.5
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
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
DR100 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 WH32.5
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
Element: Doc Type
Alpha 2
This field indicates the type of transaction.
AJ = Adjustment
BT = Bin Transfer
IR = Intransit Receiving
IS = Issue
IT = Issue Transfer
RC = Receipt
DR100 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 WH32.5
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
Element: Document
Alpha 10 (Right Justified)
This field contains the document ID, which is used as a reference number to identify transaction(s). Transactions are released (updated) to the Inventory Control system by the document ID.
DR100 IC138
IC141 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.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
WH32.5 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
Element: Trans Date
Numeric 8 (yyyymmdd)
This field contains the date the transaction was created. This date can be earlier than or equal to the current system date.
DR100 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 WH32.5
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
Element: Gl Date
Numeric 8 (yyyymmdd)
This field contains the general ledger posting date. This date indicates which general ledger period to post transactions. Transactions can be posted to any open general ledger period if this date is within 35 days (before or after) the current inventory period defined in IC01.2 (Dates). Also, If the subsystem is used, the general ledger posting date can be controlled using a date range defined for the General Ledger system. Transactions are passed to the General Ledger system by running IC130 (General Ledger Interface) or another system's general ledger interface form. If this date is earlier than the current general ledger period, transactions are backposted if the 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.
DR100 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 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
WH32.5 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-EST-DEL-DATE
Element: Est Del Date
Numeric 8 (yyyymmdd)
This field is used for intransit transfers to indicate the estimated date of delivery.
DR100 IC138
IC141 IC22.1
IC22.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 WH32.5
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
Element: Doc Total
Signed 13.4
This field contains the sum of all the item quantities for a document.
DR100 IC138
IC141 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
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
WH32.5 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
Element: Location
Alpha 5
This field contains either the from or to location code for a transfer document.
DR100 IC138
IC141 IC21.1
IC21.2 IC22.1
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
WH32.5 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
Element: Intransit Fl
Alpha 1
This field indicates whether the transfer is immediate or intransit.
Y = Yes
N = No
DR100 IC138
IC141 IC20.1
IC20.2 IC22.1
IC22.2 IC23.1
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
WH32.5 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
Element: Document
Alpha 10 (Right Justified)
This field contains the name of the document at the receiving side of the transfer.
DR100 IC138
IC141 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
WH32.5 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
Element: All Flag
Alpha 1
This field indicates whether the document is to be included (adjusted by any receivings) on the next run of Intransit Shipping (IC110).
N = No
Y = Yes
DR100 IC110
IC138 IC141
IC23.1 IC23.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
WH32.5 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
Element: Cartons
Numeric 6
This field contains the number of cartons included in a transfer. This helps in verifying receipt of intransit items.
DR100 IC138
IC141 IC22.1
IC22.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 WH32.5
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
Element: Line Nbr
Numeric 6
This field contains the number assigned to the last detail transaction line of this document.
DR100 IC138
IC141 IC20.1
IC20.2 IC21.1
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
WH32.5 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
Element: Actual Time
Numeric 4
This field contains the actual time the transaction was created. If left blank, this field defaults to the current system time.
DR100 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 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
WH32.5 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
Element: Company
Numeric 4
This field contains the from or to company for an inter-company transfer document.
DR100 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 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
WH32.5 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
LOCATION
DOC-TYPE
DOCUMENT
...
DR100 IC02.1
IC10.2 IC11.1
IC12.1 IC138
IC141 IC15.2
IC175 IC183
IC190 IC199
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC222
IC223 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC25.1 IC29.1
IACSET2 COMPANY
LOCATION
DOCUMENT
Subset
Where(DOC-TYPE ="IR")
IC110 IC22.2
IC221 IC23.1
IC23.2 IC48.1


ICACTIVITY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:18:31 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.