[Home] [Help] [Dependency Information]
Object Name: | PSB_BUDGET_REVISION_ACCOUNTS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_BUDGET_REVISION_ACCOUNTS |
Subobject Name: | |
Status: | VALID |
PSB_BUDGET_REVISION_ACCOUNTS stores the individual budget revision transactions for accounts.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_BUDGET_REVISION_ACCTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUDGET_REVISION_ACCT_LINE_ID |
PSB_BUDGET_REVISION_ACCTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CODE_COMBINATION_ID
GL_PERIOD_NAME |
PSB_BUDGET_REVISION_ACCTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_REVISION_ACCT_LINE_ID | NUMBER | (20) | Yes | Budget Revision account line unique identifier |
CODE_COMBINATION_ID | NUMBER | (20) | Yes | General Ledger code combination unique identifier |
BUDGET_GROUP_ID | NUMBER | (20) | Yes | Budget Group unique identifier |
GL_PERIOD_NAME | VARCHAR2 | (15) | Yes | Name of the General Ledger period for which the budget revision is made |
POSITION_ID | NUMBER | (15) | Position unique identifier | |
GL_BUDGET_VERSION_ID | NUMBER | (20) | General Ledger budget version unique identifier. The budget version from which budget amounts are extracted to be revised. If budgetary control is used in General Ledger, then the budget amounts are extracted from the budget for the account. | |
CURRENCY_CODE | VARCHAR2 | (15) | Indicates the currency of the budget amount | |
ACCOUNT_TYPE | VARCHAR2 | (10) | Yes | General Ledger account type. Valid Values are A (Asset), L (Liability), O (Equity), R (Revenue), or E (Expense) |
BUDGET_BALANCE | NUMBER | Budget balance for the account as of the General Ledger period | ||
ACTUAL_BALANCE | NUMBER | Actual balance for the account as of the General Ledger period. For future use. | ||
ENCUMBRANCE_BALANCE | NUMBER | Encumbrance balance for the account as of the General Ledger period. For future use. | ||
REVISION_TYPE | VARCHAR2 | (1) | Budget revision type. Valid values are I (Increase), D (Decrease). | |
REVISION_VALUE_TYPE | VARCHAR2 | (1) | Budget revision value type. Valid values are A (Amount), P (Percentage). | |
REVISION_AMOUNT | NUMBER | Budget revision change amount qualified by the revision value type. | ||
FUNDS_CONTROL_STATUS_CODE | VARCHAR2 | (1) | Funds Control status code for budget revision transaction | |
FUNDS_CONTROL_RESULTS_CODE | VARCHAR2 | (3) | Funds control result code for transaction | |
FUNDS_CONTROL_TIMESTAMP | DATE | Timestamp for the last funds check | ||
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if the budget revision transaction is frozen. Valid values are Y, N. | |
NOTE_ID | NUMBER | Note unique identifier associated with the revision of the transaction line | ||
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 | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
FUNCTIONAL_TRANSACTION | VARCHAR2 | (1) | Indicates functional currency transaction |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_REVISION_ACCT_LINE_ID
, CODE_COMBINATION_ID
, BUDGET_GROUP_ID
, GL_PERIOD_NAME
, POSITION_ID
, GL_BUDGET_VERSION_ID
, CURRENCY_CODE
, ACCOUNT_TYPE
, BUDGET_BALANCE
, ACTUAL_BALANCE
, ENCUMBRANCE_BALANCE
, REVISION_TYPE
, REVISION_VALUE_TYPE
, REVISION_AMOUNT
, FUNDS_CONTROL_STATUS_CODE
, FUNDS_CONTROL_RESULTS_CODE
, FUNDS_CONTROL_TIMESTAMP
, FREEZE_FLAG
, NOTE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, FUNCTIONAL_TRANSACTION
FROM PSB.PSB_BUDGET_REVISION_ACCOUNTS;
PSB.PSB_BUDGET_REVISION_ACCOUNTS does not reference any database object
PSB.PSB_BUDGET_REVISION_ACCOUNTS is referenced by following:
|
|
|