BU_BOOK_CC_VW

(SQL View)
 Index Back

BUt/Book for Curr Conversion


SELECT A.BUSINESS_UNIT , A.BOOK , A.BUSINESS_UNIT_GL , A.LEDGER_GROUP , A.LEDGER , B.PRIMARY_LEDGER , A.CURRENCY_CD , B.NEW_LEDGER , B.NEW_PRIMARY_LEDGER , B.NEW_IN_BASE_CUR FROM PS_BU_BOOK_TBL A , PS_CCR_LED_GRP_LED B , PS_AE_RUN_CONTROL C , PS_AM_BASE_CC_TMP D WHERE A.DISTRIBUTION_SW = 'Y' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND B.LEDGER_GROUP = A.LEDGER_GROUP AND ( B.LEDGER = A.LEDGER OR (A.LEDGER = ' ' AND B.PRIMARY_LEDGER = 'Y')) AND ((A.CURRENCY_CD = B.BASE_CURRENCY AND B.INHERIT_BASE_CUR = 'Y') OR ( A.CURRENCY_CD = B.DISPLAY_CURRENCY AND B.INHERIT_BASE_CUR <> 'Y')) AND B.ANALYSIS_ID = %Sql(EO_FUNCLIB_CONVERT_LIB, C.PROCESS_INSTANCE,10) AND D.PROCESS_INSTANCE = C.PROCESS_INSTANCE AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BOOK = A.BOOK AND D.CONVERT_BOOK_SW = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
6 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 NEW_LEDGER Character(10) VARCHAR2(10) NOT NULL New Ledger
9 NEW_PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL New Primary Ledger
10 NEW_IN_BASE_CUR Character(1) VARCHAR2(1) NOT NULL New Inherit Base Currency