SF_AFFILIATE_VW

(SQL View)
Index Back

View of GL Bus Unit Table

View of GL Bus Unit Table

select a.business_unit, b.descr, b.descrshort from ps_bus_unit_tbl_gl a, PS_BUS_UNIT_TBL_FS b where a.business_unit = b.business_unit

  • Related Language Record: SFAFILIATEVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description