# DW_CONTRACT_TYPE_D (Preview)

This table requires activation of Procurement Contracts functional area. This table stores contract types information used to create contracts.

## Details

Module: Procurement Contracts

## Key Columns

CONTRACT_TYPE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CONTRACT_TYPE_ID | NUMBER | 38 | 0 | True | Contract Type Identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. System Identifier |  |
CONTRACT_CLASS | VARCHAR2 | 32 |  |  | Contract Class | DW_OKC_CONTRACT_CLASS_LKP_TL | OKC_CONTRACT_CLASS_CODE
START_DATE | DATE |  |  |  | Contract type start date. |  |
END_DATE | DATE |  |  |  | Contract type end date. |  |
ALLOW_LINES_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate lines are allowed for a contract type. |  |
INTENT | VARCHAR2 | 32 |  |  | Intent of the contract type. | DW_OKC_SETUP_INTENT_LKP_TL | OKC_SETUP_INTENT_CODE

Copyright © 2019, 2025, Oracle and/or its affiliates.