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

TABLE: PSB.PSB_WS_ACCOUNT_LINES

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


PSB_WORKSHEET_ACCOUNT_LINES stores the balance amounts for different
account combinations in a worksheet.
For the prior years in a worksheet, each account can have budget and
actual balances. For the current year in a worksheet, each account can
have budget, actual, and estimate balances. For each proposed year, an
account has only estimate balances. The YTD_AMOUNT column contains the
balance for a given budget year in BUDGET_YEAR_ID. The allocation of
the year amount across the various budget periods in a year are stored
in the columns PERIOD1_AMOUNT through PERIOD60_AMOUNT.
For any given account, budget year, balance type, currency, or service
package combination, the balance can be different at different stages
of the worksheet. The start stage and end stage sequence identifies
the range of stages for which the amount applies. The end stage
sequence is NULL, and the current stage sequence is NOT NULL for the
row in the latest stage.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_WS_ACCOUNT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNT_LINE_ID
PSB_WS_ACCOUNT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_GROUP_ID
ColumnCODE_COMBINATION_ID
PSB_WS_ACCOUNT_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
ColumnBUDGET_YEAR_ID
PSB_WS_ACCOUNT_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_YEAR_ID
ColumnCURRENCY_CODE
PSB_WS_ACCOUNT_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERVICE_PACKAGE_ID
PSB_WS_ACCOUNT_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_LINE_ID
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_LINE_ID NUMBER (20) Yes Account line unique identifier
CODE_COMBINATION_ID NUMBER (20) Yes General Ledger code combination unique identifier
BUDGET_GROUP_ID NUMBER
Yes Budget group unique identifier. Budget group to which this account belongs.
SERVICE_PACKAGE_ID NUMBER (20) Yes Service package unique identifier. Service package to which this line is assigned.
PROJECT_ID NUMBER

For future use
TASK_ID NUMBER

For future use
AWARD_ID NUMBER

For future use
EXPENDITURE_TYPE VARCHAR2 (20)
For future use
ORGANIZATION_ID NUMBER

For future use
POSITION_ID NUMBER (20)
No longer used
POSITION_LINE_ID NUMBER

Position line unique identifier
ELEMENT_SET_ID NUMBER (20)
Element set identifier is used to group a set of account lines for a given position for a given element. Distribution percentages can be modified within a group.
SALARY_ACCOUNT_LINE VARCHAR2 (1)
Indicates if salary is being charged to this account line
STAGE_SET_ID NUMBER
Yes Stage set unique identifier
START_STAGE_SEQ NUMBER
Yes Stage in which the annual or period amounts for this account combination and service package was established for this worksheet
CURRENT_STAGE_SEQ NUMBER
Yes Current stage of this account line. If the current stage is different from the start stage and a change is made, the original amount is stored in a new line for audit trail.
END_STAGE_SEQ NUMBER

Stage up to which the annual or period amounts for the account combination and service package remained unchanged. This value is NULL for the lines in the latest stage of the worksheet.
COPY_OF_ACCOUNT_LINE_ID NUMBER (15)
Account line unique identifier. Source account line from which this line was derived.
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
TEMPLATE_ID NUMBER

General Ledger template unique identifier for summary account lines
BUDGET_YEAR_ID NUMBER (20) Yes Budget year unique identifier. Budget year for which this account line is assigned.
ANNUAL_FTE NUMBER

Full-time equivalency factor computed by annualizing the period full-time equivalencies
CURRENCY_CODE VARCHAR2 (10) Yes Functional currency of the General Ledger Set of Books or STAT for statistical currency. Indicates the currency for the annual and period amounts.
ACCOUNT_TYPE VARCHAR2 (10) Yes General Ledger account type is A (Asset), L (Liability), O (Equity), R (Revenue) or E (Expense)
BALANCE_TYPE VARCHAR2 (1) Yes Balance type is B (budget), A (actual), X (encumbrance) or E (estimate)
YTD_AMOUNT NUMBER

Annual amount
NOTE_ID NUMBER

Note unique identifier for the note associated with the account line
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
PERIOD13_AMOUNT NUMBER

For future use
PERIOD14_AMOUNT NUMBER

For future use
PERIOD15_AMOUNT NUMBER

For future use
PERIOD16_AMOUNT NUMBER

For future use
PERIOD17_AMOUNT NUMBER

For future use
PERIOD18_AMOUNT NUMBER

For future use
PERIOD19_AMOUNT NUMBER

For future use
PERIOD20_AMOUNT NUMBER

For future use
PERIOD21_AMOUNT NUMBER

For future use
PERIOD22_AMOUNT NUMBER

For future use
PERIOD23_AMOUNT NUMBER

For future use
PERIOD24_AMOUNT NUMBER

For future use
PERIOD25_AMOUNT NUMBER

For future use
PERIOD26_AMOUNT NUMBER

For future use
PERIOD27_AMOUNT NUMBER

For future use
PERIOD28_AMOUNT NUMBER

For future use
PERIOD29_AMOUNT NUMBER

For future use
PERIOD30_AMOUNT NUMBER

For future use
PERIOD31_AMOUNT NUMBER

For future use
PERIOD32_AMOUNT NUMBER

For future use
PERIOD33_AMOUNT NUMBER

For future use
PERIOD34_AMOUNT NUMBER

For future use
PERIOD35_AMOUNT NUMBER

For future use
PERIOD36_AMOUNT NUMBER

For future use
PERIOD37_AMOUNT NUMBER

For future use
PERIOD38_AMOUNT NUMBER

For future use
PERIOD39_AMOUNT NUMBER

For future use
PERIOD40_AMOUNT NUMBER

For future use
PERIOD41_AMOUNT NUMBER

For future use
PERIOD42_AMOUNT NUMBER

For future use
PERIOD43_AMOUNT NUMBER

For future use
PERIOD44_AMOUNT NUMBER

For future use
PERIOD45_AMOUNT NUMBER

For future use
PERIOD46_AMOUNT NUMBER

For future use
PERIOD47_AMOUNT NUMBER

For future use
PERIOD48_AMOUNT NUMBER

For future use
PERIOD49_AMOUNT NUMBER

For future use
PERIOD50_AMOUNT NUMBER

For future use
PERIOD51_AMOUNT NUMBER

For future use
PERIOD52_AMOUNT NUMBER

For future use
PERIOD53_AMOUNT NUMBER

For future use
PERIOD54_AMOUNT NUMBER

For future use
PERIOD55_AMOUNT NUMBER

For future use
PERIOD56_AMOUNT NUMBER

For future use
PERIOD57_AMOUNT NUMBER

For future use
PERIOD58_AMOUNT NUMBER

For future use
PERIOD59_AMOUNT NUMBER

For future use
PERIOD60_AMOUNT NUMBER

For future use
REQUEST_ID NUMBER (15)
Enhanced Who column
FUNCTIONAL_TRANSACTION VARCHAR2 (1)
Indicates functional currency transaction.
BUDGET_GROUP_CHANGED VARCHAR2 (1)
Budget group changed flag
Query Text

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


SELECT ACCOUNT_LINE_ID
,      CODE_COMBINATION_ID
,      BUDGET_GROUP_ID
,      SERVICE_PACKAGE_ID
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      EXPENDITURE_TYPE
,      ORGANIZATION_ID
,      POSITION_ID
,      POSITION_LINE_ID
,      ELEMENT_SET_ID
,      SALARY_ACCOUNT_LINE
,      STAGE_SET_ID
,      START_STAGE_SEQ
,      CURRENT_STAGE_SEQ
,      END_STAGE_SEQ
,      COPY_OF_ACCOUNT_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TEMPLATE_ID
,      BUDGET_YEAR_ID
,      ANNUAL_FTE
,      CURRENCY_CODE
,      ACCOUNT_TYPE
,      BALANCE_TYPE
,      YTD_AMOUNT
,      NOTE_ID
,      PERIOD1_AMOUNT
,      PERIOD2_AMOUNT
,      PERIOD3_AMOUNT
,      PERIOD4_AMOUNT
,      PERIOD5_AMOUNT
,      PERIOD6_AMOUNT
,      PERIOD7_AMOUNT
,      PERIOD8_AMOUNT
,      PERIOD9_AMOUNT
,      PERIOD10_AMOUNT
,      PERIOD11_AMOUNT
,      PERIOD12_AMOUNT
,      PERIOD13_AMOUNT
,      PERIOD14_AMOUNT
,      PERIOD15_AMOUNT
,      PERIOD16_AMOUNT
,      PERIOD17_AMOUNT
,      PERIOD18_AMOUNT
,      PERIOD19_AMOUNT
,      PERIOD20_AMOUNT
,      PERIOD21_AMOUNT
,      PERIOD22_AMOUNT
,      PERIOD23_AMOUNT
,      PERIOD24_AMOUNT
,      PERIOD25_AMOUNT
,      PERIOD26_AMOUNT
,      PERIOD27_AMOUNT
,      PERIOD28_AMOUNT
,      PERIOD29_AMOUNT
,      PERIOD30_AMOUNT
,      PERIOD31_AMOUNT
,      PERIOD32_AMOUNT
,      PERIOD33_AMOUNT
,      PERIOD34_AMOUNT
,      PERIOD35_AMOUNT
,      PERIOD36_AMOUNT
,      PERIOD37_AMOUNT
,      PERIOD38_AMOUNT
,      PERIOD39_AMOUNT
,      PERIOD40_AMOUNT
,      PERIOD41_AMOUNT
,      PERIOD42_AMOUNT
,      PERIOD43_AMOUNT
,      PERIOD44_AMOUNT
,      PERIOD45_AMOUNT
,      PERIOD46_AMOUNT
,      PERIOD47_AMOUNT
,      PERIOD48_AMOUNT
,      PERIOD49_AMOUNT
,      PERIOD50_AMOUNT
,      PERIOD51_AMOUNT
,      PERIOD52_AMOUNT
,      PERIOD53_AMOUNT
,      PERIOD54_AMOUNT
,      PERIOD55_AMOUNT
,      PERIOD56_AMOUNT
,      PERIOD57_AMOUNT
,      PERIOD58_AMOUNT
,      PERIOD59_AMOUNT
,      PERIOD60_AMOUNT
,      REQUEST_ID
,      FUNCTIONAL_TRANSACTION
,      BUDGET_GROUP_CHANGED
FROM PSB.PSB_WS_ACCOUNT_LINES;

Dependencies

[top of page]

PSB.PSB_WS_ACCOUNT_LINES does not reference any database object

PSB.PSB_WS_ACCOUNT_LINES is referenced by following:

SchemaAPPS
SynonymPSB_WS_ACCOUNT_LINES