BNK_ID_NBRPrompt Table: BANK_XTRAN_DVW1
BANK_ACCOUNT_NUMPrompt Table: BANK_XTRAN_DVW2
TRAN_REF_IDTRAN_DTBNK_RCN_TRAN_AV(SQL View) |
Index Back |
|---|---|
External Transactions Add VWUsed by Component.GEN_TRAN_UPDT as an Add Search Record because it respects only active BANK_STATUS and ACCT_STATUS rows. |
| SELECT BNK_ID_NBR ,BANK_ACCOUNT_NUM ,TRAN_REF_ID ,TRAN_DT FROM PS_BNK_RCN_TRAN |
| # | 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.
Prompt Table: BANK_XTRAN_DVW1 |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_XTRAN_DVW2 |
| 3 | TRAN_REF_ID |
Character(20) | VARCHAR2(20) NOT NULL | Represents the unique transaction identifier in bank reconciliation processing. |
| 4 | TRAN_DT |
Date(10) | DATE | Represents the transaction date in bank reconciliation processing. |