PRC_CPICKUP_LVW

(SQL View)
 Index Back

Customer pickup

Customer pickup

SELECT %Substring(A.FIELDVALUE, 1 , 1) , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE FIELDNAME = 'CUST_PICKUP' AND %EffdtCheck(PSXLATITEMLANG, A, %CurrentDateIn)

  • Related Language Record for PRC_CPICKUP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
    N=No
    Y=Yes

    Y/N Table Edit

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field