VAT_RPT_INST2 (SQL Table)	Index Back
VAT Report Instance Details

VAT_RPT_INST2

(SQL Table)

VAT Report Instance Details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 VAT_RPT_ID Character(8) VARCHAR2(8) NOT NULL Report ID

3 VAT_RPT_LINE_NBR Number(5,0) INTEGER NOT NULL Line Number

4 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.

5 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country

6 VAT_DCMNT_ID Number(8,0) INTEGER NOT NULL VAT Document ID

7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

8 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

9 INCLD_IN_TTL_FLG Character(1) VARCHAR2(1) NOT NULL Include in Report Total

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description

11 CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Reporting Currency
Prompt Table: CURRENCY_CD_TBL

12 TAX_BASIS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount - Reporting

13 TAX_AMT_GROSS_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Tax Amount - Reporting

14 TAX_AMT_RCVRY_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt - Reporting

15 TAX_AMT_RBT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rebate Amount - Reporting

16 TAX_TRANS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Transaction Amt - Report

17 VAT_RVCHG_MONTH Character(2) VARCHAR2(2) NOT NULL Globalizations : 09-09-2008 VAT Reverse Charge Month filed used for Reverse Charge Sales List
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December

18 VAT_RGSTRN_TPRTNR Character(20) VARCHAR2(20) NOT NULL Trading Partner's VAT Registration ID **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VAT_RPT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report ID
3	VAT_RPT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number
4	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.
5	COUNTRY_VAT_RPTG	Character(3)	VARCHAR2(3) NOT NULL	VAT Reporting Country
6	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT Document ID
7	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
8	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
9	INCLD_IN_TTL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include in Report Total
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency Prompt Table: CURRENCY_CD_TBL
12	TAX_BASIS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Basis Amount - Reporting
13	TAX_AMT_GROSS_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Tax Amount - Reporting
14	TAX_AMT_RCVRY_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amt - Reporting
15	TAX_AMT_RBT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rebate Amount - Reporting
16	TAX_TRANS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Transaction Amt - Report
17	VAT_RVCHG_MONTH	Character(2)	VARCHAR2(2) NOT NULL	Globalizations : 09-09-2008 VAT Reverse Charge Month filed used for Reverse Charge Sales List 01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December
18	VAT_RGSTRN_TPRTNR	Character(20)	VARCHAR2(20) NOT NULL	Trading Partner's VAT Registration ID ** WARNING ** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.