GP_X_PMTMTH3_LV

(SQL View)
 Index Back

Prompt View for Payment Method

This is a view for Payment Method which includes translate values from fields PAYMENT_MTHD and PAYMENT_MTHD1.

SELECT %Substring(FIELDVALUE,1,1) ,LANGUAGE_CD ,EFFDT ,XLATSHORTNAME ,XLATLONGNAME FROM PSXLATITEMLANG WHERE (FIELDNAME='PAYMENT_MTHD' OR FIELDNAME='PAYMENT_MTHD1')

  • Related Language Record for GP_X_PMTMTH3_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAYMENT_MTHD1 Character(1) VARCHAR2(1) NOT NULL Zero Net payment method
    N=Negative Net
    Z=Zero Net
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name