PJS_CN_INV_REV

Details

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

Primary Key

Name	Columns
PJS_CN_INV_REV_F_PK	CONTRACT_ID, CONTRACT_LINE_ID, CONTRACT_PROJECT_LINKAGE_ID, AGGR_LEVEL, PERIOD_NAME, CURRENCY_TYPE_ID, CURRENCY_CODE

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	Active
CONTRACT_PROJECT_LINKAGE_ID	NUMBER		18	Yes	Contains the unique ID for a link between a project task (or project) and a contract line (or contract).	Active
LINKED_PROJECT_ID	NUMBER		18		Project ID linked to the contract line or contract	Active
LINKED_TASK_ID	NUMBER		18		Task ID	Active
AGGR_LEVEL	VARCHAR2	1		Yes	Indicates whether the data is aggregated to the project, contract_line, or contract level.	Active
PERIOD_NAME	VARCHAR2	30		Yes	Period name	Active
CURRENCY_CODE	VARCHAR2	15		Yes	Currency code	Active
CURRENCY_TYPE_ID	NUMBER		18	Yes	Bitmap indicating various types of currency	Active
CC_REVENUE	NUMBER				Contract revenue	Active
PFC_REVENUE	NUMBER				Project functional revenue	Active
RC_REVENUE	NUMBER				Revenue currency revenue	Active
PC_REVENUE	NUMBER				Project revenue	Active
TC_REVENUE	NUMBER				Transaction revenue	Active
CC_BILLED	NUMBER				Billed invoice	Active
PFC_BILLED	NUMBER				Project functional billed invoice	Active
IC_BILLED	NUMBER				Billed invoice	Active
PC_BILLED	NUMBER				Project billed invoice	Active
TC_BILLED	NUMBER				Billed invoice	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
EFFECTIVE_START_DATE	DATE				Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE	DATE				Date Effective Entity: indicates the date at the end of the date range within which the row is effective.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PJS_CN_INV_REV_F_N2	Non Unique	FUSION_TS_TX_DATA	LINKED_PROJECT_ID, LINKED_TASK_ID	Active
PJS_CN_INV_REV_F_U1	Unique	FUSION_TS_TX_DATA	CONTRACT_ID, CONTRACT_LINE_ID, CONTRACT_PROJECT_LINKAGE_ID, AGGR_LEVEL, PERIOD_NAME, CURRENCY_TYPE_ID, CURRENCY_CODE