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
POI6.1


UPDATED BY
POI4.1

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.
IAC-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
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
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.
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.
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.
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.
IAC-DOC-TOTAL
Element: Doc Total
Signed 13.4
This field contains the sum of all the item quantities for a document.
IAC-FROM-TO-LOC
Element: Location
Alpha 5
This field contains either the from or to location code for a transfer document.
IAC-INTRANSIT-FL
Element: Intransit Fl
Alpha 1
This field indicates whether the transfer is immediate or intransit.
Y = Yes
N = No
IAC-RT-DOCUMENT
Element: Document
Alpha 10 (Right Justified)
This field contains the name of the document at the receiving side of the transfer.
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
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.
IAC-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the number assigned to the last detail transaction line of this document.
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.
IAC-FROM-TO-CMPY
Element: Company
Numeric 4
This field contains the from or to company for an inter-company transfer document.


ICACTIVITY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IACSET1 COMPANY
LOCATION
DOC-TYPE
DOCUMENT
POI4.1 POI6.1
IACSET2 COMPANY
LOCATION
DOCUMENT
Subset
Where(DOC-TYPE ="IR")


ICACTIVITY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
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: Wed Jun 08 20:49:37 2016

Home
Contact Us



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