FINT_PSUOMFD_VW

(SQL View)
 Index Back

PeopleSoft Units of Measure

PeopleSoft Units of Measure Field for Mapping to Demantra

SELECT DP_PSAPPS_FIELDID , DP_CAPTION , DP_FIELDTYPE FROM PS_FINT_MAPFIELDS WHERE DP_PSAPPS_FIELDID = 'UNIT_MEASURE_WT' OR DP_PSAPPS_FIELDID = 'UNIT_MEASURE_VOL' OR DP_PSAPPS_FIELDID = 'UNIT_MEASURE_STD' OR DP_PSAPPS_FIELDID = 'UNIT_MEASURE_SHIP'

  • Related Language Record: FINT_PSUOFD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_PSAPPS_FIELDID Character(18) VARCHAR2(18) NOT NULL DP_PSAPPS_FIELDID
    2 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    3 DP_FIELDTYPE Character(1) VARCHAR2(1) NOT NULL DP_FIELDTYPE
    1=Character
    2=Numeric