OM_TRMS_LVW (SQL View)	Index Back
OM Payment Terms View Payment Terms

OM_TRMS_LVW

(SQL View)

OM Payment Terms View

Payment Terms

SELECT l.setid , l.pymnt_terms_cd , l.language_cd , l.descr50 FROM PS_PAY_TRMS_TBL t , PS_PAY_TRMS_TBL_lg l WHERE t.setid = l.setid AND t.pymnt_terms_cd = l.pymnt_terms_cd AND t.effdt = l.effdt AND t.ps_system = 'AR' AND %EffdtCheck(pay_trms_tbl x, t, %CurrentDateIn)

Related Language Record for OM_TRMS_VW

# 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 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.
Prompt Table: AR_TRMS_VW

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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	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. Prompt Table: AR_TRMS_VW
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50