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)  
      
  • 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>.