ITEMORGLNEVWLNG

(SQL View)
Index Back

RelLng-Item line View

ITEMORGLNEVWLNG is the related language recordfor the record ITEM_ORG_LNE_VW

SELECT business_unit , common_id , item_nbr ,language_cd , descr FROM PS_ITEM_LNE_SF_LNG WHERE sa_id_type = 'O'

  • Related Language Record for ITEM_ORG_LNE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    3 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description