AP_COMP_FLDS_VW

(SQL View)
 Index Back

VNDR_ID specific filters

Excludes records deemed unwanted. Currently has logic to ensure VNDR_ID keys.

SELECT PNLGRPNAME , PAGE_NAME , SUBPNLNAME , DTL_PNLNAME , RECNAME_PARENT , FIELDNAME , LBLTEXT , PNLNAME , PNLFLDID , FIELDTYPE , FIELDUSE , RECNAME , SPB_PAGE_NAME , PATHNAME FROM PS_AP_COMP_FLDS_V2 WHERE RECNAME_PARENT <> 'VNDR_CHG_AUDIT' AND RECNAME_PARENT <> 'VNDR_SRCHADR_VW' AND EXISTS ( SELECT 1 FROM PSRECFIELD WHERE RECNAME = PS_AP_COMP_FLDS_V2.RECNAME_PARENT AND FIELDNUM = 1 AND FIELDNAME = 'SETID' ) AND EXISTS ( SELECT 1 FROM PSRECFIELD WHERE RECNAME = PS_AP_COMP_FLDS_V2.RECNAME_PARENT AND FIELDNUM = 2 AND FIELDNAME = 'VENDOR_ID' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
2 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
3 SUBPNLNAME Character(18) VARCHAR2(18) NOT NULL SubPanel Name
4 DTL_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Panel/Page name
5 RECNAME_PARENT Character(15) VARCHAR2(15) NOT NULL Parent Record. If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME.
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
8 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
9 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
10 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
11 FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
13 SPB_PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
14 PATHNAME Character(254) VARCHAR2(254) NOT NULL PATHNAME