PYM_TR_NT_EFFVW (SQL View)	Index Back
Net Payment Terms Effective dated view of PYMT_TRMS_NET

PYM_TR_NT_EFFVW

(SQL View)

Net Payment Terms

Effective dated view of PYMT_TRMS_NET

SELECT a.setid , a.pymnt_terms_cd , a.effdt , a.net_trms_seq_nbr , a.basis_from_day , a.basis_to_day , a.net_trms_time_id , a.dsc_trms_avail_flg , a.rebate_term_flg , a.rebate_percent , a.rebate_max_percent FROM PS_PYMT_TRMS_NET a WHERE a.effdt = ( SELECT MAX(aa.effdt) FROM PS_PYMT_TRMS_NET 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.effdt <= %CurrentDateIn)

Parent record: PYMT_TRMS_CNTL

# 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 BASIS_FROM_DAY Number(2,0) SMALLINT NOT NULL Basis From Day
Default Value: 1

6 BASIS_TO_DAY Number(2,0) SMALLINT NOT NULL Basis To Day
Default Value: 31

7 NET_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Net Terms Timing ID
Prompt Table: PYMT_TRMS_TIME

8 DSC_TRMS_AVAIL_FLG Character(1) VARCHAR2(1) NOT NULL Discount Terms Available
Y/N Table Edit
Default Value: N

9 REBATE_TERM_FLG Character(1) VARCHAR2(1) NOT NULL Rebate Term Available
Y/N Table Edit
Default Value: N

10 REBATE_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Daily Rebate Percent

11 REBATE_MAX_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Maximum Rebate Percent

#	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	BASIS_FROM_DAY	Number(2,0)	SMALLINT NOT NULL	Basis From Day Default Value: 1
6	BASIS_TO_DAY	Number(2,0)	SMALLINT NOT NULL	Basis To Day Default Value: 31
7	NET_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Net Terms Timing ID Prompt Table: PYMT_TRMS_TIME
8	DSC_TRMS_AVAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Discount Terms Available Y/N Table Edit Default Value: N
9	REBATE_TERM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Rebate Term Available Y/N Table Edit Default Value: N
10	REBATE_PERCENT	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Daily Rebate Percent
11	REBATE_MAX_PERCENT	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Maximum Rebate Percent