VAT_ENTITYIST_FLOWA=Arrivals
D=Dispatches
COUNTRY_IST_RPTGIST_CNTRY_VW(SQL View) |
Index Back |
|---|---|
VAT Entity Intrastat Countries |
| SELECT A.VAT_ENTITY, B.IST_FLOW, A.COUNTRY, C.DESCR FROM PS_VAT_ENT_RGSTRN A, PS_IST_COUNTRY_TBL B, PS_COUNTRY_TBL C WHERE A.IST_RPTG_FLG = 'Y' AND A.COUNTRY = B.COUNTRY AND A.COUNTRY = C.COUNTRY |
| # | 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 | IST_FLOW |
Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals D=Dispatches |
| 3 | COUNTRY_IST_RPTG |
Character(3) | VARCHAR2(3) NOT NULL | IST Reporting Country |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |