Use the Entity Configuration tables and forms to configure and map an entity that defines a structure and transfers the data from the source entity to the target entity.

Overview

Create the configurations and mappings for the entities by using the Entity Configuration tables.

Entity Configuration tables

The entity configuration tables provide you with the information for the fields on the entity configuration form.
Table 1. Entity Configuration tables
Table Name Description
Lead to Cash Entity sn_l2c_core_entity Defines and manages the lead-to-cash entities.
Lead to Cash Entity Definition sn_l2c_core_entity_definition Defines and manages the definitions that are associated with the lead-to-cash entities.
Lead to Cash Entity Attribute sn_l2c_core_entity_attribute Defines and manages the attributes that are associated with the lead-to-cash entities.

The lead-to-cash attributes are based on the definitions that are set for the entities.
Each field on the entity configuration form gathers the information from one entity configuration table. The following table has the information about the fields, their descriptions, and the entity tables that the data is populated from.
Note: The Lead to Cash Entity Definition and Lead to Cash Entity Attributes are related lists on the Entity Configuration form.
Table 2. Entity Configuration form
Table Field Description
Lead to Cash Entity Name Name of the lead-to-cash entity.
Lead to Cash Entity Config ID Unique configuration ID for the entity.
Lead to Cash Entity Active Status of the entity, whether active or inactive for the configuration.
Lead to Cash Entity Definition Entity Reference to the lead-to-cash entity definition.
Lead to Cash Entity Definition Type Type of the entity definition.
Note: Transaction Header, Transaction Line, Characteristic, Line Pricing Adjustments, and Covered Products are the different context types for a lead to cash entity.
Lead to Cash Entity Definition Table Table that is associated with a lead to cash entity.
Lead to Cash Entity Definition Label Label for the entity definition.
Lead to Cash Entity Definition Parent definition Parent of the current entity definition.
Lead to Cash Entity Definition Relationship field Query field that is associated with the parent entity definition record.
Lead to Cash Entity Definition Parent field Query field that is associated with the current entity definition record.
Lead to cash Entity Definition Inherit parent definition Parent definition that is also used by the current entity definition.
Note: To make the current entity definition record follow the same definition that is associated to the parent record, select Inherit parent definition.
Lead to Cash Entity Definition Order Numerical order to process and visualize the hierarchy of configurations.
Lead to Cash Entity Attribute Field Name of the field.
Lead to Cash Entity Attribute Entity Reference to the lead-to-cash entity attribute.
Lead to Cash Entity Attribute Table Table that is associated with the lead-to-cash attribute.
Lead to Cash Entity Attribute Key Unique key for the entity attribute.
Lead to Cash Entity Attribute Advanced Option for advanced configurations.
Note: To modify the script according to your requirements, select Advanced.
Lead to Cash Entity Attribute Script Script for the advanced attributes.

Entity mappings

With entity mappings, you can map the source and target tables to transfer the data between the entities that depend on the available entity configurations. The entity mapping tables provide the information for the fields on the entity mapping forms.
Table 3. Entity Mapping table
Table Name Description
Lead to Cash Entity Mapping sn_l2c_core_entity_mapping Defines and maps the lead-to-cash entity mappings.
Lead to Cash Entity Table Mapping sn_l2c_core_entity_table_mapping Defines and manages the mappings for the different tables that are associated with the lead-to-cash entities.
Lead to Cash Entity Attribute Mapping sn_l2c_core_entity_attribute_mapping Defines and manages the attributes and their mappings with the corresponding lead-to-cash entity.
The entity mapping form enables you to map the entities with their corresponding tables and attributes.
Note: The Lead to Cash Entity Table Mapping and Lead to Cash Entity Attribute Mapping are related lists on the Entity Mapping form.
Table 4. Entity Mapping form
Table Field Description
Lead to Cash Entity Mapping Mapping name Name of the mapping.
Lead to Cash Entity Mapping Mapping config ID Unique ID for the mapping.
Lead to Cash Entity Mapping Source entity Source entity in the mapping process.
Lead to Cash Entity Mapping Target entity Target entity in the mapping process.
Lead to Cash Entity Mapping Active State of the target entity, whether active for mapping or not.
Lead to Cash Entity Table Mapping Source entity table Table that is associated with the source entity.
Lead to Cash Entity Table Mapping Target entity table Table that is associated with the target entity.
Lead to Cash Entity Table Mapping Use condition Conditions required for mapping.
Note: To set specific mapping conditions, select Use condition.
Lead to Cash Entity Table Mapping Condition Conditions for mapping tables from the source entity to the target entity.
Lead to Cash Entity Table Mapping Active State of the source entity, whether active for mapping or not.
Lead to Cash Entity Table Mapping Order Numerical priority for mapping.
Lead to Cash Entity Attribute Mapping Entity table mapping Reference to the Lead-to-Cash entity table mapping.
Lead to Cash Entity Attribute Mapping Source attribute Attribute that is associated with the source entity.
Lead to Cash Entity Attribute Mapping Target attribute Attribute that is associated with the target entity.
Lead to Cash Entity Attribute Mapping Advanced Option for advanced mapping.
Note: To modify the script according to your requirements, select Advanced.
Lead to Cash Entity Attribute Mapping Script Script to customize the mappings.