{ "userName" : "eRetail_Abandoned cart lines", "technicalName" : "eretail_abandonedcartlines", "businessKey" : "abandonedCartLineID", "autoGeneratedBusinessKey" : null, "description" : null, "creationTimeColumn" : "abandonedCartDate", "entityName" : "Dormg", "prettyNameExpression" : null, "layout" : null, "emails" : [ ], "capabilityDTOs" : [ { "name" : "Interaction" }, { "name" : "EventGeneratedTable" } ], "defaultFetchingParameters" : [ ], "links" : [ { "objectType" : "DATA_SOURCE_LINK", "linkName" : "abandonedCartLines-store", "sourceFieldName" : "storeID", "targetFieldName" : "storeID", "constraintType" : "none", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_stores" }, { "objectType" : "DATA_SOURCE_LINK", "linkName" : "abandonedCartLines-product", "sourceFieldName" : "productSKU", "targetFieldName" : "SKU", "constraintType" : "none", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_productcatalog" }, { "objectType" : "DATA_SOURCE_LINK", "linkName" : "abandonedCartLines-abandonedCart", "sourceFieldName" : "abandonedCartID", "targetFieldName" : "abandonedCartID", "constraintType" : "onDeleteCascade", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_abandonedcart" }, { "objectType" : "PROFILE_LINK", "linkName" : "profile-order-lines", "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" : "totalAmount", "columnName" : "c_totalAmount", "userName" : "Total Amount", "required" : false, "unique" : false, "extended" : false, "indexed" : false, "cacheIndexed" : false, "description" : "Total amount of the abandoned cart line", "type" : "NUMERIC", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null }, { "objectType" : "SIMPLE", "fieldName" : "productSKU", "columnName" : "c_productSKU", "userName" : "Product SKU", "required" : true, "unique" : false, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "The ID of the product abandoned, it is used to link the line with the product.", "type" : "STRING", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : { "objectType" : "STRING_LENGTH", "minCharacters" : 0, "maxCharacters" : 255 } }, { "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" : "abandonedCartLineID", "columnName" : "c_abandonedCartLineID", "userName" : "Abandoned cart line ID", "required" : true, "unique" : true, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "The ID of the abandoned cart used to link the line with its cart.", "type" : "STRING", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : { "objectType" : "STRING_LENGTH", "minCharacters" : 0, "maxCharacters" : 255 } }, { "objectType" : "SIMPLE", "fieldName" : "quantity", "columnName" : "c_quantity", "userName" : "Quantity", "required" : false, "unique" : false, "extended" : false, "indexed" : false, "cacheIndexed" : false, "description" : "Quantity of products of the abandoned cart line", "type" : "LONG", "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" : "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" : "abandonedCartDate", "columnName" : "c_abandonedCartDate", "userName" : "Date", "required" : true, "unique" : false, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "Date of the abandoned cart line", "type" : "TIMESTAMP", "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" : "storeID", "columnName" : "c_storeID", "userName" : "Store ID", "required" : true, "unique" : false, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "The ID of the store where the abandoned cart was made. It is used to link the line with the store.", "type" : "STRING", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : { "objectType" : "STRING_LENGTH", "minCharacters" : 0, "maxCharacters" : 255 } }, { "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" : "unitPrice", "columnName" : "c_unitPrice", "userName" : "Unit price", "required" : false, "unique" : false, "extended" : false, "indexed" : false, "cacheIndexed" : false, "description" : "The unit price of the product at the moment of the abandoned cart.", "type" : "NUMERIC", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null } ], "compositeKeys" : [ ], "rowCleaning" : { "cleanPredicate" : null, "fifoLimit" : null, "softLimit" : false, "hardLimit" : false }, "valueField" : "totalAmount", "id" : "ff04fec8-00df-4941-aa4b-3a36d92f9928", "entityId" : 1 }