Entity synchronization

You can synchronize entity definitions from the IBP database to SCV. The Sync SCV Configuration program performs these actions on each entity definition in the IBP_SCV_ENTITY table as follows:
  • Synchronizes the entity definition from IBP tables to SCV tables. This table lists the entities that are available in the IBP and SCV tables:
    IBP Table SCV Table Level
    IBP_SCV_ENTITY SZ_ENTITY Header
    IBP_SCV_ENTITY_PROPERTY IBP_SCV_ENTITY_PROPERTY Detail
    IBP_SCV_ENTITY_PROPERTY_EXT SZ_ENTITY_PROPERTY_EXT Extension Detail
    Note: 
    • Records in the IBP header table updates the SCV header table and adds new entities.
    • New properties are only added to the Extension Detail and the Detail record levels.
  • Creates an SCV table from the entity definition:
    CREATE TABLE <current table> AS (  
    <planning process columns>
    --  
    <one column for each property in current entity>  
    --  
    <control columns>
    --  
    <custom columns>
    --  
    id          BIGINT IDENTITY(1,1)    NOT NULL  
);
    Note: The planning process columns included in the table vary based on the table area. For example, the planning process columns are different in the SCV Inbox and the SCV Export Staging tables.
  • Creates an index on the ID column:
    CREATE UNIQUE NONCLUSTERED INDEX <current table>_ID_IDX 
    ON <current table>
    (id ASC)
  • Updates an SCV table from entity definition as follows:
    • If the corresponding column is not available in <current table> for each property:
      ALTER TABLE <current table>
    ADD COLUMN <property in current entity>,  
);
    • If the corresponding column is available in <current table> for each property:
      Do nothing.
  • Processes each entity definition in the IBP_SCV_ENTITY table as follows:
    • If C_INBOX_ENABLED = "T", creates or updates the related SCV Inbox table.
    • If C_CORE_ENABLED = "T" and C_PLAN_TABLE = 'F', creates or updates the related inbound SCV Core table.
    • If C_CORE_ENABLED = "T" and C_PLAN_TABLE = 'T', creates or updates the related outbound SCV Core table.
    • If C_OUTBOX_ENABLED = "T", creates or updates the related SCV Outbox table.
    • If C_STAGING_ENABLED = "T", creates or updates the related SCV Staging table.
    • If C_PLANCONF_ENABLED = "T", creates or updates the corresponding SCV Planning Configuration table.
    • If C_EXTENSION_ENABLED = "T", creates or updates the related SCV Extension Data table.
  • Generates or updates an SCV Inbox table. See SCV Inbox table creation for more details.
  • Generates or updates an inbound SCV Core table. See Inbound SCV Core table creation for more details.
  • Generates or updates a outbound SCV Core table similar to inbound SCV Core using the planning process, control, and custom columns specified in the core_plan_flag column of the column registry table.
  • Generates or updates an SCV Outbox table. See SCV Outbox table creation for more details.
  • Generates or updates an SCV Staging table. See SCV Staging table creation for more details.
  • Generates or updates an SCV Planning Configuration table. See SCV Planning Configuration table creation for more details.
  • Generates or updates an SCV Extension Data table when a standard entity is extended. See SCV Extension Data table creation for more details.