KCRT_REQ_HEADER_DETAILS

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

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQ_HEADER_DETAIL_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

REQUEST_ID

NOT NULL

NUMBER

Unique identifier that identifies which request the header details belong to

REQUEST_TYPE_ID

NOT NULL

NUMBER

Unique identifier that identifies the type of request this header details belongs to

BATCH_NUMBER

NOT NULL

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

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_REQ_HEADER_DETAILS_U1

UNIQUE

1

REQ_HEADER_DETAIL_ID

KCRT_REQ_HEADER_DETAILS_U2

UNIQUE

1

REQUEST_ID

KCRT_REQ_HEADER_DETAILS_U2

UNIQUE

2

REQUEST_TYPE_ID

KCRT_REQ_HEADER_DETAILS_U2

UNIQUE

3

BATCH_NUMBER

Sequences

Sequence Name

Sequence Type

KCRT_REQ_HEADER_DETAILS_S

REQ_HEADER_DETAIL_ID