EPS_ZIPMRKT_TBL(SQL Table) |
Index Back |
|---|---|
EPS Zip to Market recordThis table contains the 'Zip To Market' data from EPS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL |
Ext Org Code Type
Prompt Table: EXORGCDTYPE_VW |
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL | EPS Postal Code | |
| 3 | MARKET_NAME_EPS | Character(5) | VARCHAR2(5) NOT NULL | EPS Market Name |
| 4 | MARKET_CODE_EPS | Character(4) | VARCHAR2(4) NOT NULL | EPS Market Code |