| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 2 |
ECFILEROWID |
Character(3) |
VARCHAR2(3) NOT NULL |
Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
|
| 3 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 4 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 5 |
ECACTIONCD |
Character(3) |
VARCHAR2(3) NOT NULL |
EC Action Code
|
| 6 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 7 |
BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
| 8 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 9 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 10 |
BANK_TRANS_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
A code that describes the type of transaction submitted by the bank via report or flat file.
|
| 11 |
BSP_EURO_INDEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Index for Euro for AFB statements
|
| 12 |
BSP_EXEMPTION_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Exemption code for bank statement processing
|
| 13 |
BSP_REJECT_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason for Rejection
|
| 14 |
BSP_OP_WORDING |
Character(30) |
VARCHAR2(30) NOT NULL |
Operations Wording from the Bank Statement
|
| 15 |
BSP_TRAN_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction Reference ID. Piece or Number
|
| 16 |
BSP_FUNDS_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Funds availability
0=Immediate
1=1 Day
2=2 Day
3=2 Days+
|
| 17 |
VALUE_DT |
Date(10) |
DATE |
Equivalent to a deal transaction's settlement date.
|
| 18 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 20 |
BSP_BANK_DT |
Date(10) |
DATE |
Date that the item was processed by the bank
|
| 21 |
BSP_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines the bank statements' amount type. + for Debit, - for Credit.
+=Debit
-=Credit
|
| 22 |
BSP_CALC_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate the method of balance calculation used on the bank statement.
0=From Index
1=From File
2=Original Total
|
| 23 |
BSP_TRAN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount of the Bank statement Transaction
|
| 24 |
RECON_REF_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
The transaction reference identifier on the inbound bank statement.
|
| 25 |
RECON_BANK_DT |
Date(10) |
DATE |
The bank statement date.
|
| 26 |
RECON_PAYEE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
The payee ID on the inbound bank statement.
|
| 27 |
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
|
| 28 |
BANK_REF_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
A reference identifier associated with a given bank/counterparty transaction.
|
| 29 |
OTHER_REF_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Other reference id used in the bank statement table
|
| 30 |
STMT_ACTIVITY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents a series of values that provide a more granular definition of a given reconcil
|
| 31 |
LOADED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a given treasury transaction successfully has been imp
|
| 32 |
BAL_LOADED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that designates whether a given bank balance has been loaded into the sys
|
| 33 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|