KCRT_REQ_HEADER_DETAILS_INT

This table stores information about the request header details interface for Demand Management.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUESTS_INT

TRANSACTION_ID

PARENT_TRANSACTION_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KCRT_REQ_HEADER_DETAILS

REQ_HEADER_DETAIL_ID

REQ_HEADER_DETAIL_ID

Column Descriptions

Column Name

Null?

Data Type

Description

GROUP_ID

NOT NULL

NUMBER

System-generated identifier

TRANSACTION_ID

NOT NULL

NUMBER

Transaction identifier

PARENT_TRANSACTION_ID

NOT NULL

NUMBER

Parent transaction identifier

REQ_HEADER_DETAIL_ID

NULLABLE

NUMBER

Unique identifier that identifies the request header details

REQUEST_ID

NULLABLE

NUMBER

Unique identifier for which request the header details belong to

REQUEST_TYPE_ID

NULLABLE

NUMBER

Unique identifier for the type of request this header details belongs to

BATCH_NUMBER

NULLABLE

NUMBER

Data batch number associated with the request

PARAMETER1-40

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

User data segment

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

User data segment

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

User data segment

LOOKUP_TYPE1-50

NULLABLE

VARCHAR2(80)

User data segment

VALIDATION_TYPE_CODE1-50

NULLABLE

VARCHAR2(30)

User data segment

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.