BNK_BTB_VW

(SQL View)
 Index Back

Bank Account to Ledger

Bank Account to Ledger

SELECT A.BNK_ID_NBR ,B.BANK_ACCOUNT_NUM ,B.BUSINESS_UNIT_GL ,E.SETID ,E.LEDGER_GROUP ,E.LEDGER ,B.CURRENCY_CD ,C.BASE_CURRENCY ,F.SETID ,C.CALENDAR_ID FROM PS_BANK_CD_TBL A ,PS_BANK_ACCT_DEFN B ,PS_BU_LED_GRP_TBL C ,PS_SET_CNTRL_REC D ,PS_LED_GRP_LED_TBL E ,PS_SET_CNTRL_REC F WHERE B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND C.BUSINESS_UNIT=B.BUSINESS_UNIT_GL AND C.DEFAULT_LEDGER_GRP='Y' AND D.SETCNTRLVALUE=C.BUSINESS_UNIT AND D.RECNAME='LED_GRP_LED_TBL' AND E.SETID=D.SETID AND E.LEDGER_GROUP=C.LEDGER_GROUP AND E.PRIMARY_LEDGER='Y' AND F.SETCNTRLVALUE=B.BUSINESS_UNIT_GL AND F.RECNAME='CAL_DETP_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 SETID_LEDGER_GROUP Character(5) VARCHAR2(5) NOT NULL Ledger Group SetID
5 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
7 BANK_CURRENCY Character(3) VARCHAR2(3) NOT NULL Bank Account Currency
8 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. "
9 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
10 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID