RECORD_GEO_OM

(SQL View)
Index Back

OM Records with GeoCode

OM Records with GeoCode

SELECT RECNAME , RECDESCR FROM PSRECDEFN WHERE RECNAME IN ('CUST_ADDRESS', 'ORD_ADDR', 'RMA_ADDR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME_GEO Character(15) VARCHAR2(15) NOT NULL Address Record for Geo Update
2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description