TAX_RPT_ENTITYPrompt Table: TAX_ENTITY_DEFN
ENTITY_BOOKPrompt Table: ENTTY_BOOK_DEFN
ASSET_BLOCKPrompt Table: ASSET_BLOCK_VW
FISCAL_YEARTAX_DEPR_BAL_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT TAX_RPT_ENTITY , ENTITY_BOOK , ASSET_BLOCK , FISCAL_YEAR FROM PS_TAX_DEPR_BAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAX_RPT_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Tax/Reporting Entity
Prompt Table: TAX_ENTITY_DEFN |
| 2 | ENTITY_BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
India Assets Register
Prompt Table: ENTTY_BOOK_DEFN |
| 3 | ASSET_BLOCK |
Character(20) | VARCHAR2(20) NOT NULL |
Block of Assets
Prompt Table: ASSET_BLOCK_VW |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |