COUNTRYPrompt Table: COUNTRY_TBL
GPFR_DUCS_TRSTAT0=Transportation
1=Additional Transportation
Prompt Table: GPFR_DA_ADRF_VW
Prompt Table: %EDITTABLE2
Prompt Table: %EDITTABLE3
Y/N Table Edit
Default Value: N
GPFR_DUCS_ADDR(SQL Table) |
Index Back |
|---|---|
DUCS AddressDUCS Address |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | GPFR_DUCS_TRSTAT |
Character(3) | VARCHAR2(3) NOT NULL |
Field for Transportation & Additional Transportation
0=Transportation 1=Additional Transportation |
| 3 | GPFR_DUCS_ADDRESS1 | Character(18) | VARCHAR2(18) NOT NULL |
DUCS Address Field 1
Prompt Table: GPFR_DA_ADRF_VW |
| 4 | GPFR_DUCS_ADDRESS2 | Character(18) | VARCHAR2(18) NOT NULL |
DUCS Address Field 2
Prompt Table: %EDITTABLE2 |
| 5 | GPFR_DUCS_ADDRESS3 | Character(18) | VARCHAR2(18) NOT NULL |
DUCS Address Field 3
Prompt Table: %EDITTABLE3 |
| 6 | GPFR_DUCS_SBSTRG | Character(1) | VARCHAR2(1) NOT NULL |
DUCS Substring
Y/N Table Edit Default Value: N |
| 7 | GPFR_DUCS_SUB_BGN | Number(2,0) | SMALLINT NOT NULL | DUCS Substring Beginning |
| 8 | GPFR_DUCS_SUB_LEN | Number(2,0) | SMALLINT NOT NULL | DUCS Substring Length |