{ "userName": "Simple Orders", "technicalName": "simpleOrders", "businessKey": "orderID", "autoGeneratedBusinessKey": false, "description": null, "creationTimeColumn": "orderDate", "entityName": "{{entityName}}", "prettyNameExpression": null, "layout": { "list": null, "details": null }, "emails": [], "capabilityDTOs": [ { "name": "Interaction" }, { "name": "EventGeneratedTable" } ], "defaultFetchingParameters": [], "links": [ { "objectType": "PROFILE_LINK", "linkName": "profile-orders", "constraintType": "onDeleteCascade", "sourceFieldName": "{{profileKeyAttribute}}", "targetFieldName": "{{profileKeyAttribute}}", "targetedEntityName": "{{entityName}}", "targetedProfileTableName": "{{tableName}}" } ], "tableEventDefinitions": [ { "technicalName": "create", "userName": "New order", "tableEventConditionDefinitions": [ { "updatedProperties": [], "type": "CREATE", "beforePredicate": null, "afterPredicate": null } ] } ], "fields": [ { "objectType": "SIMPLE", "fieldName": "date", "columnName": "date", "userName": "Date", "required": false, "unique": false, "extended": false, "indexed": true, "cacheIndexed": false, "description": "Date of the order", "type": "TIMESTAMP", "possibleValues": [], "valueDisplayer": null, "typeValidator": null }, { "objectType": "SIMPLE", "fieldName": "productName", "columnName": "productName", "userName": "Product Name", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": true, "description": "The name of the product ordered", "type": "STRING", "possibleValues": [], "valueDisplayer": null, "typeValidator": { "objectType": "STRING_LENGTH", "minCharacters": 0, "maxCharacters": 256 } }, { "objectType": "SIMPLE", "fieldName": "productDescription", "columnName": "productDescription", "userName": "Product descritpion", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": true, "description": "The description of the product ordered", "type": "STRING", "possibleValues": [], "valueDisplayer": null, "typeValidator": { "objectType": "STRING_LENGTH", "minCharacters": 0, "maxCharacters": 256 } }, { "objectType": "SIMPLE", "fieldName": "totalAmount", "columnName": "totalAmount", "userName": "Total Amount", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": false, "description": "Total amount of the order", "type": "NUMBER", "possibleValues": [], "valueDisplayer": null, "typeValidator": null }, { "objectType": "SIMPLE", "fieldName": "productUnitPrice", "columnName": "productUnitPrice", "userName": "Product Unit Price", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": false, "description": "Total amount of the order", "type": "NUMBER", "possibleValues": [], "valueDisplayer": null, "typeValidator": null }, { "objectType": "SIMPLE", "fieldName": "productQuantity", "columnName": "productQuantity", "userName": "Product quantity", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": false, "description": "Quantity of articles ordered", "type": "LONG", "possibleValues": [], "valueDisplayer": null, "typeValidator": null }, { "objectType": "SIMPLE", "fieldName": "paymentMethod", "columnName": "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": null, "valueDisplayer": null, "typeValidator": { "objectType": "STRING_LENGTH", "minCharacters": 0, "maxCharacters": 50 } }, { "objectType": "SIMPLE", "fieldName": "currency", "columnName": "currency", "userName": "Currency", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": true, "description": "The currency.", "type": "STRING", "possibleValues": [], "valueDisplayer": null, "typeValidator": { "objectType": "STRING_LENGTH", "minCharacters": 0, "maxCharacters": 50 } }, { "objectType": "SIMPLE", "fieldName": "shippingMode", "columnName": "shippingMode", "userName": "Shipping Mode", "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": "shippingAmount", "columnName": "shippingAmount", "userName": "Shipping amount", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": false, "description": "The amount of the shipping", "type": "NUMBER", "possibleValues": [], "valueDisplayer": null, "typeValidator": null }, { "objectType": "SIMPLE", "fieldName": "status", "columnName": "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": "storeName", "columnName": "storeName", "userName": "Store name", "required": false, "unique": false, "extended": false, "indexed": false, "cacheIndexed": true, "description": "The name of the store where the order was made", "type": "String", "possibleValues": [], "valueDisplayer": null, "typeValidator": { "objectType": "STRING_LENGTH", "minCharacters": 0, "maxCharacters": 256 } }, { "objectType": "SIMPLE", "fieldName": "orderID", "columnName": "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": null }, { "objectType": "SIMPLE", "fieldName": "{{profileKeyAttribute}}", "columnName": "{{profileKeyAttribute}}", "userName": "{{profileKeyAttribute}}", "required": true, "unique": false, "extended": false, "indexed": true, "cacheIndexed": false, "description": "The reconciliation key with the profile table.", "type": "{{profileKeyAttributeDataType}}", "possibleValues": [], "valueDisplayer": null, "typeValidator": null } ], "rowCleaning": { "cleanPredicate": null, "fifoLimit": null, "softLimit": false, "hardLimit": false } }