VAT_ENTITYCOUNTRYN=No
Y=Yes
OI_VCRY_VW(SQL View) |
Index Back |
|---|---|
VAT Reporting CountryPrimary record for VAT Reporting Country ChartField |
| SELECT VER.VAT_ENTITY , VER.COUNTRY , CRY.DESCR , VER.COUNTRY_2CHAR , VER.VAT_RGSTRN_ID , VER.LOC_RGSTRN_ID , VER.HOME_COUNTRY_FLG , VER.TAX_AUTH_REGION , VER.NAME1 , VER.NAME2 , VER.VAT_ADMIN_ID , VER.LOCATION_SETID , VER.LOCATION , LOC.DESCR LOC_DESC , VER.CURRENCY_RPTG , VER.IST_CRNCY_RPTG , VER.LAST_VAT_DCMNT_ID , VER.LAST_IST_DCMNT_ID , VER.IST_RPTG_FLG , XLI1.DESCR IST_LVL_OBLIG_DESC , XLI2.DESCR VAT_ACCTG_SCH_DESC FROM PS_VAT_ENT_RGSTRN VER LEFT OUTER JOIN PS_COUNTRY_TBL CRY ON VER.COUNTRY=CRY.COUNTRY LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = VER.IST_LEVEL_OBLIG AND XLI1.CODESETGROUPNAME='IST_LEVEL_OBLIG' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = VER.VAT_ACCTG_SCHEME AND XLI2.CODESETGROUPNAME='VAT_ACCTG_SCHEME' LEFT OUTER JOIN PS_LOCATION_TBL LOC ON VER.LOCATION_SETID=LOC.SETID AND VER.LOCATION =LOC.LOCATION AND VER.LOCATION_SETID=LOC.SETID WHERE LOC.EFFDT= ( SELECT MAX(ED.EFFDT) FROM PS_LOCATION_TBL ED WHERE LOC.SETID =ED.SETID AND LOC.LOCATION=ED.LOCATION AND ED.EFF_STATUS='A' AND ED.EFFDT <= %CurrentDateIn ) OR LOC.LOCATION IS NULL UNION SELECT ' ' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , 0 , 0 , '-' , '-' , '-' FROM PS_INSTALLATION |
| # | 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 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | COUNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Country Code |
| 5 | VAT_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | VAT Registration ID |
| 6 | LOC_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | Local VAT Registration ID |
| 7 | HOME_COUNTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Home Country
N=No Y=Yes |
| 8 | TAX_AUTH_REGION | Character(4) | VARCHAR2(4) NOT NULL | Tax Authority Region |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 11 | VAT_ADMIN_ID | Character(20) | VARCHAR2(20) NOT NULL | Administrative ID |
| 12 | LOCATION_SETID | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 13 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 14 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location |
| 15 | CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Reporting Currency |
| 16 | IST_CRNCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Intrastat Reporting Currency |
| 17 | LAST_VAT_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | Last VAT Document ID Assigned |
| 18 | LAST_IST_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | Last Intrastat Doc ID Assigned |
| 19 | IST_RPTG_FLG | Character(1) | VARCHAR2(1) NOT NULL | Intrastat Reporting Required |
| 20 | IST_LVL_OBLIG_DESC | Character(30) | VARCHAR2(30) NOT NULL | Intrastat Reporting Threshold description |
| 21 | VAT_ACCTG_SCH_DESC | Character(30) | VARCHAR2(30) NOT NULL | Accounting Scheme description |