|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MPLOPDT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| MPLOPDT_PART_CRT_OU | _decimal_10_0 | decimal(10) | No | Part Created Ou. | Yes |
| MPLOPDT_PART_NO | _varchar_40 | varchar(40) | No | The number identifying the part for which the transfer settings are specified | Yes |
| MPLOPDT_PART_TYPE | _varchar_5 | varchar(5) | No | the type of the part for which the transfer settings are specified | Yes |
| MPLOPDT_SHRTFALL_OU | _decimal_10_0 | decimal(10) | No | The location (OUInstance ID) for which part requirement is there for which stock needs to be transferred from another location.. | Yes |
| MPLOPDT_SHRTFALL_WH_ID | _varchar_10 | varchar(10) | No | select the warehouse to which the parts must be transferred | Yes |
| MPLOPDT_SOURCING_OU | _decimal_10_0 | decimal(10) | No | Location (OUInstance ID) from where stock needs to be transferred | Yes |
| MPLOPDT_SOURCING_WH_ID | _varchar_10 | varchar(10) | No | The warehouse from which the parts can be issued | Yes |
| MPLOPDT_SEQ_NO | _decimal_10_0 | decimal(10) | No | The preferred sequence in which the warehouse must be searched for free quantities of requested parts | Yes |
| MPLOPDT_PRIORITY | _varchar_5 | varchar(5) | No | the priority of the material request | Yes |
| MPLOPDT_CREATED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who created the options. | No |
| MPLOPDT_CREATEDDATE | _datetime_8 | datetime(8) | Yes | Creation Date. | No |
| MPLOPDT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who last modified | No |
| MPLOPDT_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | The date on which the options were last modified. | No |
| MPLOPDT_DEMANDMGMTOPT | udd_designparamcode | varchar(5) | Yes | Demand Management Option | No | |
| Table Name : | MPL_MPLOPMN_MTRLPL_OPT_MAIN |
| 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 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MPLOPMN_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance. | Yes |
| MPLOPMN_PART_CRT_OU | _decimal_10_0 | decimal(10) | No | Part Created Ou. | Yes |
| MPLOPMN_PART_NO | _varchar_40 | varchar(40) | No | The number identifying the part for which the transfer settings are specified in the multiline | Yes |
| MPLOPMN_PART_TYPE | _varchar_5 | varchar(5) | No | the type of the part for which the transfer settings are specified | Yes |
| MPLOPMN_SHRTFALL_OU | _decimal_10_0 | decimal(10) | No | The location (OUInstance ID) for which part requirement is there for which stock needs to be transferred from another location | Yes |
| MPLOPMN_SHRTFALL_WH_ID | _varchar_10 | varchar(10) | No | the warehouse to which the parts must be transferred | Yes |
| MPLOPMN_CREATED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who created the options. | No |
| MPLOPMN_CREATEDDATE | _datetime_8 | datetime(8) | Yes | Record Created Date. | No |
| MPLOPMN_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who last modified the options. | No |
| MPLOPMN_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | The date on which the options were last modified. | No |
| MPLOPMN_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp for the record. | No |
| MPLOPMN_RECVWH_ID | _varchar_10 | varchar(10) | Yes | the warehouse to which the parts must be transferred, if the requesting warehouse does not allow "Goods Receipt" transaction. | No | |
| Table Name : | MPL_MplOptDt_DPPref_Dtl |
| 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 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MPLOpDt_PrefOpn | udd_flag | varchar(25) | No | Preference option code. The possible values are DA(Direct Alternates), CSA(Customer Specific Alternates), ASS(Alternate Stock Status) and AWH(Alternate Warehouse). | Yes |
| MPLOptDt_OUInstance | udd_ctxt_ouinstance | int(4) | No | Ou Instance. | Yes |
| MPLOpDt_OrdOfPref | udd_seqno | int(4) | Yes | The precedence accorded to the parts. | No |
| MPLOpDt_Created_By | udd_ctxt_user | varchar(30) | Yes | The name of the user who created the options. | No |
| MPLOpDt_CreatedDate | udd_time | datetime(8) | Yes | Creation Date. | No |
| MPLOpDt_Modified_BY | udd_ctxt_user | varchar(30) | Yes | The name of the user who last modified | No |
| MPLOpDt_ModifiedDate | udd_time | datetime(8) | Yes | The date on which the options were last modified. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MPLOP_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| MPLOP_AUTOSTKTRN_NUMTYPE | _varchar_25 | Varchar(25) | No | he numbering type for stock transfer transaction created from "Plan Material" page. | Yes |
| MPLOP_AUTOSTKISS_NUMTYPE | _varchar_25 | Varchar(25) | No | the numbering type for automatic issue of material from the stock received | Yes |
| MPLOP_AUTOPRTRN_NUMTYPE | _varchar_25 | Varchar(25) | Yes | select the numbering type for purchase requests created from "Plan Material" page | No |
| MPLOP_MRWHDSP_FLAG | udd_designparamcode | varchar(5) | Yes | WareHouse Display Flag | No | |
| Table Name : | MPL_Parameter_Details |
| Comment : | This is new metadata table in the component BASMATPLN. By Vijayalakshmi.G on 29-May-2006 for Cmn-5H115/BasMatPln/Rel6/0.0 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MPL_Componentname | udd_componentid | varchar(90) | No | Name of the component. | Yes |
| MPL_paramcategory | udd_paramcategory | varchar(10) | No | Parameter category like "MULTILINE , COMBO etc.. | Yes |
| MPL_paramtype | udd_paramtype | varchar(25) | No | Parameter Type will be the Column name for which values need to be defined Eg. Preference Option . | Yes |
| MPL_paramcode | udd_parametersource | varchar(10) | No | Value set for the parameter type. Eg. DA,CSA,ASS,AWH etc.. | Yes |
| MPL_Langid | udd_ctxt_language | int(4) | No | Language ID. | Yes |
| MPL_paramdesc | udd_parameter | varchar(40) | No | Description of the parameter Eg. Direct Alternates, Customer Specific ALternates, Alternate Stock Status, ALternate Warehouse. | No |
| MPL_creationdate | udd_time | datetime(8) | Yes | Creation date. | No |