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

TABLE: PSB.PSB_FUND_BALANCE_ACCOUNTS

Object Details
Object Name: PSB_FUND_BALANCE_ACCOUNTS
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_FUND_BALANCE_ACCOUNTS
Subobject Name:
Status: VALID


PSB_FUND_BALANCE_ACCOUNTS stores the accounts that are used as the
offset account to create a balanced budget journal entry for a fund.
One account can be defined for each fund, but not all funds must have
an account defined. One account can be designated as the template
account, and this template account is used to derive the offset for the
funds for which no offset account is defined. This is done by simply
substituting the fund segment value.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_FUND_BALANCE_ACCOUNTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
CODE_COMBINATION_ID NUMBER (15) Yes General Ledger code combination identifier
SET_OF_BOOKS_ID NUMBER (15) Yes General Ledger Set of Books identifier
TEMPLATE_ACCOUNT VARCHAR2 (1)
Flag indicates if this is a template account
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
Query Text

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


SELECT CODE_COMBINATION_ID
,      SET_OF_BOOKS_ID
,      TEMPLATE_ACCOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM PSB.PSB_FUND_BALANCE_ACCOUNTS;

Dependencies

[top of page]

PSB.PSB_FUND_BALANCE_ACCOUNTS does not reference any database object

PSB.PSB_FUND_BALANCE_ACCOUNTS is referenced by following:

SchemaAPPS
SynonymPSB_FUND_BALANCE_ACCOUNTS