BI_LINE_VAT_VW(SQL View) |
Index Back |
|---|---|
Bill Line VAT View |
| SELECT business_unit , invoice , tax_cd_vat , SUM(net_extended_amt) , SUM(vat_amt) , SUM(vat_basis_amt) , bi_currency_cd FROM PS_BI_LINE WHERE bi_tax_timing = ' ' AND tax_cd_vat IN ( SELECT tax_cd FROM ps_tax_header_tbl WHERE tax_cd_type = 'V') AND adj_line_type <> 'ACR' GROUP BY business_unit, invoice, tax_cd_vat, bi_currency_Cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | 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. |
| 4 | VAT_SUM_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sum Total of VAT Code |
| 5 | VAT_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Final VAT |
| 6 | TOT_VAT_BASIS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 7 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |