BNK_BTB_DTL_VW

(SQL View)
 Index Back

Book To Bank Header

Book to Bank Header Record

SELECT A.BNK_ID_NBR ,B.BANK_ACCOUNT_NUM ,F.FISCAL_YEAR ,F.ACCOUNTING_PERIOD ,F.ACCOUNT ,F.ALTACCT ,F.DEPTID ,%subrec(CF9B_AK_SBR,F) ,F.PROJECT_ID ,F.BOOK_CODE ,F.GL_ADJUST_TYPE ,F.STATISTICS_CODE ,B.BUSINESS_UNIT_GL ,E.LEDGER ,F.CURRENCY_CD ,F.POSTED_TOTAL_AMT 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_LEDGER F WHERE A.BANK_STATUS='A' AND B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND B.ACCT_STATUS='A' 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.BUSINESS_UNIT=D.SETCNTRLVALUE AND F.LEDGER=E.LEDGER AND F.CURRENCY_CD=F.BASE_CURRENCY AND EXISTS ( SELECT 'X' FROM PS_BANK_ACCT_CHRT WHERE SETID=B.SETID AND BANK_CD=B.BANK_CD AND BANK_CD_CPTY=B.BANK_CD AND BANK_ACCT_KEY=B.BANK_ACCT_KEY AND COUNTERPARTY=B.BANK_CD AND BANK_ACCT_LED_TYPE IN ('A','C','H') AND ACCOUNT=F.ACCOUNT)

# 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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
4 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
6 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

9 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_TBL

10 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_TBL

11 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASS_CF_TBL

12 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_TBL

13 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_TBL

14 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

15 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

16 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

17 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CHARTFIELD1_TBL

18 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CHARTFIELD2_TBL

19 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CHARTFIELD3_TBL

20 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
21 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
22 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
23 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
24 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
25 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
26 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. "
27 POSTED_TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.