Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_OTD_VersionControl
|
{
|
MDSDefinition: GlobalOTDSOP
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination MappingVersionControl
|
{
|
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.Source MID_VERSIONCONTROL
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.localoracle'
|
EDIODBCLinkTable MID_VERSIONCONTROL
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="TIANMA"'
|
PrimaryKeyColumns: ENDTIME
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: PRODUCTID
|
PrimaryKeyColumns: STARTTIME
|
PrimaryKeyColumns: STOCKINGPOINTID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CREATETIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn DATAFROM
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DATATO
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ENDTIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn NAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn QTY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn RELEASETIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn STARTTIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn STOCKINGPOINTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn USER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationVersionControl
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_VERSIONCONTROL
|
OutputTable: MappingVersionControl
|
EDIColumnMatch { InputColumn: CREATETIME OutputColumn: CreateTime }
|
EDIColumnMatch { InputColumn: DATAFROM OutputColumn: DataFrom }
|
EDIColumnMatch { InputColumn: DATATO OutputColumn: DataTo }
|
EDIColumnMatch { InputColumn: ENDTIME OutputColumn: EndTime }
|
EDIColumnMatch { InputColumn: ID OutputColumn: VersionID }
|
EDIColumnMatch { InputColumn: NAME OutputColumn: VersionName }
|
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 }
|
}
|
}
|
}
|
