Quintiq file version 2.0
|
#parent: #root
|
EDIBroker GlobalOTDTable_CustomOrder
|
{
|
MDSDefinition: GlobalOTDTable
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Destination9
|
{
|
EDIMLTable Global_MappingCustomOrder
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Global_MappingCustomOrder
|
TypeIndex: GlobalOTDTable_CustomOrderTypeIndex
|
EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn Customer { Attribute: Customer ValueType: String }
|
EDIMLColumn CustomerID { Attribute: CustomerID ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsAvailable { Attribute: IsAvailable ValueType: Boolean }
|
EDIMLColumn OrderDate { Attribute: OrderDate ValueType: Date }
|
EDIMLColumn OrderID { Attribute: OrderID ValueType: String }
|
EDIMLColumn OrderLineID { Attribute: OrderLineID ValueType: String }
|
EDIMLColumn OrderTime { Attribute: OrderTime ValueType: Date }
|
EDIMLColumn OrderType { Attribute: OrderType ValueType: String }
|
EDIMLColumn Price { Attribute: Price ValueType: Real }
|
EDIMLColumn PriorityName { Attribute: PriorityName ValueType: String }
|
EDIMLColumn ProductGrade { Attribute: ProductGrade ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn SegmentPriority { Attribute: SegmentPriority ValueType: String }
|
EDIMLColumn SheetProfitability { Attribute: SheetProfitability ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source Source8
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_CUSTOMERORDER
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="OTD"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn BUSINESSTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CHECKMSG
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn CURRENCYID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CUSTOMER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CUSTOMERID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ISAVAILABLE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ISCHECKED
|
{
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ISPASS
|
{
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ORDERDATE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ORDERID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORDERLINEID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORDERTIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ORDERTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRICE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn PRIORITYNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTGRADE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn QUANTITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SALESEGMENTNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SEGMENTPRIORITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SHEETPROFITABILITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn STOCKINGPOINTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UNITOFMEASURENAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation8
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_CUSTOMERORDER
|
OutputTable: Global_MappingCustomOrder
|
EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
|
EDIColumnMatch { InputColumn: CURRENCYID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: CUSTOMER OutputColumn: Customer }
|
EDIColumnMatch { InputColumn: CUSTOMERID OutputColumn: CustomerID }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ISAVAILABLE OutputColumn: IsAvailable }
|
EDIColumnMatch
|
{
|
InputColumn: ORDERDATE
|
OutputColumn: OrderDate
|
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: ORDERID OutputColumn: OrderID }
|
EDIColumnMatch { InputColumn: ORDERLINEID OutputColumn: OrderLineID }
|
EDIColumnMatch
|
{
|
InputColumn: ORDERTIME
|
OutputColumn: OrderTime
|
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: ORDERTYPE OutputColumn: OrderType }
|
EDIColumnMatch { InputColumn: PRICE OutputColumn: Price }
|
EDIColumnMatch { InputColumn: PRIORITYNAME OutputColumn: PriorityName }
|
EDIColumnMatch { InputColumn: PRODUCTGRADE OutputColumn: ProductGrade }
|
EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: QUANTITY OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: SALESEGMENTNAME OutputColumn: SalesSegmentName }
|
EDIColumnMatch { InputColumn: SEGMENTPRIORITY OutputColumn: SegmentPriority }
|
EDIColumnMatch { InputColumn: SHEETPROFITABILITY OutputColumn: SheetProfitability }
|
EDIColumnMatch { InputColumn: STOCKINGPOINTID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UNITOFMEASURENAME OutputColumn: UnitOfMeasureName }
|
}
|
}
|
}
|
