| Data Dictionary - Organisation Setup | |||||
| Table Name es_esccur_com_currency_allw | |||||
| Table Comment Allowed Currencies for a company | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| esccur_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes |
| esccur_company_code | varchar(10) | NOT NULL | company code | Yes | Yes |
| esccur_currency_code | varchar(20) | NOT NULL | Currency Code | Yes | No |
| esccur_currency_ou | numeric(10) | NULL | Currency ou | No | No |
| ESCURR_SERIAL_NO | int | NOT NULL | ESCURR_SERIAL_NO | No | No |
| ESCURR_FROMDATE | datetime | NULL | ESCURR_FROMDATE | No | No |
| ESCURR_TODATE | datetime | NULL | ESCURR_TODATE | No | No |
| Table Name es_escfb_company_fb | |||||
| Table Comment Company wise Finance Books are defined here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| escfb_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes |
| escfb_company_code | varchar(10) | NOT NULL | company code | Yes | Yes |
| escfb_finance_book | varchar(20) | NOT NULL | Finance Book | Yes | No |
| escfb_fb_description | varchar(128) | NULL | Finance Book description | No | No |
| escfb_fb_type | varchar(5) | NULL | Finance Book Type | No | No |
| escfb_fb_status | varchar(5) | NULL | Finance Book Status | No | No |
| escfb_fb_status_eff_from | datetime | NULL | Status effective from date | No | No |
| escfb_fb_deployed_at | numeric(10) | NULL | Finance Book deployement details | No | No |
| escfb_created_by | varchar(30) | NULL | created by | No | No |
| escfb_createddate | datetime | NULL | created date | No | No |
| escfb_modified_by | varchar(30) | NULL | last modified by | No | No |
| escfb_modifieddate | datetime | NULL | last modified date | No | No |
| escfb_timestamp | numeric(10) | NULL | timestamp | No | No |
| ESCFB_SERIAL_NO | int | NOT NULL | ESCFB_SERIAL_NO | No | No |
| ESCFB_FB_status_eff_to | datetime | NULL | ESCFB_FB_status_eff_to | No | No |
| Table Name es_escomp_company_master | |||||
| Table Comment Company Master Table | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| escomp_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No |
| escomp_company_code | varchar(10) | NOT NULL | company code | Yes | No |
| escomp_company_name | varchar(40) | NULL | company name | No | No |
| escomp_status | varchar(5) | NULL | status of the company | No | No |
| escomp_base_currency | varchar(20) | NULL | base currency | No | No |
| escomp_parallel_base_currency | varchar(20) | NULL | escomp_parallel_base_currency | No | No |
| escomp_parent_company_code | varchar(10) | NULL | parent company code | No | No |
| escomp_operator_code | varchar(32) | NULL | operator code | No | No |
| escomp_address | varchar(255) | NULL | address | No | No |
| escomp_city | varchar(32) | NULL | city | No | No |
| escomp_state | varchar(32) | NULL | state | No | No |
| escomp_country | varchar(40) | NULL | country | No | No |
| escomp_zip_code | varchar(15) | NULL | zip code | No | No |
| escomp_url | varchar(70) | NULL | url | No | No |
| escomp_phone_no | varchar(70) | NULL | Phone number | No | No |
| escomp_fax_no | varchar(70) | NULL | fax number | No | No |
| escomp_telex | varchar(70) | NULL | telex | No | No |
| escomp_logo_file_name | varchar(50) | NULL | Logo File Name | No | No |
| escomp_mailstop | varchar(20) | NULL | mail stop | No | No |
| escomp_created_by | varchar(30) | NULL | created user | No | No |
| escomp_createddate | datetime | NULL | created date | No | No |
| escomp_modified_by | varchar(30) | NULL | last modified by | No | No |
| escomp_modifieddate | datetime | NULL | last modified date | No | No |
| escomp_timestamp | numeric(10) | NULL | timestamp | No | No |
| Table Name es_escou_company_ou_mapping | |||||
| Table Comment Company OU association details is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| escou_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes |
| escou_company_code | varchar(10) | NOT NULL | company code | Yes | Yes |
| escou_associated_ou | numeric(10) | NOT NULL | Associated Ou | Yes | No |
| escou_station_code | varchar(15) | NULL | Station Code | No | No |
| escou_city | varchar(32) | NULL | City | No | No |
| escou_state | varchar(32) | NULL | State | No | No |
| escou_country | varchar(40) | NULL | country | No | No |
| escou_zip_code | varchar(15) | NULL | zip code | No | No |
| escou_phone_no | varchar(70) | NULL | phone number | No | No |
| escou_telex | varchar(70) | NULL | telex | No | No |
| escou_fax_no | varchar(70) | NULL | Fax Number | No | No |
| escou_address | varchar(255) | NULL | Address Details | No | No |
| escou_created_by | varchar(30) | NULL | created user name | No | No |
| escou_created_date | datetime | NULL | created date | No | No |
| escou_modified_by | varchar(30) | NULL | last modified user | No | No |
| escou_modified_date | datetime | NULL | last modified date | No | No |
| escou_timestamp | numeric(10) | NULL | timestamp | No | No |
| Table Name es_escro_com_reg_office_det | |||||
| Table Comment Registered Office Details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| escro_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes |
| escro_company_code | varchar(10) | NOT NULL | company code | Yes | Yes |
| escro_address | varchar(255) | NULL | Registered Office Address | No | No |
| escro_city | varchar(32) | NULL | City | No | No |
| escro_phone | varchar(70) | NULL | Phone | No | No |
| escro_state | varchar(32) | NULL | State | No | No |
| escro_country | varchar(40) | NULL | Country | No | No |
| escro_telex | varchar(70) | NULL | Telex number | No | No |
| escro_fax_no | varchar(70) | NULL | Fax Number | No | No |
| escro_mailstop | varchar(20) | NULL | Mail Stop | No | No |
| escro_zip_code | varchar(15) | NULL | Zip Code | No | No |
| escro_url | varchar(70) | NULL | URL | No | No |
| escro_modified_by | varchar(30) | NULL | Last Modified By | No | No |
| escro_modifieddate | datetime | NULL | Last Modified Date | No | No |
| escro_timestamp | numeric(10) | NULL | Timestamp | No | No |
| Table Name es_escurr_currency_master | |||||
| Table Comment Currency Master Details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| escurr_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No |
| escurr_iso_currency_code | varchar(20) | NOT NULL | iso currency code | Yes | No |
| escurr_status | varchar(15) | NULL | status - Active or Inactive | No | No |
| escurr_num_iso_currency_code | varchar(20) | NULL | iso currency code in number | No | No |
| escurr_currency_symbol | varchar(20) | NULL | currency symbol | No | No |
| escurr_description | varchar(80) | NULL | description | No | No |
| escurr_currency_sub_unit | numeric(10) | NULL | currency sub unit | No | No |
| escurr_sub_unit_desc | varchar(40) | NULL | sub unit description | No | No |
| escurr_no_of_units | numeric(10) | NULL | number of units of the currency considered while defining the exchange rate | No | No |
| escurr_created_by | varchar(30) | NULL | created by | No | No |
| escurr_createddate | datetime | NULL | created date | No | No |
| escurr_modified_by | varchar(30) | NULL | last modified by | No | No |
| escurr_modifieddate | datetime | NULL | last modified date | No | No |
| escurr_timestamp | numeric(10) | NULL | timestamp | No | No |
| ESCURR_SERIAL_NO | int | NOT NULL | ESCURR_SERIAL_NO | No | No |
| ESCURR_FROMDATE | datetime | NULL | ESCURR_FROMDATE | No | No |
| ESCURR_TODATE | datetime | NULL | ESCURR_TODATE | No | No |
| Table Name es_esexrt_exchange_rate_det | |||||
| Table Comment Exchange Rate Details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| esexrt_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes |
| esexrt_from_currency | varchar(20) | NOT NULL | from currency | Yes | Yes |
| esexrt_to_currency | varchar(20) | NOT NULL | to currency | Yes | No |
| esexrt_exchange_rate | numeric(28,8) | NULL | exchange rate | No | No |
| esexrt_inverse_rate | numeric(28,8) | NULL | inverse exchange rate | No | No |
| esexrt_created_by | varchar(30) | NULL | created by | No | No |
| esexrt_createddate | datetime | NULL | created date | No | No |
| esexrt_modified_by | varchar(30) | NULL | last modified by | No | No |
| esexrt_modifieddate | datetime | NULL | last modified date | No | No |
| esexrt_deleted_by | varchar(30) | NULL | esexrt_deleted_by | No | No |
| esexrt_deleteddate | datetime | NULL | esexrt_deleteddate | No | No |
| esexrt_timestamp | numeric(28,8) | NULL | timestamp | No | No |
| Table Name es_esfbou_fb_ou_map | |||||
| Table Comment Finance book ouinstance mapping | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| esfbou_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | Yes |
| esfbou_company_code | varchar(10) | NOT NULL | company code | Yes | Yes |
| esfbou_finance_book | varchar(20) | NOT NULL | Finance Book | Yes | Yes |
| esfbou_associated_ou | numeric(10) | NOT NULL | Associated OU | Yes | No |
| esfbou_association_status | varchar(5) | NULL | Association Status | No | No |
| esfbou_status_eff_from | datetime | NULL | Status Effective From | No | No |
| Table Name es_esprm_parameter_details | |||||
| Table Comment Parameter details - meta data information | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| esprm_componentname | varchar(20) | NOT NULL | component name | Yes | No |
| esprm_paramcode | varchar(5) | NOT NULL | parameter code | Yes | No |
| esprm_paramtype | varchar(25) | NOT NULL | parameter type | Yes | No |
| esprm_paramcat | varchar(15) | NOT NULL | parametere category | Yes | No |
| esprm_langid | numeric(10) | NOT NULL | language id | Yes | No |
| esprm_param_desc | varchar(80) | NULL | parameter description | No | No |
| esprm_sortby | numeric(10) | NULL | sort by - order in which the values have to be displayed in the combo | No | No |
| esprm_createddate | datetime | NULL | created date | No | No |
| Table Name es_esxrhs_exchange_rate_his | |||||
| Table Comment Exchange Rate history is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| esxrhs_ouinstance | numeric(10) | NOT NULL | ouinstance | Yes | No |
| esxrhs_from_currency | varchar(20) | NOT NULL | from currency | Yes | No |
| esxrhs_to_currency | varchar(20) | NOT NULL | to currency | Yes | No |
| esxrhs_from_date | datetime | NOT NULL | from date | Yes | No |
| esxrhs_to_date | datetime | NULL | to date | No | No |
| esxrhs_exchange_rate | numeric(28,8) | NULL | exchange rate | No | No |
| esxrhs_inverse_rate | numeric(28,8) | NULL | inverse rate | No | No |
| esxrhs_exchange_rate_basis | char(18) | NULL | exchange rate basis - direct or derived | No | No |
| esxrhs_span_flag | varchar(40) | NULL | Span Flag | No | No |