We decided to have a history table for PM records also so that we know that who and when actually this record was modified.
1. in database configuration create a new object:
| Attribute | Type | Length | ||
| CHANGEBY | UPPER | 30 | ||
| CHANGEDATE | DATETIME | 10 | ||
| DESCRIPTION | ALN | 50 | ||
| DESCRIPTION_LONGDESCRIPTION | LONGALN | 32000 | ||
| HASLD | YORN | 1 | ||
| MEMO | ALN | 50 | ||
| ORGID | UPPER | 8 | ||
| PMNUM | UPPER | 20 | ||
| PMSTATUSID | BIGINT | 19 | ||
| SITEID | UPPER | 8 | ||
| STATUS | UPPER | 20 |
