Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_OTD_VersionControlToDB
|
{
|
MDSDefinition: GlobalOTDTable
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Source MappingVersionControlToDB
|
{
|
EDIMLTable MappingVersionControl
|
{
|
PrimaryKeyColumns: EndTime
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StartTime
|
PrimaryKeyColumns: StockingPointID
|
PrimaryKeyColumns: VersionID
|
TargetType: MappingVersionControl
|
TypeIndex: TypeIndexVersionControl
|
EDIMLColumn CreateTime { Attribute: CreateTime ValueType: DateTime }
|
EDIMLColumn DataFrom { Attribute: DataFrom ValueType: String }
|
EDIMLColumn DataTo { Attribute: DataTo ValueType: String }
|
EDIMLColumn EndTime { Attribute: EndTime ValueType: DateTime }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Qty { Attribute: Qty ValueType: Real }
|
EDIMLColumn ReleaseTime { Attribute: ReleaseTime ValueType: DateTime }
|
EDIMLColumn StartTime { Attribute: StartTime ValueType: DateTime }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn User { Attribute: User ValueType: String }
|
EDIMLColumn VersionID { Attribute: VersionID ValueType: String }
|
EDIMLColumn VersionName { Attribute: VersionName ValueType: String }
|
}
|
}
|
EDIODBCLink.Destination MID_VERSIONCONTROLTODB
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.localoracle'
|
EDIODBCLinkTable MID_VERSIONCONTROL
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="TIANMA"'
|
PrimaryKeyColumns: ENDTIME
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: PRODUCTID
|
PrimaryKeyColumns: STARTTIME
|
PrimaryKeyColumns: STOCKINGPOINTID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CREATETIME
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn DATAFROM
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DATATO
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ENDTIME
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn NAME
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn QTY
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn RELEASETIME
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn STARTTIME
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn STOCKINGPOINTID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn USER
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationVersionControlToDB
|
{
|
EDITableTransformation
|
{
|
InputTable: MappingVersionControl
|
OutputTable: MID_VERSIONCONTROL
|
EDIColumnMatch { InputColumn: CreateTime OutputColumn: CREATETIME }
|
EDIColumnMatch { InputColumn: DataFrom OutputColumn: DATAFROM }
|
EDIColumnMatch { InputColumn: DataTo OutputColumn: DATATO }
|
EDIColumnMatch { InputColumn: EndTime OutputColumn: ENDTIME }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: PRODUCTID }
|
EDIColumnMatch { InputColumn: Qty OutputColumn: QTY }
|
EDIColumnMatch { InputColumn: ReleaseTime OutputColumn: RELEASETIME }
|
EDIColumnMatch { InputColumn: StartTime OutputColumn: STARTTIME }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: STOCKINGPOINTID }
|
EDIColumnMatch { InputColumn: User OutputColumn: USER }
|
EDIColumnMatch { InputColumn: VersionID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: VersionName OutputColumn: NAME }
|
}
|
}
|
}
|
