PRC_CUSTYPE_LVW

(SQL View)
Index Back

customer type

customer type

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

  • Related Language Record for PRC_CUSTYPE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
    1=User 1
    2=User 2
    3=User 3
    4=User 4
    F=Foreign
    M=Commercial
    N=Consumer
    S=State and Local
    X=Excluded Foreign Customer
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field