VAT_RCN_AP1_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	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	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".
5	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
6	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
7	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
9	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
10	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
13	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
14	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT
15	VAT_NRCVR_ALL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allocate Non-Recoverable VAT
16	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
17	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
18	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.
19	BUS_UNIT_GL_TXN	Character(5)	VARCHAR2(5) NOT NULL	Transaction GL Business Unit
20	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
21	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
22	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
23	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
24	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.
25	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
26	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
27	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.
28	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.
29	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.