OPA COUNTRY CODE Table
View exposing country reference data used in OPA reporting including postal country codes, names, restrictions, active indicator, alternate country code, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTV_IND |
Actv ind associated with the record. |
VARCHAR2 |
1 |
ALT_POSTAL_CNTRY_CD |
Alt postal cntry cd associated with the record. |
VARCHAR2 |
3 |
POSTAL_CNTRY_CD |
Postal cntry cd associated with the record. |
VARCHAR2 |
2 |
POSTAL_CNTRY_NM |
Postal cntry nm associated with the record. |
VARCHAR2 |
255 |
PSTL_CNTRY_RSTRC_IND |
Pstl cntry rstrc ind associated with the record. |
VARCHAR2 |
1 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |