FINT_ITFLDMP_VW

(SQL View)
 Index Back

Interface Mapped Item Fields

Forecast Interface Mapped Item 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.FINT_ITEM_FLD = 'Y' AND A.FINT_FIELD_NAME NOT IN ('DM_ITEM_CODE', 'DM_ITEM_DESC', 'DM_ORG_CODE', 'DM_ORG_DESC', 'PLANNING_UOM', 'PRIMARY_UOM', 'SHIPPING_UOM', 'WEIGHT_UOM', 'VOLUME_UOM')

# 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: %EDITTABLE2

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