PJS_FP_BASE_CMT_L

Contains summarized data for commitments

Details

Schema: FUSION
Object owner: PJS
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PJS_SUMMARY_ID	NUMBER		18		The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized.	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
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
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_L_N1	Non Unique	Default	PROJECT_ID