DSC_TRMS_EFF_VW (SQL View)	Index Back
Dscnt Terms Effective View

DSC_TRMS_EFF_VW

(SQL View)

Dscnt Terms Effective View

SELECT a.setid , a.pymnt_terms_cd , b.effdt , c.net_trms_seq_nbr , d.dscnt_trms_seq_nbr , d.dscnt_trms_time_id , d.terms_adjust_days , d.dscnt_trms_percent , d.dscnt_trms_amount FROM ps_pymt_trms_hdr a , ps_pymt_trms_cntl b , PS_PYMT_TRMS_NET c , ps_pymt_trms_dscnt d WHERE b.setid = a.setid AND b.pymnt_terms_cd = a.pymnt_terms_cd AND b.eff_status = 'A' AND c.setid = b.setid AND c.pymnt_terms_cd = b.pymnt_terms_cd AND c.effdt = b.effdt AND c.dsc_trms_avail_flg = 'Y' AND d.setid = c.setid AND d.pymnt_terms_cd = c.pymnt_terms_cd AND d.effdt = c.effdt AND d.net_trms_seq_nbr = c.net_trms_seq_nbr

# 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 EFFDT Date(10) DATE NOT NULL Effective Date

4 NET_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Net Terms Sequence Number

5 DSCNT_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Discount Terms Sequence Number

6 DSCNT_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Discount Terms Timing ID

7 TERMS_ADJUST_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Terms Adjustment Days

8 DSCNT_TRMS_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Discount Terms Percent

9 DSCNT_TRMS_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Terms Amount

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	NET_TRMS_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Net Terms Sequence Number
5	DSCNT_TRMS_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Discount Terms Sequence Number
6	DSCNT_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Discount Terms Timing ID
7	TERMS_ADJUST_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Terms Adjustment Days
8	DSCNT_TRMS_PERCENT	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Discount Terms Percent
9	DSCNT_TRMS_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Terms Amount