GPFR_DUCS_TRS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPFR_DUCS_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	DUCS Process Instance
3	GPFR_DUCS_CD	Character(10)	VARCHAR2(10) NOT NULL	GPFR: DUCS Code
4	GPFR_DUCS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	GPFR: DUCS Type
5	GPFR_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number
6	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.
7	GPFR_DUCS_TRS_TX1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate 1 in the TRS DUCS Record
8	GPFR_DUCS_REG_FLG	Character(1)	VARCHAR2(1) NOT NULL	DUCS Regularization Flag Y/N Table Edit Default Value: N
9	GPFR_DUCS_RECORD	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Record Code
10	GPFR_DUCS_TRS_ID	Character(25)	VARCHAR2(25) NOT NULL	GPFR: Location Code
11	GPFR_DUCS_TRS_AMT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 1 in the TRS DUCS Record
12	GPFR_DUCS_TRS_CUR1	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Currency 1
13	GPFR_DUCS_TRS_TX2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate 2 in the TRS DUCS Record
14	GPFR_DUCS_TRS_AMT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 2 in the TRS DUCS Record
15	GPFR_DUCS_TRS_CUR2	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Currency 2
16	GPFR_DUCS_TRS_TX3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate 3 in the TRS DUCS Record
17	GPFR_DUCS_TRS_AMT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 3 in the TRS DUCS Record
18	GPFR_DUCS_TRS_CUR3	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Currency 3
19	GPFR_DUCS_RTRO_FLG	Number(6,0)	INTEGER NOT NULL	DUCS Retro Flag 0 - Retro 1 - Current
20	GPFR_DUCS_TRS_TYP1	Character(3)	VARCHAR2(3) NOT NULL	DUCS TRS Type1
21	GPFR_DUCS_TRS_TYP2	Character(3)	VARCHAR2(3) NOT NULL	DUCS TRS Type2
22	GPFR_DUCS_TRS_TYP3	Character(3)	VARCHAR2(3) NOT NULL	DUCS TRS Type3