{ "userName" : "eRetail_Orders lines", "technicalName" : "eretail_orderslines", "businessKey" : "orderLineID", "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-line-product", "sourceFieldName" : "productSKU", "targetFieldName" : "SKU", "constraintType" : "none", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_productcatalog" }, { "objectType" : "DATA_SOURCE_LINK", "linkName" : "order-line-order", "sourceFieldName" : "orderID", "targetFieldName" : "orderID", "constraintType" : "onDeleteCascade", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_orders" }, { "objectType" : "DATA_SOURCE_LINK", "linkName" : "order-line-store", "sourceFieldName" : "storeID", "targetFieldName" : "storeID", "constraintType" : "none", "targetedEntityName" : "Dormg", "skipIntegrityCheck" : null, "targetedDataSourceName" : "eretail_stores" }, { "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" : "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 order.", "type" : "NUMERIC", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null }, { "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 order was made. It is used to link the order line with the store.", "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" : "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" : "productSKU", "columnName" : "c_productSKU", "userName" : "Product SKU", "required" : true, "unique" : false, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "The ID of the product ordered, it is used to link to the order line with the product.", "type" : "STRING", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : { "objectType" : "STRING_LENGTH", "minCharacters" : 0, "maxCharacters" : 255 } }, { "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 line", "type" : "NUMERIC", "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 used to link the line with its order.", "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" : "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" : "orderLineID", "columnName" : "c_orderLineID", "userName" : "Order Line ID", "required" : true, "unique" : true, "extended" : false, "indexed" : true, "cacheIndexed" : false, "description" : "The ID of the order line", "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 ordered", "type" : "LONG", "possibleValues" : [ ], "valueDisplayer" : null, "typeValidator" : null }, { "objectType" : "SIMPLE", "fieldName" : "orderDate", "columnName" : "c_orderDate", "userName" : "Order 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" : "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" : "6b0b6f1a-ce43-4040-aa1b-4714a1b47063", "entityId" : 1 }