# DW_CONTRACT_LINE_CF

This table stored the contract line level details.

## Details

Module: Project Billing

## Key Columns

CONTRACT_LINE_ID, MAJOR_VERSION

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CONTRACT_LINE_ID | NUMBER | 38 | 0 | True | Unique identifier of the contract line. | DW_CONTRACT_LINE_TL | CONTRACT_LINE_ID
MAJOR_VERSION | NUMBER | 38 | 0 | True | Major Version Number of the Contract. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | ID of the contract to which this line belongs. | DW_CONTRACT_HEADER_D | CONTRACT_HEADER_ID
VERSION_TYPE | VARCHAR2 | 16 |  |  | Version Type can have 3 values: Current, Amendment, and History. If the version type is not Current then no update is allowed on the entity. |  |
LINE_NUMBER | VARCHAR2 | 256 |  |  | Sequential line number. |  |
CONTRACT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
CONTRACT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifies the Business Unit (that has the Projects function enabled) that will be responsible for developing this contract. Only applies to a contract type with project lines. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
CONTRACT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier for Contract. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
CONTRACT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of Contract | DW_LEDGER_D | LEDGER_ID
LINE_TYPE_ID | NUMBER | 38 | 0 |  | Line type id refers to Line Types setup. | DW_CONTRACT_LINE_TYPE_TL | LINE_TYPE_ID
START_DATE | DATE |  |  |  | The beginning of the active period, one second after midnight on the date indicated. |  |
END_DATE | DATE |  |  |  | The end of the active period, one second before midnight on the date indicated. |  |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The GL period in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | GL Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
BILL_PLAN_ID | NUMBER | 38 | 0 |  | Bill plan identifier. Refers to BILL_PLAN_ID in PJB_BILL_PLANS_B. | DW_CONTRACT_BILL_PLAN_D | BILL_PLAN_ID
REVENUE_PLAN_ID | NUMBER | 38 | 0 |  | Revenue plan identifier. Refers to PJB_BILL_PLANS_B. | DW_CONTRACT_BILL_PLAN_D | BILL_PLAN_ID
PERCENT_COMPLETE | NUMBER |  |  |  | Invoice classification |  |
LINE_AMOUNT | NUMBER |  |  |  | Usually roll up of sublines if any sub lines are present Line Type id determine whether it can be directly updated by the user. |  |
BILL_TO_PARTY_ID | NUMBER | 38 | 0 |  | Party identifier. | DW_PARTY_D | PARTY_ID
BILL_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Bill to Account (Customer Account) for Sell Intent contracts | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
BILL_TO_SITE_USE_ID | NUMBER | 38 | 0 |  | Bill to Site (Customer Account Site Use) for Sell Intent contracts | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
BILL_TO_LOCATION | VARCHAR2 | 256 |  |  | Site use identifier |  |
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
BILL_TO_CONTACT_ID | NUMBER | 38 | 0 |  | Bill to Contact (Customer Account Contact) | DW_PARTY_D | PARTY_ID
SHIP_TO_PARTY_ID | NUMBER | 38 | 0 |  | Ship to Party ID. | DW_PARTY_D | PARTY_ID
SHIP_TO_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Ship to Account (Customer Account) for Sell Intent contracts. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
SHIP_TO_LOCATION | VARCHAR2 | 256 |  |  | Site use identifier |  |
SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Ship to Site (Customer Account Site Use) Location identifier for Sell Intent contracts. | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_SITE_USE_ID | NUMBER | 38 | 0 |  | Ship to Site (Customer Account Site Use) Use identifier for Sell Intent contracts. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
IB_PROVIDER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Provider business unit that belongs to contract LE ***** | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
IB_RCVR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Receiver business unit that belongs to the bill to contact LE of the bill plan | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
IB_RECEIVER_PROJECT_ID | NUMBER | 38 | 0 |  | Receiver project defined on contract line ***** | DW_PROJECT_D | PROJECT_ID
IB_RECEIVER_TASK_ID | NUMBER | 38 | 0 |  | Receiver task defined on contract line ***** | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
IB_RECEIVER_EXPENDITURE_ORG_ID | NUMBER | 38 | 0 |  | Receiver expenditure org defined on contract line ***** | DW_INTERNAL_ORG_D | ORGANIZATION_ID
IB_RECEIVER_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Receiver expenditure type defined on contract line ***** | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
IB_EXP_TYPE_ORIG_EI_FLAG | VARCHAR2 | 16 |  |  | If the flag is 'Y', set the Expenditure Type on the internal AP invoice line to the Expenditure Type on the original provider expenditure item | DW_Y_N_D_TL | CODE
IB_EXP_ORG_SOURCE | VARCHAR2 | 32 |  |  | Optional Y/N flag. If the flag is 'Y', set Expenditure Org on the IC AP invoice line to Task-owning Org of the expenditure item | DW_Y_N_D_TL | CODE
STATUS_CODE | VARCHAR2 | 32 |  |  | User status of the contract. | DW_OKC_STATUS_LKP_TL | OKC_STATUS_CODE
TRN_CODE | VARCHAR2 | 32 |  |  | Line Termination Code. Refers to LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE IS OKC_TERMINATION_REASON. | DW_CONTRACT_TRN_CODE_LKP_TL | OKC_TRN_CODE
UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure YR(Year) or Ea(Each). | DW_PROJECT_UNIT_OF_MEASURE_TL | UOM_CODE
CONTRACT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Contract's transaction currency. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_RATE_TYPE | VARCHAR2 | 32 |  |  | Rate type used to convert costs from the contract currency to the Global currency. | DW_CONVERSION_RATE_TYPE_D | CONVERSION_TYPE
GLOBAL_RATE_DATE | DATE |  |  |  | Rate date used to convert costs from the contract currency to the Global currency. |  |
GLOBAL_EXCHANGE_RATE | NUMBER |  |  |  | Exchange rate used to convert costs from the contract currency to the Global currency. |  |
GLOBAL_LINE_AMOUNT | NUMBER |  |  |  | Global Line Amount |  |
CREATION_DATE | DATE |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | indicates the user who created the row. |  |
DATE_TERMINATED | DATE |  |  |  | Date contract was terminated. |  |
LAST_REV_RECOG_DATE | DATE |  |  |  | Last Revenue Recognition Date. |  |
AT_RISK_YN | VARCHAR2 | 16 |  |  | At Risk indicatior | DW_Y_N_D_TL | CODE
CUST_PO_NUMBER | VARCHAR2 | 64 |  |  | Free form text referring to Customer PO Number, Wire or Check. |  |
NUM_OF_ITEM | NUMBER |  |  |  | Number of line items. |  |
INTER_COMPANY_FLAG | VARCHAR2 | 16 |  |  | InterCompany Flag |  |
INTER_PROJECT_FLAG | VARCHAR2 | 16 |  |  | InterProject Flag |  |

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