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 distinct display levels: 'header' - displayed at the top of 15 - the form, 'body' - displayed lower down in forms. This may be useful in maintaining reporting consistency with the application. BANNER Integer Indicates whether the attribute is displayed in the entity O / M 1 0 banner (1) or not (0). The banner is the section displayed above the tabs for each entity.
The possible values are: 'PRV' - Project View attributes; 'SR' - Service Request attributes; 'ORD' - Order attributes; and 'ORDITEM' - Order Item attributes. 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 may be useful in maintaining reporting consistency with the application. O / M BANNER Integer 1 0 Indicates whether the attribute is displayed in the entity banner (1) or not (0). The banner is the section displayed above the tabs for each entity. O / M
ConSol_Datamart_Specification_v5.1.docx