PJC_XCC_BURDEN_DISTS
This table stores burden cost for the transactions eligible for budget check validation or encumbrance accounting.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJC_XCC_BURDEN_DISTS_PK |
BURDEN_DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BURDEN_DISTRIBUTION_ID | NUMBER | 18 | Yes | Surrogate key that uniquely identifies the burden record. | |
| DATA_SET_ID | NUMBER | 18 | Yes | Identifies data for a particular budgetary control request. A budgetary control request has only one DATA_SET_ID. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Transaction source identifier of the burden cost. | |
| SOURCE_HEADER_ID_1 | VARCHAR2 | 30 | Yes | Transaction identifier of the burden cost. | |
| SOURCE_HEADER_ID_2 | VARCHAR2 | 30 | Yes | Transaction identifier of the burden cost. | |
| SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Transaction identifier displayed to users. | ||
| SOURCE_ACTION_CODE | VARCHAR2 | 30 | Yes | Action, for example approve or validate, being performed by the user. | |
| BUDGETARY_CONTROL_ACTION | VARCHAR2 | 30 | Yes | Budgetary control action. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business unit owning the distribution. | |
| LINE_TYPE | VARCHAR2 | 10 | Yes | Attribute that indicates whether the record is created for burden cost reservation or liquidation. Valid values are RESERVE and LIQUIDATE. | |
| LIQUIDATED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the burden cost was liquidated. Default value is N. | |
| BUDGET_DATE | DATE | Date for which funds must be reserved for the distribution. | |||
| ACCOUNTING_DATE | DATE | Yes | Date for which the distribution must be accounted. | ||
| LIQUIDATION_DATE | DATE | Date used for liquidating cost. | |||
| ENTERED_CURRENCY | VARCHAR2 | 15 | Yes | Transaction currency, that is, currency in which transaction amounts are entered. | |
| ENTERED_RAW_COST | NUMBER | Yes | Raw cost in transaction currency. | ||
| ENTERED_BURDEN_COST | NUMBER | Yes | Burden cost in transaction currency. | ||
| LEDGER_CURRENCY | VARCHAR2 | 15 | Yes | Currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency. | |
| LEDGER_RAW_COST | NUMBER | Yes | Raw cost in ledger currency. | ||
| LEDGER_BURDEN_COST | NUMBER | Yes | Burden cost in ledger currency. | ||
| BURDEN_COST_CODE | VARCHAR2 | 120 | The implementation-defined name that uniquely identifies the burden cost code. | ||
| BURDEN_EXPENDITURE_TYPE_ID | NUMBER | 18 | Yes | Expenditure type of the burden transaction. | |
| BURDEN_MULTIPLIER | NUMBER | Yes | A numeric value applied to raw cost for calculating burden cost amounts. | ||
| BURDEN_IND_COMPILED_SET_ID | NUMBER | 18 | The system-generated number that uniquely identifies the compiled set. | ||
| BURDEN_CCID | NUMBER | 18 | Burden cost charge account. | ||
| PRBS_ELEMENT_ID | NUMBER | 18 | Planning resource breakdown structure element identifier of the planning resource that the transaction maps to. | ||
| FUNDS_STATUS | VARCHAR2 | 120 | Budgetary control validation status. | ||
| RAW_EVENT_ID | NUMBER | 18 | Encumbrance accounting event identifier for the raw cost. | ||
| BURDEN_EVENT_ID | NUMBER | 18 | Encumbrance accounting event identifier for the burden cost. | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Unique identifier for the transaction attributes that are used for mapping and deriving a planning resource breakdown structure element. | ||
| PROJECT_ID | NUMBER | 18 | Yes | Unique identifier for project. | |
| TASK_ID | NUMBER | 18 | Yes | Unique identifier for task. | |
| CONTRACT_ID | NUMBER | 18 | Unique identifier for contract. | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Unique identifier for contract line. | ||
| FUNDING_SOURCE_ID | NUMBER | 18 | Unique identifier for funding source. | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Yes | Unique identifier for organization to which the expenditure belongs. | |
| PARENT_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifier of the transaction type responsible for generating the burden cost. | |
| PARENT_SOURCE_HEADER_ID_1 | VARCHAR2 | 30 | Yes | Identifier of the transaction responsible for generating the burden cost. | |
| PARENT_SOURCE_HEADER_ID_2 | VARCHAR2 | 30 | Yes | Identifier of the transaction responsible for generating the burden cost. | |
| PARENT_SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Yes | Identifier of the distribution responsible for generating the burden cost. | |
| PARENT_SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Yes | Identifier of the distribution responsible for generating the burden cost. | |
| PARENT_SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Yes | Identifier of the distribution responsible for generating the burden cost. | |
| PARENT_SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Yes | Identifier of the distribution responsible for generating the burden cost. | |
| PARENT_SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Yes | Identifier of the distribution responsible for generating the burden cost. | |
| PARENT_SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Yes | Identifier of the distribution responsible for generating the burden cost. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| BACKING_HEADER_ID1 | NUMBER | 18 | Backing Header Identifier One | ||
| BACKING_DIST_ID1 | NUMBER | 18 | Backing Distribution Identifier One | ||
| BACKING_DIST_ID2 | NUMBER | 18 | Backing Distribution Identifier Two | ||
| BACKING_BURDEN_DIST_ID | NUMBER | 18 | Identifier of the burden distribution record to be liquidated. | ||
| BACKING_COST | NUMBER | Liquidation cost of the backing burden distribution. | |||
| BTC_EXP_ID | NUMBER | 18 | Identifier of the burden expenditure item created by Oracle Fusion Project Costing | ||
| PJC_BURDEN_ACTION_CODE | VARCHAR2 | 30 | Internally used action code that determines the logic used to calculate burden costs in budgetary control enabled projects. | ||
| TOP_PRBS_ELEMENT_ID | NUMBER | 18 | The identifier of the top resource derived for the transaction using the planning resource breakdown structure. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_XCC_BURDEN_DISTS | pjf_projects_all_b | PROJECT_ID |
| PJC_XCC_BURDEN_DISTS | pjf_proj_elements_b | TASK_ID |
| PJC_XCC_BURDEN_DISTS | pjf_exp_types_b | BURDEN_EXPENDITURE_TYPE_ID |
| PJC_XCC_BURDEN_DISTS | pjf_bu_impl_all | BUSINESS_UNIT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_XCC_BURDEN_DISTS_N1 | Non Unique | Default | DATA_SET_ID |
| PJC_XCC_BURDEN_DISTS_N2 | Non Unique | Default | SOURCE_HEADER_ID_1, SOURCE_LINE_ID_1, SOURCE_LINE_ID_2, TRANSACTION_TYPE_CODE, SOURCE_HEADER_ID_2, SOURCE_LINE_ID_3, SOURCE_LINE_ID_4, SOURCE_LINE_ID_5, SOURCE_LINE_ID_6 |
| PJC_XCC_BURDEN_DISTS_N3 | Non Unique | Default | PARENT_SOURCE_LINE_ID_1, PARENT_SOURCE_LINE_ID_2, PARENT_TRANSACTION_TYPE_CODE, PARENT_SOURCE_HEADER_ID_1, PARENT_SOURCE_HEADER_ID_2, PARENT_SOURCE_LINE_ID_3, PARENT_SOURCE_LINE_ID_4, PARENT_SOURCE_LINE_ID_5, PARENT_SOURCE_LINE_ID_6 |
| PJC_XCC_BURDEN_DISTS_N4 | Non Unique | Default | SOURCE_LINE_ID_2, TRANSACTION_TYPE_CODE |
| PJC_XCC_BURDEN_DISTS_U1 | Unique | Default | BURDEN_DISTRIBUTION_ID |