BUS_UNIT_TBL_PF (SQL Table)	Index Back
PF Business Units A PF Business Unit may be mapped from one to many GL or source Business Units.

BUS_UNIT_TBL_PF

(SQL Table)

PF Business Units

A PF Business Unit may be mapped from one to many GL or source Business Units.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 AS_OF_DATE Date(10) DATE NOT NULL As of Date
Default Value: %date

3 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency
Prompt Table: CURRENCY_CD_TBL

4 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL

5 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
Prompt Table: CAL_DETL_VW

6 PF_BATCH_NUM Number(6,0) INTEGER NOT NULL Last Batch Number

7 BU_CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidated
Y/N Table Edit

8 HOLIDAY_CALENDR_ID Character(2) VARCHAR2(2) NOT NULL Holiday Calendar

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AS_OF_DATE	Date(10)	DATE NOT NULL	As of Date Default Value: %date
3	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Base Currency Prompt Table: CURRENCY_CD_TBL
4	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
5	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DETL_VW
6	PF_BATCH_NUM	Number(6,0)	INTEGER NOT NULL	Last Batch Number
7	BU_CONSOLIDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Y/N Table Edit
8	HOLIDAY_CALENDR_ID	Character(2)	VARCHAR2(2) NOT NULL	Holiday Calendar