CM_BU_ACCTG_VW (SQL View)	Index Back
Book Ledger View 07/99 GMG CN800-9.0: Ties books, in business units to ledgers and ledger groups where the item's transactions will be posted.

CM_BU_ACCTG_VW

(SQL View)

Book Ledger View

07/99 GMG CN800-9.0: Ties books, in business units to ledgers and ledger groups where the item's transactions will be posted.

SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.LEDGER_GROUP , A.LEDGER , A.CM_BOOK_STATUS , B.BUSINESS_UNIT_GL , B.BASE_CURRENCY , D.GEN_BAL_ENTRIES , E.DEFAULT_LEDGER_GRP , E.ALTACCT_OPTN , E.COMMITMENT_CNTL , F.AFFILIATE_USE , G.RT_TYPE , G.CUR_RT_TYPE_DFLT FROM PS_CM_BU_BOOK_TBL A , PS_BUS_UNIT_TBL_IN B , PS_SET_CNTRL_REC C , PS_LED_GRP_TBL D , PS_BU_LED_GRP_TBL E , PS_LED_GRP_FLD_TBL F , PS_LED_GRP_LED_TBL G WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT_GL = C.SETCNTRLVALUE AND C.RECNAME = 'LED_GRP_TBL' AND C.SETID = D.SETID AND A.LEDGER_GROUP = D.LEDGER_GROUP AND B.BUSINESS_UNIT_GL = E.BUSINESS_UNIT AND A.LEDGER_GROUP = E.LEDGER_GROUP AND C.SETID = F.SETID AND A.LEDGER_GROUP = F.LEDGER_GROUP AND F.CHARTFIELD = 'BUSINESS_UNIT' AND C.SETID = G.SETID AND A.LEDGER_GROUP = G.LEDGER_GROUP AND ((A.LEDGER = G.LEDGER) OR ( A.LEDGER = ' ' AND PRIMARY_LEDGER = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

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

4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

5 CM_BOOK_STATUS Character(1) VARCHAR2(1) NOT NULL 06/30/99 RML Changed Long Name
A=Active
C=Cancel
I=Inactive
P=Pending
S=Stopped

6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

7 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. "

8 GEN_BAL_ENTRIES Character(1) VARCHAR2(1) NOT NULL IntraUnit Balancing Entries

9 DEFAULT_LEDGER_GRP Character(1) VARCHAR2(1) NOT NULL Jrnl Generator Dflt Ledger Grp

10 ALTACCT_OPTN Character(1) VARCHAR2(1) NOT NULL Enable Alternate Account

11 COMMITMENT_CNTL Character(1) VARCHAR2(1) NOT NULL Enable Commitment Control

12 AFFILIATE_USE Character(1) VARCHAR2(1) NOT NULL Use Affiliate

13 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.

14 CUR_RT_TYPE_DFLT Character(5) VARCHAR2(5) NOT NULL Exchange Rate Type Default

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
3	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
5	CM_BOOK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	06/30/99 RML Changed Long Name A=Active C=Cancel I=Inactive P=Pending S=Stopped
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
7	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. "
8	GEN_BAL_ENTRIES	Character(1)	VARCHAR2(1) NOT NULL	IntraUnit Balancing Entries
9	DEFAULT_LEDGER_GRP	Character(1)	VARCHAR2(1) NOT NULL	Jrnl Generator Dflt Ledger Grp
10	ALTACCT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Enable Alternate Account
11	COMMITMENT_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Enable Commitment Control
12	AFFILIATE_USE	Character(1)	VARCHAR2(1) NOT NULL	Use Affiliate
13	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.
14	CUR_RT_TYPE_DFLT	Character(5)	VARCHAR2(5) NOT NULL	Exchange Rate Type Default