VAT_ENTITYOI_VT_ENTITY_VW(SQL View) |
Index Back |
|---|---|
EntityOTBI Entity View |
| SELECT A.VAT_ENTITY , A.DESCR , A.DESCRSHORT FROM %Table(VAT_ENTITY) A UNION SELECT ' ' , '-' , '-' FROM %Table(INSTALLATION) B |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_ENTITY |
Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |