SP_BU_ACE_NONVW(SQL View) |
Index Back |
---|---|
Order Capture BU tableOrder 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 |
# | 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 |