Quintiq file version 2.0
|
#parent: #root
|
EDIBroker GlobalOTDTable_AIPISPIP
|
{
|
MDSDefinition: GlobalOTDTable
|
EDIModelLink.Destination Des_ActualPISPIP0
|
{
|
EDIMLTable Global_MappingActualProductInStockingPointInPeriod
|
{
|
PrimaryKeyColumns: Date
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
TargetType: Global_MappingActualProductInStockingPointInPeriod
|
TypeIndex: GlobalOTDTable_AIPISPIPTypeIndex
|
EDIMLColumn ActualInventoryLevelEnd { Attribute: ActualInventoryLevelEnd ValueType: Real }
|
EDIMLColumn Date { Attribute: Date ValueType: Date }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn IsAvailable { Attribute: IsAvailable ValueType: Boolean }
|
EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn StockType { Attribute: StockType ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MID_ActualPISPIP0
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_ACTUALPISPIP
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="TIANMA"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ACTUALLINVENTORYLEVELEND
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DATE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn DESCRIPTION
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ISAVAILABLE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MANUFACTUREDDATE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn STOCKINGPOINTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn STOCKTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationActualPISPIP0
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_ACTUALPISPIP
|
OutputTable: Global_MappingActualProductInStockingPointInPeriod
|
EDIColumnMatch
|
{
|
InputColumn: ACTUALLINVENTORYLEVELEND
|
OutputColumn: ActualInventoryLevelEnd
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" 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>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DATE
|
OutputColumn: Date
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: DESCRIPTION OutputColumn: Description }
|
EDIColumnMatch { InputColumn: ISAVAILABLE OutputColumn: IsAvailable }
|
EDIColumnMatch
|
{
|
InputColumn: MANUFACTUREDDATE
|
OutputColumn: ManufacturedDate
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: STOCKINGPOINTID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: STOCKTYPE OutputColumn: StockType }
|
}
|
}
|
}
|
