PJS_CN_BASE_CON_L

This table contains the non-persistent incremental dataset for merging into the corresponding table, PJS_CN_BASE_CON, and for continuation onto summarization RBS mapping.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PJS_SUMMARY_ID	NUMBER		18	Yes	The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized.	Active
BUSINESS_UNIT_ID	NUMBER		18	Yes	Business Unit ID	Active
CONTRACT_ID	NUMBER		18	Yes	Contains the Contract ID, not the Contract Number.	Active
CONTRACT_LINE_ID	NUMBER		18	Yes	Contains the Contract Line ID.	Active
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	Active
CALENDAR_TYPE	VARCHAR2	1			Indicates whether PA or GL calendar	Active
PERIOD_NAME	VARCHAR2	30			Period name	Active
START_DATE	DATE				Start date
END_DATE	DATE				End date
CURRENCY_TYPE_ID	NUMBER		18		Bitmap indicating various types of currency
CURRENCY_CODE	VARCHAR2	15			Currency code	Active
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				Project revenue
TC_PFC_REVENUE	NUMBER				Project functional revenue
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
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.
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
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
AWARD_PERIOD_ID	NUMBER		18		Identifier for the award budget period. The award budget period is defined separately from the GL period.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_CN_BASE_CON_L_N1	Non Unique	Default	LINKED_PROJECT_ID
PJS_CN_BASE_CON_L_N2	Non Unique	Default	CONTRACT_ID