Unit of Measurement Administration |
|||||
|
|
|||||
|
Table Name UOM_MAS_UOMMASTER |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
MAS_OUINSTANCE |
numeric(28) |
NULL |
OU instance |
No |
No |
|
MAS_UOMCODE |
varchar(10) |
NOT NULL |
UOM Code |
No |
No |
|
MAS_UOMDESC |
varchar(40) |
NULL |
UOM Description |
No |
No |
|
MAS_FRACTIONS |
numeric(28) |
NULL |
Whether fractions allowed or not for the UOM values may be either y (yes) or n (no) |
No |
No |
|
MAS_STATUS |
varchar(8) |
NULL |
It will have "I" or "A" |
No |
No |
|
MAS_REASONCODE |
varchar(6) |
NULL |
code |
No |
No |
|
MAS_CREATED_BY |
varchar(30) |
NULL |
User Id who created record |
No |
No |
|
MAS_CREATED_DATE |
datetime |
NULL |
Record creation date |
No |
No |
|
MAS_MODIFIED_BY |
varchar(30) |
NULL |
User Id who modified the record |
No |
No |
|
MAS_MODIFIED_DATE |
datetime |
NULL |
Record modification date |
No |
No |
|
MAS_TIMESTAMP |
numeric(28) |
NULL |
Timestamp for data concurrency check |
No |
No |
|
|
|||||
|
Table Name uom_parameter_details |
|
||||
|
|
|||||
|
Table 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. This table is required to support multi-language. |
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ComponentName |
varchar(80) |
NOT NULL |
Name of the component |
Yes |
No |
|
ParamCategory |
varchar(10) |
NOT NULL |
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. |
Yes |
No |
|
ParamType |
varchar(25) |
NOT NULL |
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. |
Yes |
No |
|
ParamCode |
varchar(5) |
NOT NULL |
Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component |
Yes |
No |
|
LangId |
numeric(10) |
NOT NULL |
Language id. This is the language id of the record. |
Yes |
No |
|
ParamDesc |
varchar(80) |
NOT NULL |
Description of the combo value |
No |
No |
|
|
|||||
|
Table Name Uom_UmCon_UomIndConversion |
|
||||
|
|
|||||
|
Table 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" inside SPs |
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
UmCon_Org_unit |
numeric(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
UmCon_FromUomCode |
varchar(10) |
NOT NULL |
UOM code |
Yes |
Yes |
|
UmCon_ToUomCode |
varchar(10) |
NOT NULL |
UOM code |
Yes |
Yes |
|
UmCon_Conversion_Factor |
numeric(28,8) |
NOT NULL |
Denotes the conversion factor between "from uom" and "to uom". Value in ToUom will be equal to ValueInFromUom * ConversionFactor |
No |
No |
|
UmCon_Created_By |
varchar(30) |
NOT NULL |
User Id who created the record |
No |
No |
|
UmCon_Created_Date |
datetime |
NOT NULL |
Record creation date |
No |
No |
|
UmCon_Modified_By |
varchar(30) |
NOT NULL |
User id who modified the record |
No |
No |
|
UmCon_Modified_Date |
datetime |
NOT NULL |
Record modification date |
No |
No |
|
UmCon_TimeStamp |
numeric(10) |
NOT NULL |
Timestamp for data concurrency check |
No |
No |
|
|
|||||
|
Table Name Uom_UmMas_UomMaster |
|
||||
|
|
|||||
|
Table Comment This table contains the UOM (Unit of measurement) master information. |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
UmMas_org_unit |
numeric(10) |
NOT NULL |
OU Instance |
Yes |
No |
|
UmMas_Uom_Code |
varchar(10) |
NOT NULL |
UOM code |
Yes |
No |
|
UmMas_UomDesc |
varchar(80) |
NOT NULL |
UOM code description |
No |
No |
|
UMMAS_UOMDESC_UP |
varchar(80) |
NOT NULL |
UOM code description in Uppercase |
No |
No |
|
UmMas_Fractions |
varchar(5) |
NOT NULL |
Whether fractions allowed or not for the UOM values may be either y (yes) or n (no) |
No |
No |
|
UmMas_Status_code |
varchar(5) |
NOT NULL |
Uom Status whether it is Active or Inactive "A" (Active) when enabled and "I" (InActive) when disabled. |
No |
No |
|
UmMas_Category |
varchar(25) |
NOT NULL |
uom code |
No |
No |
|
UmMas_Created_By |
varchar(30) |
NOT NULL |
User Id who created record |
No |
No |
|
UmMas_Created_Date |
datetime |
NOT NULL |
Record creation date |
No |
No |
|
UmMas_Modified_By |
varchar(30) |
NULL |
User Id who modified the record |
No |
No |
|
UmMas_Modified_Date |
datetime |
|
Record modification date |
No |
No |
|
UmMas_TimeStamp |
numeric(10) |
NOT NULL |
Timestamp for data concurrency check |
No |
No |
|
|
|||||
|
Table Name Uom_UomQc_Quick_Code |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
UomQc_OuInstance |
decimal(10) |
NOT NULL |
OU instance |
Yes |
No |
|
UomQc_Quick_Code |
varchar(25) |
NOT NULL |
Quick Code |
Yes |
No |
|
UomQc_Quick_Type |
varchar(5) |
NOT NULL |
Quick Code Type |
Yes |
No |
|
UomQc_Quick_Desc |
varchar(80) |
NULL |
Quick Code Description |
No |
No |
|
UomQc_Status |
varchar(5) |
NULL |
It will have "I" or "A" |
No |
No |
|
UomQc_Created_Date |
datetime |
NULL |
Record creation date |
No |
No |
|
UomQc_Created_By |
varchar(30) |
NULL |
User Id who created the record |
No |
No |
|
UomQc_Modified_Date |
datetime |
NULL |
Record modification date |
No |
No |
|
UomQc_Modified_By |
varchar(30) |
NULL |
User Id who modified the record |
No |
No |
|
UomQc_TimeStamp |
decimal(10) |
NULL |
Timestamp for data concurrency check |
No |
No |
|
|
|
|
|
|
|