PACKAGE_NOTE_INTERFACE_ID

I/O

NUMBER

Provides a unique identifier for the record.

If left blank, the value is derived from the KDLV_INTERFACES_S sequence.

GROUP_ID

I

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.

PACKAGE_INTERFACE_ID

I

NUMBER

Provides a unique identifier for the each record.

Derived from the KDLV_INTERFACES_S sequence.

This is required if package lines exist. For new lines, this should be left blank.

For lines tied to a new package, this can be used to tie the line record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_NUMBER and PACKAGE_ID columns can be used for this tie as well.

PACKAGE_ID

I

NUMBER

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

Derived from the KDLV_PACKAGES_S sequence.

Identifies the package ID.

This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. Either PACKAGE_INTERFACE_ID and PACKAGE_NUMBER can be used to tie the records.

PACKAGE_NUMBER

I

VARCHAR2

Identifies the package number.

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

This can be used to tie the note record to the parent record in KDLV_PACKAGES_INT. The PACKAGE_INTERFACE_ID and PACKAGE_ID can be used for this tie as well.

PROCESS_PHASE

O

NUMBER

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

See Process State Information for details.

PROCESS_STATUS

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.

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

CREATED_BY_USERNAME

I

VARCHAR2

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

This is used only if CREATED_BY is left blank.

CREATION_DATE

I/O

DATE

Indicates the transaction date.

If left blank, the current date is used.

SOURCE_CODE

I

VARCHAR2

Provides the identify of the source of the record.

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

NOTE

I

CLOB

Specifies the full text of the note.

REPLACE_NOTE_FLAG

Obsolete

VARCHAR2

No longer used.