BS_TRNS_PD_EC_C(SQL Table) |
Index Back |
---|---|
BTF:Bank Acct Transaction LineBank Account Transaction Line |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TEST_CASE | Character(30) | VARCHAR2(30) NOT NULL | BTF Test Case |
2 | COMPARE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results |
3 | COMPARE_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals E=Expected |
4 | STATEMENT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Statement ID for bank statements, key on Bank Statement Header |
5 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
6 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
7 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
8 | RECORD_SEQ_NUMBER | Number(10,0) | DECIMAL(10) NOT NULL | An internal work field utilized to enumerate database records in bank statement processing. |
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.
Prompt Table: BSP_TXN_CODE_VW |
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 | 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 |
12 | BSP_TRAN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount of the Bank statement Transaction |
13 | FUNDS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Funds Availability Type
0=Immediate Availability 1=One-day Availability 2=Two-or more-day Availability D=Distributed Availability-vary S=Distributed Availability-fixed V=Value Dated Z=unknown |
14 | IMMEDIATE_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Available Balance |
15 | FLOAT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | One Day Float Balance |
16 | FLOAT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Two or More Days Float Balance |
17 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
19 | RECON_REF_ID | Character(20) | VARCHAR2(20) NOT NULL | The transaction reference identifier on the inbound bank statement. |
20 | BANK_REF_ID | Character(16) | VARCHAR2(16) NOT NULL | A reference identifier associated with a given bank/counterparty transaction. |
21 | STMT_ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Represents a series of values that provide a more granular definition of a given reconcil |
22 | LOADED_SW | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a given treasury transaction successfully has been imp
Default Value: N |
23 | 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
Default Value: N |
24 | DESCRLONG | Long Character | CLOB | Long Description |
25 | TRANSACTION_DT | Date(10) | DATE | Transaction date (often used as trade date) |