Data Dictionary -- Financial Statement Layout

Srl. No.	Table Name	Comment
1	fsl_layout_sch_bal_dtl	Stores the Detail of Layout Balance Schedule
2	fsl_layout_sch_dtl	Stores the Detail of Layout Schedule
3	fsl_schacc_rel	Gives the Detail about Account Schedules
4	fsl_schlay_dtl	Stores the Deatail about layout Schedule
5	fsl_schlay_hdr	Stores the Header Information about Schedule Layout

Table Name :	fsl_layout_sch_bal_dtl
Comment :	Stores the Detail of Layout Balance Schedule

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Fslbal_guid	fin_guid	varchar(40)	Yes	Guid	No
Fslbal_companycode	fin_companycode	varchar(10)	Yes	Company code	No
Fslbal_pkg_ref_no	fin_mac_rpttype	varchar(50)	Yes	Package reference number	No
Fslbal_due_date	fin_datetime	datetime(8)	Yes	Due date	No
Fslbal_rpt_code	fin_hrtext20	varchar(20)	Yes	rpt code	No
Fslbal_sheet_code	fin_desc40	varchar(40)	Yes	Sheet code	No
Fslbal_run_no	fin_mac_rpttype	varchar(50)	Yes	Run number	No
Fslbal_fbid	fin_financebookid	varchar(20)	Yes	Finance book id	No
Fslbal_schno	fin_desc255	varchar(255)	Yes	Schedule number	No
Fslbal_schdesc	fin_desc120	varchar(120)	Yes	Schedule description	No
Fslbal_parschno	fin_desc255	varchar(255)	Yes	Parallel schedule number	No
Fslbal_schlaytype	fin_flag	varchar(25)	Yes	Schedule layout type	No
Fslbal_groupno	fin_desc255	varchar(255)	Yes	Group number	No
Fslbal_serialno	fin_number	int(4)	Yes	Serial number	No
Fslbal_lineno	fin_number	int(4)	Yes	Line number	No
Fslbal_seqno	fin_number	int(4)	Yes	Sequence number	No
Fslbal_obdrcr	fin_drcridentifier	varchar(6)	Yes	Order base debit credit	No
Fslbal_openbal	fin_amount	numeric(13)	Yes	Open balance	No
Fslbal_prddrcr	fin_drcridentifier	varchar(6)	Yes	Period debit credit	No
Fslbal_prddebit	fin_amount	numeric(13)	Yes	Period debit	No
Fslbal_prdcredit	fin_amount	numeric(13)	Yes	Period credit	No
Fslbal_prdbal	fin_amount	numeric(13)	Yes	Period balance	No
Fslbal_cbdrcr	fin_drcridentifier	varchar(6)	Yes	Closed balance debit credit	No
Fslbal_closebal	fin_amount	numeric(13)	Yes	Close balance	No
Fslbal_accflagbal	fin_flag	varchar(25)	Yes	Account flag balance	No
Fslbal_schlay_opr	fin_flag	varchar(25)	Yes	Schedule layout operation	No
Fslbal_acct_grp	fin_accountgroup	varchar(15)	Yes	Account group	No
Fslbal_createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
Fslbal_createddate	fin_datetime	datetime(8)	Yes	Created date	No
Fslbal_modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
Fslbal_modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fsl_layout_sch_dtl
Comment :	Stores the Detail of Layout Schedule

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fsl_compcode	fin_companycode	varchar(10)	Yes	Company code	No
fsl_fbid	fin_financebook	Varchar(40)	Yes	Finance book id	No
fsl_layoutno	fin_desc255	varchar(255)	Yes	Layout number	No
fsl_layouttype	fin_flag	varchar(25)	Yes	Layout type	No
fsl_schno	fin_desc255	varchar(255)	Yes	Schedule number	No
fsl_schdetdesc	fin_desc255	varchar(255)	Yes	Schedule detail description	No
fsl_schdesc	fin_text255	varchar(255)	Yes	Schedule description	No
fsl_parschno	fin_desc255	varchar(255)	Yes	Parallel schedule number	No
fsl_schtype	fin_flag	varchar(25)	Yes	Schedule type	No
fsl_grpno	fin_desc255	varchar(255)	Yes	Group number	No
fsl_srlno	fin_number	int(4)	Yes	Serial number	No
fsl_lineno	fin_number	int(4)	Yes	Line number	No
fsl_operation	fin_action	varchar(25)	Yes	Operation	No
fsl_guid	fin_guid	varchar(40)	Yes	Guid	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fsl_schacc_rel
Comment :	Gives the Detail about Account Schedules

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
schedule_no	fin_fslkeys	varchar(32)	No	Schedule number	Yes
acc_sch_no	fin_accountcode	varchar(32)	No	Account schedule number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
type	fin_option	varchar(20)	Yes	Type	No
parsch_no	fin_fslkeys	varchar(32)	Yes	Parallel schedule number	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 :	fsl_schlay_dtl
Comment :	Stores the Deatail about layout Schedule

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_component	varchar(16)	No	Company code	Yes
schlay_no	fin_accountcode	varchar(32)	No	Schedule layout number	Yes
acc_sch_no	fin_accountcode	varchar(32)	No	Account schedule number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
sch_layout_flag	fin_eflag	varchar(1)	No	Schedule layout flag	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
schlay_type	fin_flag	varchar(25)	Yes	Schedule layout type	No
line_no	fin_number	int(4)	Yes	Line number	No
grp_incl_flag	fin_flag	varchar(25)	Yes	Group include flag	No
schlay_incl_flag	fin_flag	varchar(25)	Yes	Schedule layout include flag	No
sequence_no	fin_sequence	int(4)	Yes	Sequence number	No
acc_flag_bal	fin_flag	varchar(25)	Yes	Account flag balance	No
schlay_operation	fin_action	varchar(25)	Yes	Schedule layout operation	No
schedule_printview	fin_printview	varchar(40)	Yes	Schedule printview	No
group_desc	fin_desc120	varchar(120)	Yes	Group description	No
schlay_tot_desc	fin_desc120	varchar(120)	Yes	Schedule layout total description	No
par_secgrp	fin_desc120	varchar(120)	Yes	Parallel sequence group	No
total_sequence	fin_int	int(4)	Yes	Total sequence	No
total_operation	fin_action	varchar(25)	Yes	Total operation	No
total_view	fin_printview	varchar(40)	Yes	Total view	No
total_bal_flag	fin_flag	varchar(25)	Yes	Total balance flag	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 :	fsl_schlay_hdr
Comment :	Stores the Header Information about Schedule Layout

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
schlay_no	fin_accountcode	varchar(32)	No	Schedule number	Yes
sch_layout_flag	fin_eflag	varchar(1)	No	Schedule layout flag	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fb_type	fin_fbtype	varchar(10)	No	Finance book type	Yes
status	fin_partstatus	varchar(40)	No	Status	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
schlay_desc	fin_accountdesc	varchar(60)	Yes	Schedule layout description	No
schlay_class	fin_schclassoption	varchar(30)	Yes	Schedule layout class	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
coa_id	fin_coaid	varchar(10)	Yes	coa id	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