[Home] [Help] [Dependency Information]
Object Name: | PSB_FLEX_MAPPING_SETS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_FLEX_MAPPING_SETS |
Subobject Name: | |
Status: | VALID |
PSB_FLEX_MAPPING_SETS stores information about the flexfield mapping between General Ledger and Public Sector Budgeting. A flexfield mapping set includes information for mapping multiple segments between General Ledger and Public Sector Budgeting and can be specified during worksheet creation and General Ledger posting. Flexfield mapping is used to : (i) consolidate the information for displaying balances in the budget preparation worksheets if the chart of accounts includes fiscal year as a segment. In this scenario, all account combinations that have only the fiscal year segment different will be consolidated into the corresponding account combination that has the value for the fiscal year segment set to the current year in the worksheet and (ii) reorganize account combinations in chart of accounts. Future changes to the account combinations can be handled by setting up the mapping information and using the posting process to create the new reorganized account combinations in General Ledger during the final posting process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_FLEX_MAPPING_SETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FLEX_MAPPING_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLEX_MAPPING_SET_ID | NUMBER | (15) | Yes | Flex mapping set unique identifier |
NAME | VARCHAR2 | (30) | Yes | Flexfield mapping set name |
DESCRIPTION | VARCHAR2 | (240) | Flexfield mapping set description | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | General Ledger Set of Books unique identifier |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT FLEX_MAPPING_SET_ID
, NAME
, DESCRIPTION
, SET_OF_BOOKS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_FLEX_MAPPING_SETS;
PSB.PSB_FLEX_MAPPING_SETS does not reference any database object
PSB.PSB_FLEX_MAPPING_SETS is referenced by following:
|
|
|