{ "userName" : "eRetail_Abandoned cart", "technicalName" : "eretail_abandonedcart", "businessKey" : "abandonedCartID", "autoGeneratedBusinessKey" : null, "description" : null, "creationTimeColumn" : "abandonedCartDate", "entityName" : "Dormg", "prettyNameExpression" : null, "layout" : null, "emails" : [ ], "capabilityDTOs" : [ { "name" : "Interaction" }, { "name" : "EventGeneratedTable" } ], "defaultFetchingParameters" : [ ], "links" : [ { "objectType" : "PROFILE_LINK", "linkName" : "profile-abandonedCarts", "sourceFieldName" : "profileId", "targetFieldName" : "profileId", "constraintType" : "onDeleteCascade", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedProfileTableName" : "Profiles" }, { "objectType" : "DATA_SOURCE_LINK", "linkName" : "abandonedCarts-store", "sourceFieldName" : "storeID", "targetFieldName" : "storeID", "constraintType" : "onDeleteCascade", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_stores" } ], "tableEventDefinitions" : [ { "technicalName" : "create", "userName" : "New", "tableEventConditionDefinitions" : [ { "updatedProperties" : [ ], "type" : "CREATE", "beforePredicate" : null, "afterPredicate" : null } ] } ], "fields" : [ { "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 abandoned cart", "type" : "NUMERIC", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null }, { "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" : "totalAmount", "columnName" : "c_totalAmount", "userName" : "Total Amount", "required" : false, "unique" : false, "extended" : false, "indexed" : false, "cacheIndexed" : false, "description" : "Total amount of the abandoned cart", "type" : "NUMERIC", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null }, { "objectType" : "SIMPLE", "fieldName" : "abandonedCartID", "columnName" : "c_abandonedCartID", "userName" : "Abandoned Cart ID", "required" : true, "unique" : true, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "The ID of the abandoned cart", "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" : "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 abandoned cart", "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" : "totalUniqueProduct", "columnName" : "c_totalUniqueProduct", "userName" : "Total Unique Product", "required" : false, "unique" : false, "extended" : false, "indexed" : false, "cacheIndexed" : false, "description" : "Number of abandoned cart lines", "type" : "LONG", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null }, { "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" : "abandonedCartDate", "columnName" : "c_abandonedCartDate", "userName" : "Date", "required" : true, "unique" : false, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "Date of the abandoned cart", "type" : "TIMESTAMP", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null } ], "compositeKeys" : [ ], "rowCleaning" : { "cleanPredicate" : null, "fifoLimit" : null, "softLimit" : false, "hardLimit" : false }, "valueField" : "totalAmount", "id" : "c90b0eed-b025-49ee-a295-a85114a7e13e", "entityId" : 1 }