SCV Inbox table creation
The Sync SCV Configuration program generates or updates an SCV table as
follows:
- Determines the corresponding SCV Inbox table name as
follows:
If <current entity>.C_IS_SYSTEM = "T" then <table name> = SI_<current entity>.C_NAME Else <table name> = SUI_<current entity>.C_NAME
- If a table is not available with the corresponding SCV Inbox table name in the SCV
database:
- Creates an SCV table from entity definition using the following planning process,
control, and custom columns specified in the inbox_flag column of the column registry
table:
Planning process columns: cycle_period_id NVARCHAR(80) scenario_id NVARCHAR(80) source NVARCHAR(80) Control columns: scp_ref NVARCHAR(150) external_ref NVARCHAR(150) deleted_flag NVARCHAR(1) -- created_by NVARCHAR(80) creation_time DATETIME2(7) modified_by NVARCHAR(80) modification_time DATETIME2(7) Custom columns: custom_string_1-10 NVARCHAR(80) custom_number_1-10 FLOAT custom_date_1-5 DATETIME2(7)
- Creates an SCV table from entity definition using the following planning process,
control, and custom columns specified in the inbox_flag column of the column registry
table:
- If the table is available in the SCV database with the same name as SCV Inbox table:
- Updates an SCV table from entity definition if the related column is not available in <table name> for each property in <current entity>.