BNK_EXCP_WL

(SQL Table)
Index Back

Autorecon Exceptions Worklist

12/16/97 JRC: Added PROCESS_INSTANCE as primary key per TPRD T-CJOHNSON-8ER6P

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
7 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
8 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
9 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
10 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.
11 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.
12 RECON_REF_ID Character(20) VARCHAR2(20) NOT NULL The transaction reference identifier on the inbound bank statement.
13 RECON_BANK_DT Date(10) DATE The bank statement date.
14 RECON_TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement transaction amount.
15 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