{
  "userName" : "eRetail_Orders",
  "technicalName" : "eretail_orders",
  "businessKey" : "orderID",
  "autoGeneratedBusinessKey" : null,
  "description" : null,
  "creationTimeColumn" : "orderDate",
  "entityName" : "Dormg",
  "prettyNameExpression" : null,
  "layout" : null,
  "emails" : [ ],
  "capabilityDTOs" : [ {
    "name" : "Interaction"
  }, {
    "name" : "EventGeneratedTable"
  } ],
  "defaultFetchingParameters" : [ ],
  "links" : [ {
    "objectType" : "DATA_SOURCE_LINK",
    "linkName" : "order-store",
    "sourceFieldName" : "storeID",
    "targetFieldName" : "storeID",
    "constraintType" : "onDeleteCascade",
    "targetedEntityName" : "Dormg",
    "skipIntegrityCheck" : null,
    "targetedDataSourceName" : "eretail_stores"
  }, {
    "objectType" : "PROFILE_LINK",
    "linkName" : "profile-orders",
    "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" : "totalProduct",
    "columnName" : "c_totalProduct",
    "userName" : "Total product",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "Number of products",
    "type" : "LONG",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "orderID",
    "columnName" : "c_orderID",
    "userName" : "Order ID",
    "required" : true,
    "unique" : true,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "The ID of the order",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "orderDate",
    "columnName" : "c_orderDate",
    "userName" : "Date",
    "required" : true,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "Date of the order",
    "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 order",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "voucherCode",
    "columnName" : "c_voucherCode",
    "userName" : "Voucher Code",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "the voucher code used",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "storeID",
    "columnName" : "c_storeID",
    "userName" : "Store ID",
    "required" : true,
    "unique" : true,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "The ID of the store where the order was made",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 255
    }
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "status",
    "columnName" : "c_status",
    "userName" : "Status",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : true,
    "description" : "The status of the order.",
    "type" : "STRING",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : {
      "objectType" : "STRING_LENGTH",
      "minCharacters" : 0,
      "maxCharacters" : 50
    }
  }, {
    "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" : "totalNonArticleAmount",
    "columnName" : "c_totalNonArticleAmount",
    "userName" : "Total Non Article Amount",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "Total amount not from articles of the order",
    "type" : "NUMERIC",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "profileId",
    "columnName" : "c_profileId",
    "userName" : "profileId",
    "required" : true,
    "unique" : false,
    "extended" : false,
    "indexed" : true,
    "cacheIndexed" : false,
    "description" : "The unique key making the link with the profile table",
    "type" : "LONG",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "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" : "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" : "shipping",
    "columnName" : "c_shipping",
    "userName" : "Shipping",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : true,
    "description" : "The shipping of the order.",
    "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
  }, {
    "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 order",
    "type" : "NUMERIC",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "totalArticleAmount",
    "columnName" : "c_totalArticleAmount",
    "userName" : "Total Article Amount",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "Total amount from articles of the order",
    "type" : "NUMERIC",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  }, {
    "objectType" : "SIMPLE",
    "fieldName" : "totalUniqueProduct",
    "columnName" : "c_totalUniqueProduct",
    "userName" : "Total Unique Product",
    "required" : false,
    "unique" : false,
    "extended" : false,
    "indexed" : false,
    "cacheIndexed" : false,
    "description" : "Number of order lines",
    "type" : "LONG",
    "possibleValues" : [ ],
    "valueDisplayer" : null,
    "typeValidator" : null
  } ],
  "compositeKeys" : [ ],
  "rowCleaning" : {
    "cleanPredicate" : null,
    "fifoLimit" : null,
    "softLimit" : false,
    "hardLimit" : false
  },
  "valueField" : "totalAmount",
  "id" : "c0cd3b59-5171-46a7-b459-f2491d299af2",
  "entityId" : 1
}