SP_BU_ACE_NONVW

(SQL View)
Index Back

Order Capture BU table

Order Capture table used for bu set control.

SELECT BUSINESS_UNIT , DESCR FROM PS_SP_BU_RO_NONVW UNION SELECT 'ALLBU' , %Substring(MESSAGE_TEXT, 1, 30) FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 17834 AND MESSAGE_NBR = 4052

  • Related Language Record: SP_BU_AC_NONLVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_FS

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description