PYM_TR_DS_EFFVW (SQL View)	Index Back
Discount Payment Terms Effective Dated view for Discount payment Terms

PYM_TR_DS_EFFVW

(SQL View)

Discount Payment Terms

Effective Dated view for Discount payment Terms

SELECT a.setid , a.pymnt_terms_cd , a.effdt , a.net_trms_seq_nbr , a.dscnt_trms_seq_nbr , a.dscnt_trms_time_id , a.terms_adjust_days , a.dscnt_trms_percent , a.dscnt_trms_amount FROM PS_PYMT_TRMS_DSCNT a WHERE a.effdt = ( SELECT MAX(aa.effdt) FROM PS_PYMT_TRMS_DSCNT aa WHERE aa.setid = a.setid AND aa.pymnt_terms_cd = a.pymnt_terms_cd AND aa.net_trms_seq_nbr = a.net_trms_seq_nbr AND aa.dscnt_trms_seq_nbr = a.dscnt_trms_seq_nbr AND aa.effdt <= %CurrentDateIn)

Parent record: PYMT_TRMS_NET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SETID_TBL

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
Default Value: %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
Prompt Table: PYMT_TRMS_TIME

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 Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL
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 Default Value: %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 Prompt Table: PYMT_TRMS_TIME
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