Stock Demand Management

 

 

 

Table Name MPL_MPlOp_MtrlPl_Opt_Set

 

 

Table Comment table which is used to store the plan material set options value

 

Table Column Name

Table Column Datatype

Table Column Null Option

 Table Column Comment Table Column Is PK Table Column Is FK

 

MPlOp_OUInstance

numeric(10)

NOT NULL

 OUinstance Yes No

 

MPlOp_AutoStkTrn_NumType

varchar(25)

NOT NULL

 he numbering type for stock transfer transaction created from "Plan Material" page. Yes No

 

MPlOp_AutoStkIss_NumType

varchar(25)

NOT NULL

 the numbering type for automatic issue of material from the stock received Yes No

 

MPLOP_AUTOPRTRN_NUMTYPE

varchar(25)

NULL

 select the numbering type for purchase requests created from "Plan Material" page No No

 

 

Table Name MPL_MPlOpDt_MtrlPl_Opt_Dtl

 

 

Table Comment this table is used to store plan material &nbspset options values

 

Table Column Name

Table Column Datatype

Table Column Null Option

 Table Column Comment Table Column Is PK Table Column Is FK

 

MPlOpDt_Priority

varchar(5)

NOT NULL

 the priority of the material request Yes No

 

MPlOpDt_Seq_No

numeric(10)

NOT NULL

 The preferred sequence in which the warehouse must be searched for free quantities of requested parts Yes No

 

MPlOpDt_Sourcing_Wh_Id

varchar(10)

NOT NULL

 The warehouse from which the parts can be issued Yes No

 

MPlOpDt_Modified_By

varchar(30)

NULL

 The name of the user who last modified No No

 

MPlOpDt_Created_By

varchar(30)

NULL

 The name of the user who was created No No

 

MPlOpDt_CreatedDate

datetime

NULL

 The date on which the doc is getting created. No No

 

MPlOpDt_ModifiedDate

datetime

NULL

 The date on which the values were last modified. No No

 

MPlOpDt_Part_Crt_Ou

decimal(10)

NOT NULL

 Part Created Ou. Yes Yes

 

MPlOpDt_Part_No

varchar(40)

NOT NULL

 The number identifying the part for which the transfer settings are specified Yes Yes

 

MPLOPDT_OUINSTANCE

decimal(10)

NOT NULL

 OUinstance Yes No

 

MPlOpDt_Sourcing_Ou

numeric(10)

NOT NULL

 Location (OUInstance ID) from where stock needs to be transferred Yes No

 

MPlOpDt_ShrtFall_Wh_Id

varchar(10)

NOT NULL

 select the warehouse to which the parts must be transferred Yes Yes

 

MPlOpDt_Part_Type

varchar(5)

NOT NULL

 the type of the part for which the transfer settings are specified Yes Yes

 

MPlOpDt_ShrtFall_Ou

decimal(10)

NOT NULL

 The location (OUInstance ID) for which part requirement is there for which stock needs to be transferred from another location.. Yes Yes

 

 

Table Name MPL_MPLOpMn_MtrlPl_Opt_Main

 

 

Table Comment This table is used to store the options that are set by the user. The two options are: 1. Allow Input of Stock Value for Standard Cost Parts. It takes values ’Y’ and ’N’.  If it is set as ’Y’, then the value entered by the user is taken as the Stock  value. If it is set as ’N’, the standard cost is taken as the Stock value. 2. Method for Conversion of Fractional Receipt Qty. This option takes values:   &nbspRound Up,Round Down, Round Off.

 

Table Column Name

Table Column Datatype

Table Column Null Option

 Table Column Comment Table Column Is PK Table Column Is FK

 

MPLOPMN_OUINSTANCE

decimal(10)

NOT NULL

 OUinstance. Yes No

 

MPLOpMn_Part_Crt_Ou

decimal(10)

NOT NULL

 Part Created Ou. Yes No

 

MPLOpMn_Part_No

varchar(40)

NOT NULL

 The number identifying the part for which the transfer settings are specified in the multiline Yes No

 

MPLOpMn_Part_Type

varchar(5)

NOT NULL

 the type of the part for which the transfer settings are specified Yes No

 

MPLOpMn_ShrtFall_Ou

decimal(10)

NOT NULL

 The location (OUInstance ID) for which part requirement is there for which stock needs to be transferred from another location Yes No

 

MPLOpMn_ShrtFall_Wh_Id

varchar(10)

NOT NULL

 the warehouse to which the parts must be transferred Yes No

 

MPLOpMn_Created_By

varchar(30)

NULL

 The name of the user who created the options. No No

 

MPLOpMn_CreatedDate

datetime

NULL

 Record Created Date. No No

 

MPLOpMn_Modified_By

varchar(30)

NULL

 The name of the user who last modified the options. No No

 

MPLOpMn_ModifiedDate

datetime

NULL

 The date on which the options were last modified. No No

 

MPLOpMn_Timestamp

decimal(10)

NULL

 Timestamp for the record. No No

 

MPLOPMN_RECVWH_ID

varchar(10)

NULL

 the warehouse to which the parts must be transferred, if the requesting warehouse does not allow “Goods Receipt” transaction. No No

 

 

Table Name MPL_MplOptDt_DPPref_Dtl

 

 

Table Comment This table is added for the new multiline included for Demand & Receipt Pegging preference setting. By Vijayalakshmi.G on 29-May-2006 for Cmn-5H115/BasMatPln/Rel6/0.0

 

Table Column Name

Table Column Datatype

Table Column Null Option

 Table Column Comment Table Column Is PK Table Column Is FK

 

MPLOpDt_PrefOpn

sql_variant

NOT NULL

 Preference option code. The possible values are DA(Direct Alternates), CSA(Customer Specific Alternates), ASS(Alternate Stock Status) and AWH(Alternate Warehouse). Yes No

 

MPLOptDt_OUInstance

int

NOT NULL

 Ou Instance. Yes No

 

MPLOpDt_OrdOfPref

int

NULL

 The precedence accorded to the parts. No No

 

MPLOpDt_Created_By

sql_variant

NULL

 The name of the user who created the options. No No

 

MPLOpDt_CreatedDate

datetime

NULL

 Creation Date. No No

 

MPLOpDt_Modified_BY

sql_variant

NULL

 The name of the user who last modified the options. No No

 

MPLOpDt_ModifiedDate

datetime

NULL

 The date on which the options were last modified. No No

 

 

Table Name MPL_Parameter_Details

 

 

Table Comment This is new metadata table in the component BASMATPLN. By Vijayalakshmi.G on 29-May-2006 for Cmn-5H115/BasMatPln/Rel6/0.0

 

Table Column Name

Table Column Datatype

Table Column Null Option

 Table Column Comment Table Column Is PK Table Column Is FK

 

MPL_Componentname

sql_variant

NOT NULL

 Name of the component. Yes No

 

MPL_paramcategory

sql_variant

NOT NULL

 Parameter category like "MULTILINE’,’COMBO’ etc.. Yes No

 

MPL_paramtype

sql_variant

NOT NULL

 Parameter Type will be the Column name for which values need to be defined Eg. ’Preference Option’. Yes No

 

MPL_paramcode

sql_variant

NOT NULL

 Value set for the parameter type. Eg. DA,CSA,ASS,AWH etc.. Yes No

 

MPL_Langid

int

NOT NULL

 Language ID. Yes No

 

MPL_paramdesc

sql_variant

NOT NULL

 Description of the parameter Eg. Direct Alternates, Customer Specific Alternates, Alternate Stock Status, Alternate Warehouse. No No

 

MPL_creationdate

datetime

NULL

 Creation date. No No

 

 

Table Name SMN_SMNSD_SHIP_DTL

 

 

Table Comment Stagging Table to save the details like Ship By, Shipping Instructions, Process Qty from Plan Material Page

Table Column Name

Table Column Datatype

Table Column Null Option

 Table Column Comment Table Column Is PK Table Column Is FK

 

SMN_SMNSD_MTRL_OU

int

NULL

 Plan Material Source OUInstance in an interacting set of OUs No No

 

SMN_SMNSD_MTRL_REQ_NO

sql_variant

NULL

 To store the Material Request No, for which PR or ST or Issue or Update task performed in Plan Material. No No

 

SMN_SMNSD_MTRL_LINE_NO

int

NULL

 To store the MR’s corresponding Line No No No

 

SMN_SMNSD_PART_NO

sql_variant

NULL

 To Store the Part No involved in the Material Request. No No

 

SMN_SMNSD_FROM_WAREHOUSE_NO

sql_variant

NULL

 To store the Warehouse code (From Warehouse) No No

 

SMN_SMNSD_PROCESS_DOC_TYPE

sql_variant

NULL

 To Store the document type generated for the MR selected from the Plan Material page. No No

 

SMN_SMNSD_PROCESS_DOC_NO

sql_variant

NULL

 To store the Document No generated ie PR # (or) STA  # (or) Issue No No

 

SMN_SMNSD_SHIP_BY

sql_variant

NULL

 To store the value of Ship-by field No No

 

SMN_SMNSD_SHIP_INS

sql_variant

NULL

 To store the shipping instructions value No No

 

SMN_SMNSD_REMARKS

sql_variant

NULL

 To store the value of Remarks column No No

 

SMN_SMNSD_PROCESS_QTY

bigint

NULL

 To capture the Process Qty entered by the user in the plan Material page No No

 

SMN_SMNSD_CREATED_BY

sql_variant

NULL

 Created User Name No No

 

SMN_SMNSD_CREATED_DATE

datetime

NULL

 Created Date No No

 

SMN_SMNSD_MR_PR_STO_COVERED_QTY

bigint

NULL

 To capture the covered quantity for MR in the generated document (PR / STO) No No

 

SMN_SMNSD_MODIFIED_DATE

datetime

NULL

 Modified Date No No

 

SMN_SMNSD_MODIFIED_BY

sql_variant

NULL

 Modified User Name No No