FINT_SAFLDMP_VW

(SQL View)
 Index Back

Interface Mapped Sales Fields

Forecast Interface Mapped Sales 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 , PS_FINT_FIELDS B WHERE A.IN_USE_FLAG = 'Y' AND B.FINT_FIELD_NAME = A.FINT_FIELD_NAME AND B.FINT_SALE_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
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