TAX_ENTITY_DEFN(SQL Table) |
Index Back |
|---|---|
Tax Entity Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Tax/Reporting Entity | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | FIFTY_PERC_RULE | Signed Number(4,0) | DECIMAL(3) NOT NULL | 50% rule, assets in service < |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 5 | UPD_CLOSE_BAL | Character(1) | VARCHAR2(1) NOT NULL |
Update on Close Balances
Y/N Table Edit Default Value: Y |
| 6 | UPD_OTH_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Update on other amounts
Y/N Table Edit Default Value: Y |