COUNTRYGPDE_AD_TGD_IDGPDE_ADDR_POSITIONPrompt Table: PSRECFIELD_VW
GPDE_ADMAP_DTL(SQL Table) |
Index Back |
|---|---|
Foreign Address MappingDetail table for Foreign Address Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | GPDE_AD_TGD_ID |
Character(18) | VARCHAR2(18) NOT NULL | Target Fieldname for GPDE Address mapping. |
| 3 | GPDE_ADDR_POSITION |
Number(2,0) | SMALLINT NOT NULL | Address position number |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELD_VW |
| 5 | GPDE_ADDR_PRE_SEP | Character(3) | VARCHAR2(3) NOT NULL | Address pre separator |
| 6 | GPDE_ADDR_PST_SEP | Character(3) | VARCHAR2(3) NOT NULL | Address post separator |