OM_PAYTERMS_VW (SQL View)	Index Back
OM pricing: payment terms view View to select best payment terms for OM pricing

OM_PAYTERMS_VW

(SQL View)

OM pricing: payment terms view

View to select best payment terms for OM pricing

SELECT pn.setid , pn.pymnt_terms_cd , pn.effdt , pt.month_increment , pt.day_increment FROM ps_pay_trms_time pt , PS_PAY_TRMS_NET pn WHERE pt.setid = pn.setid AND pt.pay_trms_time_id = pn.pay_trms_time_id

# 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 Effective Date
Default Value: %date

4 MONTH_INCREMENT Number(2,0) SMALLINT NOT NULL Month Increment

5 DAY_INCREMENT Number(3,0) SMALLINT NOT NULL Day Increment

#	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	Effective Date Default Value: %date
4	MONTH_INCREMENT	Number(2,0)	SMALLINT NOT NULL	Month Increment
5	DAY_INCREMENT	Number(3,0)	SMALLINT NOT NULL	Day Increment