AP_FLDSELDFT_VW

(SQL View)
 Index Back

AP MECC - Field Sel Dftl Rec

AP MECC - Field Selection Default View

SELECT RECNAME , FIELDNAME ,0 FROM PSRECFIELD WHERE RECNAME = 'AP_MECC_LIST_VW' AND FIELDNAME IN ('VENDOR_ID','CREATE_DTTM','AP_MECC_STATUS','BUSINESS_UNIT','VOUCHER_ID','VOUCHER_LINE_NUM','BUSINESS_UNIT_PO','PO_ID','LINE_NBR','SCHED_NBR','AP_MECC_ASSIGNTO') UNION SELECT RECNAME , FIELDNAME ,0 FROM PSRECFIELD WHERE RECNAME = 'AP_MTCH_RSV_WRK' AND FIELDNAME IN ('BUSINESS_UNIT_RECV','RECEIVER_ID','RECV_LN_NBR','RECV_SHIP_SEQ_NBR') UNION SELECT RECNAME , FIELDNAME ,0 FROM PSRECFIELD WHERE RECNAME = 'AP_MECCL_WRK' AND FIELDNAME IN ('AP_MEC_AGE_DAYS','DSCNT_APPL_FLG') UNION SELECT RECNAME , FIELDNAME ,0 FROM PSRECFIELD WHERE RECNAME = 'VENDOR' AND FIELDNAME IN ('NAME1')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number