WTHD_BU_TAO (SQL Table)	Index Back
Default Ledger Group/Ledgers

WTHD_BU_TAO

(SQL Table)

Default Ledger Group/Ledgers

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
Prompt Table: LED_DETL_VW

5 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL

6 DECIMAL_POS_BSE Number(2,0) SMALLINT NOT NULL Base Cur Decimal Positions

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: LED_DETL_VW
5	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Prompt Table: CURRENCY_CD_TBL
6	DECIMAL_POS_BSE	Number(2,0)	SMALLINT NOT NULL	Base Cur Decimal Positions
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID