Customer Attributes Table (SUCAA_SU09)

The Customer Attributes Table (ibis_sucaa) view allows you to define customer attributes that are unique to your site. Once attributes are created:

  • The attributes can be given values in the Customer Attribute Values (ibis_sucaav) view; this is optional.

  • The attribute can be assigned to customers and prospects in the Customer Attributes (SU13) (ibis_suca.su13) view.

  • Note: The Customer Attributes view is a related view linked to the Customers (ibis_sucu.su13) view.

Note: The ability to create and update information in Customer Attribute Table is controlled by the permissions (create, read, update and delete) assigned to the resource within the role. This help topic assumes that you have the appropriate permissions to create and update records in Customer Attribute Table. For more information, see Role Master-Permissions.

The following list defines every field available in the customer attribute table (sucaa) table in alphabetical order:

  • Attribute - enter an attribute or unique element/characteristic which will be used (optionally) with the customer record. The attribute can be a maximum of 32 alpha numeric characters in length. Once the record is created, you cannot modify this field.

  • Attribute Type - from the drop list, select the type associated with the attribute. Once the record is created, you cannot modify this field. Valid options and a description of how each option is used are listed below:

    A - Alphanumeric You can create multiple values for alphanumeric type attributes in the Customer Attribute Values view. When the attribute is added to the customer, you select one of the pre-defined alphanumeric values.
    You can also have no values added for the alphanumeric type attribute. When the attribute is added to the customer, the value entered is completely user-defined, i.e. a free-format field.
    D - Date The value added to the attribute will in date format. When the attribute is added to the customer, you select a date from the calendar look up.
    F - Flag The value is system defined as Yes or No. When the attribute is added to the customer, you select Yes or No from a drop list.
    I - Integer The value of the attribute will be an integer/whole number. When the attribute is added to the customer, you enter an integer in the integer field.
    N - Number The value of the attribute will be a number with up to 2 decimal places. When the attribute is added to the customer, you enter a number in the decimal field.

  • Company - the company field is available when you create a new customer attribute record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the customer attribute creation process only. Once the attribute record is created, the company to which the record is associated displays in the General section (at the top of the view).

  • Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Description - enter a description of the attribute. The description can be a maximum of 32 alpha numeric characters in length.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.