PAY_TRMS_DSCNT (SQL Table)	Index Back
Discount Payment Terms Discount Payment Terms

PAY_TRMS_DSCNT

(SQL Table)

Discount 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 DS_PY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Discount Timing
Prompt Table: PAY_TRMS_TIME

6 DSCNT_PCT Number(7,3) DECIMAL(6,3) NOT NULL Discount Percentage

7 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

#	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	DS_PY_TRMS_TIME_ID	Character(3)	VARCHAR2(3) NOT NULL	Discount Timing Prompt Table: PAY_TRMS_TIME
6	DSCNT_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Discount Percentage
7	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL