GP_X_PMTMTH3_VW

(SQL View)
 Index Back

Payment Method View Lang Rel

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

SELECT %Substring(FIELDVALUE,1,1) ,EFFDT ,XLATSHORTNAME ,XLATLONGNAME FROM PSXLATITEM WHERE (FIELDNAME='PAYMENT_MTHD' OR FIELDNAME='PAYMENT_MTHD1') AND EFF_STATUS='A'

  • Related Language Record: GP_X_PMTMTH3_LV

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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