PJS_FP_BASE_CMT
This table contains persistent Commitment data that is aggregated by period and has relevant resource attributes assigned.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| 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 | Active | ||
| SUP_INV_CMT_PLANNED_BRDN_COST | NUMBER | SUP_INV_CMT_PLANNED_BRDN_COST | ||||
| PO_CMT_PLANNED_BRDN_COST | NUMBER | PO_CMT_PLANNED_BRDN_COST | ||||
| PR_CMT_PLANNED_BRDN_COST | NUMBER | PR_CMT_PLANNED_BRDN_COST | ||||
| OTH_CMT_PLANNED_BRDN_COST | NUMBER | OTH_CMT_PLANNED_BRDN_COST | ||||
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | Active | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit ID | Active | ||
| TASK_ID | NUMBER | 18 | Task ID | Active | ||
| RESOURCE_CLASS_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | |||
| CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | Active | ||
| CALENDAR_TYPE | VARCHAR2 | 1 | Indicates whether PA or GL calendar | Active | ||
| PERIOD_NAME | VARCHAR2 | 30 | Period name | Active | ||
| CURRENCY_TYPE | VARCHAR2 | 1 | Currency type | Active | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost | ||||
| SUP_INV_CMT_BRDN_COST | NUMBER | Supplier invoice commitment cost | ||||
| PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost | ||||
| PO_CMT_BRDN_COST | NUMBER | Purchase order commitment cost | ||||
| PR_CMT_RAW_COST | NUMBER | Requisition commitment cost | ||||
| PR_CMT_BRDN_COST | NUMBER | Requisition commitment cost | ||||
| OTH_CMT_RAW_COST | NUMBER | Commitment cost | ||||
| OTH_CMT_BRDN_COST | NUMBER | Commitment cost | ||||
| PRJ_SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost | ||||
| PRJ_SUP_INV_CMT_BRDN_COST | NUMBER | Supplier invoice commitment cost | ||||
| PRJ_PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost | ||||
| PRJ_PO_CMT_BRDN_COST | NUMBER | Purchase order commitment cost | ||||
| PRJ_PR_CMT_RAW_COST | NUMBER | Requisition commitment cost | ||||
| PRJ_PR_CMT_BRDN_COST | NUMBER | Requisition commitment cost | ||||
| PRJ_OTH_CMT_RAW_COST | NUMBER | Commitment cost | ||||
| PRJ_OTH_CMT_BRDN_COST | NUMBER | Commitment cost | ||||
| FUN_SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost | ||||
| FUN_SUP_INV_CMT_BRDN_COST | NUMBER | Supplier invoice commitment cost | ||||
| FUN_PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost | ||||
| FUN_PO_CMT_BRDN_COST | NUMBER | Purchase order commitment cost | ||||
| FUN_PR_CMT_RAW_COST | NUMBER | Requisition commitment cost | ||||
| FUN_PR_CMT_BRDN_COST | NUMBER | Requisition commitment cost | ||||
| FUN_OTH_CMT_RAW_COST | NUMBER | Commitment cost | ||||
| FUN_OTH_CMT_BRDN_COST | NUMBER | Commitment cost | ||||
| START_DATE | DATE | Start date | ||||
| END_DATE | DATE | End date | ||||
| UOM_CODE | VARCHAR2 | 30 | Unit of measure code | |||
| CMT_SUP_INV_QUANTITY | NUMBER | Commitment supplier invoice quantity | ||||
| CMT_PO_QUANTITY | NUMBER | Commitment purchase order quantity | ||||
| CMT_PR_QUANTITY | NUMBER | Requisition commitment quantity | ||||
| CMT_OTH_QUANTITY | NUMBER | Commitment other quantity | ||||
| AWARD_PERIOD_ID | NUMBER | 18 | Identifier for the award budget period. The award budget period is defined separately from the GL period. | |||
| CONTRACT_ID | NUMBER | 18 | Unique identifier of the award. | |||
| FUNDING_SOURCE_ID | NUMBER | 18 | Identifier of the award funding source. | |||
| TO_CMT_RAW_COST | NUMBER | Raw cost committed through transfer orders. | ||||
| TO_CMT_BRDN_COST | NUMBER | Burdened cost committed through transfer orders. | ||||
| TO_CMT_QUANTITY | NUMBER | Quantity committed through transfer orders. | ||||
| RCPT_CMT_RAW_COST | NUMBER | Raw cost committed through receipts. | ||||
| RCPT_CMT_BRDN_COST | NUMBER | Burdened cost committed through receipts. | ||||
| RCPT_CMT_QUANTITY | NUMBER | Quantity committed through receipts. | ||||
| TTL_CMT_RAW_COST | NUMBER | Total raw cost that is committed. | ||||
| TTL_CMT_BRDN_COST | NUMBER | Total burdened cost that is committed. | ||||
| TTL_CMT_QUANTITY | NUMBER | Total quantity that is committed. | ||||
| ADDL_ATTRIBUTE_NUM_1 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_2 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_3 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_4 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_5 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_6 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_7 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_8 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_9 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_10 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_11 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_12 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_CHAR_1 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_2 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_3 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_4 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_5 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_6 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_7 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_8 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_9 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_10 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_11 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_12 | VARCHAR2 | 150 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_FP_BASE_CMT_N1 | Non Unique | Default | PROJECT_ID |