GPFR_AF_DU_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPFR_AF_EXTRACT_ID	Character(18)	VARCHAR2(18) NOT NULL	Application Framework - Extraction ID
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	GPFR_AF_APPL	Character(10)	VARCHAR2(10) NOT NULL	Application Framework - Application
4	GPFR_AF_NODE_SET	Character(16)	VARCHAR2(16) NOT NULL	Application Framework - Node Set
5	GPFR_DUCS_CD	Character(10)	VARCHAR2(10) NOT NULL	GPFR: DUCS Code
6	GPFR_DUCS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	GPFR: DUCS Type
7	GPFR_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number
8	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.
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	GPFR_DUCS_DEST	Character(10)	VARCHAR2(10) NOT NULL	GPFR: DUCS Addressee
11	GPFR_DUCS_MR1	Character(10)	VARCHAR2(10) NOT NULL	Contact code for the Urssaf, Assedic, agirc/Arrco which will receive the Ducs file
12	GPFR_DUCS_FR1	Character(10)	VARCHAR2(10) NOT NULL	FR record in DUCS
13	GPFR_DUCS_DT1	Character(10)	VARCHAR2(10) NOT NULL	DT record in DUCS
14	GPFR_DUCS_AE1	Character(10)	VARCHAR2(10) NOT NULL	AE record in DUCS
15	GPFR_DUCS_PAI1	Character(10)	VARCHAR2(10) NOT NULL	Glopal Payroll France DUCS Payment Field
16	GPFR_DUCS_SLIP_TYP	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Slip Type
17	GPFR_DUCS_PAI_MD	Character(3)	VARCHAR2(3) NOT NULL	GPFR: Payment Type
18	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
19	GPFR_DUCS_EN1	Character(10)	VARCHAR2(10) NOT NULL	GPFR: Establishment
20	GPFR_DUCS_FZ1	Character(1)	VARCHAR2(1) NOT NULL	Flag for VLU : Main establishment or not Y/N Table Edit Default Value: N
21	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
22	GPFR_DUCS_R2_REF1	Character(35)	VARCHAR2(35) NOT NULL	GPFR: Reference 1