Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_DII_CIM_DB_Export_Calendars
|
{
|
MDSDefinition: LibDII_CIM_IntegrationDataset
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Source Source_DII_CIM_DB_Export_Calendars
|
{
|
EDIMLTable LibCIM_Calendar
|
{
|
PrimaryKeyColumns: CalendarID
|
PrimaryKeyColumns: CalendarType
|
TargetType: LibCIM_Calendar
|
TypeIndex: LibCIM_Calendar_ByTypeAndID
|
EDIMLColumn Base { Attribute: Base ValueType: DateTime }
|
EDIMLColumn CalendarID { Attribute: CalendarID ValueType: String }
|
EDIMLColumn CalendarType { Attribute: CalendarType ValueType: String }
|
EDIMLColumn History { Attribute: History ValueType: Number }
|
EDIMLColumn IsAlwaysAvailable { Attribute: IsAlwaysAvailable ValueType: Boolean }
|
EDIMLColumn OwnerID { Attribute: OwnerID ValueType: String }
|
EDIMLColumn UpdateInterval { Attribute: UpdateInterval ValueType: Duration }
|
EDIMLColumn Window { Attribute: Window ValueType: Number }
|
}
|
EDIMLTable LibCIM_Event
|
{
|
PrimaryKeyColumns: EventID
|
TargetType: LibCIM_Event
|
TypeIndex: LibCIM_ByEventID
|
EDIMLColumn CalendarID { Attribute: CalendarID ValueType: String }
|
EDIMLColumn CalendarType { Attribute: CalendarType ValueType: String }
|
EDIMLColumn Category { Attribute: Category ValueType: String }
|
EDIMLColumn Duration { Attribute: Duration ValueType: Duration }
|
EDIMLColumn EventID { Attribute: EventID ValueType: String }
|
EDIMLColumn IsAllDay { Attribute: IsAllDay ValueType: Boolean }
|
EDIMLColumn IsDefault { Attribute: IsDefault ValueType: Boolean }
|
EDIMLColumn IsRecurring { Attribute: IsRecurring ValueType: Boolean }
|
EDIMLColumn PartialCapacity { Attribute: PartialCapacity ValueType: Real }
|
EDIMLColumn PatternDaily_IsEveryWeekday { Attribute: PatternDaily_IsEveryWeekday ValueType: Boolean }
|
EDIMLColumn PatternMonthly_Day { Attribute: PatternMonthly_Day ValueType: Number }
|
EDIMLColumn PatternMonthly_DayOfWeek { Attribute: PatternMonthly_DayOfWeek ValueType: String }
|
EDIMLColumn PatternMonthly_IsDay { Attribute: PatternMonthly_IsDay ValueType: Boolean }
|
EDIMLColumn PatternMonthly_WeekOfMonth { Attribute: PatternMonthly_WeekOfMonth ValueType: String }
|
EDIMLColumn PatternType { Attribute: PatternType ValueType: String }
|
EDIMLColumn PatternWeekly_Weekdays { Attribute: PatternWeekly_Weekdays ValueType: String }
|
EDIMLColumn PatternYearly_Day { Attribute: PatternYearly_Day ValueType: Number }
|
EDIMLColumn PatternYearly_DayOfWeek { Attribute: PatternYearly_DayOfWeek ValueType: String }
|
EDIMLColumn PatternYearly_IsDay { Attribute: PatternYearly_IsDay ValueType: Boolean }
|
EDIMLColumn PatternYearly_Month { Attribute: PatternYearly_Month ValueType: Number }
|
EDIMLColumn PatternYearly_WeekOfMonth { Attribute: PatternYearly_WeekOfMonth ValueType: String }
|
EDIMLColumn RecurrenceInterval { Attribute: RecurrenceInterval ValueType: Number }
|
EDIMLColumn StartTimeOfDay { Attribute: StartTimeOfDay ValueType: Duration }
|
EDIMLColumn Subject { Attribute: Subject ValueType: String }
|
EDIMLColumn Type { Attribute: Type ValueType: String }
|
}
|
EDIMLTable LibCIM_Participation
|
{
|
PrimaryKeyColumns: ParticipationID
|
TargetType: LibCIM_Participation
|
TypeIndex: LibCIM_ByParticipationID
|
EDIMLColumn CalendarID { Attribute: CalendarID ValueType: String }
|
EDIMLColumn CalendarType { Attribute: CalendarType ValueType: String }
|
EDIMLColumn EventID { Attribute: EventID ValueType: String }
|
EDIMLColumn EventIsRecurring { Attribute: EventIsRecurring ValueType: Boolean }
|
EDIMLColumn HasSpecificPeriod { Attribute: HasSpecificPeriod ValueType: Boolean }
|
EDIMLColumn IsSubscription { Attribute: IsSubscription ValueType: Boolean }
|
EDIMLColumn ParticipationID { Attribute: ParticipationID ValueType: String }
|
EDIMLColumn PeriodEndDate { Attribute: PeriodEndDate ValueType: Date }
|
EDIMLColumn PeriodNrOfOccurrences { Attribute: PeriodNrOfOccurrences ValueType: Number }
|
EDIMLColumn PeriodStartDate { Attribute: PeriodStartDate ValueType: Date }
|
EDIMLColumn PeriodType { Attribute: PeriodType ValueType: String }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
}
|
}
|
EDIODBCLink.Destination Destination_DII_CIM_DB_Export_Calendars
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.exportcim'
|
EDIODBCLinkTable Calendars
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: CalendarID
|
PrimaryKeyColumns: CalendarType
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Base
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn CalendarID
|
{
|
Length: 64
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CalendarType
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn History
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn IsAlwaysAvailable
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OwnerID
|
{
|
Length: 64
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UpdateInterval
|
{
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Window
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
}
|
EDIODBCLinkTable Events
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: EventID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CalendarID
|
{
|
Length: 64
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CalendarType
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Category
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Duration
|
{
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn EventID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsAllDay
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsDefault
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsRecurring
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn PartialCapacity
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn PatternDaily_IsEveryWeekday
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn PatternMonthly_Day
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PatternMonthly_DayOfWeek
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PatternMonthly_IsDay
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn PatternMonthly_WeekOfMonth
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PatternType
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PatternWeekly_Weekdays
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PatternYearly_Day
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PatternYearly_DayOfWeek
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PatternYearly_IsDay
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn PatternYearly_Month
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PatternYearly_WeekOfMonth
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RecurrenceInterval
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn StartTimeOfDay
|
{
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Subject
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Type
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Participations
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ParticipationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CalendarID
|
{
|
Length: 64
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CalendarType
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EventID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EventIsRecurring
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasSpecificPeriod
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsSubscription
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ParticipationID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PeriodEndDate
|
{
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn PeriodNrOfOccurrences
|
{
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PeriodStartDate
|
{
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn PeriodType
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StartDate
|
{
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation_DII_CIM_DB_Export_Calendars
|
{
|
EDITableTransformation
|
{
|
InputTable: LibCIM_Calendar
|
OutputTable: Calendars
|
EDIColumnMatch { InputColumn: Base OutputColumn: Base }
|
EDIColumnMatch { InputColumn: CalendarID OutputColumn: CalendarID }
|
EDIColumnMatch { InputColumn: CalendarType OutputColumn: CalendarType }
|
EDIColumnMatch { InputColumn: History OutputColumn: History }
|
EDIColumnMatch { InputColumn: IsAlwaysAvailable OutputColumn: IsAlwaysAvailable }
|
EDIColumnMatch { InputColumn: OwnerID OutputColumn: OwnerID }
|
EDIColumnMatch { InputColumn: UpdateInterval OutputColumn: UpdateInterval }
|
EDIColumnMatch { InputColumn: Window OutputColumn: Window }
|
}
|
EDITableTransformation
|
{
|
InputTable: LibCIM_Event
|
OutputTable: Events
|
EDIColumnMatch { InputColumn: CalendarID OutputColumn: CalendarID }
|
EDIColumnMatch { InputColumn: CalendarType OutputColumn: CalendarType }
|
EDIColumnMatch { InputColumn: Category OutputColumn: Category }
|
EDIColumnMatch { InputColumn: Duration OutputColumn: Duration }
|
EDIColumnMatch { InputColumn: EventID OutputColumn: EventID }
|
EDIColumnMatch { InputColumn: IsAllDay OutputColumn: IsAllDay }
|
EDIColumnMatch { InputColumn: IsDefault OutputColumn: IsDefault }
|
EDIColumnMatch { InputColumn: IsRecurring OutputColumn: IsRecurring }
|
EDIColumnMatch { InputColumn: PartialCapacity OutputColumn: PartialCapacity }
|
EDIColumnMatch { InputColumn: PatternDaily_IsEveryWeekday OutputColumn: PatternDaily_IsEveryWeekday }
|
EDIColumnMatch { InputColumn: PatternMonthly_Day OutputColumn: PatternMonthly_Day }
|
EDIColumnMatch { InputColumn: PatternMonthly_DayOfWeek OutputColumn: PatternMonthly_DayOfWeek }
|
EDIColumnMatch { InputColumn: PatternMonthly_IsDay OutputColumn: PatternMonthly_IsDay }
|
EDIColumnMatch { InputColumn: PatternMonthly_WeekOfMonth OutputColumn: PatternMonthly_WeekOfMonth }
|
EDIColumnMatch { InputColumn: PatternType OutputColumn: PatternType }
|
EDIColumnMatch { InputColumn: PatternWeekly_Weekdays OutputColumn: PatternWeekly_Weekdays }
|
EDIColumnMatch { InputColumn: PatternYearly_Day OutputColumn: PatternYearly_Day }
|
EDIColumnMatch { InputColumn: PatternYearly_DayOfWeek OutputColumn: PatternYearly_DayOfWeek }
|
EDIColumnMatch { InputColumn: PatternYearly_IsDay OutputColumn: PatternYearly_IsDay }
|
EDIColumnMatch { InputColumn: PatternYearly_Month OutputColumn: PatternYearly_Month }
|
EDIColumnMatch { InputColumn: PatternYearly_WeekOfMonth OutputColumn: PatternYearly_WeekOfMonth }
|
EDIColumnMatch { InputColumn: RecurrenceInterval OutputColumn: RecurrenceInterval }
|
EDIColumnMatch { InputColumn: StartTimeOfDay OutputColumn: StartTimeOfDay }
|
EDIColumnMatch { InputColumn: Subject OutputColumn: Subject }
|
EDIColumnMatch { InputColumn: Type OutputColumn: Type }
|
}
|
EDITableTransformation
|
{
|
InputTable: LibCIM_Participation
|
OutputTable: Participations
|
EDIColumnMatch { InputColumn: CalendarID OutputColumn: CalendarID }
|
EDIColumnMatch { InputColumn: CalendarType OutputColumn: CalendarType }
|
EDIColumnMatch { InputColumn: EventID OutputColumn: EventID }
|
EDIColumnMatch { InputColumn: EventIsRecurring OutputColumn: EventIsRecurring }
|
EDIColumnMatch { InputColumn: HasSpecificPeriod OutputColumn: HasSpecificPeriod }
|
EDIColumnMatch { InputColumn: IsSubscription OutputColumn: IsSubscription }
|
EDIColumnMatch { InputColumn: ParticipationID OutputColumn: ParticipationID }
|
EDIColumnMatch { InputColumn: PeriodEndDate OutputColumn: PeriodEndDate }
|
EDIColumnMatch { InputColumn: PeriodNrOfOccurrences OutputColumn: PeriodNrOfOccurrences }
|
EDIColumnMatch { InputColumn: PeriodStartDate OutputColumn: PeriodStartDate }
|
EDIColumnMatch { InputColumn: PeriodType OutputColumn: PeriodType }
|
EDIColumnMatch { InputColumn: StartDate OutputColumn: StartDate }
|
}
|
}
|
}
|
