CONVR_Q_ALL_LVW

(SQL View)
Index Back

Qualifier View for Conversatio

Shows all Qualifiers

SELECT %Substring(FIELDVALUE, 1, 2) , LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'CONVR_QUALIFIER_CD'

  • Related Language Record for CONVR_Q_ALL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONVR_QUALIFIER_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
    BA=Buy Agremt
    BI=Invoice #
    CP=Cust Pay
    CT=Contract
    D=Document
    I=Item
    L=Lading
    P=PO Number
    PY=Payment ID
    QU=Quote
    RM=RMA
    SC=Case Num
    SO=Sale Order
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name