COUNTRYPrompt Table: COUNTRY_TBL
GPDE_AD_TGD_IDPrompt Table: GPDE_RECFLD_VW
GPDE_ADDR_MAP(SQL Table) |
Index Back |
|---|---|
Foreign Address MappingMaster table for Foreign Address Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | GPDE_AD_TGD_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Target Fieldname for GPDE Address mapping.
Prompt Table: GPDE_RECFLD_VW |
| 3 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |