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 POI4.1 POI6.1 WHD1.1 WHD2.1
UPDATED BY
BL92.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 BL92.1 WH130
Element: Company Identifies the AP company if the WH132 WH190
resource type = V. Identifies the HR WH30.1 WH30.2
company if the resource type = E. It is WH30.3 WH30.4
blank for type A, P or Q resources. 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 WH130
Element: Location This field contains a valid stocking WH132 WH190
location within the company inventory. 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 WH130
Element: Doc Type This field indicates the type of WH132 WH190
transaction. WH30.1 WH30.2
AJ = Adjustment WH30.3 WH30.4
BT = Bin Transfer WH31.1 WH31.2
IR = Intransit Receiving WH31.3 WH31.4
IS = Issue WH32.1 WH32.2
IT = Issue Transfer WH32.3 WH32.4
RC = Receipt 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 WH130
Element: Document This field contains the document ID, WH132 WH190
which is used as a reference number to WH30.1 WH30.2
identify transaction(s). WH30.3 WH30.4
WH31.1 WH31.2
Transactions are released (updated) to WH31.3 WH31.4
the Inventory Control system by the WH32.1 WH32.2
document ID. 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 WH130
Element: Trans Date This field contains the date the WH132 WH190
transaction was created. This date can WH30.1 WH30.2
be earlier than or equal to the current WH30.3 WH30.4
system date. 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 WH130
Element: Gl Date This field contains the general ledger WH132 WH190
posting date. This date indicates which WH30.1 WH30.2
general ledger period to post WH30.3 WH30.4
transactions. WH31.1 WH31.2
WH31.3 WH31.4
Transactions can be posted to any open WH32.1 WH32.2
general ledger period if this date is WH32.3 WH32.4
within 35 days (before or after) the WH33.1 WH33.2
current inventory period defined in WH33.3 WH33.4
IC01.2 (Dates). Also, If the subsystem WH33.5 WH33.6
is used, the general ledger posting date WH33.8 WH33.9
can be controlled using a date range WH34.1 WH34.2
defined for the General Ledger system. WH34.3 WH34.4
WH40.1 WH40.2
Transactions are passed to the General WH520 WH830
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.
IAC-EST-DEL-DATE Numeric 8 (yyyymmdd) BL92.1 WH130
Element: Est Del Date This field is used for intransit WH132 WH190
transfers to indicate the estimated date WH30.1 WH30.2
of delivery. 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 WH130
Element: Doc Total This field contains the sum of all the WH132 WH190
item quantities for a document. 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 WH130
Element: Location This field contains either the from or WH132 WH190
to location code for a transfer WH30.1 WH30.2
document. 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 WH130
Element: Intransit Fl This field indicates whether the WH132 WH190
transfer is immediate or intransit. WH30.1 WH30.2
Y = Yes WH30.3 WH30.4
N = No 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 WH130
Element: Document This field contains the name of the WH132 WH190
document at the receiving side of the WH30.1 WH30.2
transfer. 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 WH130
Element: All Flag This field indicates whether the WH132 WH190
document is to be included (adjusted by WH30.1 WH30.2
any receivings) on the next run of WH30.3 WH30.4
Intransit Shipping (IC110). WH31.1 WH31.2
N = No WH31.3 WH31.4
Y = Yes 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 WH130
Element: Cartons This field contains the number of WH132 WH190
cartons included in a transfer. This WH30.1 WH30.2
helps in verifying receipt of intransit WH30.3 WH30.4
items. 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 WH130
Element: Line Nbr This field contains the number assigned WH132 WH190
to the last detail transaction line of WH30.1 WH30.2
this document. 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 WH130
Element: Actual Time This field contains the actual time the WH132 WH190
transaction was created. If left blank, WH30.1 WH30.2
this field defaults to the current WH30.3 WH30.4
system time. 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 WH130
Element: Company This field contains the from or to WH132 WH190
company for an inter-company transfer WH30.1 WH30.2
document. 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 IC190
LOCATION POI4.1 POI6.1
DOC-TYPE WH130 WH132
DOCUMENT 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
...
IACSET2 COMPANY Subset
LOCATION Where (DOC-TYPE = "IR" )
DOCUMENT
ICACTIVITY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
IAC-COMPANY -> ICC-COMPANY (ICCSET1)
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
|