FINT_KLOFDMP_VW

(SQL View)
 Index Back

Interface Map Location Fields

Forecast Interface Mapped Location Fields

SELECT A.MAPID , A.FINT_FIELD_NAME , A.DP_PSAPPS_FIELDID , A.IN_USE_FLAG , A.DP_FIELDTYPE FROM PS_FINT_FLD_MAPS A WHERE A.IN_USE_FLAG = 'Y' AND A.FINT_FIELD_NAME IN ('DM_ORG_CODE', 'DM_ORG_DESC', 'DM_SITE_CODE', 'E1_CUST_BUS_UNIT') AND A.FINT_LOC_FLD = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MAPID Character(3) VARCHAR2(3) NOT NULL Map ID
2 FINT_FIELD_NAME Character(30) VARCHAR2(30) NOT NULL Forecast Interface Field Name
3 DP_PSAPPS_FIELDID Character(18) VARCHAR2(18) NOT NULL DP_PSAPPS_FIELDID

Prompt Table: %EDITTABLE3

4 IN_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Row in use flag

Y/N Table Edit

5 DP_FIELDTYPE Character(1) VARCHAR2(1) NOT NULL DP_FIELDTYPE
1=Character
2=Numeric