private CustomerBrokerClose getCustomerBrokerCloseFromRecord(DatabaseTableRecord record)
      throws InvalidParameterException {

    UUID transactionId =
        record.getUUIDValue(
            CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                .CUSTOMER_BROKER_CLOSE_TRANSACTION_ID_COLUMN_NAME);
    UUID negotiationId =
        record.getUUIDValue(
            CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                .CUSTOMER_BROKER_CLOSE_NEGOTIATION_ID_COLUMN_NAME);
    String publicKeyBroker =
        record.getStringValue(
            CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                .CUSTOMER_BROKER_CLOSE_PUBLIC_KEY_BROKER_COLUMN_NAME);
    String publicKeyCustomer =
        record.getStringValue(
            CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                .CUSTOMER_BROKER_CLOSE_PUBLIC_KEY_CUSTOMER_COLUMN_NAME);
    NegotiationTransactionStatus status =
        NegotiationTransactionStatus.getByCode(
            record.getStringValue(
                CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                    .CUSTOMER_BROKER_CLOSE_STATUS_COLUMN_NAME));
    NegotiationType negotiationType =
        NegotiationType.getByCode(
            record.getStringValue(
                CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                    .CUSTOMER_BROKER_CLOSE_NEGOTIATION_TYPE_COLUMN_NAME));
    String negotiationXML =
        record.getStringValue(
            CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                .CUSTOMER_BROKER_CLOSE_NEGOTIATION_XML_COLUMN_NAME);
    long timestamp =
        record.getLongValue(
            CustomerBrokerCloseNegotiationTransactionDatabaseConstants
                .CUSTOMER_BROKER_CLOSE_TIMESTAMP_COLUMN_NAME);

    return new CustomerBrokerCloseImpl(
        transactionId,
        negotiationId,
        publicKeyBroker,
        publicKeyCustomer,
        status,
        negotiationType,
        negotiationXML,
        timestamp);
  }