This table stored the contract line level details.
Module: Project Billing
CONTRACT_LINE_ID, MAJOR_VERSION
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.