SCV Outbox table creation

The Sync SCV Configuration program creates or updates an SCV Outbox table as follows:
  • Determines the corresponding SCV Outbox table name:
    If <current entity>.C_IS_SYSTEM = "T" then <table name> = SO_<currententity>.C_NAME
Else <table name> = SUO_<current entity>.C_NAME
  • If the table is not available in the SCV database with the corresponding SCV Outbox table name:
    • Creates an SCV table from entity definition using this planning process, control, and custom columns specified in the outbox_flag column of the column registry table:
      Planning process columns:
    cycle_period_id             NVARCHAR(80)  
    scenario_id                 NVARCHAR(80)  
    source                      NVARCHAR(80)  
    --
    export_status               NVARCHAR(30),  

Control columns:
    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 corresponding SCV Outbox 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>.