Stock Status Conversion

Stock Status Conversion
Table Name Ssc_SscAdl_Stl_Sts_Conv_Adl

Table Comment Stock Status Conversion additional details are stored here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscAdl_Part_Qty_InStkUom	numeric(20,2)	NOT NULL	(The quantity of the part to be converted for the serial number or lot number entered )Quantity in StockUom.	No	No
SscAdl_Srl_No	varchar(40)	NOT NULL	Serial of the part. This will be ## if the part is not serial controlled (The number identifying the serial number issued by the manufacturer)	Yes	No
SscAdl_Remarks	varchar(255)	NULL	Remarks (Any remarks pertaining to the converted part ).	No	No
SscAdl_New_Lot_No	varchar(18)	NULL	New Lot Number.. The New Lot Number will be generate if Part is "Only Lot Control".	No	No
SscAdl_OUInstance	numeric(10)	NOT NULL	Stock Status Conversion OUInstance ID.	Yes	Yes
SscAdl_Lot_No	varchar(18)	NOT NULL	Lot number of the part. This will be ## if the part is not lot controlled (The number identifying the lot number issued by the manufacturer)	Yes	No
SscAdl_StkStsConv_No	varchar(18)	NOT NULL	The unique transaction number assigned to the stock status conversion..	Yes	Yes
SscAdl_Line_No	varchar(30)	NOT NULL	line number of the stock status conversion document which contains the part for which you wish to enter the serial or lot number details.	Yes	Yes
SSCADL_PO_NO	varchar(40)	NULL	When stock status is converted from consignment - any of internal stock status , PO # of the GR through which the Consignment part was brought into Stock is maintained here.	No	No
SSCADL_PO_AMENDNO	numeric(10)	NULL	When stock status is converted from consignment - any of internal stock status , PO Amendment # - Latest Amendment # of the PO which is in Authorized status is maintained here.	No	No
SSCADL_PO_LINENO	numeric(10)	NULL	When stock status is converted from consignment - any of internal stock status, the corresponding PO Line # is maintained here.	No	No
SSCADL_GR_NO	varchar(40)	NULL	When stock status is converted from consignment - any of internal stock status , GR# through which the Consignment part was brought into Stock is maintained here.	No	No
SSCADL_GR_LINENO	numeric(10)	NULL	When stock status is converted from consignment - any of internal stock status, the corresponding GR Line # is maintained here.	No	No
SSCADL_PO_CURRENCY	varchar(20)	NULL	When stock status is converted from consignment - any of internal stock status, the corresponding PO currency is maintained here.	No	No
SSCADL_EXCH_RATE	numeric(28,8)	NULL	When stock status is converted from consignment - any of internal stock status, Exchange Rate - if Forward Cover is applicable then the Forward Cover Rate specified in the PO should be taken. If Forward Cover is not applicable then Erate needs to be derived as on the SSC date (between PO currency and Base currency) and be considered.	No	No
SSCADL_UNIT_RATE	numeric(28,8)	NULL	When stock status is converted from consignment - any of internal stock status, Unit Rate - as available in corresponding PO, PO line # multiplied with the Exchange Rate	No	No
sscadl_frmstat_part_cost	numeric(28,8)	NULL	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 part cost of old stock status is maintained here..	No	No
SSCADL_ISSRCPT_COST	numeric(28,8)	NULL	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 tran. Cost is maintained here..	No	No
sscadl_ownership	varchar(5)	NULL	When stock status is converted, ownership of old stock status is maintained here.	No	No
sscadl_owningagency	varchar(60)	NULL	When stock status is converted, owner agency of old stock status is maintained here.	No	No
sscadl_owningagency_ou	int(4)	NULL	When stock status is converted, owner agency ou of old stock status is maintained here.	No	No
SSCADL_PART_COST	numeric(28,8)	NULL	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 part cost is maintained here..	No	No

Table Name Ssc_SscDA_Doc_Attach_Dtl

Table Comment This table allows you to store the reference details of the stock status conversion document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscDA_OUInstance	numeric(10)	NOT NULL	stock status conversion Created OU	Yes	No
SscDA_StkStsConv_No	varchar(40)	NOT NULL	The number identifying the stock conversion document to which the reference documents are associated with..	Yes	No
SscDA_Seq_No	numeric(10)	NOT NULL	line no	Yes	No
SscDA_Doc_Type	varchar(15)	NOT NULL	the reference document associated with the stock status conversion document.	Yes	No
SscDA_Doc_Id	varchar(40)	NOT NULL	The document ID containing the details of the stock status conversion document.	Yes	No
SscDA_File_Name	varchar(50)	NULL	The name of the file used for reference.	No	No
SscDA_Remarks	varchar(255)	NULL	Any additional comments pertaining to the reference document.	No	No

Table Name Ssc_SscDt_Stk_Sts_Conv_Dtl

Table Comment Stock Status Conversion Details are stored here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscDt_To_Status	varchar(40)	NULL	the status of the part to which it is to be converted	No	No
SscDt_Remarks	varchar(255)	NULL	Any comments regarding the stock status conversion	No	No
SscDt_From_Status	varchar(40)	NULL	the current stock status of the part.	No	No
SscDt_Bin_No	varchar(10)	NULL	The number identifying the bin in which the part converted is stored in the zone	No	No
SSCDT_COMPUTED_COST	decimal(28,8)	NULL	cost of the part after stock status conversion	No	No
SscDt_IssRcpt_Cost	numeric(28,8)	NULL	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	No
sscdt_frmstat_part_cost	numeric(28,8)	NULL	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 part cost of old stock status is maintained here..	No	No
SSCDT_PART_COST	numeric(28,8)	NULL	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 part cost is maintained here..	No	No
SSC_ADL_EXISTFLAG	varchar(5)	NULL	this flag defines whether additional details are exist or not.	No	No
SSCDT_COMPUTED_DATE	datetime	NULL	date on which part cost getting calculated	No	No
SscDt_StkStsConv_No	varchar(18)	NOT NULL	The unique transaction number assigned to the stock status conversion..	Yes	Yes
SscDt_Line_No	varchar(30)	NOT NULL	System generated Line Num for part level conversion detail (The sequential number generated by the system for every line containing a part number).	Yes	No
SscDt_OUInstance	numeric(10)	NOT NULL	Stock Status Conversion OUInstance ID.	Yes	Yes
SscDt_Zone_Id	varchar(10)	NULL	The number identifying the zone in which the part converted is stored in the warehouse	No	No
SscDt_Part_Qty_InStkUom	numeric(20,2)	NOT NULL	Part Qty in Stock Uom which is converted to a different stock status.	No	No
SscDt_Part_Crt_OU	numeric(10)	NOT NULL	Part Created OUInstance ID.	No	No
SscDt_Part_No	varchar(40)	NOT NULL	The number identifying the part to be converted	No	No
SscDt_Part_Pln_Ou	numeric(10)	NULL	Part Planning Ouinstance ID.	No	No

Table Name SSC_SSCDT_STK_STS_CONV_DTL_RA

Table Comment Stock Status Conversion Details are stored here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SSCDT_OUINSTANCE	decimal(10)	NOT NULL	Stock Status Conversion OUInstance ID.	No	No
SSCDT_STKSTSCONV_NO	varchar(18)	NOT NULL	The unique transaction number assigned to the stock status conversion..	No	No
SSCDT_LINE_NO	varchar(30)	NOT NULL	System generated Line Num for part level conversion detail (The sequential number generated by the system for every line containing a part number).	No	No
SSCDT_PART_CRT_OU	decimal(10)	NOT NULL	Part Created OUInstance ID.	No	No
SSCDT_PART_PLN_OU		NULL	Part Planning Ouinstance ID.	No	No
SSCDT_PART_NO	varchar(40)	NOT NULL	The number identifying the part to be converted	No	No
SSCDT_PART_QTY_INSTKUOM	decimal(20,2)	NOT NULL	Part Qty in Stock Uom which is converted to a different stock status.	No	No
SSCDT_ZONE_ID	varchar(10)	NULL	The number identifying the zone in which the part converted is stored in the warehouse	No	No
SSCDT_BIN_NO	varchar(10)	NULL	The number identifying the bin in which the part converted is stored in the zone	No	No
SSCDT_FROM_STATUS	varchar(40)	NULL	the current stock status of the part.	No	No
SSCDT_TO_STATUS	varchar(40)	NULL	the status of the part to which it is to be converted	No	No
SSCDT_REMARKS	varchar(255)	NULL	Any comments regarding the stock status conversion	No	No
SSCDT_ISSRCPT_COST	decimal(28,8)	NULL	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	No
SSC_ADL_EXISTFLAG	varchar(5)	NULL	this flag defines whether additional details are exist or not.	No	No
SSCDT_COMPUTED_COST	decimal(28,8)	NULL	cost of the part after stock status conversion	No	No
SSCDT_COMPUTED_DATE	datetime	NULL	date on which part cost getting calculated	No	No
SSCDT_COST_FOR_TOOL	decimal(28,8)	NULL	cost for tool	No	No

Table Name Ssc_SscMn_Stk_Sts_Conv_Hdr

Table Comment Stock Status Conversion main info details are stored here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscMn_OUInstance	numeric(10)	NOT NULL	Stock Status Conversion OUInstance ID.	Yes	No
SscMn_StkStsConv_No	varchar(18)	NOT NULL	The unique transaction number assigned to the stock status conversion.	Yes	No
SscMn_Category	varchar(25)	NULL	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	No
SscMn_Status	varchar(5)	NOT NULL	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 information pertaining to the stock conversion document has been entered. The stock status conversion document can be sent for authorization. 3. Authorized - indicates that the stock status conversion document has been authorized. An authorized stock conversion document cannot be modified or cancelled. 4.Cancelled - indicates that the stock status conversion document has been cancelled.	No	No
SscMn_User_Status	varchar(25)	NULL	User Defined Statuses (user-defined status assigned to the stock status conversion document)	No	No
SscMn_Warehouse_OU	numeric(10)	NOT NULL	Warehouse OU.	No	No
SscMn_Warehouse_Id	varchar(10)	NOT NULL	The number identifying the warehouse in which the parts are stored.	No	No
SscMn_Auth_By	varchar(30)	NULL	The login user ID of the person that authorized the stock status conversion document.	No	No
SscMn_Auth_Date	datetime	NULL	The date on which the stock status conversion document was authorized (Authorize Date)	No	No
SscMn_FileName	varchar(50)	NULL	The name of the file	No	No
SscMn_User_Def_1	varchar(25)	NULL	Additional details pertaining to the viewing of the stock status conversion	No	No
SscMn_User_Def_2	varchar(25)	NULL	Additional details pertaining to the viewing of the stock status conversion	No	No
SscMn_Remarks	varchar(255)	NULL	Additional comments pertaining to the viewing of the stock status conversion	No	No
SscMn_Created_By	varchar(30)	NOT NULL	The login user ID of the person that created the stock status conversion document.	No	No
SscMn_Created_Date	datetime	NOT NULL	The date on which the stock status conversion document was created.	No	No
SscMn_Modified_By	varchar(30)	NOT NULL	The login user ID of the person that last modified the stock status conversion document.	No	No
SscMn_Modified_Date	datetime	NOT NULL	The date on which the stock status conversion document was last modified.	No	No
SscMn_Timestamp	decimal(38)	NOT NULL	Time Stamp of a Record.	No	No
SSCMN_SOURCE_DOC_OU	int	NULL	This column holds the document ouinstance	No	No
SSCMN_SOURCE_DOC_NO	varchar(40)	NULL	This column holds the source document number	No	No

Table Name Ssc_SscPrm_parameter_details

Table Comment this table is used to store the meta data details for the basstockconv component.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscPrm_ComponentName	varchar(80)	NOT NULL	Component Code.	Yes	No
SscPrm_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
SscPrm_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
SscPrm_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
SscPrm_Langid	numeric(10)	NOT NULL	Language id. This is the language id of the record..	Yes	No
SscPrm_ParamDesc	varchar(80)	NOT NULL	Description of the Param Code.	No	No
SscPrm_sort_by	numeric(10)	NOT NULL	The order in which the values are populated..	No	No
SscPrm_CreationDate	datetime	NOT NULL	Parameters created date.	No	No

Table Name Ssc_SscQc_Quick_Code

Table Comment this table is used to store the quick code details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscQc_OUInstance	numeric(10)	NOT NULL	Quick Code Created OU.	Yes	No
SscQc_Quick_Code	varchar(25)	NOT NULL	A unique identifier for the quick code .This code must be unique for the organization unit.	Yes	No
SscQc_Type	varchar(5)	NOT NULL	Quick Code Type CA - Category US- User Status	Yes	No
SscQc_Desc	varchar(80)	NOT NULL	A textual description for the quick code	No	No
SscQc_Status	varchar(5)	NOT NULL	status of the quick code. The system provides the options Active and Inactive.	No	No
SscQc_Created_Date	datetime	NOT NULL	The date on which the quick code was created.	No	No
SscQc_Created_By	varchar(30)	NOT NULL	The name of the user that created the quick code.	No	No
SscQc_Modified_Date	datetime	NOT NULL	The date on which the quick code was last modified.	No	No
SscQc_Modified_By	varchar(30)	NOT NULL	The name of the user that last modified the quick code.	No	No
SscQc_Timestamp	decimal(38)	NOT NULL	Time Stamp.	No	No

Table Name Ssc_SscTmp1_Stk_Status_Upd
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SscTmp1_OUInstance	numeric(10,0)	NULL	Ouinstance Id	No	No
SscTmp1_StkStsConv_No	varchar(18)	NULL	Stock Status Conversion Number	No	No
SscTmp1_Line_No	varchar(30)	NULL	Line No	No	No
SscTmp1_Auth_Date	datetime	NULL	Authorised Date	No	No
SscTmp1_Warehouse_OU	numeric(10,0)	NULL	Warehouse Ouinstance	No	No
SscTmp1_Warehouse_Id	varchar(10)	NULL	Warehouse Id	No	No
SscTmp1_Part_Crt_OU	numeric(10,0)	NULL	Part Created Ouinstance ID	No	No
SscTmp1_Part_Plan_OU	numeric(10,0)	NULL	Part Planning Ouinstance	No	No
SscTmp1_Part_No	varchar(40)	NULL	Part Number	No	No
SscTmp1_Stk_UomOU	numeric(10,0)	NULL	Stock Uom instance	No	No
SscTmp1_Stk_Uom	varchar(40)	NULL	Stock UOM	No	No
SscTmp1_Uom_Fractions	varchar(5)	NULL	Uom Fractions	No	No
SscTmp1_Uom_Status	varchar(5)	NULL	Uom status	No	No
SscTmp1_Part_Qty_InStkUom	numeric(20,2)	NULL	part quantity in stock uom	No	No
SscTmp1_Zone_No	varchar(10)	NULL	Zone ID	No	No
SscTmp1_Bin_No	varchar(10)	NULL	Bin No	No	No
SscTmp1_OldLot_No	varchar(18)	NULL	Old Lot Number	No	No
SscTmp1_NewLot_No	varchar(18)	NULL	New Lot Number	No	No
SscTmp1_Serial_No	varchar(40)	NULL	Serial Number	No	No
SscTmp1_From_Part_Status	varchar(40)	NULL	From Part Status which requires conversion	No	No
SscTmp1_To_Part_Status	varchar(40)	NULL	To part status - which needs to be converted	No	No
SscTmp1_Planning_status	varchar(5)	NULL	Part planning status	No	No
SscTmp1_Udds_TranFlag	varchar(5)	NULL	Trans flag	No	No
SscTmp1_Guid	varchar(40)	NULL	Guid	No	No