SCV Planning Configuration table creation

The Sync SCV Configuration program creates or updates an SCV Planning Configuration table as follows:

Determines the corresponding SCV Planning Configuration table name:

If <current entity>.C_IS_SYSTEM = "T" then <table name> = SM_<current entity>.C_NAME
Else <table name> = SUM_<current entity>.C_NAME

If the table is not available in the SCV database with the corresponding SCV Planning Configuration table name:

Creates an SCV table from entity definition using these columns for the Inbox specified in the planning_configuration_table_flag column of the column registry table:

Planning process columns:
    cycle_period_id             NVARCHAR(80)  
    scenario_id                 NVARCHAR(80)  
    source                      NVARCHAR(80)  
    --
    scp_validated_flag          NVARCHAR(1)  
    scp_validation_passed_flag  NVARCHAR(1)  
    scp_validation_status       NVARCHAR(30)  

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 ID index on the ID column.

If the table name is available in the SCV database with the corresponding SCV Planning Configuration table name:
- Updates an SCV table from entity definition if the corresponding column is not available in <table name> for each property in <current entity>.