BNK_ID_NBRDefault Value: BANK_CD_TBL.BNK_ID_NBR
BANK_ACCOUNT_NUMDefault Value: BNK_BAL_SRCH.BANK_ACCOUNT_NUM
BANK_STMT_DTBNK_BAL_DT_VW(SQL View) |
Index Back |
|---|---|
Bank Balance Table VWBank Balance Date View |
| SELECT A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.BANK_STMT_DT FROM PS_BNK_BALANCE_TBL A WHERE A.BANK_STMT_DT >= %DateAdd(%CURRENTDATEIN, -32) AND A.BANK_STMT_DT <= %CurrentDateIn |
| # | 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.
Default Value: BANK_CD_TBL.BNK_ID_NBR |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Default Value: BNK_BAL_SRCH.BANK_ACCOUNT_NUM |
| 3 | BANK_STMT_DT |
Date(10) | DATE NOT NULL | "The bank statement date |