| Data Dictionary -- Inter FB Reconcilation | ||||||||
| Srl. No. | Table Name | Comment |
| 1 | ifb_reconcile_trn_dtl | Stores the Detail of Reconcile Transaction |
| Table Name : | |
| Comment : | Stores the Detail of Reconcile Transaction |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| run_no | fin_number | int(4) | No | Run number | Yes |
| serial_no | fin_serialno | varchar(18) | No | Serial number | Yes |
| timestamp | fin_int | int(4) | Yes | Timestamp | No |
| company_code | fin_companycode | varchar(10) | Yes | Company code | No |
| bu_id | fin_buid | varchar(20) | Yes | Business unit id | No |
| fb_id | fin_financebookid | varchar(20) | Yes | Finance book id | No |
| account_code | fin_accountcode | varchar(32) | Yes | Account code | No |
| tran_type | fin_transactiontype | varchar(40) | Yes | Transaction type | No |
| tran_ou | fin_ouinstid | int(4) | Yes | Transaction OU | No |
| document_no | fin_documentno | varchar(40) | Yes | Document number | No |
| tran_date | fin_datetime | datetime(8) | Yes | Transaction date | No |
| tran_currency | fin_currencycode | varchar(5) | Yes | Transaction currency | No |
| tran_amount | fin_amount | numeric(13) | Yes | Transaction amount | No |
| base_amount | fin_amount | numeric(13) | Yes | Base amount | No |
| drcr_flag | fin_drcridentifier | varchar(6) | Yes | Debit credit flag | No |
| tag_group | fin_tagno | varchar(20) | Yes | Tag group | No |
| batch_id | fin_guid | varchar(40) | Yes | Batch id | No |
| recon_by | fin_ctxt_user | varchar(30) | Yes | Reconsile by | No |
| recon_date | fin_datetime | datetime(8) | Yes | Reconsile date | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Created by | No |
| createddate | fin_datetime | datetime(8) | Yes | Created date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| modifieddate | fin_datetime | datetime(8) | Yes | Modified date | No |