PJS_CN_EXTR_CON_GT
This global temporary table contains non-persistent contract data shortly after it has been extracted from transaction tables.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORKER_ID | NUMBER | 18 | A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit ID | |
| CONTRACT_ID | NUMBER | 18 | Yes | Contains the Contract ID, not the Contract Number. | |
| CONTRACT_LINE_ID | NUMBER | 18 | Yes | Contains the Contract Line ID. | |
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Yes | Billing type code | |
| CONTRACT_PROJECT_LINKAGE_ID | NUMBER | 18 | Contains the unique ID for a link between a project task (or project) and a contract line (or contract). | ||
| LINKED_PROJECT_ID | NUMBER | 18 | Project ID linked to the contract line or contract | ||
| LINKED_TASK_ID | NUMBER | 18 | Task ID | ||
| TRANSACTION_PROJECT_ID | NUMBER | 18 | Project ID linked to the contract line or contract | ||
| TRANSACTION_TASK_ID | NUMBER | 18 | Task ID | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping | ||
| GL_PERIOD_NAME | VARCHAR2 | 30 | Period name | ||
| GL_START_DATE | DATE | Stores the GL period start date | |||
| GL_END_DATE | DATE | Stores the GL period end date | |||
| PA_PERIOD_NAME | VARCHAR2 | 30 | Period name | ||
| PA_START_DATE | DATE | Stores the PA period start date | |||
| PA_END_DATE | DATE | Stores the PA period end date | |||
| CURRENCY_TYPE_ID | NUMBER | 18 | Bitmap indicating various types of currency | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | ||
| CC_REVENUE | NUMBER | Contract revenue | |||
| PFC_REVENUE | NUMBER | Project functional revenue | |||
| RC_REVENUE | NUMBER | Revenue currency revenue | |||
| PC_REVENUE | NUMBER | Project revenue | |||
| TC_REVENUE | NUMBER | Transaction revenue | |||
| TC_PC_REVENUE | NUMBER | Stores the amount in PC for T lines. | |||
| TC_PFC_REVENUE | NUMBER | Stores the amount in PFC for T lines. | |||
| CC_BILLED | NUMBER | Billed invoice | |||
| PFC_BILLED | NUMBER | Project functional billed invoice | |||
| IC_BILLED | NUMBER | Billed invoice | |||
| PC_BILLED | NUMBER | Project billed invoice | |||
| TC_BILLED | NUMBER | Billed invoice | |||
| AWARD_PERIOD_ID | NUMBER | 18 | AWARD_PERIOD_ID | ||
| CC_PREPAY_REQUEST_AMOUNT | NUMBER | Prepayment request amount in contract currency. | |||
| CC_PREPAY_APPLIED_AMOUNT | NUMBER | Prepayment applied amount in contract currency. | |||
| PFC_PREPAY_REQUEST_AMOUNT | NUMBER | Prepayment request amount in project functional currency. | |||
| PFC_PREPAY_APPLIED_AMOUNT | NUMBER | Prepayment applied amount in project functional currency. |