BI_BU_COPY_TBL

(SQL Table)
Index Back

BI Business Unit Management

Billing Business Unit Management

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 NEW_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL New Business Unit
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_BI_NONVW

4 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID
5 FROM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL From Business Unit
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

Prompt Table: SP_BUARDS_NONVW

9 BI_BU_COPY_STATUS Character(1) VARCHAR2(1) NOT NULL Status
C=Created
I=Initiated
10 YES_OR_NO Character(1) VARCHAR2(1) NOT NULL No Prepaid Balance Entry
N=No
Y=Yes

Default Value: Y