BNK_ACT_RCN_LNG(SQL Table) |
Index Back |
|---|---|
Acct Recon Attributes12/12/2005 cmh Removed fields RECON_ACCT_TYPE and TRANSACTION_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 3 | 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 |
| 4 | 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 |
| 5 | RCN_SOURCE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Source Type
1=Pre-process (before Recon) 2=Recon Process 3=Post-process (after Recon) |
| 6 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | RCN_SOURCE_NAME |
Character(20) | VARCHAR2(20) NOT NULL | This field contains the reconciliation source that reconcile with a bank statement line |
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |