This table stored the contract line level details.
Module: Project Billing
MAJOR_VERSION, CONTRACT_LINE_ID
| 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, 2024, Oracle and/or its affiliates.