BUSINESS_UNIT_GLSETIDBANK_CDBANK_ACCT_KEYASOFDATEBNK_BU_GRP_VW1(SQL View) |
Index Back |
|---|---|
Bank Account Register View |
| SELECT DISTINCT A.BUSINESS_UNIT_GL ,A.SETID ,A.BANK_CD ,A.BANK_ACCT_KEY ,A.ASOFDATE ,A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.RECON_CYCLE_NBR ,A.BALANCE ,A.CURRENCY_CD ,B.BUS_UNIT_GROUP_ID ,A.STMT_BAL_OPEN ,A.STMT_BAL_CLOSE FROM PS_BANK_BAL_AA_VW A , PS_BU_GRP_TBL_2 B WHERE A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 4 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 5 | ASOFDATE |
Date(10) | DATE | As of Date |
| 6 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 7 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 8 | RECON_CYCLE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 9 | BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | BUS_UNIT_GROUP_ID | Character(8) | VARCHAR2(8) NOT NULL | A unique key identifier that represents a grouping of general ledger business units. |
| 12 | STMT_BAL_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement opening balance as submitted by the bank. |
| 13 | STMT_BAL_CLOSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement closing balance as submitted by the bank. |