1. User Guide
  2. Object Management
  3. Adding Management Ledger Class tables
  4. Setting Processing Key Property

3.6.4 Setting Processing Key Property

'Processing Key' user defined property needs to be set for the following columns within the transaction table: ID_NUMBER, IDENTITY_CODE, Leaf columns that are part of the unique index

The following are the steps to set this property in ERwin:
  1. Choose Physical View within the ERwin model.
  2. Choose TRANS_LEAF_COLUMNS super-class table.
  3. Choose the leaf column that needs to be set 'Processing Key' property.
  4. Go to UDP tab in Column Properties window for this column.
  5. Specify 'Yes' against 'Processing Key' user-defined property.
  6. Choose the custom transaction table.
  7. Go to UDP tab in Column Properties window for ID_NUMBER and IDENTITY_CODE columns.Specify Yes for Processing Key user-defined property.