KDLV_TRANSACTIONS_INT

This table as well as other interface tables will be processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allow for scheduled processing.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KDLV_PACKAGES

PACKAGE_ID

PACKAGE_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

WORKFLOW_STEP_ID

KDLV_PACKAGE_LINES

PACKAGE_LINE_ID

PACKAGE_LINE_ID

KNTA_USERS

USER_ID

CREATED_BY

KWFL_WORKFLOW_INSTANCE_STEPS

WORKFLOW_INSTANCE_STEP_ID

WORKFLOW_INSTANCE_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TRANSACTION_INTERFACE_ID

NULLABLE

NUMBER

System-generated identifier

GROUP_ID

NULLABLE

NUMBER

Common column among interface tables.This value is used to tie records in the interface tables together. Most of database processing is done based on this value

PROCESS_PHASE

NULLABLE

NUMBER

Common column, indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed

PROCESS_STATUS

NULLABLE

NUMBER

Common column, indicates the current status of the interface record: Pending, In Process, Errored or Completed

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

CREATED_BY_USERNAME

NULLABLE

VARCHAR2(200)

Username that creates the record

CREATION_DATE

NULLABLE

DATE

Date record was created

SOURCE_CODE

NULLABLE

VARCHAR2(30)

Common column, used to differentiate interface records by their point of origin

PACKAGE_ID

NULLABLE

NUMBER

ID of a Package

PACKAGE_NUMBER

NULLABLE

VARCHAR2(40)

Assigned number of a Package

PACKAGE_LINE_ID

NULLABLE

NUMBER

ID of a Package Line

PACKAGE_LINE_SEQ

NULLABLE

NUMBER

Sequence number of a Package Line

WORKFLOW_INSTANCE_STEP_ID

NULLABLE

NUMBER

ID of an instance of a specific workflow step

WORKFLOW_STEP_ID

NULLABLE

NUMBER

ID of a specific step in a workflow

WORKFLOW_STEP_NAME

NULLABLE

VARCHAR2(80)

Name of a step in a workflow

RESULT_VALUE

NULLABLE

VARCHAR2(200)

Hidden value of a workflow status

VISIBLE_RESULT_VALUE

NULLABLE

VARCHAR2(200)

Visible value of a workflow status

EXECUTE_FLAG

NULLABLE

VARCHAR2(1)

Whether or not a specific step is executable

COMMENTS

NULLABLE

VARCHAR2(2000)

Comments

SCHEDULE_DATE

NULLABLE

DATE

Scheduled date for transaction

Indexes

Index Name

Index Type

Sequence

Column Name

KDLV_TRANSACTIONS_INT_N1

NONUNIQUE

1

TRANSACTION_INTERFACE_ID

KDLV_TRANSACTIONS_INT_N2

NONUNIQUE

1

GROUP_ID

KDLV_TRANSACTIONS_INT_N2

NONUNIQUE

2

TRANSACTION_INTERFACE_ID

KDLV_TRANSACTIONS_INT_N3

NONUNIQUE

1

PACKAGE_NUMBER

Sequences

This table uses no sequences.