KCRT_REQUEST_DETAILS_INT

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.

TRANSACTION_ID

I

NUMBER

Uniquely identifies each transaction.

PARENT_TRANSACTION_ID

I

NUMBER

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

REQUEST_DETAIL_ID

I/O

NUMBER

Identifies the detail ID of the request (from KCRT_REQUEST_DETAILS).

REQUEST_ID

I/O

NUMBER

Identifies the request.

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

REQUEST_TYPE_ID

I/O

NUMBER

Identifies the request type.

If left blank, the value is derived from REQUEST_TYPE_NAME.

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.

BATCH_NUMBER

I

NUMBER

Specifies the batch number for the custom fields.

This corresponds to the Storage tab in the field definition window on the request type.

PARAMETER1

VISIBLE_PARAMETER1

through

PARAMETER50

VISIBLE_PARAMETER50

I

VARCHAR2

Specifies the values for all the custom fields defined in the request. Values do not need to be entered.

LOOKUP_TYPE1

VALIDATION_TYPE_CODE1

through

LOOKUP_TYPE50

VALIDATION_TYPE_CODE50

I

VARCHAR2

VARCHAR2

Identifies the lookup type for each PARAMETER and the validation type code for each PARAMETER.

This is required only if custom data is defined.