AP_TRMS_TIME_DS (SQL View)	Index Back
AP Discount Terms Timing Discount Terms Timing

AP_TRMS_TIME_DS

(SQL View)

AP Discount Terms Timing

Discount Terms Timing

SELECT A.SETID , A.PYMNT_TERMS_CD , A.EFFDT , A.NET_TRMS_SEQ_NBR , B.PAY_TRMS_TIME_ID , B.TMG_BASIS_OPTION , B.TMG_REL_MONTH_VAL , B.TMG_MONTH_DUE_CD , B.TMG_DAY_DUE_CD , B.DUE_DT , B.TMG_DAY_INCR_VAL , B.TMG_MONTH_INCR_VAL , B.TMG_YEAR_INCR_VAL FROM PS_PYMT_TRMS_DSCNT A , PS_PYMT_TRMS_TIME B WHERE A.SETID = B.SETID AND A.DSCNT_TRMS_TIME_ID = B.PAY_TRMS_TIME_ID

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

4 NET_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Net Terms Sequence Number

5 PAY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Timing Definition ID

6 TMG_BASIS_OPTION Character(1) VARCHAR2(1) NOT NULL Timing Basis Option
F=Fixed Month/Day Values:
M=End of Relative Month:
N=None (Basis Date)
S=Specific Due Date:

7 TMG_REL_MONTH_VAL Signed Number(3,0) DECIMAL(2) NOT NULL End of Relative Month

8 TMG_MONTH_DUE_CD Character(2) VARCHAR2(2) NOT NULL Month Due

9 TMG_DAY_DUE_CD Character(2) VARCHAR2(2) NOT NULL Day Due

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.

11 TMG_DAY_INCR_VAL Signed Number(4,0) DECIMAL(3) NOT NULL Day Increment

12 TMG_MONTH_INCR_VAL Signed Number(3,0) DECIMAL(2) NOT NULL Month Increment

13 TMG_YEAR_INCR_VAL Signed Number(3,0) DECIMAL(2) NOT NULL Year Increment

#	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	Effective Date Default Value: %date
4	NET_TRMS_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Net Terms Sequence Number
5	PAY_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Timing Definition ID
6	TMG_BASIS_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Timing Basis Option F=Fixed Month/Day Values: M=End of Relative Month: N=None (Basis Date) S=Specific Due Date:
7	TMG_REL_MONTH_VAL	Signed Number(3,0)	DECIMAL(2) NOT NULL	End of Relative Month
8	TMG_MONTH_DUE_CD	Character(2)	VARCHAR2(2) NOT NULL	Month Due
9	TMG_DAY_DUE_CD	Character(2)	VARCHAR2(2) NOT NULL	Day Due
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.
11	TMG_DAY_INCR_VAL	Signed Number(4,0)	DECIMAL(3) NOT NULL	Day Increment
12	TMG_MONTH_INCR_VAL	Signed Number(3,0)	DECIMAL(2) NOT NULL	Month Increment
13	TMG_YEAR_INCR_VAL	Signed Number(3,0)	DECIMAL(2) NOT NULL	Year Increment