SETIDPYMNT_TERMS_CDMULT_PYMNT_TRMS_CDEFFDTA=Active
I=Inactive
SPT_WHR_USED_VW(SQL View) |
Index Back |
|---|---|
Single Pay Terms Where-Used Vw |
| SELECT a.setid , a.pymnt_terms_cd , b.pymnt_terms_cd , c.effdt , c.eff_status , c.nbr_of_terms , COUNT(*) FROM ps_pymt_tr_sngl_vw a , ps_pymt_tr_mult_vw b , ps_pymt_trms_cntl c , PS_PYMT_TRMS_INST d WHERE b.setid = a.setid AND c.setid = b.setid AND c.pymnt_terms_cd = b.pymnt_terms_cd AND d.setid = c.setid AND d.pymnt_terms_cd = c.pymnt_terms_cd AND d.effdt = c.effdt AND d.sngl_pymnt_trms_cd = a.pymnt_terms_cd GROUP BY a.setid, a.pymnt_terms_cd, b.pymnt_terms_cd, c.effdt, c.eff_status, c.nbr_of_terms HAVING COUNT(*) > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PYMNT_TERMS_CD |
Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 3 | MULT_PYMNT_TRMS_CD |
Character(5) | VARCHAR2(5) NOT NULL | Multi-Payment Terms ID |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | NBR_OF_TERMS | Number(2,0) | SMALLINT NOT NULL | Number of Terms |
| 7 | NBR_OF_OCCURRENCES | Number(3,0) | SMALLINT NOT NULL | Number of Occurrences |