ICACTIVITY – Pre-Released Document Header

System
Inventory Control (IC)
Prefix
IAC
Primary key
COMPANY, LOCATION, DOC-TYPE, DOCUMENT
Fields
16
Updated by
50 programs
Referenced by
41 programs

ICACTIVITY is the Pre-Released Document Header table in Lawson Inventory Control (prefix IAC). It is indexed by COMPANY, LOCATION, DOC-TYPE, DOCUMENT (IACSET1); alternate indexes: IACSET2. It is related 1:1 to ICCOMPANY and ICLOCATION and 1:M to ICTRANS. It is updated by DR100, IC110, IC138, IC141, IC20.1, IC20.2, IC21.1, IC21.2 and 42 more and referenced by IC02.1, IC10.2, IC11.1, IC12.1, IC15.2, IC175, IC183, IC190 and 33 more. The table has 16 fields, 2 indexes and 3 documented relations.

About ICACTIVITY

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.

Fields (16)

Column = COBOL field name without the IAC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
IAC-COMPANY PK
COMPANY		Numeric 4Identifies 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 +40 more
IAC-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.DR100, IC138, IC141, IC20.1, IC20.2, IC21.1, IC21.2, IC22.1 +40 more
IAC-DOC-TYPE PK
DOC_TYPE		Alpha 2This 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 +40 more
IAC-DOCUMENT PK
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 +39 more
IAC-TRANS-DATE
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 +40 more
IAC-GL-DATE
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 +39 more
IAC-EST-DEL-DATE
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 +30 more
IAC-DOC-TOTAL
DOC_TOTAL		Signed 13.4This 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 +41 more
IAC-FROM-TO-LOC
FROM_TO_LOC		Alpha 5This 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 +35 more
IAC-INTRANSIT-FL
INTRANSIT_FL		Alpha 1This 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 +35 more
IAC-RT-DOCUMENT
RT_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 +31 more
IAC-REPRINT-FL
REPRINT_FL		Alpha 1This 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 +31 more
IAC-CARTONS
CARTONS		Numeric 6This 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 +30 more
IAC-LINE-NBR
LINE_NBR		Numeric 6This 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 +37 more
IAC-ACTUAL-TIME
ACTUAL_TIME		Numeric 4This 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 +39 more
IAC-FROM-TO-CMPY
FROM_TO_CMPY		Numeric 4This 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 +39 more

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IACSET1COMPANY, LOCATION, DOC-TYPE, DOCUMENTPrimaryDR100, IC02.1, IC10.2, IC11.1, IC12.1, IC138, IC141, IC15.2 +22 more (list truncated in source)
IACSET2COMPANY, LOCATION, DOCUMENTSubsetWhere (DOC-TYPE = "IR")IC110, IC22.2, IC221, IC23.1, IC23.2, IC48.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyICCOMPANYRequiredIAC-COMPANY → ICC-COMPANY
LocationICLOCATIONNot RequiredIAC-COMPANY → ICL-COMPANY, IAC-LOCATION → ICL-LOCATION

One to many (1) — child tables

RelationTableRulesConditionField map
IctransICTRANSIAC-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

Programs

Updated by (50)

Referenced by (41)