TAX_RPT_ENTITYPrompt Table: TAX_ENTITY_DEFN
ENTITY_BOOKPrompt Table: ENTTY_BOOK_DEFN
ASSET_BLOCKPrompt Table:
ASSET_BLOCK_VW
Set Control Field: ASSET_BLOCK
FISCAL_YEARTAX_CLASS_AMPrompt Table: TAX_CLASS_AM_VW
Prompt Table: CURRENCY_CD_TBL
TAX_DEPR_BAL(SQL Table) |
Index Back |
|---|---|
Tax Depreciation Balance - IND |
| # | 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 |
| 5 | TAX_CLASS_AM |
Character(6) | VARCHAR2(6) NOT NULL |
Guideline Tax Class
Prompt Table: TAX_CLASS_AM_VW |
| 6 | OPEN_WDV_VAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 7 | ADD_50_RULE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Add/Adj (50% Rule) |
| 8 | ADD_REG_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Add/Adj (Regular) |
| 9 | TOTAL_PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Proceeds |
| 10 | CCA_RATE | Number(7,3) | DECIMAL(6,3) NOT NULL | CCA Rate % |
| 11 | DEPR_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Depreciation Amount |
| 12 | DEPR_AMT_50 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Depreciation Amt - 50% |
| 13 | MANUAL_ADJ | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Manual Adjustment |
| 14 | CLOSING_WDV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Closing Balance |
| 15 | LAST_UPDATED_BY | Character(30) | VARCHAR2(30) NOT NULL | LastUpdatedUser |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |