GPFR_DSN_ESTREF(SQL Table) |
Index Back |
---|---|
Estab for DSN Sending RefDSN 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 |