PeopleSoft Tips and Tricks

' ' TEST Macro ' Macro created 2/16/2012 by PCTR010312DM Sub PageDelete() sNumber = InputBox("Delete from which page", "Delete Pages", 1) sRange = InputBox("Delete how many pages", "Delete Pages", 1) Selection.GoTo What:=wdGoToPage, Which:=wdGoToNext, Name:=sNumber For a = 1 To sRange ActiveDocument.Bookmarks("\page").Range.Delete Next a End Sub

PS Documents

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;