AR_TRMS_VW1 (SQL View)	Index Back
AR Payment Terms View

AR_TRMS_VW1

(SQL View)

AR Payment Terms View

SELECT setid , pymnt_terms_cd , effdt , eff_status , descr50 , descrshort , pymnt_terms_dt , pymnt_terms_amt , ps_system FROM PS_PAY_TRMS_TBL WHERE ps_system = 'AR' AND EXISTS ( SELECT MAX(EFFDT) FROM PS_PAY_TRMS_TBL WHERE EFFDT <= %CurrentDateIn) AND EFF_STATUS='A'

Related Language Record: AR_TRMS_LVW

# 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 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.
Prompt Table: AR_TRMS_VW

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

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

7 PYMNT_TERMS_DT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date
1=User Date 1
2=User Date 2
A=As of Date
I=Accounting Date
N=Invoice Date

8 PYMNT_TERMS_AMT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Amount
1=User Amount 1
2=User Amount 2
G=Gross Voucher Amount
I=Item Amount
V=VAT Discountable Amount

9 PS_SYSTEM Character(2) VARCHAR2(2) NOT NULL PeopleSoft Application
AM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
GL=General Ledger
HR=Human Resources/Payroll
PM=Purchasing Management

#	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	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. Prompt Table: AR_TRMS_VW
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	PYMNT_TERMS_DT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date 1=User Date 1 2=User Date 2 A=As of Date I=Accounting Date N=Invoice Date
8	PYMNT_TERMS_AMT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Amount 1=User Amount 1 2=User Amount 2 G=Gross Voucher Amount I=Item Amount V=VAT Discountable Amount
9	PS_SYSTEM	Character(2)	VARCHAR2(2) NOT NULL	PeopleSoft Application AM=Asset Management AP=Accounts Payable AR=Accounts Receivable GL=General Ledger HR=Human Resources/Payroll PM=Purchasing Management