ORD_PAYTRMSLVW

(SQL View)
 Index Back

Ord Payment Terms Defn Header

Related language rec for ORD_PAYTRMS_VW

SELECT oh.business_Unit , oh.order_no , p.setid , p.pymnt_terms_cd , p.language_cd , p.descr50 , p.descrshort FROM ps_pay_trms_tbl_lg p , ps_pay_trms_tbl t , ps_set_cntrl_rec sc , PS_ORD_HEADER oh WHERE p.setid = sc.setid AND %EffdtCheck(pay_trms_tbl_lg, p, oh.order_date) AND sc.setcntrlvalue = oh.business_unit AND sc.recname = 'PAY_TRMS_TBL_LG' AND t.setid = p.setid AND t.pymnt_terms_cd = p.pymnt_terms_cd AND t.effdt = p.effdt AND t.eff_status = 'A'

  • Related Language Record for ORD_PAYTRMS_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description