PeopleSoft Tips and Tricks

SELECT * FROM PS_MTCH_CNTRL; -- Match Control Details SELECT * FROM PS_MTCH_LOG_HDR_VW; -- Matching Log SELECT * FROM ps_vchr_mtch_detls; -- Voucher Details selected for Matching SELECT * FROM PS_MTCH_RULE_OVRD; -- If any Voucher has been match Over-Ridden SELECT * FROm PS_MTCH_VCHR_SRCH; -- Vouchers Selected for Matching SELECT * FROM PS_AP_MATCH_EXC_VW; -- Match Exception SELECT * FROM PSXLATITEM where FIELDNAME = 'MTCH_EXCPTN_TYPE'; SELECT * FROM PS_AP_MTCH_RULECFG; -- Match Rule SELECT * FROM PS_AP_MTCH_RULES; -- Match Rule SELECT * FROm PS_AP_MTCH_WB_FLD; -- Match Rule SELECT * FROm PS_AP_MTH_RULETYPE; -- Match Rule SELECT * FROm PS_AP_VCHR_HDR_SUM; -- Header Details that stores and used for Match Rule SELECT * FROm PS_AP_VCHR_LN_SUM; -- Line Details that stores and used for Match Rule SELECT * FROM PS_AP_VCHR_MTCH_VW; SELECT * FROm PS_AP_MTCH_WB_VW; SELECT * FROm PS_AP_WB_OTH_VW; SELECT * FROM PS_MATCH_OBJECT;

SELECT A.FIELDNAME, A.FIELDNUM, CASE WHEN b.fieldtype = '0' THEN 'Character' WHEN b.fieldtype = '1' THEN 'Long Character' WHEN b.fieldtype = '2' THEN 'Number' WHEN b.fieldtype = '3' THEN 'Signed Number' WHEN b.fieldtype = '4' THEN 'Date' WHEN b.fieldtype = '5' THEN 'Time' WHEN b.fieldtype = '6' THEN 'Date Time' END AS FIELD_TYPE,B.LENGTH,B.DESCRLONG FROM PSRECFIELDDB A, PSDBFIELD B WHERE RECNAME = 'VCHR_BANK_STG' AND A.FIELDNAME = B.FIELDNAME ORDER BY FIELDNUM;