1. Tables and Views for Project Management
  2. PJS_PRJ_BILLED_AMT

PJS_PRJ_BILLED_AMT

Table to store Billed Cost for each project.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
CONTRACT_ID NUMBER 18 CONTRACT_ID
TXN_ACCUM_HEADER_ID NUMBER 18 Accum header Identifier
PROJECT_ID NUMBER 18 Yes Project Identifier
BUSINESS_UNIT_ID NUMBER 18 Business Unit ID
TASK_ID NUMBER 18 Yes Task Identifier
CALENDAR_ID NUMBER 18 Time dimension calendar ID
CALENDAR_TYPE VARCHAR2 1 Yes Indicates whether PA or GL calendar
PERIOD_NAME VARCHAR2 30 Yes Period name
START_DATE DATE Start date
END_DATE DATE End date
RESOURCE_CLASS_ID NUMBER 18 Resource Class Identifier
CURRENCY_TYPE VARCHAR2 1 Yes Currency type
CURRENCY_CODE VARCHAR2 15 Yes Currency code
UOM_CODE VARCHAR2 30 Unit of measure code
AWARD_PERIOD_ID NUMBER 18 Identifier for the award budget period. The award budget period is defined separately from the GL period.
FUNC_BILLED_COST NUMBER FUNC_BILLED_COST
PRJ_BILLED_COST NUMBER PRJ_BILLED_COST
TXN_BILLED_COST NUMBER TXN_BILLED_COST
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
PJS_PRJ_BILLED_AMT_N1 Non Unique Default PROJECT_ID
PJS_PRJ_BILLED_AMT_U1 Unique Default CONTRACT_ID, TXN_ACCUM_HEADER_ID, PROJECT_ID, TASK_ID, PERIOD_NAME, AWARD_PERIOD_ID, CURRENCY_TYPE, CURRENCY_CODE, CALENDAR_TYPE