RO_PK_TERMS_LVW (SQL View)	Index Back
Payment Terms Header This view is used to get the information on Payment Terms Definition Header

RO_PK_TERMS_LVW

(SQL View)

Payment Terms Header

This view is used to get the information on Payment Terms Definition Header

SELECT x.setid , x.pymnt_terms_cd , x.language_cd , x.descr50 FROM PS_PAY_TRMS_TBL_LG x WHERE x.effdt = ( SELECT MAX(y.effdt) FROM PS_PAY_TRMS_TBL_LG y WHERE y.setid = x.setid AND y.pymnt_terms_cd = x.pymnt_terms_cd AND y.language_cd = x.language_cd AND y.effdt <= %CurrentDateIn)

Related Language Record for RO_PK_TERMS_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field