| Srl. No. | Table Name | Comment |
| 1 | UDS_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. |
| 2 | UDS_UDSATT_UDSS_ATTRIB_MAP | This table stores the Attribute types that are mapped to the User defined Stock status name. |
| 3 | UDS_UDSMN_UDSSTATUS_MASTER | This table contains the master details of the User defined stock status such as OU, Udss name, udds description, Status of Udss and other details. |
| 4 | UDS_UDSPART_UDSS_PART_MAP | This table stores the mapping details of the stock status with part types. It stores the various part types which take the User defined stock status. |
| 5 | UDS_UDSSTS_UDSS_STATUS_MAP | This table stores the list of User defined stock status that are mapped to a particular User defined stock status ,alternatives and Order Of Preference |
| 6 | UDS_UDSTRN_UDSS_TRANS_MAP | This table stores the transactions allowed for a user defined stock status. |
| 7 | UDS_USER_STOCK_STATUS_DTL | This table stores User Stock Status Details. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDS_COMPONENTNAME | _varchar_80 | varchar(80) | No | Name of the component - BASUDSS | No |
| UDS_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 |
| UDS_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 |
| UDS_PARAMCODE | _varchar_40 | varchar(40) | No | Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component | No |
| UDS_LANGID | _decimal_10_0 | decimal(10) | No | Language id. This is the language id of the record. | No |
| UDS_CREATIONDATE | _datetime_8 | datetime(8) | No | Created date of the record. | No |
| UDS_PARAMDESC | _varchar_80 | varchar(80) | Yes | Description of the combo value | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique No | Yes | |
| Table Name : | UDS_UDSATT_UDSS_ATTRIB_MAP |
| Comment : | This table stores the Attribute types that are mapped to the User defined Stock status name. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDSATT_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Ouinstance | No |
| UDSATT_UDSS_NAME | _varchar_40 | varchar(40) | No | user defined stock status name | No |
| UDSATT_ATTRIBUTE_TYPE | _varchar_25 | Varchar(25) | No | Attribute type is the paramtype defined in Parameter Details table. It takes following values CC - Cycle Counting NET - Nettable PI - Physical Inventory ST - Stockable VA - Valuated ALC - Allocable OC - Ownership-Customer OI | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique No | Yes | |
| Table Name : | UDS_UDSMN_UDSSTATUS_MASTER |
| Comment : | This table contains the master details of the User defined stock status such as OU, Udss name, udds description, Status of Udss and other details. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDSMN_ORG_UNIT | _decimal_10_0 | decimal(10) | No | ouinstance | No |
| UDSMN_UDSS_NAME | _varchar_40 | varchar(40) | No | user defined stock status name The predefined user defined stock status names are: Customer Goods PBH | No |
| UDSMN_UDSS_NAME_UP | _varchar_40 | varchar(40) | No | user defined stock status name in Upper Case | No |
| UDSMN_UDSS_DESC | _varchar_150 | varchar(150) | No | Description of user defined stock status | No |
| UDSMN_STATUS | _varchar_25 | Varchar(25) | No | Status of the user defined stock status It may be 1. A - Active 2. I - Inactive | No |
| UDSMN_CREATED_BY | _varchar_30 | varchar(30) | Yes | User who created the details | No |
| UDSMN_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User who modified the details | No |
| UDSMN_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Date at which user created the details | No |
| UDSMN_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Date at which the user modified the details | No |
| UDSMN_SORT_BY | _decimal_10_0 | decimal(10) | Yes | Sort by - it will have Order by numbers by which sorting is done in stock status combo loading | No |
| UDSMN_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp for the concurrency check. | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique No | Yes | |
| Table Name : | UDS_UDSPART_UDSS_PART_MAP |
| Comment : | This table stores the mapping details of the stock status with part types. It stores the various part types which take the User defined stock status. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDSPART_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Ouinstance | Yes |
| UDSPART_UDSS_NAME | _varchar_40 | varchar(40) | No | user defined stock status name | Yes |
| UDSPART_PART_TYPE | _varchar_25 | Varchar(25) | No | Part type The Part type takes the following values : CM - component CNSMB - Consumable KIT - Kit RWMTR - Raw Material SP - Spare Part TOOL - Tool | Yes | |
| Table Name : | UDS_UDSSTS_UDSS_STATUS_MAP |
| Comment : | This table stores the list of User defined stock status that are mapped to a particular User defined stock status ,alternatives and Order Of Preference |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDSSTS_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Ouinstance | Yes |
| UDSSTS_UDSS_NAME | _varchar_40 | varchar(40) | No | user defined stock status name | Yes |
| UDSSTS_STATUS_MAPPED | _varchar_40 | varchar(40) | No | Mapped user defined stock status name | Yes |
| UdsSts_Conv_Prmt_Flag | udd_flag1 | varchar(25) | No | The Conversion Permitted Flag. It takes values Y - Yes N - No | No |
| UdsSts_Alternate_Flag | udd_flag1 | varchar(25) | No | The Alternate Flag. It takes values Y - Yes N - No | No |
| UdsSts_Pref_Order | udd_count | int(4) | Yes | Order Of Preference for Alternatives | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDSTRN_ORG_UNIT | _decimal_10_0 | decimal(10) | No | Ouinstance | Yes |
| UDSTRN_UDSS_NAME | _varchar_40 | varchar(40) | No | user defined stock status name | Yes |
| UDSTRN_TRAN_TYPE | _varchar_25 | Varchar(25) | No | transaction code The Transaction types are: MNISU - Maintenance Issue UPLISU - UnPlanned Issue GISU -General Issue STISU -Stock Transfer Issue ROISU -Repair Order Issue STRC- Stock Transfer Receipt STR - Stock Transfer STKCORR - Stock Correc | Yes |
| UDSTRN_DEFAULT_FLAG | _varchar_25 | Varchar(25) | Yes | The Transaction type Default Flag It takes values Y - Yes N - No | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UDS_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ou Instance | No |
| UDS_FUNCTIONNAME | _varchar_25 | Varchar(25) | No | Function name | No |
| UDS_TRANSACTIONTYPE | _varchar_25 | Varchar(25) | No | Transaction Type | No |
| UDS_UDSS_CODE | _varchar_40 | varchar(40) | No | Userdefind Code | No |
| UDS_UDSS_DESCRIPTION | _varchar_150 | varchar(150) | Yes | User defind staock status description | No |
| UDS_CREATED_BY | _varchar_30 | varchar(30) | No | User who Created the details | No |
| UDS_CREATED_DATE | _datetime_8 | datetime(8) | No | Date at which user created the details | No |
| UDS_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| UDS_MODIFIED_DATE | _datetime_8 | datetime(8) | No | Date at which the user modified the details | No |
| UDS_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the concurrency check. | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique No | Yes |