OMPB_ARTRM_VW (SQL View)	Index Back
AR Payment Terms - Price Book

OMPB_ARTRM_VW

(SQL View)

AR Payment Terms - Price Book

SELECT setid , pymnt_terms_cd , effdt , eff_status , descr50 , descrshort , pymnt_terms_dt , pymnt_terms_amt , ps_system , descr50 FROM PS_PAY_TRMS_TBL WHERE ps_system = 'AR'

Related Language Record: OMPB_ARTRM_LVW

# 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 NOT NULL Effective Date

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

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

10 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

#	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 NOT NULL	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
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
10	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field