{
  "userName" : "Subscription_Subscription purchases",
  "technicalName" : "subscription_subscriptionpurchases",
  "businessKey" : "subscriptionPurchaseID",
  "autoGeneratedBusinessKey" : null,
  "description" : null,
  "creationTimeColumn" : "subscriptionPurchasesDate",
  "entityName" : "Dormg",
  "prettyNameExpression" : null,
  "layout" : null,
  "emails" : [ ],
  "capabilityDTOs" : [ {
    "name" : "Interaction"
  }, {
    "name" : "EventGeneratedTable"
  } ],
  "defaultFetchingParameters" : [ ],
  "links" : [ {
    "objectType" : "DATA_SOURCE_LINK",
    "linkName" : "subscription-catalog",
    "sourceFieldName" : "subscriptionID",
    "targetFieldName" : "subscriptionID",
    "constraintType" : "onDeleteCascade",
    "targetedEntityName" : "Dormg",
    "skipIntegrityCheck" : null,
    "targetedDataSourceName" : "subscription_subscriptioncatalog"
  }, {
    "objectType" : "PROFILE_LINK",
    "linkName" : "profile-subscription-purchases",
    "sourceFieldName" : "profileId",
    "targetFieldName" : "profileId",
    "constraintType" : "onDeleteCascade",
    "targetedEntityName" : "Dormg",
    "skipIntegrityCheck" : null,
    "targetedProfileTableName" : "Profiles"
  } ],
  "tableEventDefinitions" : [ {
    "technicalName" : "create",
    "userName" : "New",
    "tableEventConditionDefinitions" : [ {
      "updatedProperties" : [ ],
      "type" : "CREATE",
      "beforePredicate" : null,
      "afterPredicate" : null
    } ]
  } ],
  "fields" : [ {
    "objectType" : "SIMPLE",
    "fieldName" : "subscriptionPurchasesDate",
    "columnName" : "c_subscriptionPurchasesDate",
    "userName" : "Date",
    "required" : true,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "Date of the subscription purchase",
    "type" : "TIMESTAMP",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "endDate",
    "columnName" : "c_endDate",
    "userName" : "End date",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "End date of the subscription",
    "type" : "TIMESTAMP",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "updateMoment",
    "columnName" : "updateMoment",
    "userName" : null,
    "required" : true,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : null,
    "type" : "TIMESTAMP",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "source",
    "columnName" : "c_source",
    "userName" : "Source",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : true,
    "description" : "The source of the subscription purchase.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "subscriptionID",
    "columnName" : "c_subscriptionID",
    "userName" : "Subscription ID",
    "required" : true,
    "unique" : true,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "The ID of the subscription purchaseed, it is used as link with the subscription catalog",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "subscriptionPurchaseID",
    "columnName" : "c_subscriptionPurchaseID",
    "userName" : "Subscription purchase ID",
    "required" : true,
    "unique" : true,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "The ID of the subscription purchase",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "profileId",
    "columnName" : "c_profileId",
    "userName" : "profileId",
    "required" : true,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "The reconciliation key with the profile table.",
    "type" : "LONG",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "status",
    "columnName" : "c_status",
    "userName" : "Status",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : true,
    "description" : "The status of the subscription purchase.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientAddressCity",
    "columnName" : "c_recipientAddressCity",
    "userName" : "Recipient address city",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient address city of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientEmailAddress",
    "columnName" : "c_recipientEmailAddress",
    "userName" : "Recipient e-mail address",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient e-mail address of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientAddressStreet",
    "columnName" : "c_recipientAddressStreet",
    "userName" : "Recipient address street",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient address street of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "id",
    "columnName" : "id",
    "userName" : null,
    "required" : true,
    "unique" : true,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : null,
    "type" : "LONG",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientAddressCountry",
    "columnName" : "c_recipientAddressCountry",
    "userName" : "Recipient address country",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient address country of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : {
      "displayerType" : "Country"
    },
    "typeValidator" : {
      "objectType" : "COUNTRY"
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientAddressPostalCode",
    "columnName" : "c_recipientAddressPostalCode",
    "userName" : "Recipient address postal code",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient address postal code of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "currency",
    "columnName" : "c_currency",
    "userName" : "Currency",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The currency.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "startDate",
    "columnName" : "c_startDate",
    "userName" : "Start date",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "Start date of the subscription",
    "type" : "TIMESTAMP",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "paymentMethod",
    "columnName" : "c_paymentMethod",
    "userName" : "Payment Method",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : true,
    "description" : "The payment method used to pay the purchase",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "totalAmount",
    "columnName" : "c_totalAmount",
    "userName" : "Total Amount",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "Total amount of the subscription purchase",
    "type" : "NUMERIC",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientFirstname",
    "columnName" : "c_recipientFirstname",
    "userName" : "Recipient firstname",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient firstname of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "recipientLastname",
    "columnName" : "c_recipientLastname",
    "userName" : "Recipient lastname",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "The recipient lastname of the subscription.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "creationMoment",
    "columnName" : "creationMoment",
    "userName" : null,
    "required" : true,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : null,
    "type" : "TIMESTAMP",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  } ],
  "compositeKeys" : [ ],
  "rowCleaning" : {
    "cleanPredicate" : null,
    "fifoLimit" : null,
    "softLimit" : false,
    "hardLimit" : false
  },
  "valueField" : "totalAmount",
  "id" : "87fa5161-fbe6-4575-af96-036ef871de7d",
  "entityId" : 1
}