POS_BNK_R_TRN_V

(SQL View)
 Index Back

Pos Bnk Rcn Tran Vw

Position view of bank recon generic transactions.

select BNK_ID_NBR ,BANK_ACCOUNT_NUM ,TRAN_REF_ID ,BUSINESS_UNIT ,TRAN_DT ,TRAN_AMT ,CURRENCY_CD ,TRAN_DESCR from PS_BNK_RCN_TRAN where RECON_STATUS = 'UNR'

# 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_ID_VW

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

Prompt Table: BANK_ACCTNUM_VW

3 TRAN_REF_ID Character(20) VARCHAR2(20) NOT NULL Represents the unique transaction identifier in bank reconciliation processing.
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BU_GL_UPDATE_VW

5 TRAN_DT Date(10) DATE Represents the transaction date in bank reconciliation processing.
6 TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount in bank reconciliation processing.
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 TRAN_DESCR Character(60) VARCHAR2(60) NOT NULL Describes the transaction.