[Home] [Help] [Dependency Information]
Object Name: | PSBFV_WS_ACCOUNT_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_WS_ACCOUNT_LINES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBFV_WS_ACCOUNT_LINES displays information about worksheet account lines.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_YEAR_NAME | VARCHAR2 | (15) | Budget year name | |
SERVICE_PACKAGE_NAME | VARCHAR2 | (15) | Short name of service package for worksheet account line | |
PAY_ELEMENT_NAME | VARCHAR2 | (30) | Pay element name | |
_LA:BALANCE_TYPE | CHAR | (57) | Balance type. B indicates Budget, A indicates Actual, or E indicates Estimate. | |
TEMPLATE_NAME | VARCHAR2 | (100) | Summary template name | |
_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. | |
NOTE | VARCHAR2 | (4000) | Description associated with account line | |
ANNUAL_FTE | NUMBER | Full-time equivalency factor computed by annualizing period full-time equivalencies | ||
CURRENCY_CODE | VARCHAR2 | (10) | Functional currency of General Ledger Set of Books or STAT for statistical currency. Indicates the currency of the YTD_AMOUNT. | |
YEAR_AMOUNT | NUMBER | Year-to-date amount | ||
PERIOD1_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD2_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD3_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD4_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD5_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD6_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD7_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD8_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD9_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD10_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD11_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
PERIOD12_AMOUNT | NUMBER | Amount allocated to periods in budget year | ||
SET_OF_BOOKS_NAME | VARCHAR2 | (30) | General Ledger Set of Books name | |
_KF:GL_ACCOUNT | CHAR | (17) | General Ledger account | |
START_STAGE_SEQ | NUMBER | Stage in which annual amount established | ||
CURRENT_STAGE_SEQ | NUMBER | Current stage of account line | ||
END_STAGE_SEQ | NUMBER | Stage up to which annual amount remains unchanged | ||
WORKSHEET_ID | NUMBER | (20) | Worksheet identifier | |
SET_OF_BOOKS_ID | NUMBER | (15) | General Ledger Set of Books identifier | |
ACCOUNT_LINE_ID | NUMBER | (20) | Account line unique identifier | |
POSITION_LINE_ID | NUMBER | Position line unique identifier | ||
CODE_COMBINATION_ID | NUMBER | (20) | General Ledger code combination unique identifier | |
SERVICE_PACKAGE_ID | NUMBER | (20) | Service package unique identifier. Service package to which line is assigned. | |
BUDGET_YEAR_ID | NUMBER | (20) | Budget year unique identifier. Budget year for which account line is assigned. | |
TEMPLATE_ID | NUMBER | General Ledger summary template unique identifier. Column has a value for summary account lines. | ||
PAY_ELEMENT_ID | NUMBER | Pay element unique identifier. Element for which account line is created. | ||
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. | |
NOTE_ID | NUMBER | Note unique identifier. Note associated with account line. | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_YEAR_NAME
, SERVICE_PACKAGE_NAME
, PAY_ELEMENT_NAME
, _LA:BALANCE_TYPE
, TEMPLATE_NAME
, _LA:ACCOUNT_TYPE
, NOTE
, ANNUAL_FTE
, 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
, SET_OF_BOOKS_NAME
, _KF:GL_ACCOUNT
, START_STAGE_SEQ
, CURRENT_STAGE_SEQ
, END_STAGE_SEQ
, WORKSHEET_ID
, SET_OF_BOOKS_ID
, ACCOUNT_LINE_ID
, POSITION_LINE_ID
, CODE_COMBINATION_ID
, SERVICE_PACKAGE_ID
, BUDGET_YEAR_ID
, TEMPLATE_ID
, PAY_ELEMENT_ID
, ELEMENT_SET_ID
, NOTE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.PSBFV_WS_ACCOUNT_LINES;
APPS.PSBFV_WS_ACCOUNT_LINES is not referenced by any database object
|
|
|