PYMT_TRMS_INST (SQL Table)	Index Back
Installment Payment Terms

PYMT_TRMS_INST

(SQL Table)

Installment Payment Terms

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

4 INSTALLMENT_NBR Number(2,0) SMALLINT NOT NULL Installment Number

5 INSTALLMENT_PCT Number(12,8) DECIMAL(11,8) NOT NULL Installment Percent

6 SNGL_PYMNT_TRMS_CD Character(5) VARCHAR2(5) NOT NULL Single-Payment Terms ID
Prompt Table: SPT_EFF_APPL_VW

#	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 NOT NULL	Effective Date Default Value: %date
4	INSTALLMENT_NBR	Number(2,0)	SMALLINT NOT NULL	Installment Number
5	INSTALLMENT_PCT	Number(12,8)	DECIMAL(11,8) NOT NULL	Installment Percent
6	SNGL_PYMNT_TRMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Single-Payment Terms ID Prompt Table: SPT_EFF_APPL_VW