VAT_ROUND_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ROUND_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Round Type C=Currency G=Generic
3	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
4	FIELDNAME_IN	Character(18)	VARCHAR2(18) NOT NULL	Input Fieldname
5	FIELDNAME_CUR	Character(18)	VARCHAR2(18) NOT NULL	Currency Field
6	FIELDNAME_CUREFFDT	Character(18)	VARCHAR2(18) NOT NULL	Currency Effective Date
7	FIELDNAME_OUT	Character(18)	VARCHAR2(18) NOT NULL	Output Fieldname
8	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
9	RETURN_CODE	Signed Number(5,0)	DECIMAL(4) NOT NULL	Return Code
10	TRUNCATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used for Round Up. 'Y'es - truncate 1 decimal place past the round precision. 'N' - do not truncate
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	CHAR_KEY_01	Character(25)	VARCHAR2(25) NOT NULL	Character field variable for storing value of KEY field that consisted of characters.
13	CHAR_KEY_02	Character(25)	VARCHAR2(25) NOT NULL	Character field variable for storing value of KEY field that consisted of characters.
14	TRUNC_PRECISION	Signed Number(3,0)	DECIMAL(2) NOT NULL	Truncation Precision
15	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
16	ROUND_PRECISION	Signed Number(4,0)	DECIMAL(3) NOT NULL	Rounding Precision
17	COLUMN_ADJ	Number(3,0)	SMALLINT NOT NULL	Column Adjustment Value
18	ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down N=Natural Round U=Round Up
19	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups