Column name Data type Required Default update able Data target Comments
external_key** VARCHAR (255) Yes* No alts_timesheet.ts_document_id The external key - Primary Key
user_ekey VARCHAR (255) Yes* No alts_timesheet.user_id The user the entry belongs to
import_status SMALLINT Yes Yes The import command/status (0=dont import, 1=do import, 2=success, 100+=re-process, -1=failed)
import_error_message VARCHAR (255) No No The import error message
import_change_timestamp DATETIME No No The import timestamp
submit_status SMALLINT Yes Yes The auto-submit command/status (0=dont submit, 1=do submit, 2=success, -1=failed)
submit_error_message VARCHAR (255) No No The submit error message
submit_change_timestamp DATETIME No No The submit timestamp
create_location_id_ekey VARCHAR (255) No Yes alts_timesheet.create_location_id Document element
keyword_date_in_period DATETIME Yes Yes The documents date-in-period
keyword_note TEXT No Yes The documents note

* System required field

** Value must be unique