KCRT_REQ_HEADER_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.

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_REQUESTS_INT) of the parent table being imported.

REQ_HEADER_DETAIL_ID

I/O

NUMBER

Identifies the header detail ID for the request.

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

REQUEST_ID

I/O

NUMBER

Identifies the request.

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

REQUEST_TYPE_ID

I/O

NUMBER

Identifies the request type.

This is normally left blank and is derived from 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.

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.