PAY_TRM_AP_VWLN (SQL View)	Index Back
AP View of Payment Terms Table

PAY_TRM_AP_VWLN

(SQL View)

AP View of Payment Terms Table

SELECT setid , pymnt_terms_cd , effdt , language_cd , descr50 , descrshort FROM PS_PAY_TRMS_TBL_LG

Related Language Record for PAY_TRMS_AP_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.

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

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

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	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.
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description