RMA_IVC_VAT_VW (SQL View)	Index Back
RMA VAT Fields fr Invoice RMA VAT Fields fr Invoice

RMA_IVC_VAT_VW

(SQL View)

RMA VAT Fields fr Invoice

SELECT HV.BUSINESS_UNIT , HV.INVOICE , HV.PROVINCE , HV.VAT_CALC_GROSS_NET , HV.VAT_DCLRTN_DT_SRC , HV.VAT_DCLRTN_POINT , HV.VAT_EXCPTN_CERTIF , HV.VAT_EXCPTN_TYPE , HV.VAT_HDR_IND , HV.VAT_RECALC_FLG , HV.VAT_RGSTRN_BUYER , HV.VAT_RGSTRN_SELLER , HV.VAT_ROUND_RULE FROM PS_BI_HDR_VAT HV

# 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 PROVINCE Character(1) VARCHAR2(1) NOT NULL Province

4 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net

5 VAT_DCLRTN_DT_SRC Character(1) VARCHAR2(1) NOT NULL Declaration Date Source
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable

6 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time

7 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.

8 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated

9 VAT_HDR_IND Character(1) VARCHAR2(1) NOT NULL VAT Header Indicator

10 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.

11 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.

12 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration

13 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up

#	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	PROVINCE	Character(1)	VARCHAR2(1) NOT NULL	Province
4	VAT_CALC_GROSS_NET	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount. G=Calculate at Gross N=Calculate at Net
5	VAT_DCLRTN_DT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Declaration Date Source A=Delivery Date - Ext Process D=Delivery Date - Txn Entry I=Invoice Date M=Manual Entry N=Not Applicable
6	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
7	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
8	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
9	VAT_HDR_IND	Character(1)	VARCHAR2(1) NOT NULL	VAT Header Indicator
10	VAT_RECALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
11	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
12	VAT_RGSTRN_SELLER	Character(20)	VARCHAR2(20) NOT NULL	Seller's VAT Registration
13	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up