GPFR_CONT_CD1=Company Address
2=Establishment Address
3=Other
1=Company Phone
2=Establishment Phone
3=Other
GPFR_AF_CON_TMP(SQL Table) |
Index Back |
|---|---|
Temporary Contact RecordThe record holds contact data i.e. Address and Phone, corresponding to Contact Code |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_CONT_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: Contact Definition |
| 2 | GPFR_CONT_AD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Address Type
1=Company Address 2=Establishment Address 3=Other |
| 3 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 4 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 5 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 6 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 7 | GPFR_CONT_TEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Contact Type
1=Company Phone 2=Establishment Phone 3=Other |
| 8 | GPFR_CONT_SERVICE | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Service / Correspondent |
| 9 | GPFR_DUCS_R2_TEL | Character(25) | VARCHAR2(25) NOT NULL | GPFR: Telephone |
| 10 | GPFR_DUCS_R2_FAX | Character(25) | VARCHAR2(25) NOT NULL | GPFR: Fax |
| 11 | GPFR_CONT_EMAIL | Character(252) | VARCHAR2(252) NOT NULL | Email Address |