RO_PK_PSUB_LVW

(SQL View)
Index Back

Pricing Partner Subtypes

This view lists all the partner subtypes that can be used for pricing.

SELECT DISTINCT PARTNER_TYPE , PARTNER_SUBTYPE , LANGUAGE_CD , DESCRIPTION FROM PS_RD_PR_SUBTYPE_L

  • Related Language Record for RO_PK_PSUB_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PARTNER_TYPE Character(4) VARCHAR2(4) NOT NULL Partner type
    2 PARTNER_SUBTYPE Character(4) VARCHAR2(4) NOT NULL Partner subtype
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field