BNK_RCN_MTM_TBL(SQL Table) |
Index Back |
|---|---|
M:M Bank Reconciliation |
| # | 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. |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 3 | STATEMENT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Statement ID for bank statements, key on Bank Statement Header |
| 4 | RECON_RUN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Recon Run ID |
| 5 | BNK_RCN_SEQUENCE |
Number(6,0) | INTEGER NOT NULL | Sequence # |
| 6 | RECON_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Represents the source system table(s) for reconciling items.
00=Bank Statement 01=Receivables Deposits 02=Payables 03=Treasury 04=Receivables Drafts 05=External Transactions 06=Receivables Payments 07=Direct Debits |
| 7 | RECON_CYCLE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 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 | TRAN_REF_ID | Character(20) | VARCHAR2(20) NOT NULL | Represents the unique transaction identifier in bank reconciliation processing. |
| 10 | TRAN_DT | Date(10) | DATE | Represents the transaction date in bank reconciliation processing. |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | DEPOSIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 13 | PAYMENT_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 14 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 15 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 16 | 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 |
| 17 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 18 | TR_SOURCE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Accounting only
B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers |
| 19 | CASH_FLOW_LINE | Number(15,0) | DECIMAL(15) NOT NULL | A sequential number that indicates the time order sequence of a given deal transaction's cash flows. |
| 20 | CASH_FLOW_LEG | Number(1,0) | SMALLINT NOT NULL | A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg |