GST_MAP_HDR_VW

(SQL View)
Index Back

GST MAP Header view

GST MAP Header view

SELECT H.FS_MAP_ID ,H.DESCR FROM PS_FS_MAP_HDR_TBL H ,PS_FS_MAP_SRC_HDR S ,PS_FS_MAP_TRG_HDR T WHERE H.FS_MAP_ID = S.FS_MAP_ID AND H.FS_MAP_ID = T.FS_MAP_ID AND S.FS_MAP_ID = T.FS_MAP_ID AND S.IB_SCHEMANAME LIKE 'GST_TXN_TBL%' AND H.FS_MAP_ACT_FLG = 'Y' AND H.FS_MAP_STATUS = 'R'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description