Data Dictionary -- Account Based Budget

Srl. No.	Table Name	Comment
1	abb_account_analysis_map	Stores the Mapping detail of Account Analysis
2	abb_account_anal_budget_dtl	Stores the detail of Account Analysis Budget
3	abb_account_budget_dtl	Stores the Detail of Account Budget
4	abb_account_budget_sap_dtl	Stores the mapping detail of Account Budget
5	abb_account_budg_consol	Stores the Console Information of Account Budget
6	abb_analysis_budget_dtl	Stores the Detail of Analysis Budget
7	abb_analysis_mst	Stores the Information of Analysis
8	abb_analysis_subanal_map	Stores the Mapping detail of Ananlysis and SubAnalysis
9	abb_attach_notes	Stores the Information Attachment Notes
10	abb_attach_notes_hist	Stores the History of Attachment Notes
11	abb_sub_analysis_mst	Stores the Information of Sub Analysis

Table Name :	abb_account_analysis_map
Comment :	Stores the Mapping detail of Account Analysis

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
sub_analysis_code	fin_subanalysiscode	varchar(5)	Yes	Sub analysis code	No
default_analysis_code	fin_partstatus	varchar(40)	Yes	Default analysis code	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
map_status	fin_partstatus	varchar(40)	Yes	Mapped status	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_datetime	datetime(8)	Yes	Mapped 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

Table Name :	abb_account_anal_budget_dtl
Comment :	Stores the detail of Account Analysis Budget

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	Yes	Company code	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year_code	fin_calendarcode	varchar(10)	Yes	Financial year code	No
fin_period_code	fin_calendarcode	varchar(10)	Yes	Financial period code	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
control_action	fin_controlaction	varchar(20)	Yes	Control action	No
budget_amount	fin_amount	numeric(13)	Yes	Budget amount	No
status	fin_partstatus	varchar(40)	Yes	Status	No
account_currency	fin_currencycode	varchar(5)	Yes	Account currency	No
carry_over_balance	fin_amount	numeric(13)	Yes	Carry over balance	No
net_budget_amount	fin_amount	numeric(13)	Yes	Net budget amount	No
carry_forward_flag	fin_flag	varchar(25)	Yes	Carry forward flag	No
budget_basis	fin_option	varchar(20)	Yes	Budget basis	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
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	abb_account_budget_dtl
Comment :	Stores the Detail of Account Budget

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year_code	fin_calendarcode	varchar(10)	No	Financial year code	Yes
fin_period_code	fin_calendarcode	varchar(10)	No	Financial period code	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
control_action	fin_controlaction	varchar(20)	Yes	Control action	No
budget_amount	fin_amount	numeric(13)	Yes	Budget amount	No
carry_fwd_budget	fin_partstatus	varchar(40)	Yes	Carry forward budget	No
app_season_pat	fin_partstatus	varchar(40)	Yes	app_season_pat	No
status	fin_partstatus	varchar(40)	Yes	Status	No
account_currency	fin_currencycode	varchar(5)	Yes	Account currency	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

Table Name :	abb_account_budget_sap_dtl
Comment :	Stores the mapping detail of Account Budget

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fin_year_code	fin_calendarcode	varchar(10)	No	Financial year code	Yes
fin_period_code	fin_calendarcode	varchar(10)	No	Financial period code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ratio	fin_ratio	numeric(13)	Yes	Ratio	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

Table Name :	abb_account_budg_consol
Comment :	Stores the Console Information of Account Budget

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fin_year_code	fin_calendarcode	varchar(10)	No	Financial year code	Yes
fin_period_code	fin_calendarcode	varchar(10)	No	Financial period code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
run_no	fin_number	int(4)	No	Run number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
consol_by	fin_ctxt_user	varchar(30)	Yes	Console by	No
consol_date	fin_datetime	datetime(8)	Yes	Console 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

Table Name :	abb_analysis_budget_dtl
Comment :	Stores the Detail of Analysis Budget

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year_code	fin_calendarcode	varchar(10)	No	Financial year code	Yes
fin_period_code	fin_calendarcode	varchar(10)	No	Financial period code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
sub_analysis_code	fin_subanalysiscode	varchar(5)	Yes	Sub analysis code	No
budget_amount	fin_amount	numeric(13)	Yes	Budget amount	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
status	fin_partstatus	varchar(40)	Yes	Status	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

Table Name :	abb_analysis_mst
Comment :	Stores the Information of Analysis

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
analysis_code	fin_analysiscode	varchar(5)	No	Analysis code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
analysis_desc	fin_accountdesc	varchar(60)	Yes	Analysis description	No
effective_date_from	fin_datetime	datetime(8)	Yes	Effective date from	No
effective_date_to	fin_datetime	datetime(8)	Yes	Effective date to	No
effective_date	fin_datetime	datetime(8)	Yes	Effective date	No
status	fin_partstatus	varchar(40)	Yes	Status	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
rpt_costce	fin_analysiscode	varchar(5)	Yes	rpt_costce	No

Table Name :	abb_analysis_subanal_map
Comment :	Stores the Mapping detail of Ananlysis and SubAnalysis

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
analysis_code	fin_analysiscode	varchar(5)	No	Analysis code	Yes
sub_analysis_code	fin_subanalysiscode	varchar(5)	No	Sub analysis code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
effective_date	fin_datetime	datetime(8)	Yes	Effective date	No
map_status	fin_partstatus	varchar(40)	Yes	Mapped status	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_datetime	datetime(8)	Yes	Mapped 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

Table Name :	abb_attach_notes
Comment :	Stores the Information Attachment Notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year_code	fin_calendarcode	varchar(10)	No	Financial year code	Yes
fin_period_code	fin_calendarcode	varchar(10)	No	Financial period code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach notes description	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

Table Name :	abb_attach_notes_hist
Comment :	Stores the History of Attachment Notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year_code	fin_calendarcode	varchar(10)	No	Financial year code	Yes
fin_period_code	fin_calendarcode	varchar(10)	No	Financial period code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach notes description	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

Table Name :	abb_sub_analysis_mst
Comment :	Stores the Information of Sub Analysis

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
sub_analysis_code	fin_subanalysiscode	varchar(5)	No	Sub analysis code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
sub_analysis_desc	fin_accountdesc	varchar(60)	Yes	Sub analysis description	No
effective_date	fin_datetime	datetime(8)	Yes	Effective date	No
status	fin_partstatus	varchar(40)	Yes	Status	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