PAY_TRMS_TIME (SQL Table)	Index Back
Payment Terms Timing Defn

PAY_TRMS_TIME

(SQL Table)

Payment Terms Timing Defn

# 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 PAY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Timing Definition ID
Prompt Table: PAY_TRMS_TIME

3 DS_PY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Discount Timing

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

6 MONTH_INCREMENT Number(2,0) SMALLINT NOT NULL Month Increment

7 DAY_INCREMENT Number(3,0) SMALLINT NOT NULL Day Increment

8 DAY_DUE Number(2,0) SMALLINT NOT NULL Due on this day

9 EOM_FLG Character(1) VARCHAR2(1) NOT NULL End of Month
Y/N Table Edit
Default Value: N

10 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

#	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	PAY_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Timing Definition ID Prompt Table: PAY_TRMS_TIME
3	DS_PY_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Discount Timing
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	MONTH_INCREMENT	Number(2,0)	SMALLINT NOT NULL	Month Increment
7	DAY_INCREMENT	Number(3,0)	SMALLINT NOT NULL	Day Increment
8	DAY_DUE	Number(2,0)	SMALLINT NOT NULL	Due on this day
9	EOM_FLG	Character(1)	VARCHAR2(1) NOT NULL	End of Month Y/N Table Edit Default Value: N
10	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.