BANKACTRCN_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BANK_ACCT_RECON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 3 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 4 | BANK_CD_CPTY | Character(5) | VARCHAR2(5) NOT NULL |
An internal key field convention that facilitates the system distinction between banks and counterparties.
Prompt Table: BANK_CD_TBL |
| 5 | 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
Prompt Table: BANK_ACCT_DEFN |
| 6 | RECON_ACCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
A transaction type value that associates a reconciling item with its source transaction table(s).
01=Other 02=Receipts 03=Disbursements |
| 7 | RCN_SOURCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Source Type
1=Pre-process (before Recon) 2=Recon Process 3=Post-process (after Recon) |
| 8 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 9 | TRANSACTION_TBL | Character(18) | VARCHAR2(18) NOT NULL |
Represents the database table(s) that contain system source transaction data for reconciliation pu
Prompt Table: BNK_RCN_TBL_VW |
| 10 | RCN_SOURCE_NAME | Character(20) | VARCHAR2(20) NOT NULL |
This field contains the reconciliation source that reconcile with a bank statement line
Prompt Table: RCN_SOURCE_TBL |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | 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 |
| 13 | BNK_ACTIVE_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
This field determines the type of tolerance on a transaction's amount
A=Amount D=Date N=None P=Percent Default Value: A |
| 14 | BNK_LIMIT_HIGH_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | This field contains the upper amount when added to a transaction amount that will still reconcile. |
| 15 | BNK_LIMIT_HIGH_PCT | Number(8,2) | DECIMAL(7,2) NOT NULL | This field contains the high percent limit that when multiplied by the transaction amount and then added to the transaction amount will still allow the transaction to reconcile. |
| 16 | BNK_LIMIT_LOW_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | This field contains the lower amount when subtracted from a transaction amount that will still reconcile. |
| 17 | BNK_LIMIT_LOW_PCT | Number(8,2) | DECIMAL(7,2) NOT NULL | This field contains the low percent limit that when multiplied by the transaction amount and then subtracted to the transaction amount will still allow the transaction to reconcile. |
| 18 | BNK_LIMIT_HIGH_DAY | Number(3,0) | SMALLINT NOT NULL | Upper Day Limit |
| 19 | BNK_LIMIT_LOW_DAY | Number(3,0) | SMALLINT NOT NULL | Lower Day Limit |
| 20 | ACCTG_TMPL_ID | Character(15) | VARCHAR2(15) NOT NULL |
A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table: TRA_BSP_TMPL_VW |
| 21 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |