CONVR_Q_ALL_VW

(SQL View)
 Index Back

Qualifier View for Conversatio

Shows all Qualifiers

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

  • Related Language Record: CONVR_Q_ALL_LVW

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name