SETIDASSET_BLOCKTAX_CLASS_AMTAX_CLASS_AM_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT SETID , ASSET_BLOCK , TAX_CLASS_AM , DESCR50 FROM PS_TAX_CLASS_AM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ASSET_BLOCK |
Character(20) | VARCHAR2(20) NOT NULL | Block of Assets |
| 3 | TAX_CLASS_AM |
Character(6) | VARCHAR2(6) NOT NULL | Guideline Tax Class |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |