DBA Data[Home] [Help] [Dependency Information]

TABLE: BIM.BIM_R_FDSP_DAILY_FACTS

Object Details
Object Name: BIM_R_FDSP_DAILY_FACTS
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


BIM_R_FDSP_DAILY_FACTS keeps 90 days of fund spending facts


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_FDSP_DAILY_FACTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPEND_TRANSACTION_ID
BIM_R_FDSP_DAILY_FACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_CREATE_DATE
Columns
Name Datatype Length Mandatory Comments
SPEND_TRANSACTION_ID NUMBER
Yes unique identifier
CREATION_DATE DATE
Yes standard who column
CREATED_BY NUMBER
Yes standard who column
LAST_UPDATE_DATE DATE
Yes standard who column
LAST_UPDATED_BY NUMBER
Yes standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
FUND_ID NUMBER
Yes fund id for fund spending
BUSINESS_UNIT_ID NUMBER

business unit id
OBJECT_ID NUMBER

object id for fund spending
OBJECT_TYPE VARCHAR2 (30)
object type for fund spending
STANDARD_DISCOUNT NUMBER

standard discount for fund spending
ACCRUAL NUMBER

accural for fund spending
MARKET_EXPENSE NUMBER

amount of market expense for fund spending
COMMITED_AMT NUMBER

amount commited for fund spending
PLANNED_AMT NUMBER

amount planned for fund spending
PAID_AMT NUMBER

amount paid for fund spending
DELETE_FLAG VARCHAR2 (1)
delete flag are used when records need to be deleted
TRANSACTION_CREATE_DATE DATE
Yes Creation date of the transaction.
LOAD_DATE DATE

This column provides the week end date of the transaction create date.
UTIL_ORG_ID NUMBER

utility organization id
SECURITY_GROUP_ID NUMBER

This column is used in hosted environments
METRIC1 NUMBER

additional metrics column
METRIC2 NUMBER

additional metrics column
METRIC3 NUMBER

additional metrics column
METRIC4 NUMBER

additional metrics column
METRIC5 NUMBER

additional metrics column
METRIC6 NUMBER

additional metrics column
METRIC7 NUMBER

additional metrics column
METRIC8 NUMBER

additional metrics column
METRIC9 NUMBER

additional metrics column
METRIC10 NUMBER

additional metrics column
METRIC11 NUMBER

additional metrics column
METRIC12 NUMBER

additional metrics column
METRIC13 NUMBER

additional metrics column
METRIC14 NUMBER

additional metrics column
METRIC15 NUMBER

additional metrics column
FIS_MONTH VARCHAR2 (30)
Fiscal period month
FIS_QTR VARCHAR2 (30)
Fiscal period quarter
FIS_YEAR VARCHAR2 (30)
Fiscal period year
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SPEND_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUND_ID
,      BUSINESS_UNIT_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      STANDARD_DISCOUNT
,      ACCRUAL
,      MARKET_EXPENSE
,      COMMITED_AMT
,      PLANNED_AMT
,      PAID_AMT
,      DELETE_FLAG
,      TRANSACTION_CREATE_DATE
,      LOAD_DATE
,      UTIL_ORG_ID
,      SECURITY_GROUP_ID
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      FIS_MONTH
,      FIS_QTR
,      FIS_YEAR
FROM BIM.BIM_R_FDSP_DAILY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_FDSP_DAILY_FACTS does not reference any database object

BIM.BIM_R_FDSP_DAILY_FACTS is referenced by following:

SchemaAPPS
SynonymBIM_R_FDSP_DAILY_FACTS