ORD_PAYTRMS_VW (SQL View)	Index Back
Ord Payment Terms Defn Header

ORD_PAYTRMS_VW

(SQL View)

Ord Payment Terms Defn Header

SELECT oh.business_Unit , oh.order_no , p.setid , p.pymnt_terms_cd , p.descr50 , p.descrshort , p.pymnt_terms_dt , p.pymnt_terms_amt , p.ps_system FROM ps_pay_trms_tbl p , ps_set_cntrl_rec sc , PS_ORD_HEADER oh WHERE p.setid = sc.setid AND p.eff_status = 'A' AND %EffdtCheck(pay_trms_tbl, p, oh.order_date) AND sc.setcntrlvalue = oh.business_unit AND sc.recname = 'PAY_TRMS_TBL'

Related Language Record: ORD_PAYTRMSLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

4 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.

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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
4	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.
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