Creating and Updating the Business Components for Many-to-Many Effective Dating Records
After you create and update the tables for effective dating records, you create a history business component for the history table, and you update the parent and child business components.
To create and update the business components for effective dating records
Use the wizard to create the history business component in the PUB Effective Dating project using the history table.
In this example, the name of the history business component is Account Contact ED.
The following table includes the field and column names for the history business component.
Field Name Column Name Join Type Field Name
FIELD_NAME
None
DTYPE_TEXT
Field Value
FIELD_VALUE
None
DTYPE_TEXT
Effective Start Date
EFF_START_DATE
None
DTYPE_UTCDATE
Effective End Date
EFF_END_DATE
None
DTYPE_UTCDATE
Created By UserName
LOGIN
S_USER
DTYPE_TEXT
Deliver the changes to the Integration Branch.
In the PUB Effective Dating project, create the links between the parent or child business components and the history business components.
The following table includes the parent business components, child business components, history business components, source fields, and destination fields for each link in this example.
Link Name Parent Business Component Child Business Component History Business Component Source Field Destination Field Account/Account History
Account
None
Account History
Id
Parent Id
Contact/Contact History
None
Contact
Contact History
Id
Parent Id
Account/Account Contact ED
Account
None
Account Contact ED
Contact/Account.Id
Parent Id
Contact/Account Contact ED
None
Contact
Account Contact ED
Account/Contact.Id
Parent Id
Use these links to add the history business components to the two business objects for the parent and child business components.
The following table includes the links to use to add the history business components to the business objects for the parent and child business components in this example.
Link Name History Business Component Business Object Account/Account History
Account History
Account
Contact/Contact History
Contact History
Account
Contact/Account Contact ED
Account Contact ED
Account
Account/Account History
Account History
Contact
Contact/Contact History
Contact History
Contact
Account/Account Contact ED
Account Contact ED
Contact
Add a field to the parent and child business component.
The following table includes the values in the columns for the field name in the parent and child business component.
Business Component Name Join Column Type Account
Contact/Acount.ED_DELETED_FLG
S_PARTY_PER
ED_DELETED_FLG
DTYPE_FLG
Contact
Account/Contact.ED_DELETED_FLG
S_PARTY_PER
ED_DELETED_FLG
DTYPE_FLG
Add user properties to the parent and child business component.
The following table includes the values in the columns for the user property names in the parent and child business component.
Business Component Name Value Account
ED Link BusComp:Contact/Account
Account Contact ED
Contact
ED Link BusComp:Account/Contact
Account Contact ED
Deliver the changes to the Integration Branch.