KCRT_TABLE_ENTRIES_INT

The KCRT_TABLE_ENTRIES_INT interface table specifies the table fields defined in the request type for the request.

Table A-20. KCRT_TABLE_ENTRIES_INT interface table

Column

Usage

Data Type

Description

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.

This value should be the same as the parent's GROUP_ID in KCRT_REQUEST_INT.

TRANSACTION_ID

I

NUMBER

Uniquely identifies each transaction.

PARENT_TRANSACTION_ID

I

NUMBER

Provides the transaction ID (from KCRT_REQUEST_DETAILS_INT) of the parent table being imported.

PARENT_FIELD_TOKEN

I

VARCHAR2

Specifies the token.

TABLE_ENTRY_ID

I/O

NUMBER

Identifies the table entry record.

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

REQUEST_ID

I/O

NUMBER

Identifies the request.

This is normally left blank and is derived from the KCRT_REQUESTS_S sequence.

PARAMETER_SET_FIELD_ID

I/O

NUMBER

Specifies the field in the table to which this entry belongs.

SEQ

I

NUMBER

Provides a user-visible sequence number for the package line.

This must be a unique, positive integer that does not conflict with other records being imported.

PARAMETER_SET_CONTEXT_ID

I/O

NUMBER

Sets the context identifier for the detail fields.

If left blank, the value is derived from the REQUEST_TYPE_NAME.

VISIBLE_PARAMETER1

PARAMETER1

through

VISIBLE_PARAMETER50

PARAMETER50

I

VARCHAR2

Specifies the user-defined fields attached to the user screen.

This is required only if user data is defined.

LOOKUP_TYPE1

through

LOOKUP_TYPE50

I

VARCHAR2

Identifies the lookup type for each PARAMETER.

This is required only if user data is defined.

VALIDATION_TYPE_CODE1

through

VALIDATION_TYPE_CODE50

I

VARCHAR2

Identifies the validation type code for each PARAMETER.

This is required only if user data is defined.