FCST_PRDAY_RCPT

(SQL View)
 Index Back

Bank Recon Receipts Table

Used to pull out all the items that are receipts. This is becuase the bank statement is no signed so we use the RECN_TRANS_CODE to determine if a payment or receipt. Linked to BNK_STMT_RCT_VW

SELECT DISTINCT A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.RECON_CYCLE_NBR , A.RECORD_SEQ_NUMBER , A.RECON_REF_ID , A.RECON_BANK_DT , A.RECON_TRAN_AMT , A.RECON_TRANS_CODE , A.BANK_STMT_CODE , A.RECON_STATUS , A.PROCESS_INSTANCE , A.STMT_ACTIVITY_TYPE , B.CURRENCY_CD , A.VALUE_DT , B.BUSINESS_UNIT_GL , B.SETID , C.BANK_CD , B.BANK_ACCT_KEY FROM PS_BANK_CD_TBL C , PS_BANK_ACCT_DEFN B , PS_STMT_CODE_TBL E , PS_BANK_STMT_TBL A WHERE A.BNK_ID_NBR = C.BNK_ID_NBR AND B.SETID = C.SETID AND B.BANK_CD = C.BANK_CD AND A.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM AND A.BANK_STMT_CODE = E.BANK_STMT_CODE AND E.CR_DB = '1'

# 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 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.
4 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.
5 RECON_REF_ID Character(20) VARCHAR2(20) NOT NULL The transaction reference identifier on the inbound bank statement.
6 RECON_BANK_DT Date(10) DATE The bank statement date.
7 RECON_TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement transaction amount.
8 RECON_TRANS_CODE Character(3) VARCHAR2(3) NOT NULL The PeopleSoft-specific bank transaction code
ACH=Automated Clearing House
B=Direct Debit
BA=Bank Adjustments
BOE=Bill of Exchange - Disburse
BOO=Bill of Order - Disburse
C=Trade Receipt
CHK=Check
D=Deposits
DD=Direct Debit - Disburse
EFT=Electronic Funds Transfer
F=Fee Expense
G=General Transaction
I=Interest Expense
M=Miscellaneous Transaction
MAN=Manual Check
P=Payment
R=Drafts
S=Stop Pay
TRW=Treasury Wire
U=Funding Receipt
V=Voided Payment
WIR=Wire - Disbursement
WRI=Wire - Incoming
9 BANK_STMT_CODE Character(8) VARCHAR2(8) NOT NULL Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions.
10 RECON_STATUS Character(3) VARCHAR2(3) NOT NULL Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 STMT_ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Represents a series of values that provide a more granular definition of a given reconcil
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 FORECAST_DATE Date(10) DATE Forecast Date
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
16 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
17 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
18 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