BI_BU_COPY_VW

(SQL View)
 Index Back

BI Business Unit Management

Billing Business Unit Management

SELECT A.BUSINESS_UNIT , A.NEW_BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.BI_BU_COPY_STATUS , A.DESCR , A.DESCRSHORT , A.BUSINESS_UNIT_AR , A.DEFAULT_SETID , A.YES_OR_NO FROM PS_BI_BU_COPY_TBL A UNION SELECT ' ' , A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , 'C' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_BUS_UNIT_TBL_BI A WHERE BUSINESS_UNIT NOT IN ( SELECT NEW_BUSINESS_UNIT FROM PS_BI_BU_COPY_TBL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AP_NONVW

2 NEW_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL New Business Unit
3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
4 BI_BU_COPY_STATUS Character(1) VARCHAR2(1) NOT NULL Status
C=Created
I=Initiated
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

Prompt Table: SP_BUARDS_NONVW

8 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID
9 YES_OR_NO Character(1) VARCHAR2(1) NOT NULL No Prepaid Balance Entry
N=No
Y=Yes