BNK_BTB_STMT_VW

(SQL View)
Index Back

Book To Bank Header

Book to Bank Header Record

SELECT BNK_ID_NBR , BANK_ACCOUNT_NUM , FISCAL_YEAR , ACCOUNTING_PERIOD , STATEMENT_ID , ASOFDATE FROM PS_BNK_BTB_HDR_VW WHERE BTB_STATUS = 'Y'

# 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 STATEMENT_ID Number(10,0) DECIMAL(10) NOT NULL Statement ID for bank statements, key on Bank Statement Header
6 ASOFDATE Date(10) DATE As of Date