Data Dictionary -- Unit of Measurement Administration

Srl. No.	Table Name	Comment
1	uom_mas_uommaster	This table contains the UOM (Unit of measurement) master information
2	UOM_PARAMETER_DETAILS	This table holds the meta data for the component. This table will exist in all the component as part of the component. This table will hold the static values like combos, combo defaults, guidance text etc. Values are stored against the screen control. Thi
3	UOM_UMCON_UOMINDCONVERSION	This table contains the UOM independent conversion details for those UOMs present in the UOM master table "uoa_uomas_uom_master" The Primary Key columns FromUom and toUom, should be checked for their existence in the master table "Uom_UmMas_UomMaster" in
4	UOM_UMMAS_UOMMASTER	This table contains the UOM (Unit of measurement) master information.
5	UOM_UOMQC_QUICK_CODE	UOM (Unit of measurement) Quick Code

Table Name :	uom_mas_uommaster
Comment :	This table contains the UOM (Unit of measurement) master information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mas_ouinstance	udd_ouinstid	int(4)	No	Ouinstance	Yes
mas_uomcode	udd_uomcode	varchar(10)	No	UOM Code	Yes
mas_uomdesc	udd_uomdesc	varchar(40)	No	UOM Description	No
mas_fractions	udd_sequence	numeric(9)	No	Whether fractions allowed or not for the UOM values may be either y (yes) or n (no)	No
mas_status	udd_metadata_code	varchar(8)	No	It will have "I" or "A"	No
mas_reasoncode	udd_code	varchar(6)	Yes	reasoncode	No
mas_created_by	udd_ctxt_user	varchar(30)	No	User Id who created record	No
mas_created_date	udd_date	varchar(15)	No	Record creation date	No
mas_modified_by	udd_ctxt_user	varchar(30)	No	User Id who modified the record	No
mas_modified_date	udd_date	varchar(15)	No	Record modification date	No
mas_timestamp	udd_timestamp	int(4)	No	Timestamp for data concurrency check	No

Table Name :	UOM_PARAMETER_DETAILS
Comment :	This table holds the meta data for the component. This table will exist in all the component as part of the component. This table will hold the static values like combos, combo defaults, guidance text etc. Values are stored against the screen control. Thi

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_80	varchar(80)	No	Name of the component	No
PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	No
PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	No
PARAMCODE	_varchar_5	varchar(5)	No	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
PARAMDESC	_varchar_80	varchar(80)	No	Description of the combo value	No
LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	UOM_UMCON_UOMINDCONVERSION
Comment :	This table contains the UOM independent conversion details for those UOMs present in the UOM master table "uoa_uomas_uom_master" The Primary Key columns FromUom and toUom, should be checked for their existence in the master table "Uom_UmMas_UomMaster" in

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UMCON_ORG_UNIT	_decimal_10_0	decimal(10)	No	OUInstance	No
UMCON_FROMUOMCODE	_varchar_10	varchar(10)	No	UOM code	No
UMCON_TOUOMCODE	_varchar_10	varchar(10)	No	UOM code.	No
UMCON_CONVERSION_FACTOR	_decimal_28_8	decimal(28)	No	Denotes the conversion factor between "from uom" and "to uom". Value in ToUom will be equal to ValueInFromUom * ConversionFactor	No
UMCON_CREATED_BY	_varchar_30	varchar(30)	No	User Id who created the record	No
UMCON_CREATED_DATE	_datetime_8	datetime(8)	No	Record creation date	No
UMCON_MODIFIED_BY	_varchar_30	varchar(30)	No	User id who modified the record	No
UMCON_MODIFIED_DATE	_datetime_8	datetime(8)	No	Record modification date	No
UMCON_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp for data concurrency check	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	UOM_UMMAS_UOMMASTER
Comment :	This table contains the UOM (Unit of measurement) master information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UMMAS_ORG_UNIT	_decimal_10_0	decimal(10)	No	OUInstance	No
UMMAS_UOM_CODE	_varchar_10	varchar(10)	No	UOM code	No
UMMAS_UOMDESC	_varchar_80	varchar(80)	No	UOM code description	No
UMMAS_UOMDESC_UP	_varchar_80	varchar(80)	No	UOM code description in Uppercase	No
UMMAS_FRACTIONS	_varchar_5	varchar(5)	No	Whether fractions allowed or not for the UOM values may be either y (yes) or n (no)	No
UMMAS_STATUS_CODE	_varchar_5	varchar(5)	No	Uom Status whether it is Active or Inactive "A" (Active) when enabled and "I" (InActive) when disabled.	No
UMMAS_CATEGORY	_varchar_25	Varchar(25)	Yes	UOM Category	No
UMMAS_CREATED_BY	_varchar_30	varchar(30)	No	User Id who created record	No
UMMAS_CREATED_DATE	_datetime_8	datetime(8)	No	Record creation date	No
UMMAS_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User Id who modified the record	No
UMMAS_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Record modification date	No
UMMAS_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp for data concurrency check	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	UOM_UOMQC_QUICK_CODE
Comment :	UOM (Unit of measurement) Quick Code

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UOMQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	No
UOMQC_QUICK_CODE	_varchar_25	Varchar(25)	No	Quick Code	No
UOMQC_QUICK_TYPE	_varchar_5	varchar(5)	No	Quick Code Type	No
UOMQC_QUICK_DESC	_varchar_80	varchar(80)	Yes	Quick Code Description	No
UOMQC_STATUS	_varchar_5	varchar(5)	Yes	It will have "I" or "A"	No
UOMQC_CREATED_DATE	_datetime_8	datetime(8)	Yes	Record creation date	No
UOMQC_CREATED_BY	_varchar_30	varchar(30)	Yes	User Id who created the record	No
UOMQC_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Record modification date	No
UOMQC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User Id who modified the record	No
UOMQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp for data concurrency check	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes