GPFR_DSN_ESTREF

(SQL Table)
Index Back

Estab for DSN Sending Ref

DSN related record: stores the establishment details for a comapny in sending reference setup.

# 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_DA_ESTAB Character(12) VARCHAR2(12) NOT NULL DADS related field

Prompt Table: ESTB_DSN_VW_FRA

4 GPFR_DSN_FRCTN_NBR Number(2,0) SMALLINT NOT NULL Fraction Number
5 GPFR_DSN_SUBROGTN Character(1) VARCHAR2(1) NOT NULL Subrogation for Establishment

Y/N Table Edit

Default Value: N

6 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

Prompt Table: SRC_BANK

7 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set

Prompt Table: GPFR_AF_NODSET

8 GPFR_DA_CONNM Character(50) VARCHAR2(50) NOT NULL DADS related field
9 GPFR_DA_PHONE Character(20) VARCHAR2(20) NOT NULL GPFR DADS Phone contact
10 GPFR_CONT_EMAIL Character(252) VARCHAR2(252) NOT NULL Email Address
11 GPFR_DSN_CHR_UF_01 Character(50) VARCHAR2(50) NOT NULL User Fields
12 GPFR_DSN_CHR_UF_02 Character(50) VARCHAR2(50) NOT NULL User Fields
13 GPFR_DSN_CHR_UF_03 Character(50) VARCHAR2(50) NOT NULL User Fields
14 GPFR_DSN_CHR_UF_04 Character(50) VARCHAR2(50) NOT NULL User Fields
15 GPFR_DSN_CHR_UF_05 Character(50) VARCHAR2(50) NOT NULL User Fields
16 GPFR_DSN_NBR_UF_01 Number(15,0) DECIMAL(15) NOT NULL User field 01
17 GPFR_DSN_NBR_UF_02 Number(15,0) DECIMAL(15) NOT NULL User field 02
18 GPFR_DSN_NBR_UF_03 Number(15,0) DECIMAL(15) NOT NULL User field 03
19 GPFR_DSN_NBR_UF_04 Number(15,0) DECIMAL(15) NOT NULL User field 04
20 GPFR_DSN_NBR_UF_05 Number(15,0) DECIMAL(15) NOT NULL User field 05
21 GPFR_DSN_DT_UF_01 Date(10) DATE Userfield 01
22 GPFR_DSN_DT_UF_02 Date(10) DATE Userfield 02
23 GPFR_DSN_DT_UF_03 Date(10) DATE Userfield 03
24 GPFR_DSN_DT_UF_04 Date(10) DATE Userfield 04
25 GPFR_DSN_DT_UF_05 Date(10) DATE Userfield 05