Configure integer effectivities
Effectivity designates a period of time when a part in the BOM is valid or when it will become valid. By default, this is expressed as a "from" date and "to" date. However, your usage may require a lot number or sequence number (integer value) rather than a date range. Since dates are stored in the database in UTC_TIME format (which is an integer format), you can reconfigure the DB_EFFECTIVE_FROM and DB_EFFECTIVE_TO attributes to be integers.
How to configure integer effectivities
1. Copy the database class entry from wmconf.xml to your custom xml file.
2. Edit the DB_EFFECTIVE_FROM and DB_EFFECTIVE_TO attributes to be integers.
For example, to configure integer effectivities on MASTERDATA:
<Class extends="DMMasterdata">
<Name>MASTERDATA</Name>
<Attribute>
DB_EFFECTIVE_FROM
<IsLinkAttribute>true</IsLinkAttribute>
<DataType>INTEGER</DataType>
<Visible>false</Visible>
</Attribute>
<Attribute>
DB_EFFECTIVE_TO
<IsLinkAttribute>true</IsLinkAttribute>
<DataType>INTEGER</DataType>
<Visible>false</Visible>
</Attribute>
</Class>
<Name>MASTERDATA</Name>
<Attribute>
DB_EFFECTIVE_FROM
<IsLinkAttribute>true</IsLinkAttribute>
<DataType>INTEGER</DataType>
<Visible>false</Visible>
</Attribute>
<Attribute>
DB_EFFECTIVE_TO
<IsLinkAttribute>true</IsLinkAttribute>
<DataType>INTEGER</DataType>
<Visible>false</Visible>
</Attribute>
</Class>
 |
You must remove the <DisplayFormat> tags.
|