FS_MAP_IDES_PPL_MAPID_VW(SQL View) |
Index Back |
|---|---|
Map Definition ViewPEPPOL Map Definition View |
| SELECT H.FS_MAP_ID , H.DESCR , H.VERSION 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 H.FS_MAP_ACT_FLG = 'Y' AND H.FS_MAP_STATUS = 'R' AND S.FS_MAP_NODE_TYP = 'X' AND T.FS_MAP_NODE_TYP = 'D' AND S.FS_MAP_RELT_TYPE = 'X' AND T.FS_MAP_RELT_TYPE = 'T' AND H.OBJECTOWNERID = 'FMP' AND T.IB_SCHEMANAME = 'VCHR_IMP_QV' AND H.FS_MAP_ID LIKE '%UBL%' |
| # | 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 |
| 3 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |