AM_VATRCVR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
3	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW
5	YEAR_OF_REG	Number(4,0)	SMALLINT NOT NULL	Year of Regularization
6	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BOOKB3_NONVW
7	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
8	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
9	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
10	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
11	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
12	RATE_EFFDT	Date(10)	DATE	Rate Effective Date
13	DRAFT_RCVRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Run Mode D=Draft F=Final
14	VAT_TRANS_TYPE_POS	Character(4)	VARCHAR2(4) NOT NULL	Positive Adjustment
15	VAT_TRANS_TYPE_NEG	Character(4)	VARCHAR2(4) NOT NULL	Negative Adjustment
16	AM_MIN_VAT_VAR	Number(6,2)	DECIMAL(5,2) NOT NULL	VAT Adjust Variance
17	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
18	AM_VAT_UPDT_COE_SW	Character(1)	VARCHAR2(1) NOT NULL	Update Final Coefficients Y/N Table Edit
19	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.
20	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
21	VAT_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	Maintain VAT Balances
22	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.
23	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
24	LOOP_COUNT	Number(4,0)	SMALLINT NOT NULL	Number of Program Loops
25	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
26	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.
27	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
28	VAT_RGSTRN_ID	Character(20)	VARCHAR2(20) NOT NULL	VAT Registration ID
29	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
30	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
31	SETID_CAL_DETP	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetId
32	PREV_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Previous Book
33	PREV_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Previous Business Unit
34	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
35	ROW_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Row Found
36	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
37	VAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	VAT SetID
38	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
39	BUSINESS_UNIT_VAT	Character(5)	VARCHAR2(5) NOT NULL	Vat Apportionment Business Uni
40	CHARTFIELD_PR1_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 1 Value
41	CHARTFIELD_PR2_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 2 Value
42	VAT_CONFIN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Final Coeff. of Constraint
43	VAT_TAXFIN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Final Coefficient of Taxation
44	VAT_ADMFIN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Final Coefficient of Admission
45	VAT_RCVRFIN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Final Vat Recoverability %
46	YEAR_OF_ADJ	Number(4,0)	SMALLINT NOT NULL	Year of Adjustment
47	SETID_DIST_TMPLLN	Character(5)	VARCHAR2(5) NOT NULL	Setid Dist_ln
48	VAT_ATTR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	VAT Attribute Status E=Errored F=Final N=New P=Posted T=Temporary
49	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
50	ASSET_ID_PREV	Character(12)	VARCHAR2(12) NOT NULL	Previous Asset ID
51	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
52	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
53	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
54	IN_SECONDS	Number(6,0)	INTEGER NOT NULL	Seconds
55	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
56	YEAR_OF_INIT	Number(4,0)	SMALLINT NOT NULL	Initial VAT Recoverable Year
57	SETID_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Setid
58	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
59	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag