GPFR_DSN_COMREF

(SQL Table)
 Index Back

Companies for DSN Sending Re.

DSN related record: stores the companies for the a sending references.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field
2 GPFR_DA_COMPANY Character(3) VARCHAR2(3) NOT NULL DADS related field

Prompt Table: COMPANY_TBL

3 GPFR_DUCS_CD Character(10) VARCHAR2(10) NOT NULL GPFR: DUCS Code

Prompt Table: GPFR_DSN_URS_VW

4 GPFR_DA_MNESTAB Character(12) VARCHAR2(12) NOT NULL DADS related field

Prompt Table: ESTAB_COMP_VW

5 GPFR_IJSS_ESTAB Character(12) VARCHAR2(12) NOT NULL IJSS Receiving Establishment

Prompt Table: ESTAB_COMP_VW

6 GPFR_DSN_FRCTN_NBR Number(2,0) SMALLINT NOT NULL Fraction Number
7 EMPL_COUNT Number(12,0) DECIMAL(12) NOT NULL Employee Count
8 GPFR_DA_FORGN_COMP Character(2) VARCHAR2(2) NOT NULL Foreign Establishkent

Prompt Table: GPFR_FGNCMPCD_V

9 GPFR_DSN_CHR_UF_01 Character(50) VARCHAR2(50) NOT NULL User Fields
10 GPFR_DSN_CHR_UF_02 Character(50) VARCHAR2(50) NOT NULL User Fields
11 GPFR_DSN_CHR_UF_03 Character(50) VARCHAR2(50) NOT NULL User Fields
12 GPFR_DSN_CHR_UF_04 Character(50) VARCHAR2(50) NOT NULL User Fields
13 GPFR_DSN_CHR_UF_05 Character(50) VARCHAR2(50) NOT NULL User Fields
14 GPFR_DSN_NBR_UF_01 Number(15,0) DECIMAL(15) NOT NULL User field 01
15 GPFR_DSN_NBR_UF_02 Number(15,0) DECIMAL(15) NOT NULL User field 02
16 GPFR_DSN_NBR_UF_03 Number(15,0) DECIMAL(15) NOT NULL User field 03
17 GPFR_DSN_NBR_UF_04 Number(15,0) DECIMAL(15) NOT NULL User field 04
18 GPFR_DSN_NBR_UF_05 Number(15,0) DECIMAL(15) NOT NULL User field 05
19 GPFR_DSN_DT_UF_01 Date(10) DATE Userfield 01
20 GPFR_DSN_DT_UF_02 Date(10) DATE Userfield 02
21 GPFR_DSN_DT_UF_03 Date(10) DATE Userfield 03
22 GPFR_DSN_DT_UF_04 Date(10) DATE Userfield 04
23 GPFR_DSN_DT_UF_05 Date(10) DATE Userfield 05
24 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

Prompt Table: SRC_BANK