SII_INV_VAT_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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. |
| 3 | VAT_TXN_SOURCE |
Character(6) | VARCHAR2(6) NOT NULL | VAT Transaction Source |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | SII_INVOICE_ID |
Character(60) | VARCHAR2(60) NOT NULL | SII_INVOICE_ID |
| 6 | TAX_CD_VAT |
Character(8) | VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table: VAT_HEADER_VW |
| 7 | TAX_CD_VAT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage. |
| 8 | VAT_RVRSE_CHG_GDS |
Character(1) | VARCHAR2(1) NOT NULL | VAT Reverse Charge goods flag |
| 9 | SII_VAT_TXN_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 10 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 11 | SII_INTRA_COMM_CD | Character(1) | VARCHAR2(1) NOT NULL |
Intra-Comm Trans Type
A=A(Transactions in Article 70) B=B(Transactions in Article 9) N=Not Applicable |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | TOT_VAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 14 | TOT_VAT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 15 | TOT_VAT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 16 | TOT_VAT_BASIS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 17 | TOT_VAT_BASIS_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 18 | TOT_VAT_BASIS_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 19 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 20 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 21 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 22 | SII_RATE_DIV_XEU | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 23 | SII_RATE_MULT_XEU | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 24 | VAT_APPLICABILITY |
Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |