Data Dictionary -- Financial Calendar Closure

Srl. No.	Table Name	Comment
1	FCC_BFG_COMPONENT_MAP	Stores the Mapping Information about BFG component
2	fcc_bfg_error_dtl	Stores the detail about BFG error
3	FCC_BFG_MST	Stores the Information about BFG
4	FCC_BFG_PRD_CLOSE_STATUS	Stores the detail about BFG Period Close status
5	FCC_BFG_YR_CLOSE_STATUS	Stores the Detail about BFG year close status
6	fcc_cls_fb_run_trn	Stores the Information about cls Finance Book run Transaction
7	FCC_ERROR_DTL	Stores the detail about Error
8	fcc_mac_fbp_post	Stores the detail about mac Finance book period Post
9	FCC_PRD_CLOSE_HISTORY	Stores the History about Period Close
10	FCC_PRD_CLOSE_STATUS	Stores the Information about Period Close Status
11	FCC_YR_CLOSE_HISTORY	Stores the History about Year Close
12	FCC_YR_CLOSE_STATUS	Stores the Information about Year Close Status

Table Name :	FCC_BFG_COMPONENT_MAP
Comment :	Stores the Mapping Information about BFG component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
BFG_CODE	fin_varchar	varchar(800)	No	bfg code	Yes
COMPONENT_ID	fin_varchar	varchar(800)	No	Component id	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
MAP_STATUS	fin_varchar	varchar(800)	Yes	Mapped status	No
MAP_BY	fin_varchar	varchar(800)	Yes	Mapped by	No
MAP_DATE	fin_datetime	datetime(8)	Yes	Mapped date	No
UNMAP_BY	fin_varchar	varchar(800)	Yes	Unmapped by	No
UNMAP_DATE	fin_datetime	datetime(8)	Yes	Unmapped date	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	fcc_bfg_error_dtl
Comment :	Stores the detail about BFG error

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
run_no	fin_documentnumber	varchar(18)	No	Run number	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
error_id	fin_documentno	varchar(40)	Yes	Error id	No
error_desc	fin_errmsg	varchar(30)	Yes	Error 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 :	FCC_BFG_MST
Comment :	Stores the Information about BFG

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
BFG_CODE	fin_varchar	varchar(800)	No	bfg code	Yes
LANGUAGE_ID	fin_decimal	decimal(17)	No	Language id	Yes
BFG_NAME	fin_varchar	varchar(800)	No	bfg name	No
STATUS	fin_varchar	varchar(800)	No	Status	No
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
PREBFG_CODE	fin_varchar	varchar(800)	Yes	Pre bfg code	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	FCC_BFG_PRD_CLOSE_STATUS
Comment :	Stores the detail about BFG Period Close status

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
BFG_CODE	fin_varchar	varchar(800)	No	bfg code	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
FIN_PERIOD	fin_varchar	varchar(800)	No	Financial period	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
STATUS	fin_varchar	varchar(800)	Yes	Status	No
CLOSED_BY	fin_varchar	varchar(800)	Yes	Closed by	No
CLOSED_DATE	fin_datetime	datetime(8)	Yes	Closed date	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No
RUN_NO	fin_varchar	varchar(800)	Yes	Run number	No

Table Name :	FCC_BFG_YR_CLOSE_STATUS
Comment :	Stores the Detail about BFG year close status

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
BFG_CODE	fin_varchar	varchar(800)	No	bfg code	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
STATUS	fin_varchar	varchar(800)	Yes	Status	No
CLOSED_BY	fin_varchar	varchar(800)	Yes	Closed by	No
CLOSED_DATE	fin_datetime	datetime(8)	Yes	Closed date	No
RUN_NO	fin_varchar	varchar(800)	Yes	Run number	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	fcc_cls_fb_run_trn
Comment :	Stores the Information about cls Finance Book run Transaction

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	No	Timestamp	No
guid	fin_guid	varchar(40)	No	Guid	No
company_code	fin_companycode	varchar(10)	No	Company code	No
run_no	fin_documentno	varchar(40)	No	Run number	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
prd_yr_option	fin_status	varchar(25)	No	Period year option	No
status	fin_status	varchar(25)	No	Status	No
language_id	fin_language	varchar(25)	No	Language id	No
run_status	fin_status	varchar(25)	No	Run status	No
service	fin_desc28	varchar(28)	No	Service	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 :	FCC_ERROR_DTL
Comment :	Stores the detail about Error

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ERROR_ID	fin_varchar	varchar(800)	No	Error id	Yes
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
FIN_PERIOD	fin_varchar	varchar(800)	No	Financial period	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
ERROR_DESC	fin_varchar	varchar(800)	Yes	Error description	No
RUN_NO	fin_varchar	varchar(800)	Yes	Run number	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	fcc_mac_fbp_post
Comment :	Stores the detail about mac Finance book period Post

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_companyname	varchar(60)	Yes	Component name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
document_no	fin_documentno	varchar(40)	Yes	Document number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_macdate	datetime(8)	Yes	Transaction date	No
posting_date	fin_macdate	datetime(8)	Yes	Posting date	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
par_base_amount	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	Sub analysis code	No
cost_center	fin_maccost	varchar(32)	Yes	Cost center	No
mac_post_flag	fin_flag	varchar(25)	Yes	mac post flag	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	FCC_PRD_CLOSE_HISTORY
Comment :	Stores the History about Period Close

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
FIN_PERIOD	fin_varchar	varchar(800)	No	Financial period	Yes
BFG_CODE	fin_varchar	varchar(800)	No	bfg code	Yes
SERIAL_NO	fin_varchar	varchar(800)	No	Serial number	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
RUN_NO	fin_varchar	varchar(800)	Yes	Run number	No
STATUS	fin_varchar	varchar(800)	Yes	Status	No
CLOSED_BY	fin_varchar	varchar(800)	Yes	Closed by	No
CLOSED_DATE	fin_datetime	datetime(8)	Yes	Closed date	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	FCC_PRD_CLOSE_STATUS
Comment :	Stores the Information about Period Close Status

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
FIN_PERIOD	fin_varchar	varchar(800)	No	Financial period	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
STATUS	fin_varchar	varchar(800)	Yes	Status	No
CLOSED_BY	fin_varchar	varchar(800)	Yes	Closed by	No
CLOSED_DATE	fin_datetime	datetime(8)	Yes	Closed date	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No
RUN_NO	fin_varchar	varchar(800)	Yes	Run number	No
SEQUENCENO	fin_decimal	decimal(17)	Yes	Sequence number	No

Table Name :	FCC_YR_CLOSE_HISTORY
Comment :	Stores the History about Year Close

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
BFG_CODE	fin_varchar	varchar(800)	No	bfg code	Yes
SERIAL_NO	fin_varchar	varchar(800)	No	Serial number	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
STATUS	fin_varchar	varchar(800)	Yes	Status	No
CLOSED_BY	fin_varchar	varchar(800)	Yes	Closed by	No
CLOSED_DATE	fin_datetime	datetime(8)	Yes	Cloase date	No
RUN_NO	fin_varchar	varchar(800)	Yes	Run number	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	FCC_YR_CLOSE_STATUS
Comment :	Stores the Information about Year Close Status

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPANY_CODE	fin_varchar	varchar(800)	No	Company code	Yes
OU_ID	fin_decimal	decimal(17)	No	Organization unit id	Yes
FB_ID	fin_varchar	varchar(800)	No	Finance book id	Yes
FIN_YEAR	fin_varchar	varchar(800)	No	Financial year	Yes
TIMESTAMP	fin_decimal	decimal(17)	Yes	Timestamp	No
STATUS	fin_varchar	varchar(800)	Yes	Status	No
CLOSED_BY	fin_varchar	varchar(800)	Yes	Closed by	No
CLOSED_DATE	fin_datetime	datetime(8)	Yes	Closed date	No
CREATEDBY	fin_varchar	varchar(800)	Yes	Created by	No
CREATEDDATE	fin_datetime	datetime(8)	Yes	Created date	No
MODIFIEDBY	fin_varchar	varchar(800)	Yes	Modified by	No
MODIFIEDDATE	fin_datetime	datetime(8)	Yes	Modified date	No