TRANSACTION_INTERFACE_ID

I/O

NUMBER

System-generated identifier

GROUP_ID

I/O

NUMBER

Groups all the records that should be processed at the same time.

Use only one GROUP_ID each time you run a report.

Derived from the KNTA_INTERFACE_GROUPS_S sequence.

PROCESS_PHASE

I/O

NUMBER

Indicates the current stage of the record as it is being processed.

See Process State Information for details.

PROCESS_STATUS

I/O

NUMBER

Indicates the current disposition of the record.

See Process State Information for details.

CREATED_BY

I/O

NUMBER

Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction.

If left blank, the value is derived from CREATED_BY_USERNAME.

CREATED_BY_USERNAME

I/O

VARCHAR2

Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction.

This is used only if CREATED_BY is left blank.

If both are left blank, the value is set to the user currently running the report.

CREATION_DATE

I/O

DATE

Indicates the date that the record was created.

If left blank, the current date is used.

SOURCE_CODE

I/O

VARCHAR2

Provides the identify of the source of the record.

This value is not validated and is for informational purposes only.

PACKAGE_ID

I/O

NUMBER

Provides an identifier for a package and makes the association between the package and package lines.

Derived from the KDLV_PACKAGES_S sequence.

For lines tied to a new package, this column can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records.

For new lines to be imported into existing packages, this column should refer to the PACKAGE_ID of the existing package.

PACKAGE_NUMBER

I/O

VARCHAR2

Identifies the package number.

This must use either the same value as PACKAGE_ID or a unique string.

PACKAGE_LINE_ID

I/O

NUMBER

Provides the identifier for a package line.

This is normally left blank and the value is derived from the KDLV_PACKAGE_LINES_S sequence.

PACKAGE_LINE_SEQ

I/O

NUMBER

Provides the identifier for a package line.

Derived from the KDLV_PACKAGE_LINES_S sequence.

Use if the transaction is for a package line.

WORKFLOW_INSTANCE_STEP_ID

I/O

NUMBER

Specifies the instance step ID.

WORKFLOW_STEP_ID

I/O

NUMBER

Specifies the workflow step ID (WORKFLOW_STEP_ID from KWFL_WORKFLOW_STEPS).

Supply this, WORKFLOW_STEP_NAME, or WORKFLOW_STEP_SEQ.

WORKFLOW_STEP_NAME

I/O

VARCHAR2

Specifies the name of the workflow step (STEP_NAME from KWFL_WORKFLOW_STEPS).

Supply this or P_WORKFLOW_STEP_SEQ.

RESULT_VALUE

I/O

VARCHAR2

Indicates the result of the step. This is normally not displayed to the user; therefore it may be an ID or internal code.

VISIBLE_RESULT_VALUE

I/O

VARCHAR2

Indicates the result of the step. This is the result value that a user normally sees.

EXECUTE_FLAG

I/O

VARCHAR2

Indicates whether or not a specific step is executable.

COMMENTS

I/O

VARCHAR2

Specifies comments for the transaction. Any comments are appended to the notes for the package or request.

SCHEDULE_DATE

I/O

DATE

Indicates the date that the execution step is scheduled to run.