BNK_BTB_HDR_VW1(SQL View) |
Index Back |
|---|---|
Book To Bank HeaderBook to Bank Header Record |
| SELECT A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.BUSINESS_UNIT , A.LEDGER , A.STATEMENT_ID , A.ASOFDATE , A.BANK_CURRENCY , A.BASE_CURRENCY , A.RATE_INDEX , A.CUR_RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.BEGIN_DT , A.END_DT , A.DATETIME_STAMP , A.OPRID , A.BTB_RECON_STATUS , A.ADJUSTING_PERIOD , A.BANK_STMT_BAL , A.BANK_STMT_BAL_BASE , A.PYMNT_IN_TRANSIT , A.DEP_IN_TRANSIT , A.GL_ADJUSTMENTS , A.ADJ_BANK_BAL , A.ADJUSTED_BNK_BAL , A.ADJ_DIFFERENCE , A.GL_BANK_ACCT_BAL , A.FEES_INTEREST , A.UNBOOKED_PYMNT , A.UNBOOKED_DEP , A.BANK_ADJUSTMENTS , A.ADJ_GL_BAL , A.ADJ_LEDGER_BAL , A.REVAL_ADJUSTMENT , A.EVENT_TRACKING_ID , A.DESCRLONG FROM PS_BNK_BTB_HDR A |
| # | 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
Prompt Table: BNK_BTB_FY_VW |
| 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.
Prompt Table: BNK_BTB_PR_VW |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 7 | STATEMENT_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Statement ID for bank statements, key on Bank Statement Header
Prompt Table: BNK_BTB_STMT_VW |
| 8 | ASOFDATE | Date(10) | DATE | As of Date |
| 9 | BANK_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Bank Account Currency |
| 10 | 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. " |
| 11 | RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Rate index |
| 12 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 13 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 14 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 15 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 16 | END_DT | Date(10) | DATE | End Date |
| 17 | DATETIME_STAMP | DateTime(26) | TIMESTAMP |
DateTime Stamp
Default Value: %datetime |
| 18 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID |
| 19 | BTB_RECON_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Book to bank Reconciliation Status
1=Confirmed 2=Awaiting Confirmation 3=Calculating 4=New Default Value: 4 |
| 20 | ADJUSTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Adjustment Period |
| 21 | BANK_STMT_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Book to bank Recon |
| 22 | BANK_STMT_BAL_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Book to bank Recon |
| 23 | PYMNT_IN_TRANSIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment in Tansit use in Book to bank Recon |
| 24 | DEP_IN_TRANSIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deposits in Transit |
| 25 | GL_ADJUSTMENTS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | GL Adj field used in Book to Bank Recon |
| 26 | ADJ_BANK_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Use in Book to Bank Recon |
| 27 | ADJUSTED_BNK_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Use in Book to Bank Recon |
| 28 | ADJ_DIFFERENCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Adjustment Difference |
| 29 | GL_BANK_ACCT_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bank Acct Ledger Balance |
| 30 | FEES_INTEREST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unbooked Fees and Interest |
| 31 | UNBOOKED_PYMNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unbooked Payments |
| 32 | UNBOOKED_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unbooked Deposits |
| 33 | BANK_ADJUSTMENTS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bank Adjustments |
| 34 | ADJ_GL_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | GL Adjustments Subtotal |
| 35 | ADJ_LEDGER_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Adjusted Ledger Balance |
| 36 | REVAL_ADJUSTMENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revaluation Adjustment Amount |
| 37 | EVENT_TRACKING_ID | Number(10,0) | DECIMAL(10) NOT NULL | The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID. |
| 38 | DESCRLONG | Long Character | CLOB | Long Description |