TMG_DSC_XREF_VW (SQL View)	Index Back
Timing/Dscnt Terms Xref View

TMG_DSC_XREF_VW

(SQL View)

Timing/Dscnt Terms Xref View

SELECT a.setid , a.pay_trms_time_id , b.pymnt_terms_cd , b.effdt , COUNT(*) FROM PS_PYMT_TRMS_TIME a , ps_pymt_trms_dscnt b WHERE b.setid = a.setid AND b.dscnt_trms_time_id = a.pay_trms_time_id GROUP BY a.setid, a.pay_trms_time_id, b.pymnt_terms_cd, b.effdt

# 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: SP_SETID_NONVW

2 PAY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Timing Definition ID
Prompt Table: PYMT_TRMS_TIME

3 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.

4 EFFDT Date(10) DATE NOT NULL Effective Date

5 DSC_TRM_NBR_OCCURS Number(3,0) SMALLINT NOT NULL Discount Terms Occurrences

#	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: SP_SETID_NONVW
2	PAY_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Timing Definition ID Prompt Table: PYMT_TRMS_TIME
3	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.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	DSC_TRM_NBR_OCCURS	Number(3,0)	SMALLINT NOT NULL	Discount Terms Occurrences