| customer_code_id |
int8 |
19 |
|
|
null |
|
|
The primary key of this table. System column calculated by the source System. |
| name |
varchar |
256 |
|
|
null |
|
|
The name of the customer code. |
| description |
varchar |
256 |
|
|
null |
|
|
The description of the customer code. |
| color_hex |
varchar |
256 |
√ |
|
null |
|
|
The color of the customer code in hexadecimal format displayed on the UI. |
| active |
bool |
1 |
|
|
null |
|
|
Whether the customer code currently is assignable to customers. |
| archived |
bool |
1 |
|
|
null |
|
|
Permanently removed but kept for historic relations. |
| last_updated |
timestamptz |
35 |
√ |
|
null |
|
|
System column. UTC Timestamp at which entry was calculated (lags behind source system). |
