BNK_RN_T_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BNK_RCN_TRAN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | 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 |
| 4 | TRAN_REF_ID | Character(20) | VARCHAR2(20) NOT NULL | Represents the unique transaction identifier in bank reconciliation processing. |
| 5 | TRAN_DT | Date(10) | DATE NOT NULL |
Represents the transaction date in bank reconciliation processing.
Default Value: %DATE |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 7 | TRAN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents a transaction amount in bank reconciliation processing. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | TRAN_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Describes the transaction. |
| 10 | 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 |
| 11 | RECON_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled B=Balance System(s) to BankTran F=Forced to Reconcile M=Manually Reconciled S=Semi Manual U=Unreconciled Default Value: U |
| 12 | 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 |
| 13 | RECONCILE_DT | Date(10) | DATE | The transaction reconciliation date. |
| 14 | RECONCILE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The user ID that performed the reconciliation for a given transaction. |
| 15 | RECON_CYCLE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 16 | RECORD_SEQ_NUMBER | Number(10,0) | DECIMAL(10) NOT NULL | An internal work field utilized to enumerate database records in bank statement processing. |
| 17 | STTLMNT_DT_ACTUAL | Date(10) | DATE | Date in which a deal transaction is actually settled with a counterparty. |
| 18 | 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 |
| 19 | 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 |
| 20 | 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 |
| 21 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 22 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 23 | DTTM_ENTERED | DateTime(26) | TIMESTAMP | Date Time Stamp for Entry |
| 24 | RECON_RUN_ID | Character(15) | VARCHAR2(15) NOT NULL | Recon Run ID |
| 25 | BANK_ACCT_RVL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Field used to store the amount on a transaction revalued in the base currency of the transactions bank account. |
| 26 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |
| 27 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |