Used to determine what to use for a prefix and suffix when generating call request numbers. Users may not create new records or delete records in this table.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
description |
STRING 240 |
|
Textual description |
|
code |
STRING 12 UNIQUE NOT_NULL S_KEY |
|
noneditable key for record |
|
del |
INTEGER NOT_NULL |
Active_Boolean_Table::enum |
Deleted flag 0—Active 1—Inactive/marked as deleted |
|
id |
INTEGER UNIQUE NOT_NULL KEY |
|
Unique (to the table) Numeric ID |
|
last_mod_by |
UUID |
ca_contact::uuid |
Specifies the UUID of the contact who last modified this record. |
|
last_mod_dt |
LOCAL_TIME |
|
Indicates the timestamp of when this record was last modified. |
|
prefix |
STRING 5 |
|
Indicates the prefix to sequence number. |
|
suffix |
STRING 5 |
|
Indicates the suffix to sequence number. |
|
sym |
STRING 30 NOT_NULL |
|
|
|
Copyright © 2013 CA.
All rights reserved.
|
|