Data Dictionary -- Organization Setup

Srl. No.	Table Name	Comment
1	emod_addr_mst	Stores the address details of the companies in the system.
2	emod_bank_ref_mst	Stores the details of the Banks defined in the system along with their reference numbers.
3	emod_bfg_component_met	Stores the mapping information of various bfgs and the components under each bfg in the system.
4	emod_bfg_met	Stores the information of all the Bfgs created in the system.
5	emod_bfg_ou_map	tores the information about the Bfg and Organization unit mapping.
6	emod_bfg_preceedbfg_met	Stores the information of all the Bfgs in the system along with their preceeding Bfg informations.
7	emod_bpc_met	Stores the information about the various Bpcs in the system
8	emod_bu_mst	Stores the Information of Business Unit in the System
9	emod_bu_ou_fb_map	Stores the Mapping Information of Business Unit,Organization Unit and Finance Book
10	emod_company_currency_map	Stores the Mapping Information of Company and Currency
11	emod_company_mst	Stores the Information about Company
12	emod_company_parent_child	Stores the Company Parent child Details
13	EMOD_COMPONENT_LEVEL	Stores the Component Level Information
14	emod_country_mst	Stores the Information of Country
15	emod_currdenom_mst	Stores the Information about Currdenom
16	emod_currency_mst	Stores the Information about Currency
17	emod_finbook_mst	Stores the Information about Finance Book
18	emod_identification_dtl	Stores details of Identification
19	emod_lo_bu_map	Stores the mapping Information about Lot Number and Business Unit
20	emod_notes_his	Stores the History of Notes
21	emod_notes_mst	Stores the Information of Notes in the system
22	emod_ou_bu_map	Stores the Mapping Information of Organization Unit and Business Unit
23	emod_ou_mst	Stores the Information about Organization Unit
24	emod_post_trantype_sys	Stores the Information of Post Trantype
25	emod_prec_round_sys	Stores the Information about prec round
26	emod_reg_office_mst	Stores the Information about reg office
27	emod_segment_mst	Stores the Information about Segment

Table Name :	emod_addr_mst
Comment :	Stores the address details of the companies in the system.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
address_id	fin_txt255	varchar(255)	No	Address id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
address1	fin_txt255	varchar(255)	Yes	Address 1	No
address2	fin_txt255	varchar(255)	Yes	Address 2	No
address3	fin_txt255	varchar(255)	Yes	Address 3	No
address_desc	fin_description	varchar(100)	Yes	Address description	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
phone_no	fin_phone	varchar(18)	Yes	Phone number	No
fax	fin_fax	varchar(40)	Yes	Fax	No
telex	fin_communicationid	varchar(30)	Yes	Telex	No
url	fin_url	varchar(50)	Yes	URL	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail stop	No
zip_code	fin_zip	varchar(20)	Yes	Zip code	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 :	emod_bank_ref_mst
Comment :	Stores the details of the Banks defined in the system along with their reference numbers.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bank_ref_no	fin_banknumber	varchar(20)	No	Bank reference number	Yes
bank_status	fin_partstatus	varchar(40)	No	Bank status	Yes
timestamp	fin_int	int(4)	No	Timestamp	No
bank_ptt_flag	fin_eflag	varchar(1)	No	Bank ptt flag	No
bank_type	fin_type	varchar(25)	No	Bank type	No
bank_name	fin_bankname	varchar(40)	No	Bank name	No
address1	fin_txt255	varchar(255)	No	Address 1	No
address2	fin_txt255	varchar(255)	No	Address 2	No
address3	fin_txt255	varchar(255)	No	Address 3	No
city	fin_city	varchar(40)	No	City	No
state	fin_state	varchar(40)	No	State	No
country	fin_country	varchar(40)	No	Country	No
clearing_no	fin_banknumber	varchar(20)	No	Clearing number	No
swift_no	fin_banknumber	varchar(20)	No	Swift number	No
phone_no	fin_communicationid	varchar(30)	No	Phone number	No
telex	fin_communicationid	varchar(30)	No	Texlex	No
mail_stop	fin_mailstop	varchar(20)	No	Mail stop	No
zip_code	fin_zip	varchar(20)	No	Zip code	No
fax	fin_fax	varchar(40)	No	Fax	No
email_id	fin_email	varchar(60)	No	Email id	No
creation_ou	fin_ouinstid	int(4)	No	Creation OU	No
modification_ou	fin_ouinstid	int(4)	No	Modification OU	No
effective_from	fin_datetime	datetime(8)	No	Effective from	No
effective_to	fin_datetime	datetime(8)	No	Effective to	No
createdby	fin_ctxt_user	varchar(30)	No	Created by	No
createddate	fin_datetime	datetime(8)	No	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	No	Modified by	No
modifieddate	fin_datetime	datetime(8)	No	Modified date	No

Table Name :	emod_bfg_component_met
Comment :	Stores the mapping information of various bfgs and the components under each bfg in the system.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
component_id	fin_component	varchar(16)	No	Component code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
map_status	fin_status	varchar(25)	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
unmap_by	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmap_date	fin_datetime	datetime(8)	Yes	Unmapped 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 :	emod_bfg_met
Comment :	Stores the information of all the Bfgs created in the system.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
bfg_name	fin_businessfunctiongroup	varchar(40)	No	bfg name	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
bpc_code	fin_bfgid	varchar(20)	Yes	bpc code	No
language_id	fin_languageid	int(4)	Yes	Language 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

Table Name :	emod_bfg_ou_map
Comment :	tores the information about the Bfg and Organization unit mapping.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_desc40	varchar(40)	No	Company code	Yes
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
map_status	fin_status	varchar(25)	Yes	Mapped status	No
effective_from	fin_datetime	datetime(8)	Yes	Effecive from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
mapby	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
mapdate	fin_datetime	datetime(8)	Yes	Mapped date	No
unmappedby	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmappeddate	fin_datetime	datetime(8)	Yes	Unmapped 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 :	emod_bfg_preceedbfg_met
Comment :	Stores the information of all the Bfgs in the system along with their preceeding Bfg informations.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
prebfg_code	fin_bfgid	varchar(20)	No	Pre bfg code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
language_id	fin_languageid	int(4)	Yes	Language 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

Table Name :	emod_bpc_met
Comment :	Stores the information about the various Bpcs in the system

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bpc_code	fin_bfgid	varchar(20)	No	bpc code	Yes
bpc_name	fin_businessfunctiongroup	varchar(40)	No	bpd name	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
language_id	fin_languageid	int(4)	Yes	Language 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

Table Name :	emod_bu_mst
Comment :	Stores the Information of Business Unit in the System

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bu_id	fin_buid	varchar(20)	No	Business unit id	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
bu_name	fin_desc40	varchar(40)	Yes	Business name	No
status	fin_status	varchar(25)	Yes	Status	No
address_id	fin_txt255	varchar(255)	Yes	Address id	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	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 :	emod_bu_ou_fb_map
Comment :	Stores the Mapping Information of Business Unit,Organization Unit and Finance Book

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
bu_id	fin_buid	varchar(20)	No	Business unit id	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_datetime	datetime(8)	Yes	Mapped date	No
unmap_by	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmap_date	fin_datetime	datetime(8)	Yes	Unmapped date	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective date	No
map_status	fin_status	varchar(25)	Yes	Mapped 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 :	emod_company_currency_map
Comment :	Stores the Mapping Information of Company and Currency

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
serial_no	fin_int	int(4)	No	Serial number	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
map_status	fin_status	varchar(25)	Yes	Mapped status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_datetime	datetime(8)	Yes	Mapped date	No
unmap_by	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmap_date	fin_datetime	datetime(8)	Yes	Unmapped date	No
currency_flag	fin_flag	varchar(25)	Yes	Currency 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 :	emod_company_mst
Comment :	Stores the Information about Company

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
address1	fin_txt255	varchar(255)	Yes	Address 1	No
address2	fin_txt255	varchar(255)	Yes	Address 2	No
address3	fin_txt255	varchar(255)	Yes	Address 3	No
city	fin_city	varchar(40)	Yes	City	No
country	fin_country	varchar(40)	Yes	Country	No
zip_code	fin_zip	varchar(20)	Yes	Zip code	No
phone_no	fin_zip	varchar(20)	Yes	Phone number	No
state	fin_state	varchar(40)	Yes	State	No
company_url	fin_desc255	varchar(255)	Yes	Company URL	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail stop	No
telex	fin_communicationid	varchar(30)	Yes	Telex	No
par_comp_code	fin_companycode	varchar(10)	Yes	Parallel comp code	No
fax_no	fin_fax	varchar(40)	Yes	Fax number	No
base_currency	fin_currencycode	varchar(5)	Yes	Base currency	No
parcur_cr_date	fin_datetime	datetime(8)	Yes	Parallel currency created date	No
parcur_dl_date	fin_datetime	datetime(8)	Yes	Parallel currency deleted date	No
status	fin_status	varchar(25)	Yes	Status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
para_base_flag	fin_eflag	varchar(1)	Yes	Parallel base flag	No
reg_date	fin_datetime	datetime(8)	Yes	Register 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 :	emod_company_parent_child
Comment :	Stores the Company Parent child Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
par_comp_code	fin_companycode	varchar(10)	No	Parallel comp code	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	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 :	EMOD_COMPONENT_LEVEL
Comment :	Stores the Component Level Information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	fin_varchar	varchar(800)	Yes	Component name	No
MANDATORY_FLAG	fin_varchar	varchar(800)	Yes	Mandatory flag	No
INST_LEVEL	fin_varchar	varchar(800)	Yes	INST_LEVEL	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	emod_country_mst
Comment :	Stores the Information of Country

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
country_code	fin_countrycode	varchar(5)	No	Country code	Yes
iso_curr_code	fin_currencycode	varchar(5)	No	iso current code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
country_descr	fin_description	varchar(100)	Yes	Country 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 :	emod_currdenom_mst
Comment :	Stores the Information about Currdenom

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
iso_curr_code	fin_currencycode	varchar(5)	No	iso current code	Yes
curr_denom	fin_currencydenomination	numeric(13)	No	Current denom	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
denom_desc	fin_desc40	varchar(40)	Yes	Denomination 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 :	emod_currency_mst
Comment :	Stores the Information about Currency

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
iso_curr_code	fin_currencycode	varchar(5)	No	iso current code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
num_curr_code	fin_currencycode	varchar(5)	Yes	Numbering current code	No
curr_symbol	fin_currencycode	varchar(5)	Yes	Currency symbol	No
curr_desc	fin_desc120	varchar(120)	Yes	Currency description	No
curr_sub_units	fin_units	int(4)	Yes	Currency sub units	No
curr_sub_unit_desc	fin_description	varchar(100)	Yes	Currency sub unit description	No
curr_units	fin_units	int(4)	Yes	Currency units	No
currency_status	fin_status	varchar(25)	Yes	Currency status	No
curr_symbol_flag	fin_flag	varchar(25)	Yes	Currency symbol flag	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_Datetime	datetime(8)	Yes	Effective to	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 :	emod_finbook_mst
Comment :	Stores the Information about Finance Book

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
fb_type	fin_fbtype	varchar(10)	No	Finance book type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
fb_desc	fin_desc255	varchar(255)	Yes	Finance book description	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
status	fin_status	varchar(25)	Yes	Status	No
resou_id	fin_ouinstid	int(4)	Yes	Resourse 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

Table Name :	emod_identification_dtl
Comment :	Stores details of Identification

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	No
bu_id	fin_buid	varchar(20)	No	Business unit id	No
ou_id	fin_ouinstid	int(4)	No	Organization unit id	No
id_type	fin_option	varchar(20)	No	Id type	No
id_no	fin_desc40	varchar(40)	No	Id number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
id_reference	fin_desc28	varchar(28)	Yes	Id reference	No
default_flag	fin_flag	varchar(25)	Yes	Default flag	No
created_by	fin_ctxt_user	varchar(30)	Yes	Created by	No
created_date	fin_datetime	datetime(8)	Yes	Created date	No
moified_by	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modified_date	fin_datetime	datetime(8)	Yes	Modified date	No
status	fin_option	varchar(20)	Yes	Status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Createdby	No
createddate	fin_datetime	datetime(8)	Yes	Createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modifiedby	No
modifieddate	fin_datetime	datetime(8)	Yes	Modifieddate	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	emod_lo_bu_map
Comment :	Stores the mapping Information about Lot Number and Business Unit

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
lo_id	fin_buid	varchar(20)	No	lo_id	Yes
bu_id	fin_buid	varchar(20)	No	Business unit id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
lo_name	fin_desc40	varchar(40)	Yes	lo_name	No
map_status	fin_status	varchar(25)	Yes	lo name	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_datetime	datetime(8)	Yes	Mapped date	No
unmap_by	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmap_date	fin_datetime	datetime(8)	Yes	Unmapped 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 :	emod_notes_his
Comment :	Stores the History of Notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
entity	fin_desc28	varchar(28)	No	Entity	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
entity_id	fin_buid	varchar(20)	No	Entity id	Yes
action_time	fin_datetime	datetime(8)	No	Action time	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
notes_desc	fin_notes	varchar(2000)	Yes	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 :	emod_notes_mst
Comment :	Stores the Information of Notes in the system

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
entity	fin_desc28	varchar(28)	No	Entity	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
entity_id	fin_buid	varchar(20)	No	Entity id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
notes_desc	fin_notes	varchar(2000)	Yes	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 :	emod_ou_bu_map
Comment :	Stores the Mapping Information of Organization Unit and Business Unit

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
bu_id	fin_buid	varchar(20)	No	Business unit id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
map_status	fin_status	varchar(25)	Yes	Mapped status	No
effective_from	fin_Datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_Datetime	datetime(8)	Yes	Effective to	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_Datetime	datetime(8)	Yes	Mapped date	No
unmap_by	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmap_date	fin_Datetime	datetime(8)	Yes	Unmapped 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 :	emod_ou_mst
Comment :	Stores the Information about Organization Unit

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
bu_id	fin_buid	varchar(20)	No	Business unit id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
address_id	fin_txt255	varchar(255)	No	Address id	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
op_code	fin_flag	varchar(25)	Yes	Operation code	No
stn_code	fin_txt150	varchar(150)	Yes	Station code	No
logo_name	fin_name	varchar(60)	Yes	Logo name	No
default_flag	fin_flag	varchar(25)	Yes	Default flag	No
map_status	fin_status	varchar(25)	Yes	Mapped status	No
effective_from	fin_Datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_Datetime	datetime(8)	Yes	Effective to	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 :	emod_post_trantype_sys
Comment :	Stores the Information of Post Trantype

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bpc_id	fin_componentshortid	varchar(20)	No	bpc id	Yes
component_id	fin_componentshortid	varchar(20)	No	Component id	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_desc	fin_desc120	varchar(120)	Yes	Transaction description	No
language_id	fin_languageid	int(4)	Yes	Language id	No
fb_post_flag	fin_flag	varchar(25)	Yes	Finance book post 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
short_desc	fin_cmntrantype	varchar(10)	Yes	Short description	No

Table Name :	emod_prec_round_sys
Comment :	Stores the Information about prec round

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
type	fin_option	varchar(20)	No	Type	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
method	fin_option	varchar(20)	Yes	Method	No
significance	fin_tolerancelimit	numeric(13)	Yes	Significance	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	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 :	emod_reg_office_mst
Comment :	Stores the Information about reg office

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
address1	fin_txt255	varchar(255)	Yes	Address 1	No
address2	fin_txt255	varchar(255)	Yes	Address 2	No
address3	fin_txt255	varchar(255)	Yes	Address 3	No
city	fin_city	varchar(40)	Yes	City	No
state	fin_state	varchar(40)	Yes	State	No
country	fin_country	varchar(40)	Yes	Country	No
zip_code	fin_zip	varchar(20)	Yes	Zip code	No
phone_no	fin_phone	varchar(18)	Yes	Phone number	No
url	fin_url	varchar(50)	Yes	URL	No
mail_stop	fin_mailstop	varchar(20)	Yes	Mail stop	No
telex	fin_communicationid	varchar(30)	Yes	Telex	No
fax_no	fin_fax	varchar(40)	Yes	Fax 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 :	emod_segment_mst
Comment :	Stores the Information about Segment

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
seg_id	fin_buid	varchar(20)	No	Segment id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
seg_type	fin_type	varchar(25)	No	Segment type	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
seg_name	fin_desc40	varchar(40)	Yes	Segment name	No
map_status	fin_status	varchar(25)	Yes	Mapped status	No
effective_from	fin_datetime	datetime(8)	Yes	Effective from	No
effective_to	fin_datetime	datetime(8)	Yes	Effective to	No
map_by	fin_ctxt_user	varchar(30)	Yes	Mapped by	No
map_date	fin_datetime	datetime(8)	Yes	Mapped date	No
unmap_by	fin_ctxt_user	varchar(30)	Yes	Unmapped by	No
unmap_date	fin_datetime	datetime(8)	Yes	Unmapped 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