Quintiq file version 2.0
|
#parent: #root
|
EDIBroker GlobalOTDTable_Operation
|
{
|
MDSDefinition: GlobalOTDTable
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Destination5
|
{
|
EDIMLTable Global_MappingOperation
|
{
|
PrimaryKeyColumns: BusinessType
|
PrimaryKeyColumns: Line
|
PrimaryKeyColumns: OrganCode
|
PrimaryKeyColumns: PlantName
|
PrimaryKeyColumns: ProcessSection
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SequenceNumber
|
TargetType: Global_MappingOperation
|
TypeIndex: GlobalOTDTable_OperationTypeIndex
|
EDIMLColumn ActualCapacity { Attribute: ActualCapacity ValueType: Real }
|
EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
|
EDIMLColumn DestinationOrganizationId { Attribute: DestinationOrganizationId ValueType: String }
|
EDIMLColumn Line { Attribute: Line ValueType: String }
|
EDIMLColumn MaximumQuantity { Attribute: MaximumQuantity ValueType: Number }
|
EDIMLColumn MinimumQuantity { Attribute: MinimumQuantity ValueType: Number }
|
EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
|
EDIMLColumn OrganId { Attribute: OrganId ValueType: String }
|
EDIMLColumn OrganName { Attribute: OrganName ValueType: String }
|
EDIMLColumn PlantName { Attribute: PlantName ValueType: String }
|
EDIMLColumn ProcessSection { Attribute: ProcessSection ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Real }
|
}
|
}
|
EDIODBCLink.Source Source4
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_OPERATION
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="OTD"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ACTUALCAPACITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn BUSINESSTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DESTINATIONORGANIZATIONID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LINE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MAXIMUMQUANTITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MINIMUMQUANTITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANCODE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PLANTNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PROCESSSECTION
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SEQUENCENUMBER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UNITOFMEASURENAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn USERLEADTIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation4
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_OPERATION
|
OutputTable: Global_MappingOperation
|
EDIColumnMatch { InputColumn: ACTUALCAPACITY OutputColumn: ActualCapacity }
|
EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
|
EDIColumnMatch { InputColumn: DESTINATIONORGANIZATIONID OutputColumn: DestinationOrganizationId }
|
EDIColumnMatch { InputColumn: LINE OutputColumn: Line }
|
EDIColumnMatch
|
{
|
InputColumn: MAXIMUMQUANTITY
|
OutputColumn: MaximumQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>Chinese (China)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MINIMUMQUANTITY
|
OutputColumn: MinimumQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>Chinese (China)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
|
EDIColumnMatch { InputColumn: ORGANNAME OutputColumn: OrganName }
|
EDIColumnMatch { InputColumn: ORGID OutputColumn: OrganId }
|
EDIColumnMatch { InputColumn: PLANTNAME OutputColumn: PlantName }
|
EDIColumnMatch { InputColumn: PROCESSSECTION OutputColumn: ProcessSection }
|
EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
|
EDIColumnMatch
|
{
|
InputColumn: SEQUENCENUMBER
|
OutputColumn: SequenceNumber
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>Chinese (China)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: UNITOFMEASURENAME OutputColumn: UnitOfMeasureName }
|
EDIColumnMatch { InputColumn: USERLEADTIME OutputColumn: UserLeadTime }
|
}
|
}
|
}
|
