CLC_PAY_DTA_TMP (SQL Table)	Index Back
Pymt Trms Calc Pay Data Tmp

CLC_PAY_DTA_TMP

(SQL Table)

Pymt Trms Calc Pay Data Tmp

# 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 CALC_RSLTS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Calc Results Sequence Nbr

4 CALC_NET_DUE_DT Date(10) DATE Net Due Date

5 CALC_NET_DUE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Net Amount

6 CALC_DSCNT_DUE_DT Date(10) DATE Discount Due Date

7 CALC_DSCNT_DUE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Discount Amount

#	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	CALC_RSLTS_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Calc Results Sequence Nbr
4	CALC_NET_DUE_DT	Date(10)	DATE	Net Due Date
5	CALC_NET_DUE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Net Amount
6	CALC_DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
7	CALC_DSCNT_DUE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Discount Amount