VAT_ENT_RGSTRN(SQL Table) |
Index Back |
|---|---|
VAT RegistrationVAT Registration |
| # | 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
Prompt Table: COUNTRY_VAT_VW |
| 3 | COUNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Country Code |
| 4 | VAT_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | VAT Registration ID |
| 5 | LOC_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | Local VAT Registration ID |
| 6 | HOME_COUNTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Home Country
N=No Y=Yes Y/N Table Edit Default Value: N |
| 7 | TAX_AUTH_REGION | Character(4) | VARCHAR2(4) NOT NULL | Tax Authority Region |
| 8 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 9 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 10 | VAT_ADMIN_ID | Character(20) | VARCHAR2(20) NOT NULL | Administrative ID |
| 11 | LOCATION_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Location Set ID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 12 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOC_LOCSET_VW |
| 13 | CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL |
Reporting Currency
Prompt Table: CURRENCY_CD_TBL |
| 14 | IST_CRNCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL |
Intrastat Reporting Currency
Prompt Table: CURRENCY_CD_TBL |
| 15 | LAST_VAT_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | Last VAT Document ID Assigned |
| 16 | LAST_IST_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | Last Intrastat Doc ID Assigned |
| 17 | IST_RPTG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Reporting Required
Y/N Table Edit Default Value: Y |
| 18 | IST_LEVEL_OBLIG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Level of Obligation
1=Level 1 2=Level 2 3=Level 3 4=Level 4 |
| 19 | VAT_ACCTG_SCHEME | Character(1) | VARCHAR2(1) NOT NULL |
VAT Accounting Scheme
0=Non-cash (Accrual) 1=Cash Accounting Default Value: 0 |
| 20 | GT_RPT_ENTITY | Character(1) | VARCHAR2(1) NOT NULL |
Used by GTA
Y/N Table Edit Default Value: N |
| 21 | MOSS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
MOSS Applicable
Y/N Table Edit Default Value: N |