Organization Setup

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	Cm_StnDtl_Station_Dtl		StnDtl_Created_OUInstance	int	Created Organization Unit Instance	No	No
			StnDtl_Station_No	varchar(32)	Station Number
			StnDtl_Station_Desc	varchar(150)	Station Description
			StnDtl_Station_Desc_up		Station Description Up
			StnDtl_Station_Status	varchar(5)	Station Status
			StnDtl_Station_Code_Type	varchar(25)	Station Code Type
			StnDtl_Station_TimeZone_No	varchar(30)	Station Time Zone Number
			StnDtl_Station_OUInstance	int	Station Organization Unit Instance
			StnDtl_IATA_Station_Ref	varchar(32)	Iata Station Reference
			StnDtl_ICAO_Station_Ref		Icao Station Reference
			StnDtl_Others_Station_Ref		Other Station Reference
			StnDtl_City		City
			StnDtl_City_up		City Up
			StnDtl_Country	varchar(40)	Country
			StnDtl_Country_up		Country Up
			StnDtl_Longest_Runway	int	Longest Run Way
			StnDtl_Runway_Width		Longest Run Way Width
			StnDtl_Latitude	varchar(20)	Latitude
			StnDtl_Longitude		Longitude
			StnDtl_Timestamp	int	Time Stamp
			StnDtl_Overload_Capability	varchar(5)	Over Load Capability
	dnm_manno_manualnumbering		manno_ou	sql_variant	Organization Unit	Yes
			manno_function		Function
			manno_transaction		Transaction
			manno_trantype		Transaction Type
			manno_manual_alwd		Manual Allowed	No
			manno_default		Default Value
			manno_created_by		Created By
			manno_created_date		Created Date
			manno_modified_by		Modified By
			manno_modified_date		Modified Date
			manno_timestamp_value	int	Time Stamp Value
	dnm_mapnt_mapnotypeno		mapnt_notypeno	sql_variant	Numbering Type Number	Yes
			mapnt_ou		Organization Unit
			mapnt_function		Function
			mapnt_transaction		Transaction
			mapnt_trantype		Transaction Type
			numcls_lo		Numbering Class Logistics Organization	No
			mapnt_map		Type Mapped
			mapnt_default		Default
	dnm_meta_funtran_metadata		meta_langid	int	Language Id	Yes
			meta_function	sql_variant	Function
			meta_transaction		Transactions
			meta_trantype		Transactions Type
			meta_autofired		Autofired	No
			meta_manual_allwd		Manual Allowed
			meta_usage_code		Usage Code
			meta_component_name		Component Name
			meta_trantype_code		Transaction Type Code
	dnm_numcls_numclshdr		numcls_notypeno		Numbering Type Number	Yes
			numcls_lo		Logistics Organization	No
			numcls_ou	int	Organization Unit
			numcls_notypedesc	sql_variant	Numbering Type Description
			numcls_lotserno	int	Lot Serial Number
			numcls_autono_length		Autonumber Length
			numcls_status	sql_variant	Status
			numcls_created_by		Created By
			numcls_created_date		Created Date
			numcls_reason_code		Reason Code
			numcls_modified_by		Modified By
			numcls_modified_date		Modified Date
			numcls_timestamp_value	int	Time Stamp
	emod_addr_mst	Stores the address details of the companies in the system.	address_id	sql_variant	Address Id	Yes
			timestamp	int	Time Stamp	No
			address1	sql_variant	Address 1
			address2		Address 2
			address3		Address 3
			address_desc		Address Description
			city		City
			state		State
			country		Country
			phone_no		Phone Number
			fax		Fax
			telex		Telex
			url		Universal Resource Locator
			mail_stop		Mail Stop
			zip_code		Zip Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bank_ref_mst	Stores the details of the Banks defined in the system along with their reference numbers.	bank_ref_no	sql_variant	Bank Reference Number	Yes
			bank_status		Bank Status.Values 0-Inactive,1-Active
			timestamp	int	Time Stamp	No
			bank_ptt_flag	sql_variant	Bank PTT Flag
			bank_type		Bank Type
			bank_name		Bank Name
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			clearing_no		Clearing Number
			swift_no		Swift Number
			phone_no		Phone Number
			telex		Telex
			mail_stop		Mail Stop
			zip_code		Zip Code
			fax		Fax
			email_id		Email Id
			creation_ou	int	Creation Organization Unit
			modification_ou		Modification Organization Unit
			effective_from	datetime	Effective From
			effective_to		Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bank_ref_upload_tmp		bank_ref_no	sql_variant	Bank Reference Number	Yes
			timestamp	int	Time Stamp	No
			bank_type	sql_variant	Bank Type
			bank_name		Bank Name
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			clearing_no		Clearing Number
			swift_no		Swift Number
			phone_no		Phone Number
			telex		Telex
			mail_stop		Mail Stop
			zip_code		Zip Code
			fax		Fax
			email_id		Email Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bfg_component_met	Stores the mapping information of various bfgs and the components under each bfg in the system.	bfg_code	sql_variant	Business Function Group Code	Yes
			component_id		Component Id
			timestamp	int	Time Stamp	No
			map_status	sql_variant	Map Status.Values 0-Inactive,1-Active
			map_by		Map By
			map_date	datetime	Map Date
			unmap_by	sql_variant	Unmap By
			unmap_date	datetime	Unmap Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bfg_met	Stores the information of all the Bfgs created in the system.	bfg_code	sql_variant	Business Function Group Code	Yes
			bfg_name		Business Function Group Name
			timestamp	int	Time Stamp	No
			bpc_code	sql_variant	Business Processing Chain Code
			language_id	int	Language Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bfg_ou_map	Stores the information about the Bfg and Organization unit mapping.	company_code	sql_variant	Company Code	Yes
			bfg_code		Business Function Group Code
			ou_id	int	Organization Unit Id
			serial_no		Serial Number
			timestamp		Time Stamp	No
			map_status	sql_variant	Map Status.Values M-Mapped,U-Unmapped
			effective_from	datetime	Effective From
			effective_to		Effective To
			mapby	sql_variant	Map By
			mapdate	datetime	Map Date
			unmappedby	sql_variant	Unmapped By
			unmappeddate	datetime	Unmapped Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bfg_preceedbfg_met	Stores the information of all the Bfgs in the system along with their preceeding Bfg informations.	bfg_code	sql_variant	Business Function Group Code	Yes
			prebfg_code		Prebusiness Function Group
			timestamp	int	Time Stamp	No
			language_id		Language Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bpc_met	Stores the information about the various Bpcs in the system	bpc_code	sql_variant	Business Processing Chain Code	Yes
			bpc_name		Business Processing Chain Name
			timestamp	int	Time Stamp	No
			language_id		Language Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bu_mst	Stores the information about all the Business Units existent in the system	company_code	sql_variant	Company Code	Yes
			bu_id		Business Unit Id
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			bu_name	sql_variant	Business Unit Name
			status		Status.Values 0-Inactive,1-Active
			address_id		Address Id
			effective_from	datetime	Effective From
			effective_to		Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_bu_ou_fb_map	Stores the information of BU-OU-FB mapping in the system.	fb_id	sql_variant	Finance Book Id	Yes
			ou_id	int	Organization Unit Id
			bu_id	sql_variant	Business Unit Id
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			map_by	sql_variant	Map By
			map_date	datetime	Map Date
			unmap_by	sql_variant	Unmap By
			unmap_date	datetime	Unmap Date
			effective_from		Effective From
			effective_to		Effective To
			map_status	sql_variant	Map Status.Values M-Mapped,U-Unmapped
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_company_currency_map	Stores the information about the company to currency mapping in the system	serial_no	int	Serial Number	Yes
			company_code	sql_variant	Company Code
			currency_code		Currency Code
			timestamp	int	Time Stamp	No
			map_status	sql_variant	Map Status.Values M-Mapped,U-Unmapped
			effective_from	datetime	Effective From
			effective_to		Effective To
			map_by	sql_variant	Map By
			map_date	datetime	Map Date
			unmap_by	sql_variant	Unmap By
			unmap_date	datetime	Unmap Date
			currency_flag	sql_variant	Currency Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_company_mst	Stores the information about the companies that are created in the system.	company_code	sql_variant	Company Code	Yes
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			company_name	sql_variant	Company Name
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			country		Country
			zip_code		Zip Code
			phone_no		Phone Number
			state		State
			company_url		Company Universal Resource Locator
			mail_stop		Mail Stop
			telex		Telex
			par_comp_code		Parent Company Code
			fax_no		Fax Number
			base_currency		Base Currency
			parcur_cr_date	datetime	Parent Currency Credit Date
			parcur_dl_date		Parallel Currency Date
			status	sql_variant	Status.Values 0-Inactive,1-Active
			effective_from	datetime	Effective From
			effective_to		Effective To
			para_base_flag	sql_variant	Parallel Base Flag
			reg_date	datetime	Registered Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_company_parent_child	Stores the information about the companies and their child companies	par_comp_code	sql_variant	Parent Company Code	Yes
			company_code		Company Code
			timestamp	int	Time Stamp	No
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	EMOD_COMPONENT_LEVEL	Stores the information about the various components and their levels.	COMPONENTNAME	varchar(80)	Component Name
			MANDATORY_FLAG	varchar(5)	Mandatory Flag
			INST_LEVEL	varchar(10)	Instrument Level
	emod_country_mst	Stores the information about the various Countries in the system.	country_code	sql_variant	Country Code	Yes
			iso_curr_code		ISO Currency Code
			timestamp	int	Time Stamp	No
			country_descr	sql_variant	Country Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_currdenom_mst	Stores the information about the various currencies and their denominations in the system	iso_curr_code	sql_variant	ISO Currency Code	Yes
			curr_denom	bigint	Currency Denomination
			timestamp	int	Time Stamp	No
			denom_desc	sql_variant	Denomination Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_currency_mst	Stores the information about all the currencies in the system	iso_curr_code	sql_variant	ISO Currency Code	Yes
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			num_curr_code	sql_variant	Numbering Currency Code
			curr_symbol		Currency Symbol
			curr_desc		Currency Description
			curr_sub_units	int	Currency Subunits
			curr_sub_unit_desc	sql_variant	Currency Subunits Description
			curr_units	int	Currency Units
			currency_status	sql_variant	Currency Status.Values 0-Inactive,1-Active
			curr_symbol_flag		Currency Symbol Flag
			effective_from	datetime	Effective From
			effective_to		Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_fbfcc_tmp		timestamp	int	Time Stamp
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fb_type		Finance Book Type
			ou_id	int	Organization Unit Id
			guid	sql_variant	Guid
			status		Status
			effective_from	datetime	Effective From
			effective_to		Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_fcc_tmp		timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			bfg_code	sql_variant	Business Function Group
			effective_from	datetime	Effective From
			company_code	sql_variant	Company Code
			guid		Guid
			status		Status
			effective_to	datetime	Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_finbook_mst	Stores the information about all the Finance Books that are created in the system	fb_id	sql_variant	Finance Book Id	Yes
			company_code		Company Code
			serial_no	int	Serial Number
			fb_type	sql_variant	Finance Book Type
			timestamp	int	Time Stamp	No
			fb_desc	sql_variant	Finance Book Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			status	sql_variant	Status.Values 0-Inactive,1-Active
			resou_id	int	Resource Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_identification_dtl	Stores the information about all the companies and their Ids in the system.	company_code	sql_variant	Company Code	Yes
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			id_type	sql_variant	Id Type
			id_no		Id Number
			timestamp	int	Time Stamp	No
			id_reference	sql_variant	Id Reference
			default_flag		Default Flag
			created_by		Created By
			created_date	datetime	Created Date
			moified_by	sql_variant	Modified By
			modified_date	datetime	Modified Date
			status	sql_variant	Status.Values 0-Inactive,1-Active
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_lo_bu_map	Stores the information about the mapping that exists between Lo and Bu	lo_id	sql_variant	Logistics Organization Id	Yes
			bu_id		Business Unit Id
			company_code		Company Code
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			lo_name	sql_variant	Login Name
			map_status		Map Status.Values M-Mapped,U-Unmapped
			effective_from	datetime	Effective From
			effective_to		Effective To
			map_by	sql_variant	Map By
			map_date	datetime	Map Date
			unmap_by	sql_variant	Unmap By
			unmap_date	datetime	Unmap Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_notes_his	Stores the History information about all the notes that get updated in the system	ou_id	int	Organization Unit Id	Yes
			entity	sql_variant	Entity
			serial_no	int	Serial Number
			entity_id	sql_variant	Entity Id
			action_time	datetime	Action Time
			timestamp	int	Time Stamp	No
			notes_desc	sql_variant	Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_notes_mst	Stores the information about all the notes that get updated in the system	ou_id	int	Organization Unit Id	Yes
			entity	sql_variant	Entity
			serial_no	int	Serial Number
			entity_id	sql_variant	Entity Id
			timestamp	int	Time Stamp	No
			notes_desc	sql_variant	Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_notes_tmp		timestamp	int	Time Stamp
			notes_id	sql_variant	Notes Id
			notes_desc		Notes Description
			notes		Notes
			guid		Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_ou_bu_map	Stores the information about the mapping that exists between Ou and Bu	ou_id	int	Organization Unit Id	Yes
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			map_status	sql_variant	Map Status.Values M-Mapped,U-Unmapped
			effective_from	datetime	Effective From
			effective_to		Effective To
			map_by	sql_variant	Map By
			map_date	datetime	Map Date
			unmap_by	sql_variant	Unmap By
			unmap_date	datetime	Unmap Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_ou_mst	Stores the information about all the Organization units that are created in the system.	ou_id	int	Organization Unit Id	Yes
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			address_id		Address Id
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			op_code	sql_variant	Operation Code
			stn_code		Station Code
			logo_name		Logo Name
			default_flag		Default Flag
			map_status		Map Status.Values M-Mapped,U-Unmapped
			effective_from	datetime	Effective From
			effective_to		Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_post_trantype_sys	Stores the information about all the transaction types that are used in the system	bpc_id	sql_variant	Business Processing Chain Id	Yes
			component_id		Component Id
			tran_type		Transaction Type
			timestamp	int	Time Stamp	No
			tran_desc	sql_variant	Transaction Description
			language_id	int	Language Id
			fb_post_flag	sql_variant	Finance Book Posting Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			short_desc	sql_variant	Short Description
	emod_prec_round_sys	Stores the information about all the precision types that are used in the system	company_code		Company Code	Yes
			bfg_code		Business Function Group Code
			type		Type
			currency_code		Currency Code
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			method	sql_variant	Method
			significance	bigint	Significance
			effective_from	datetime	Effective From
			effective_to		Effective To
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_reg_office_mst	Stores the information about all the registered offices of the companies.	company_code	sql_variant	Company Code	Yes
			timestamp	int	Time Stamp	No
			address1	sql_variant	Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip_code		Zip Code
			phone_no		Phone Number
			url		Universal Resource Locator
			mail_stop		Mail Stop
			telex		Telex
			fax_no		Fax Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_rpt_oubufbmap_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			fb_id		Finance Book Id
			fb_type		Finance Book Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	emod_segment_mst	Stores the information about all the segments of the companies.	seg_id	sql_variant	Segment Id	Yes
			company_code		Company Code
			fb_id		Finance Book Id
			seg_type		Sequence Type
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			seg_name	sql_variant	Sequence Name
			map_status		Map Status.Values M-Mapped,U-Unmapped
			effective_from	datetime	Effective From
			effective_to		Effective To
			map_by	sql_variant	Map By
			map_date	datetime	Map Date
			unmap_by	sql_variant	Unmap By
			unmap_date	datetime	Unmap Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_error_message_sys	Stores the information about all the Error messages that are used in the system	error_code	int	Error Code	Yes
			component_id	sql_variant	Component Id
			timestamp	int	Time Stamp	No
			designerr_code		Designer Code
			error_desc	sql_variant	Error Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_integration_map_met	Stores the information about all the Integration services and their corresponding calling services that are used in the system	component_id	sql_variant	Component Id
			service_name		Service Name
			isservice_name		Is Service Name
			timestamp	int	Time Stamp
			mapped	sql_variant	Mapped
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_is_information_dft		timestamp	int	Time Stamp
			published_is_name	sql_variant	Published Is Name
			calling_service		Calling Service
			target_column		Target Column
			default_value		Default Value
			createdby	varchar(40)	Created By
			createddate	datetime	Created Date
			modifiedby	varchar(40)	Modified By
			modifieddate	datetime	Modified Date
	fin_is_information_dtl	Stores the information about all the Finance posting services and the views that are to be used for fetching data while doing finance postings.	parent_key	sql_variant	Parent Key	Yes
			current_key		Current Key
			timestamp	int	Time Stamp	No
			col_name_in_vw	sql_variant	Column Name in View
			target_column		Target Column
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_is_information_hdr		current_key	sql_variant	Current Key	Yes
			timestamp	int	Time Stamp	No
			published_is_name	sql_variant	Published is Name
			calling_component		Calling Component
			calling_service		Calling Service
			view_name		View Name
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_processparam_his	Stores History Information about the various codes that are used in the system along with their	company_code	sql_variant	Company Code	Yes
			ou_id	int	Organization Unit Id
			component_id	sql_variant	Component Id
			parameter_type		Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			action_time	datetime	Action Time
			timestamp	int	Time Stamp	No
			parameter_text	sql_variant	Parameter Text
			extension_flag		Extension Flag
			language_id	int	Language Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_processparam_sys	Stores the information about the various codes that are used in the system along with their detailed descriptions.	company_code	sql_variant	Company Code	Yes
			ou_id	int	Organization Unit Id
			component_id	sql_variant	Component Id
			parameter_type		Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			timestamp	int	Time Stamp	No
			parameter_text	sql_variant	Parameter Text
			extension_flag		Extension Flag
			language_id	int	Language Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	fin_quick_code_met		component_id	sql_variant	Component Id
			parameter_type		Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			parameter_text		Parameter Text
			timestamp	int	Time Stamp
			language_id		Language Id
			extension_flag	sql_variant	Extension Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			sequence_no	int	Sequence Number
	SP_SUPBNK_BANK_DTL		SUPBKD_CREATED_OUINSTANCE		Created Organization Unit Instance	Yes
			SUPBKD_SUPPLIER_ID	sql_variant	Supplier Id
			SUPBKD_LINE_NO	int	Line Number
			SUPBKD_PAY_MODE	sql_variant	Pay Mode	No
			SUPBKD_COMP_BANK_ID		Company Bank Id
			SUPBKD_COMP_PTT_ID		Company PTT Id
			SUPBKD_SUPP_BANK		Supplier Bank
			SUPBKD_SUPP_BANK_NAME		Supplier Bank Name
			SUPBKD_SUPP_BANK_TYPE		Supplier Bank Type
			SUPBKD_BANK_CLEAR_NO		Bank Clearance Number
			SUPBKD_BANK_ACC		Bank Account
			SUPBKD_SWIFT_ID		Swift Id
			SUPBKD_PAY_TO_BANK_ACC		Pay To Bank Account
			SUPBKD_SUPP_PTT_ID		Supplier PTT Id
			SUPBKD_SUPP_PTT_NAME		Supplier PTT Name
			SUPBKD_SUPP_PTT_TYPE		Supplier PTT Type
			SUPBKD_PTT_CLEAR_NO		PTT Clearance Number
			SUPBKD_SUPP_PTT_ACC		Supplier PTT Account
			SUPBKD_LSV_CONTRACT_ID		LSV Contract Id
			SUPBKD_CONTRACT_REF		Contract Reference
			SUPBKD_LSV_FROM_DATE	datetime	LSV From Date
			SUPBKD_LSV_TO_DATE		LSV To Date
			SUPBKD_CONTESTATION_ALLOWED	sql_variant	Contestation Allowed
			SUPBKD_ESR_TYPE		ESR Type
			SUPBKD_ESR_PARTICIPATION_NO		ESR Participation Number
			SUPBKD_SUPP_PARTICIPATION_NO		Supplier Participation Number
			SUPBKD_CONTACT_PERSON		Contact Person
			SUPBKD_ADDRESS1		Address 1
			SUPBKD_ADDRESS2		Address 2
			SUPBKD_ADDRESS3		Address 3
			SUPBKD_CITY		City
			SUPBKD_STATE		State
			SUPBKD_COUNTRY		Country
			SUPBKD_ZIP		Zip
			SUPBKD_FAX		Fax
			SUPBKD_PHONE		Phone
			SUPBKD_EMAIL		Email