VAT_RECON_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	VAT_TXN_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	VAT Transaction Source
4	VAT_RPT_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Print Report As DRFT=Draft Report FNL=Final Report RPRN=Reprint
5	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
6	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	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"". "
8	REFERENCE	Character(30)	VARCHAR2(30) NOT NULL	Field to show when a variable is a reference variable.
9	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
11	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
12	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
13	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.
14	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
15	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
16	EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	EmplID
17	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
18	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
19	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
20	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
21	TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Transaction Code
22	TAX_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Basis Amount - Base
23	VAT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Amount in Base Curr
24	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.
25	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.
26	ACCOUNT_2	Character(10)	VARCHAR2(10) NOT NULL	Account
27	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT Document ID
28	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
29	VAT_ENTRY_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Entry Type I=Input O=Output