|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SSCDT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Stock Status Conversion OUInstance ID. | Yes |
| SSCDT_STKSTSCONV_NO | _varchar_18 | varchar(18) | No | The unique transaction number assigned to the stock status conversion.. | Yes |
| SSCDT_LINE_NO | _varchar_30 | varchar(30) | No | System generated Line Num for part level conversion detail (The sequential number generated by the system for every line containing a part number). | Yes |
| SSCDT_PART_CRT_OU | _decimal_10_0 | decimal(10) | No | Part Created OUInstance ID. | No |
| SSCDT_PART_PLN_OU | _decimal_10_0 | decimal(10) | Yes | Part Planning Ouinstance ID. | No |
| SSCDT_PART_NO | _varchar_40 | varchar(40) | No | The number identifying the part to be converted | No |
| SSCDT_PART_QTY_INSTKUOM | _decimal_20_2 | decimal(20) | No | Part Qty in Stock Uom which is converted to a different stock status. | No |
| SSCDT_ZONE_ID | _varchar_10 | varchar(10) | Yes | The number identifying the zone in which the part converted is stored in the warehouse | No |
| SSCDT_BIN_NO | _varchar_10 | varchar(10) | Yes | The number identifying the bin in which the part converted is stored in the zone | No |
| SSCDT_FROM_STATUS | _varchar_40 | varchar(40) | Yes | the current stock status of the part. | No |
| SSCDT_TO_STATUS | _varchar_40 | varchar(40) | Yes | the status of the part to which it is to be converted | No |
| SSCDT_REMARKS | _varchar_255 | varchar(255) | Yes | Any comments regarding the stock status conversion | No |
| SSCDT_ISSRCPT_COST | _decimal_28_8 | decimal(28) | Yes | When stock status is converted, stock in old stock status is considered as issued and the stock in new status is considered as received. The cost reduced and increased is maintained here.. | No |
| SSC_ADL_EXISTFLAG | _varchar_5 | varchar(5) | Yes | this flag defines whether additional details are exist or not. | No |
| SSCDT_COMPUTED_COST | _decimal_28_8 | decimal(28) | Yes | cost of the part after stock status conversion | No |
| SSCDT_COMPUTED_DATE | _datetime_8 | datetime(8) | Yes | date on which part cost getting calculated | No |
| SSCDT_PART_COST | udd_amount | numeric(13) | Yes | Issue Receipt cost | No |
| SSCDT_FRMSTAT_PART_COST | udd_value | numeric(13) | Yes | From Status Part Cost | No |
| SSCDT_STOCK_UOM | udd_uom | varchar(15) | Yes | Stock UOM (Unit Of Measurement) | No |
| SSCDT_CNTRLTYPE | udd_flag | varchar(25) | Yes | Control type of the part | No |
| SSCDT_EXPENSETYPE | udd_flag | varchar(25) | Yes | Expense type of the part | No |
| SSCDT_EXPENSING_POLICY | udd_designparamcode | varchar(5) | Yes | Expensing policy of the part | No |
| SSCDT_ISSUEBASIS | udd_designparamcode | varchar(5) | Yes | Issue basis of the part | No |
| SSCDT_NONSTOCKABLE_FLAG | udd_flag | varchar(25) | Yes | Non stockable attribute of the part | No |
| SSCDT_PARTTYPE | udd_parttype | varchar(25) | Yes | Part type of the part | No |
| SSCDT_VALUATION_METHOD | udd_designparamcode | varchar(5) | Yes | Valuation Method of the part | No |
| SSCDT_FRM_OWNERSHIP | udd_designparamcode | varchar(5) | Yes | from ownership | No |
| SSCDT_FRM_OWNINGAGENCY | udd_vendorcode | varchar(45) | Yes | from owingagency | No |
| SSCDT_FRM_OWNINGAGENCY_OU | udd_ctxt_ouinstance | int(4) | Yes | from owingagency Ouinstance | No |
| SSCDT_TO_BIN | udd_designparamcode | varchar(5) | Yes | to bin | No |
| SSCDT_TO_OWNERSHIP | udd_vendorcode | varchar(45) | Yes | to ownership | No |
| SSCDT_TO_OWNINGAGENCY | udd_ctxt_ouinstance | int(4) | Yes | to owningagency | No |
| SSCDT_TO_OWNINGAGENCY_OU | udd_warehouse | varchar(10) | Yes | to owningagency ouinstance | No |
| SSCDT_TO_ZONE | udd_warehouse | varchar(10) | Yes | to zone | No |
| SSCDT_CAP_WRITEOFF_FLAG | udd_designparamcode | varchar(5) | Yes | Write off flag | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SSCMN_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Stock Status Conversion OUInstance ID. | Yes |
| SSCMN_STKSTSCONV_NO | _varchar_18 | varchar(18) | No | The unique transaction number assigned to the stock status conversion. | Yes |
| SSCMN_CATEGORY | _varchar_25 | Varchar(25) | Yes | The category of the stock status conversion document. Stock status conversion can be categorized by one of the user defined code. (quick codes of the type "Category" defined in the "Create Quick Codes" activity ) | No |
| SSCMN_STATUS | _varchar_5 | varchar(5) | No | The status of the stock conversion document. It could be Draft, Fresh, Authorized or Cancelled. 1. Draft - indicates that some more information has to be entered for the stock status conversion document. 2. Fresh - indicates that all the informatio | No |
| SSCMN_USER_STATUS | _varchar_25 | Varchar(25) | Yes | User Defined Statuses (user-defined status assigned to the stock status conversion document) | No |
| SSCMN_WAREHOUSE_OU | _decimal_10_0 | decimal(10) | No | Warehouse OU. | No |
| SSCMN_WAREHOUSE_ID | _varchar_10 | varchar(10) | No | The number identifying the warehouse in which the parts are stored. | No |
| SSCMN_AUTH_BY | _varchar_30 | varchar(30) | Yes | The login user ID of the person that authorized the stock status conversion document. | No |
| SSCMN_AUTH_DATE | _datetime_8 | datetime(8) | Yes | The date on which the stock status conversion document was authorized (Authorize Date) | No |
| SSCMN_CREATED_BY | _varchar_30 | varchar(30) | No | The login user ID of the person that created the stock status conversion document. | No |
| SSCMN_CREATED_DATE | _datetime_8 | datetime(8) | No | The date on which the stock status conversion document was created. | No |
| SSCMN_MODIFIED_BY | _varchar_30 | varchar(30) | No | The login user ID of the person that last modified the stock status conversion document. | No |
| SSCMN_MODIFIED_DATE | _datetime_8 | datetime(8) | No | The date on which the stock status conversion document was last modified. | No |
| SSCMN_FILENAME | _varchar_50 | varchar(50) | Yes | The name of the file | No |
| SSCMN_USER_DEF_1 | _varchar_25 | Varchar(25) | Yes | Additional details pertaining to the viewing of the stock status conversion | No |
| SSCMN_USER_DEF_2 | _varchar_25 | Varchar(25) | Yes | Additional details pertaining to the viewing of the stock status conversion2 | No |
| SSCMN_REMARKS | _varchar_255 | varchar(255) | Yes | Additional comments pertaining to the viewing of the stock status conversion | No |
| SSCMN_TIMESTAMP | _decimal_38_0 | decimal(38) | No | Time Stamp of a Record. | No |
| SSCMN_SOURCE_DOC_OU | udd_ctxt_ouinstance | int(4) | Yes | This column holds the document ouinstance | No |
| SSCMN_SOURCE_DOC_NO | udd_documentno | varchar(40) | Yes | This column holds the source document number | No |
| SSCMN_ADL_SOURCE_DOC_NO | udd_documentno | varchar(40) | Yes | udd_documentno | No |
| SSCMN_ADL_SOURCE_DOC_TYPE | udd_designparamcode | varchar(5) | Yes | udd_designparamcode | No |
| SSCMN_ADL_SOURCE_DOC_OU | udd_ctxt_ouinstance | int(4) | Yes | Additional Source document OU | No |
| SSCMN_SOURCE_DOC_TYPE | udd_designparamcode | varchar(5) | Yes | Source document type | No |
| SSCMN_CONV_TYPE | udd_designparamcode | varchar(5) | Yes | conversion type | No |
| SSCMN_CONDITION_CHANGE | udd_designparamcode | varchar(5) | Yes | condition change flag | No |
| SSCMN_ZONE_BIN_CHNGE | udd_designparamcode | varchar(5) | Yes | zone bin change | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SSCPRM_COMPONENTNAME | _varchar_80 | varchar(80) | No | Component Code. | Yes |
| SSCPRM_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.. | Yes |
| SSCPRM_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.. | Yes |
| SSCPRM_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. | Yes |
| SSCPRM_PARAMDESC | _varchar_80 | varchar(80) | No | Description of the Param Code. | No |
| SSCPRM_LANGID | _decimal_10_0 | decimal(10) | No | Language id. This is the language id of the record.. | Yes |
| SSCPRM_SORT_BY | _decimal_10_0 | decimal(10) | No | The order in which the values are populated.. | No |
| SSCPRM_CREATIONDATE | _datetime_8 | datetime(8) | No | Parameters created date. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SSCQC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Quick Code Created OU. | Yes |
| SSCQC_QUICK_CODE | _varchar_25 | Varchar(25) | No | A unique identifier for the quick code .This code must be unique for the organization unit. | Yes |
| SSCQC_TYPE | _varchar_5 | varchar(5) | No | Quick Code Type CA - Category US- User Status | Yes |
| SSCQC_DESC | _varchar_80 | varchar(80) | No | A textual description for the quick code | No |
| SSCQC_STATUS | _varchar_5 | varchar(5) | No | status of the quick code. The system provides the options Active and Inactive. | No |
| SSCQC_CREATED_DATE | _datetime_8 | datetime(8) | No | The date on which the quick code was created. | No |
| SSCQC_CREATED_BY | _varchar_30 | varchar(30) | No | The name of the user that created the quick code. | No |
| SSCQC_MODIFIED_DATE | _datetime_8 | datetime(8) | No | The date on which the quick code was last modified. | No |
| SSCQC_MODIFIED_BY | _varchar_30 | varchar(30) | No | The name of the user that last modified the quick code. | No |
| SSCQC_TIMESTAMP | _decimal_38_0 | decimal(38) | No | Time Stamp. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SSCTMP1_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | Ouinstance Id | No |
| SSCTMP1_STKSTSCONV_NO | _varchar_18 | varchar(18) | Yes | Stock Status Conversion Number | No |
| SSCTMP1_LINE_NO | _varchar_30 | varchar(30) | Yes | Line No | No |
| SSCTMP1_AUTH_DATE | _datetime_8 | datetime(8) | Yes | Authorised Date | No |
| SSCTMP1_WAREHOUSE_OU | _decimal_10_0 | decimal(10) | Yes | Warehouse Ouinstance | No |
| SSCTMP1_WAREHOUSE_ID | _varchar_10 | varchar(10) | Yes | Warehosue Id | No |
| SSCTMP1_PART_CRT_OU | _decimal_10_0 | decimal(10) | Yes | Part Created Ouinstance ID | No |
| SSCTMP1_PART_PLAN_OU | _decimal_10_0 | decimal(10) | Yes | Part Planning Ouinstance | No |
| SSCTMP1_PART_NO | _varchar_40 | varchar(40) | Yes | Part Number | No |
| SSCTMP1_STK_UOMOU | _decimal_10_0 | decimal(10) | Yes | Stock Uom instance | No |
| SSCTMP1_STK_UOM | _varchar_40 | varchar(40) | Yes | Stock UOM | No |
| SSCTMP1_UOM_FRACTIONS | _varchar_5 | varchar(5) | Yes | Uom Fractions | No |
| SSCTMP1_UOM_STATUS | _varchar_5 | varchar(5) | Yes | Uom status | No |
| SSCTMP1_PART_QTY_INSTKUOM | _decimal_20_2 | decimal(20) | Yes | part quantity in stock uom | No |
| SSCTMP1_ZONE_NO | _varchar_10 | varchar(10) | Yes | Zone ID | No |
| SSCTMP1_BIN_NO | _varchar_10 | varchar(10) | Yes | Bin No | No |
| SSCTMP1_OLDLOT_NO | _varchar_18 | varchar(18) | Yes | Old Lot Number | No |
| SSCTMP1_NEWLOT_NO | _varchar_18 | varchar(18) | Yes | New Lot Number | No |
| SSCTMP1_SERIAL_NO | _varchar_40 | varchar(40) | Yes | Serial Number | No |
| SSCTMP1_FROM_PART_STATUS | _varchar_40 | varchar(40) | Yes | From Part Status which requires conversion | No |
| SSCTMP1_TO_PART_STATUS | _varchar_40 | varchar(40) | Yes | To part status - which needs to be converted | No |
| SSCTMP1_PLANNING_STATUS | _varchar_5 | varchar(5) | Yes | Part planning status | No |
| SSCTMP1_UDDS_TRANFLAG | _varchar_5 | varchar(5) | Yes | Udds Transaction Flag | No |
| SSCTMP1_GUID | _varchar_40 | varchar(40) | Yes | Guid | No |
| ssctmp1_ownership | udd_designparamcode | varchar(5) | Yes | Ownership. | No |
| ssctmp1_owningagency | UDD_TXT60 | varchar(60) | Yes | Owning Agency. | No |
| ssctmp1_owningagency_ou | udd_ctxt_ouinstance | int(4) | Yes | Owning Agency OU. | No |
| ssctmp1_IsuRecCost | udd_value | numeric(13) | Yes | Issue Receipt cost | No |
| ssctmp1_partcost | udd_value | numeric(13) | Yes | Part cost | No |
| SSCTMP1_FRMSTAT_PARTCOST | udd_value | numeric(13) | Yes | From Status Part Cost | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique No | Yes |
| SSCTMP1_FRM_CONDITION | udd_designparamcode | varchar(5) | No | From condition | Yes |
| SSCTMP1_TO_BIN | udd_warehouse | varchar(10) | Yes | To Bin No | No |
| SSCTMP1_TO_CONDITION | udd_designparamcode | varchar(5) | Yes | To condition | No |
| SSCTMP1_TO_OWNERSHIP | udd_designparamcode | varchar(5) | Yes | To ownership | No |
| SSCTMP1_TO_OWNING_OU | udd_ctxt_ouinstance | int(4) | Yes | Ownership OU | No |
| SSCTMP1_TO_OWNINGAGENCY | udd_vendorcode | varchar(45) | Yes | Owningagency | No |
| SSCTMP1_TO_ZONE | udd_warehouse | varchar(10) | Yes | To Zone ID | No |
| SscTmp1_Capex_Proposalno | udd_desc40 | varchar(40) | Yes | Proposal No | No |