BI_LN_VATRVC_VW(SQL View) |
Index Back |
|---|---|
Bill Line Reverse VAT View |
| SELECT business_unit , invoice , tax_cd_vat_rvc , SUM(net_extended_amt) , SUM(vat_amt_rvc) , SUM(vat_basis_amt) , bi_currency_cd FROM PS_BI_LINE WHERE bi_tax_timing = ' ' AND tax_cd_vat_rvc 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_rvc, 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_RVC | Character(8) | VARCHAR2(8) NOT NULL | Reverse Charge VAT Code |
| 4 | VAT_SUM_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sum Total of VAT Code |
| 5 | VAT_RVC_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Final VAT Reverse Charge |
| 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 |