PP_MET_RPT_VW

(SQL View)
 Index Back

Payment Predictor Method View


select a.setid ,a.pp_method ,a.effdt ,b.pp_sort_seq_num ,b.pp_seq_num ,b.pp_micr_status ,b.pp_ref_status ,c.pp_usage ,c.pp_main_use ,c.algorithm_group ,c.pp_main_bu ,c.pp_main_custid ,c.pp_main_sysfunc ,c.pp_main_tol ,c.pp_review_sw ,c.pp_main_tol_per from ps_pp_met_tbl a, ps_pp_met_use_tbl b, PS_PP_MET_FUNC_TBL c where a.setid = b.setid and b.setid = c.setid and a.pp_method = b.pp_method and b.pp_method = c.pp_method and a.effdt = (select max(d.effdt) from ps_pp_met_tbl d where a.setid = setid and a.pp_method = pp_method and effdt <= %currentdatein) and a.effdt = b.effdt and b.effdt = c.effdt and b.pp_seq_num = c.pp_seq_num

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 PP_METHOD Character(15) VARCHAR2(15) NOT NULL Payment Predictor Method
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 PP_SORT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sorting Sequence number
5 PP_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 PP_MICR_STATUS Character(1) VARCHAR2(1) NOT NULL Customers Identified
I=Doesn't Matter
M=More Than One
N=None
S=One
7 PP_REF_STATUS Character(1) VARCHAR2(1) NOT NULL References Supplied
D=Detail
I=Doesn't Matter
N=No
Y=Summary
8 PP_USAGE Character(1) VARCHAR2(1) NOT NULL Usage
1=First...
2=Any Overpayment
3=Overpayment Exceeds
4=Overpayment Is Less Than
5=Any Underpayment
6=Underpayment Exceeds
7=Underpayment Is Less Than
9 PP_MAIN_USE Character(1) VARCHAR2(1) NOT NULL Main use
A=Execute Algorithm Group
C=Apply To Control Customer
I=Generate An Item
M=Execute Custom Algorithm
N=Release The Payment
W=Generate A Worksheet

Default Value: N

10 ALGORITHM_GROUP Character(15) VARCHAR2(15) NOT NULL Algorithm Group for Payment Predictor
11 PP_MAIN_BU Character(5) VARCHAR2(5) NOT NULL Main Control Account BU

Prompt Table: BUS_UNIT_TBL_GL

12 PP_MAIN_CUSTID Character(15) VARCHAR2(15) NOT NULL Main Control Account Custid

Prompt Table: CUSTOMER

13 PP_MAIN_SYSFUNC Character(5) VARCHAR2(5) NOT NULL Main system function Id

Prompt Table: PP_SYSFUNC_VW

14 PP_MAIN_TOL Number(9,3) DECIMAL(8,3) NOT NULL Tolerance Amount
15 PP_REVIEW_SW Character(1) VARCHAR2(1) NOT NULL Require Review

Y/N Table Edit

Default Value: N

16 PP_MAIN_TOL_PER Number(6,2) DECIMAL(5,2) NOT NULL Tolerance Percent