SII_LN_AP_VW

(SQL View)
 Index Back

SELECT d.business_unit , d.voucher_id , d.voucher_line_num , d.DISTRIB_LINE_NUM ,l.voucher_id_related , d.tax_cd_vat , d.tax_cd_vat_pct , d.vat_applicability , L.VAT_RVRSE_CHG_GDS , d.VAT_TXN_TYPE_CD , H.invoice_dt , d.VAT_CALC_AMT , d.VAT_CALC_AMT_BSE ,d.VAT_BASIS_AMT , d.VAT_BASIS_AMT_BSE ,d.CURRENCY_CD , d.txn_currency_cd , d.rt_type , d.vat_entity , h.invoice_id ,L.descr ,H.ACCOUNTING_DT FROM PS_DISTRIB_LINE d , PS_VOUCHER_line L , PS_VOUCHER H WHERE D.VAT_ENTITY <> ' ' AND H.POST_STATUS_AP = 'P' AND d.business_unit = L.business_unit AND d.voucher_id = L.voucher_id AND d.voucher_line_num = L.voucher_line_num AND d.business_unit = H.business_unit AND d.voucher_id = H.voucher_id AND d.VAT_APPLICABILITY NOT IN ('V', 'N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 VAT_SEQ_NUM Number(6,0) INTEGER NOT NULL VAT Sequence Number
5 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher
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.
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_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
9 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag
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 INVOICE_DT Date(10) DATE Invoice Date
12 TOT_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
13 TOT_VAT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
14 TOT_VAT_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Basis Amount
15 TOT_VAT_BASIS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Basis Amount
16 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. "
17 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
18 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.
19 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.
20 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
22 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple