PJS_CN_BASE_CON_B

This table contains non-persistent contract data and is only used by bulk summarization.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
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				Period start date
END_DATE	DATE				Period end date
CURRENCY_TYPE_ID	NUMBER		18		Bitmap indicating various types of currency
CURRENCY_CODE	VARCHAR2	3			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				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
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.