presented for selection on orders with the specified ESA attribute values. This flag indicates that the attribute is available to restrict work order allocation on contracts. BUSINESS_OBJECT String Attributes can be attached to different ConSol entities. O / M This indicates which entity the attribute applies to. 8 - The possible values are: 'PRV' - Project View attributes; 'SR' - Service Request attributes; 'ORD' - Order attributes; and 'ORDITEM' - Order Item attributes. VIEW_BY String Identifies who is allowed to view the attribute within the M / M application. The possible values are: 'SUPPLIER' - only the supplier can 8 - view the attribute; 'CUSTOMER' - Only the customer can view the attribute; 'BOTH' both customer and supplier – can view the attribute EDIT_BY String Identifies who is able to edit the attribute within the M / M application. The possible values are: 'SUPPLIER' - only the supplier can 8 - edit the attribute; 'CUSTOMER' - Only the customer can edit the attribute; 'BOTH' both customer and supplier – can edit the attribute DATA_TYPE String ConSol currently supports five distinct data types for O / M attributes. These are: 'text' a string of text that accepts – most character values; 'date' a date in dd/mm/yyyy – 15 - format; 'list' a defined list of coded values and – descriptions; 'currency' numeric value in currency – format ($9999.99); and 'number' numeric value. – DISPLAY_LEVEL String Attributes in the application can be marked with two O / M 15 - distinct display levels: 'header' - displayed at the top of the form, 'body' - displayed lower down in forms. This
presented for selection on orders with the specified ESA attribute values. This flag indicates that the attribute is available to restrict work order allocation on contracts. BUSINESS_OBJECT String 8 - Attributes can be attached to different ConSol entities. This indicates which entity the attribute applies to. The possible values are: 'PRV' - Project View attributes; 'SR' - Service Request attributes; 'ORD' - Order attributes; and 'ORDITEM' - Order Item attributes. O / M VIEW_BY String 8 - Identifies who is allowed to view the attribute within the application. The possible values are: 'SUPPLIER' - only the supplier can view the attribute; 'CUSTOMER' - Only the customer can view the attribute; 'BOTH' – both customer and supplier can view the attribute M / M EDIT_BY String 8 - Identifies who is able to edit the attribute within the application. The possible values are: 'SUPPLIER' - only the supplier can edit the attribute; 'CUSTOMER' - Only the customer can edit the attribute; 'BOTH' – both customer and supplier can edit the attribute M / M DATA_TYPE String 15 - ConSol currently supports five distinct data types for attributes. These are: 'text' – a string of text that accepts most character values; 'date' – a date in dd/mm/yyyy format; 'list' – a defined list of coded values and descriptions; 'currency' – numeric value in currency format ($9999.99); and 'number' – numeric value. O / M DISPLAY_LEVEL String 15 - Attributes in the application can be marked with two distinct display levels: 'header' - displayed at the top of the form, 'body' - displayed lower down in forms. This O / M
ConSol_Datamart_Specification_v6.0.docx