[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSBBV_WS_ACCOUNT_LINES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PSB.PSBBV_WS_ACCOUNT_LINES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
PSBBV_WS_ACCOUNT_LINES displays information about worksheet account lines.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WORKSHEET_ID | NUMBER | (20) | Yes | Worksheet identifier |
| ACCOUNT_LINE_ID | NUMBER | (20) | Yes | Account line unique identifier |
| POSITION_LINE_ID | NUMBER | Position line unique identifier | ||
| CODE_COMBINATION_ID | NUMBER | (20) | Yes | General Ledger code combination unique identifier |
| SERVICE_PACKAGE_ID | NUMBER | (20) | Yes | Service package unique identifier. Service package to which line is assigned. |
| ELEMENT_SET_ID | NUMBER | (20) | Element set identifier. Used to group a set of account lines for a given position for a given element. Distribution percentages can be modified within a group. | |
| BUDGET_YEAR_ID | NUMBER | (20) | Yes | Budget year unique identifier. Budget year for which this account line is assigned. |
| _LA:BALANCE_TYPE | CHAR | (57) | Balance type. B indicates Budget, A indicates Actual, or E indicates Estimate. | |
| TEMPLATE_ID | NUMBER | General Ledger template unique identifier. This column has a value for summary account lines. | ||
| _LA:ACCOUNT_TYPE | CHAR | (53) | General Ledger account type. A indicates Asset, L indicates Liability, O indicates Equity, R indicates Revenue, or E indicates Expense. | |
| ANNUAL_FTE | NUMBER | The full-time equivalency factor computed by annualizing the period full-time equivalencies | ||
| NOTE_ID | NUMBER | Note unique identifier. Note associated with the account line. | ||
| CURRENCY_CODE | VARCHAR2 | (10) | Yes | Functional currency of the General Ledger Set of Books or STAT for statistical currency. This indicates the currency of the YTD_AMOUNT. |
| YEAR_AMOUNT | NUMBER | Year-to-date amount | ||
| PERIOD1_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD2_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD3_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD4_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD5_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD6_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD7_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD8_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD9_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD10_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD11_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| PERIOD12_AMOUNT | NUMBER | Amount allocated to periods in a budget year | ||
| START_STAGE_SEQ | NUMBER | Yes | Stage in which the annual amount was established | |
| CURRENT_STAGE_SEQ | NUMBER | Yes | Current stage of this account line | |
| END_STAGE_SEQ | NUMBER | Stage up to which the annual amount remains unchanged | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_ID
, ACCOUNT_LINE_ID
, POSITION_LINE_ID
, CODE_COMBINATION_ID
, SERVICE_PACKAGE_ID
, ELEMENT_SET_ID
, BUDGET_YEAR_ID
, _LA:BALANCE_TYPE
, TEMPLATE_ID
, _LA:ACCOUNT_TYPE
, ANNUAL_FTE
, NOTE_ID
, CURRENCY_CODE
, YEAR_AMOUNT
, PERIOD1_AMOUNT
, PERIOD2_AMOUNT
, PERIOD3_AMOUNT
, PERIOD4_AMOUNT
, PERIOD5_AMOUNT
, PERIOD6_AMOUNT
, PERIOD7_AMOUNT
, PERIOD8_AMOUNT
, PERIOD9_AMOUNT
, PERIOD10_AMOUNT
, PERIOD11_AMOUNT
, PERIOD12_AMOUNT
, START_STAGE_SEQ
, CURRENT_STAGE_SEQ
, END_STAGE_SEQ
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.PSBBV_WS_ACCOUNT_LINES;
APPS
PSB_WS_ACCOUNT_LINES
PSB_WS_LINES
APPS.PSBBV_WS_ACCOUNT_LINES is not referenced by any database object
|
|
|
|