GPFR_DUCS_TAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPFR_DUCS_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	DUCS Process Instance
2	GPFR_DUCS_CD	Character(10)	VARCHAR2(10) NOT NULL	GPFR: DUCS Code
3	GPFR_DUCS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	GPFR: DUCS Type
4	GPFR_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number
5	GPFR_ROW_NUM2	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number (level2). Used in the DUCS/BDA/TRC reports.
6	GPFR_DUCS_REG_FLG	Character(1)	VARCHAR2(1) NOT NULL	DUCS Regularization Flag Default Value: N
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
8	GPFR_DUCS_RECORD	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Record Code
9	GPFR_DUCS_TAT_ID	Character(25)	VARCHAR2(25) NOT NULL	DUCS TAT ID
10	GPFR_DUCS_TAT_AMT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DUCS TAT Amount 1
11	GPFR_DUCS_TAT_TX1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DUCS TAT Tax 1
12	GPFR_DUCS_TAT_TYP1	Character(3)	VARCHAR2(3) NOT NULL	DUCS TAT Type 1
13	GPFR_DUCS_TAT_AMT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DUCS TAT Amount 2
14	GPFR_DUCS_TAT_TX2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DUCS TAT Tax 2
15	GPFR_DUCS_TAT_TYP2	Character(3)	VARCHAR2(3) NOT NULL	Base Type 2
16	GPFR_DUCS_TAT_TX3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DUCS TAT Tax 3
17	GPFR_DUCS_TAT_TYP3	Character(3)	VARCHAR2(3) NOT NULL	DUCS TAT Type3
18	GPFR_DUCS_TAT_AMT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DUCS TAT Amount 3
19	GPFR_DUCS_TRS_CUR1	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Currency 1
20	GPFR_DUCS_TRS_CUR2	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Currency 2
21	GPFR_DUCS_TRS_CUR3	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Currency 3
22	GPFR_DUCS_RTRO_FLG	Number(6,0)	INTEGER NOT NULL	DUCS Retro Flag 0 - Retro 1 - Current