PO_ENTITY_BU_VW

(SQL View)
Index Back

Procurement Entity BU Table


SELECT REPORT_ENTITY , UNIT_TYPE , BUSINESS_UNIT FROM PS_PRCR_ENTITY_BU

  • Parent record: PRCR_ENTITY_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
    2 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type
    A=A/P
    P=PO
    R=Receiving
    S=AUC
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_FS_NONVW