Previous Topic: sa_event_type_param TableNext Topic: sa_field_type Table


sa_field Table

Program control table used bySupport Automation.

Field

Data Type

Reference

Remarks

id

INTEGER

 

KEY

fieldType

INTEGER

sa_field_type

NOT_NULL

fieldName

STRING 50

 

NOT_NULL

fieldOrder

INTEGER

 

NOT_NULL

mandatory

INTEGER

 

NOT_NULL

active

INTEGER

 

NOT_NULL

displayName

STRING 150

 

 

guestMandatory

INTEGER

 

NOT_NULL

last_mod_by

UUID

cnt

Specifies the UUID of the contact who last modified this record.

last_mod_dt

LOCAL_TIME

 

Specifies the timestamp of when this record was last modified.

tenant

UUID

ca_tenant

Specifies the UUID of the tenant.