PAY_TRMS_NET (SQL Table)	Index Back
Net Payment Terms Net Payment Terms

PAY_TRMS_NET

(SQL Table)

Net Payment Terms

# 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: SETID_TBL

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 BASIS_FROM_DAY Number(2,0) SMALLINT NOT NULL Basis From Day

5 BASIS_TO_DAY Number(2,0) SMALLINT NOT NULL Basis To Day
Default Value: 31

6 PAY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Timing Definition ID
Prompt Table: PAY_TRMS_TIME

#	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: SETID_TBL
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	BASIS_FROM_DAY	Number(2,0)	SMALLINT NOT NULL	Basis From Day
5	BASIS_TO_DAY	Number(2,0)	SMALLINT NOT NULL	Basis To Day Default Value: 31
6	PAY_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Timing Definition ID Prompt Table: PAY_TRMS_TIME