Data Dictionary -- Consolidation

Srl. No.	Table Name	Comment
1	consol_bcon_1to1_trn	Contains the Consolidate tran_type,account_code,tran_amt details
2	consol_bcon_parent_sum_bal	Contains the Consolidate of summary balance details of finance_year,finance_period,run_no details.
3	consol_bcon_run_trn	Contains the Consolidate of run details in corresponding period
4	consol_bcon_sum_bal	Contains the Consolidate of opening balance summary details.
5	consol_cmpy_segment_mst	Contains the Consolidate of segment master.
6	consol_convert_rate	Contains the Consolidate exchange rate details.
7	consol_error_desc	Contains the Consolidate Finance Error Description.
8	consol_ext_acc_map	Contains the Consolidate External and posting account details.
9	consol_ext_ent_mst	Contains the Consolidate of External Enterprise master.
10	consol_ext_sum_bal	Contains the Consolidate of External summary balance.
11	consol_jv_dtl	Contains the Consolidate of Journal Voucher details.
12	consol_jv_hdr	Contains the Consolidate of Journal Voucher header.
13	consol_layout_sum_bal	Contains the consolidate layout summary balance.
14	consol_notes_his	Contains the Consolidate of notes history
15	consol_notes_mst	Contains the Consolidate of notes master.
16	consol_posted_status	Contains the Consolidate of run details.
17	consol_postings_dtl	Contains the Consolidate of postings details.
18	consol_post_run_history	Contains the consolidate of run history details.
19	consol_report_struct_dtl	Contains the Consolidate report status details.
20	consol_report_struct_mst	Contains the Consolidate report master.

Table Name :	consol_bcon_1to1_trn
Comment :	Contains the Consolidate tran_type,account_code,tran_amt details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	int	int(4)	Yes	Time Stamp	No
run_no	fin_documentno	varchar(40)	Yes	Run Number	No
batch_id	fin_guid	varchar(40)	Yes	Batch Id	No
component_name	fin_component	varchar(16)	Yes	Component Name	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction Organization Unit	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance Book Id	No
doc_no	fin_documentno	varchar(40)	Yes	Document Number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction Type	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit Credit Flag	No
tran_date	datetime	Datetime(8)	Yes	Transaction Date	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank Code	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency Code	No
tran_amt	fin_amount	numeric(13)	Yes	Transaction Amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
entry_date	datetime	Datetime(8)	Yes	Entry Date	No
auth_date	datetime	Datetime(8)	Yes	Authorized Date	No
item_code	fin_itemcode	varchar(40)	Yes	Item Code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item Variant	No
narration	fin_name	varchar(60)	Yes	Narration	No
post_amt	fin_amount	numeric(13)	Yes	Post Amount	No
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference Transaction Finance Book Id	No
reftran_no	fin_documentno	varchar(40)	Yes	Reference Transaction Number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference Transaction Organization Unit	No
reftran_type	fin_transactiontype	varchar(40)	Yes	Reference Transaction Type	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Supplier Customer Code	No
uom	fin_uom	varchar(15)	Yes	Unit Of Measurement	No
fb_voucher_no	fin_documentno	varchar(40)	Yes	Finance Book Voucher Number	No
fb_voucher_date	datetime	Datetime(8)	Yes	Finance Book Voucher Date	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	consol_bcon_parent_sum_bal
Comment :	Contains the Consolidate of summary balance details of finance_year,finance_period,run_no details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_no	fin_documentno	varchar(40)	No	Run Number	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
timestamp	int	int(4)	Yes	Timestamp	No
finance_year	fin_financeyear	varchar(15)	Yes	Finance year	No
finance_period	fin_financeperiod	varchar(15)	Yes	Finance period	No
ou_id	fin_ouinstid	int(4)	Yes	Organization Unit Id	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
account_balance	fin_amount	numeric(13)	Yes	Account Balance	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit Credit Flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_bcon_run_trn
Comment :	Contains the Consolidate of run details in corresponding period

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
run_no	fin_documentno	varchar(40)	No	Run Number	Yes
serial_no	fin_number	int(4)	No	Serial Number	Yes
timestamp	int	int(4)	Yes	Timestamp	No
finance_structid	fin_name	varchar(60)	Yes	Finance Structure Id	No
finance_year	fin_financeyear	varchar(15)	Yes	Finance Year	No
finance_period	fin_financeperiod	varchar(15)	Yes	Finance Period	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance Book Id	No
ext_enterprise_id	fin_name	varchar(60)	Yes	Exchange Enterprise Id	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency Code	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
account_codeto	fin_accountcode	varchar(32)	Yes	Account Code To	No
from_date	datetime	Datetime(8)	Yes	From Date	No
to_date	datetime	Datetime(8)	Yes	To Date	No
posting_type	fin_type	varchar(25)	Yes	Posting Type	No
error_id	fin_number	int(4)	Yes	Error Id	No
run_status	fin_status	varchar(25)	Yes	Run Status.Values A-Abort,C-Completed,I-In Progress,N-Not Started,R-Resume,U-Cancelled	No
numbering_type	fin_notypeno	varchar(10)	Yes	Numbering Type	No
select_option	fin_desc16	varchar(16)	Yes	Select Option	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_bcon_sum_bal
Comment :	Contains the Consolidate of opening balance summary details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_no	fin_documentno	varchar(40)	No	Run Number	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
account_code	fin_accountcode	varchar(32)	No	Account Code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit Credit Flag	No
timestamp	int	int(4)	Yes	Timestamp	No
finance_year	fin_financeyear	varchar(15)	Yes	Finance Year	No
finance_period	fin_financeperiod	varchar(15)	Yes	Finance Period	No
ou_id	fin_ouinstid	int(4)	Yes	Organization Unit Id	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
account_balance	fin_amount	numeric(13)	Yes	Account Balance	No
open_account_balance	fin_amount	numeric(13)	Yes	Opening Account Balance	No
open_drcr_flag	fin_drcridentifier	varchar(6)	Yes	Opening Debit Credit Flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_cmpy_segment_mst
Comment :	Contains the Consolidate of segment master.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
finance_sgmntid	fin_desc28	varchar(28)	No	Finance Segment Id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
seg_status	fin_status	varchar(25)	No	Segment Status.Values A-Active,I-Inactive	Yes
timestamp	int	int(4)	Yes	Timestamp	No
finance_sgmnt_desc	fin_description	varchar(100)	Yes	Finance Segment Descripiton	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_convert_rate
Comment :	Contains the Consolidate exchange rate details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
exchgrate_typeno	fin_exchratetype	varchar(40)	No	Exchange Rate Type Number	Yes
account_group	fin_accountgroup	varchar(15)	No	Account Group	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
ext_enterprise_id	fin_documentno	varchar(40)	No	External Enterprise Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_error_desc
Comment :	Contains the Consolidate Finance Error Description.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_no	fin_documentno	varchar(40)	No	Run Number	Yes
error_id	fin_number	int(4)	No	Error Id	Yes
timestamp	fin_timestamp	int(4)	Yes	Time Stamp	No
language_id	fin_ctxt_language	int(4)	Yes	Language id	No
fin_error_desc	fin_desc255	varchar(255)	Yes	Error description	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_ext_acc_map
Comment :	Contains the Consolidate External and posting account details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
external_id	fin_documentno	varchar(40)	No	External id	Yes
ext_account_code	fin_accountcode	varchar(32)	No	External Account Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
ext_account_grp	fin_accountgroup	varchar(15)	Yes	External Account Group	No
post_account_code	fin_accountcode	varchar(32)	Yes	Posting Account Code	No
ext_account_desc	fin_accountdescription	varchar(40)	Yes	External Account Description	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_ext_ent_mst
Comment :	Contains the Consolidate of External Enterprise master.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
external_id	fin_documentno	varchar(40)	No	External id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
external_ent_name	fin_description	varchar(100)	Yes	External Enterprise Name	No
status	fin_status	varchar(25)	Yes	Status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_ext_sum_bal
Comment :	Contains the Consolidate of External summary balance.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
external_id	fin_documentno	varchar(40)	No	External id	Yes
ext_account_code	fin_accountcode	varchar(32)	No	External Account Code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
finance_year	fin_financeyear	varchar(15)	No	Finance Year	Yes
finance_period	fin_financeperiod	varchar(15)	No	Finance Period	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
ext_account_grp	fin_accountgroup	varchar(15)	Yes	External Account Group	No
account_balance	fin_amount	numeric(13)	Yes	Account Balance	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit Credit Flag	No
layout_heading	fin_param_text	varchar(255)	Yes	Layout Heading	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_jv_dtl
Comment :	Contains the Consolidate of Journal Voucher details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	No
voucher_no	fin_documentno	varchar(40)	No	Voucher Number	No
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	No
account_code	fin_accountcode	varchar(32)	No	Account Code	No
timestamp	int	int(4)	Yes	Time Stamp	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit Credit Flag	No
tran_currency	fin_currencycode	varchar(5)	Yes	Transaction Currency	No
tran_amt	fin_amount	numeric(13)	Yes	Transaction Amount	No
base_amt	fin_amount	numeric(13)	Yes	Base Amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
par_base_amt	fin_amount	numeric(13)	Yes	Parallel Base Amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel  Exchange Rate	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost Center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis Code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	consol_jv_hdr
Comment :	Contains the Consolidate of Journal Voucher header.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
voucher_no	fin_documentno	varchar(40)	No	Voucher Number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
tran_date	datetime	Datetime(8)	Yes	Transaction Date	No
credit_total	fin_amount	numeric(13)	Yes	Credit Total	No
credit_base_total	fin_amount	numeric(13)	Yes	Credit Base Total	No
credit_parbase_total	fin_amount	numeric(13)	Yes	Credit Parallel Base Total	No
debit_total	fin_amount	numeric(13)	Yes	Debit Total	No
debit_base_total	fin_amount	numeric(13)	Yes	Debit  Base Total	No
debit_parbase_total	fin_amount	numeric(13)	Yes	Debit Parallel Base Total	No
status	fin_status	varchar(25)	Yes	Status.Values A-Active,I-Inactive	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No
report_id	fin_accountcode	varchar(32)	Yes	report_id	No

Table Name :	consol_layout_sum_bal
Comment :	Contains the consolidate layout summary balance.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	int	int(4)	Yes	Time Stamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
layout_head	fin_desc255	varchar(255)	Yes	Layout heading	No
account_balance	fin_amount	numeric(13)	Yes	Account Balance	No
open_account_balance	fin_amount	numeric(13)	Yes	Opening Account Balance	No
drcr_identifier	fin_desc16	varchar(16)	Yes	Debit Credit Identifier	No
open_drcr_identifier	fin_desc16	varchar(16)	Yes	Open Debit Credit Identifier	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
fin_year	fin_desc16	varchar(16)	Yes	Finance year	No
fin_period	fin_docuemntno	varchar(18)	Yes	Finance period	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	consol_notes_his
Comment :	Contains the Consolidate of notes history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
external_id	fin_documentno	varchar(40)	No	External id	Yes
fin_year	fin_financeyear	varchar(15)	No	Finance year	Yes
action_time	datetime	Datetime(8)	No	Action Time	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
notes_desc	fin_notes	varchar(2000)	Yes	Notes Descripiton	No
notes	fin_text2500	varchar(2500)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_notes_mst
Comment :	Contains the Consolidate of notes master.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
external_id	fin_documentno	varchar(40)	No	External id	Yes
fin_year	fin_financeyear	varchar(15)	No	Finance year	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
notes	fin_text2500	varchar(2500)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_posted_status
Comment :	Contains the Consolidate of run details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_no	fin_documentno	varchar(40)	No	Run Number	Yes
serial_no	fin_number	int(4)	No	Serial Number	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
finance_year	fin_financeyear	varchar(15)	No	Finance Year	Yes
finance_period	fin_financeperiod	varchar(15)	No	Finance Period	Yes
batch_id	fin_guid	varchar(40)	No	Batch Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
ou_id	fin_ouinstid	int(4)	Yes	Organization Unit Id	No
consol_type	fin_type	varchar(25)	Yes	Consolidation Type	No
consol_status	fin_status	varchar(25)	Yes	Consolidation Status.Values C - Completed,N-Not completed,I-In progress	No
run_status	fin_status	varchar(25)	Yes	Run Status.Values C - Completed,N-Not completed	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_postings_dtl
Comment :	Contains the Consolidate of postings details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	int	int(4)	Yes	Time Stamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ou_id	fin_ouinstid	int(4)	Yes	Organization Unit Id	No
component_name	fin_compname	varchar(40)	Yes	Component Name	No
company_code	fin_companycode	varchar(10)	Yes	Company Code	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance Book Id	No
bu_id	fin_buid	varchar(20)	Yes	Business Unit Id	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit Credit Flag	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction Organization Unit	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction Type	No
tran_date	datetime	Datetime(8)	Yes	Transaction Date	No
tran_amt	fin_amount	numeric(13)	Yes	Transaction Amount	No
voucher_no	fin_documentno	varchar(40)	Yes	Voucher Number	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency Code	No
posting_date	datetime	Datetime(8)	Yes	Posting Date	No
base_amt	fin_amount	numeric(13)	Yes	Base Amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange Rate	No
par_base_amt	fin_amount	numeric(13)	Yes	Parallel Base Amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel Exchange Rate	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis Code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis Code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost Center	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	consol_post_run_history
Comment :	Contains the consolidate of run history details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_no	fin_documentno	varchar(40)	No	Run Number	Yes
serial_no	fin_number	int(4)	No	Serial Number	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
finance_year	fin_financeyear	varchar(15)	No	Finance Year	Yes
finance_period	fin_financeperiod	varchar(15)	No	Finance Period	Yes
batch_id	fin_guid	varchar(40)	No	Batch Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
ou_id	fin_ouinstid	int(4)	Yes	Organization Unit Id	No
consol_status	fin_status	varchar(25)	Yes	Consolidation Status.Values C - Completed,N-Not completed,I-In progress	No
consol_type	fin_type	varchar(25)	Yes	Consolidation Type	No
run_status	fin_status	varchar(25)	Yes	Run Status.Values C - Completed,N-Not completed	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_report_struct_dtl
Comment :	Contains the Consolidate report status details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
report_id	fin_accountcode	varchar(32)	No	report_id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
status	fin_status	varchar(25)	Yes	Status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	consol_report_struct_mst
Comment :	Contains the Consolidate report master.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
report_id	fin_accountcode	varchar(32)	No	report_id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
report_desc	fin_description	varchar(100)	Yes	Report Descripiton	No
status	fin_status	varchar(25)	Yes	Status	No
ou_id	fin_ouinstid	int(4)	Yes	Organization Unit Id	No
modified_ou	fin_ouinstid	int(4)	Yes	Modified Organization  Unit	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No