GPFR_CONT_CDGPFR_DUCS_TYPEPrompt Table: GPFR_DUCS_PAR0
2=Establishment
3=Other Identifier
Prompt Table:
COMPANY_TBL
Set Control Field: COMPANY
Prompt Table: %EDITTABLE2
Prompt Table: %EDITTABLE3
R=Recipient
S=Sender
Default Value: S
GPFR_DUCS_CONT1(SQL Table) |
Index Back |
|---|---|
Contact definition for DUCSEach contact (company, establishment or other) is defined in this table : Identifier given by the recipients |
| # | 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_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
GPFR: DUCS Type
Prompt Table: GPFR_DUCS_PAR0 |
| 3 | GPFR_PAR1_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Identifier Type
2=Establishment 3=Other Identifier |
| 4 | GPFR_CONT_OPS_SIRN | Character(3) | VARCHAR2(3) NOT NULL |
GPFR: Company ID
Prompt Table:
COMPANY_TBL
|
| 5 | GPFR_CONT_OPS_SIRT | Character(12) | VARCHAR2(12) NOT NULL | Establishment for DUCS |
| 6 | GPFR_CONT_OPS_ID | Character(35) | VARCHAR2(35) NOT NULL |
GPFR: Identification Number
Prompt Table: %EDITTABLE2 |
| 7 | GPFR_DUCS_R2_REF1 | Character(35) | VARCHAR2(35) NOT NULL |
GPFR: Reference 1
Prompt Table: %EDITTABLE3 |
| 8 | GPFR_CONT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
DUCS Contact Type
R=Recipient S=Sender Default Value: S |