| # |
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 |
TRAN_DT |
Date(10) |
DATE NOT NULL |
Represents the transaction date in bank reconciliation processing.
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 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 |
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
Default Value: UNR
|
| 9 |
BUILD_ACCTG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates the point in time construction status for a a given treasu
Y/N Table Edit
|
| 10 |
TRA_PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The processing status for a given accounting entry build.
A=Accruing
D=Deactivated
E=Error
I=In Process
N=Not Processed
P=Processed
T=Temporary Hold
Default Value: N
|