VENDOR_IDVAT_ENTITYPrompt Table: VAT_ENTITY
ITA_VAT_RPT2_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT VENDOR_ID ,PROCESS_INSTANCE ,VAT_ENTITY ,ITA_CNTRY_2CHAR ,VAT_RGSTRN_TPRTNR ,STATE ,POSTAL ,CITY ,ADDRESS1 ,VNDR_LOC ,NAME1 ,PROGRESSIVE_ID FROM PS_ITA_VAT_RPT6_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | 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.
Prompt Table: VAT_ENTITY |
| 4 | ITA_CNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Country Code |
| 5 | VAT_RGSTRN_TPRTNR | Character(20) | VARCHAR2(20) NOT NULL | Trading Partner's VAT Registration ID **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages. |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 9 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | PROGRESSIVE_ID | Character(5) | VARCHAR2(5) NOT NULL | Progressive ID |