VAT_DF_TXC_TMP (SQL Table)	Index Back
VAT Transaction Default Temp

VAT_DF_TXC_TMP

(SQL Table)

VAT Transaction Default Temp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

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

5 VAT_TXN_CD_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates at what level PeopleSoft General Ledger determines the VAT transaction type (VAT_TXN_TYPE_CD) for accounting and reporting. The transaction type can be specified at the Journal Source, Account, or Business Unit level.
D=Default from Higher Level
S=Specify at this Level

6 VAT_DCLRTN_PNT_FLG Character(1) VARCHAR2(1) NOT NULL VAT Declaration Point
D=Default from Higher Level
S=Specify at this Level

7 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4	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.
5	VAT_TXN_CD_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates at what level PeopleSoft General Ledger determines the VAT transaction type (VAT_TXN_TYPE_CD) for accounting and reporting. The transaction type can be specified at the Journal Source, Account, or Business Unit level. D=Default from Higher Level S=Specify at this Level
6	VAT_DCLRTN_PNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Declaration Point D=Default from Higher Level S=Specify at this Level
7	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