VAT_RCN_TR1_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ACCOUNTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Represents the unique alphanumeric identifier for treasury-specific accounting entries.
4	ACCOUNTING_LINE	Number(5,0)	INTEGER NOT NULL	The specific unique numeric identifier that distinguishes debit and credits for a given treasury accounting ent
5	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	VAT_DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
10	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
11	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
12	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
13	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
14	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT
15	VAT_RCRD_INPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
16	VAT_RCRD_OUTPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
17	TRAN_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Represents the unique transaction identifier in bank reconciliation processing.
18	EVENT_ID	Character(20)	VARCHAR2(20) NOT NULL	The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).
19	TRA_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
20	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
21	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
22	VAT_TRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount in base currency against which the VAT is applicable
23	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
24	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount Base Cur
25	VAT_DCLRTN_DT	Date(10)	DATE	"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "