GNMATERIALVWLNG

(SQL View)
Index Back

relLng-General Materials View

GNMATERIALVWLNG is the related language recordfor the record GEN_MATERIAL_VW

SELECT EMPLID , GENL_MATL_GROUP , GENL_MATL_TYPE , GENL_MATL_NBR ,LANGUAGE_CD , DESCR_EXT_ORG FROM PS_GENLMATERIALLNG

  • Related Language Record for GEN_MATERIAL_VW
  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group

    Prompt Table: MATL_GRP_VW

    3 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type

    Prompt Table: MATL_GRPTYP_VW

    4 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR_EXT_ORG Character(30) VARCHAR2(30) NOT NULL Org Name