Quintiq file version 2.0
|
#parent: #root
|
EDIBroker GlobalOTDTable_AnnualBudgetData
|
{
|
MDSDefinition: GlobalOTDTable
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination DES_AnnualBudgetData
|
{
|
EDIMLTable Global_MappingAnnualBudgetData
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Global_MappingAnnualBudgetData
|
TypeIndex: Global_MappingAnnualBudgetDataTypeIndex
|
EDIMLColumn BusinessSort { Attribute: BusinessSort ValueType: String }
|
EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
|
EDIMLColumn CapacityEquivalent { Attribute: CapacityEquivalent ValueType: String }
|
EDIMLColumn CutsNumber { Attribute: CutsNumber ValueType: String }
|
EDIMLColumn DisplayTechSort { Attribute: DisplayTechSort ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn MaskNumber { Attribute: MaskNumber ValueType: String }
|
EDIMLColumn MonthlyModCapacity1 { Attribute: MonthlyModCapacity1 ValueType: String }
|
EDIMLColumn MonthlyModCapacity10 { Attribute: MonthlyModCapacity10 ValueType: String }
|
EDIMLColumn MonthlyModCapacity11 { Attribute: MonthlyModCapacity11 ValueType: String }
|
EDIMLColumn MonthlyModCapacity12 { Attribute: MonthlyModCapacity12 ValueType: String }
|
EDIMLColumn MonthlyModCapacity2 { Attribute: MonthlyModCapacity2 ValueType: String }
|
EDIMLColumn MonthlyModCapacity3 { Attribute: MonthlyModCapacity3 ValueType: String }
|
EDIMLColumn MonthlyModCapacity4 { Attribute: MonthlyModCapacity4 ValueType: String }
|
EDIMLColumn MonthlyModCapacity5 { Attribute: MonthlyModCapacity5 ValueType: String }
|
EDIMLColumn MonthlyModCapacity6 { Attribute: MonthlyModCapacity6 ValueType: String }
|
EDIMLColumn MonthlyModCapacity7 { Attribute: MonthlyModCapacity7 ValueType: String }
|
EDIMLColumn MonthlyModCapacity8 { Attribute: MonthlyModCapacity8 ValueType: String }
|
EDIMLColumn MonthlyModCapacity9 { Attribute: MonthlyModCapacity9 ValueType: String }
|
EDIMLColumn MonthlySales1 { Attribute: MonthlySales1 ValueType: String }
|
EDIMLColumn MonthlySales10 { Attribute: MonthlySales10 ValueType: String }
|
EDIMLColumn MonthlySales11 { Attribute: MonthlySales11 ValueType: String }
|
EDIMLColumn MonthlySales12 { Attribute: MonthlySales12 ValueType: String }
|
EDIMLColumn MonthlySales2 { Attribute: MonthlySales2 ValueType: String }
|
EDIMLColumn MonthlySales3 { Attribute: MonthlySales3 ValueType: String }
|
EDIMLColumn MonthlySales4 { Attribute: MonthlySales4 ValueType: String }
|
EDIMLColumn MonthlySales5 { Attribute: MonthlySales5 ValueType: String }
|
EDIMLColumn MonthlySales6 { Attribute: MonthlySales6 ValueType: String }
|
EDIMLColumn MonthlySales7 { Attribute: MonthlySales7 ValueType: String }
|
EDIMLColumn MonthlySales8 { Attribute: MonthlySales8 ValueType: String }
|
EDIMLColumn MonthlySales9 { Attribute: MonthlySales9 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity1 { Attribute: MonthlySheetCapacity1 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity10 { Attribute: MonthlySheetCapacity10 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity11 { Attribute: MonthlySheetCapacity11 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity12 { Attribute: MonthlySheetCapacity12 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity2 { Attribute: MonthlySheetCapacity2 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity3 { Attribute: MonthlySheetCapacity3 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity4 { Attribute: MonthlySheetCapacity4 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity5 { Attribute: MonthlySheetCapacity5 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity6 { Attribute: MonthlySheetCapacity6 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity7 { Attribute: MonthlySheetCapacity7 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity8 { Attribute: MonthlySheetCapacity8 ValueType: String }
|
EDIMLColumn MonthlySheetCapacity9 { Attribute: MonthlySheetCapacity9 ValueType: String }
|
EDIMLColumn OrgCodeFromBom { Attribute: OrgCodeFromBom ValueType: String }
|
EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
|
EDIMLColumn OrganName { Attribute: OrganName ValueType: String }
|
EDIMLColumn PlantName { Attribute: PlantName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn ProductLineAndSpecification { Attribute: ProductLineAndSpecification ValueType: String }
|
EDIMLColumn ResolutionRatio { Attribute: ResolutionRatio ValueType: String }
|
EDIMLColumn ShippingForm { Attribute: ShippingForm ValueType: String }
|
EDIMLColumn YearNo { Attribute: YearNo ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MID_AnnualBudgetData
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_ANNUALBUDGETDATA
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="YUXTEST"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn BUSINESSSORT
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn BUSINESSTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CAPACITYEQUIVALENT
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CUTSNUMBER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DISPLAYTECHSORT
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MASKNUMBER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY1
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY10
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY11
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY12
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY2
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY3
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY4
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY5
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY6
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY7
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY8
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYMODCAPACITY9
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES1
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES10
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES11
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES12
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES2
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES3
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES4
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES5
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES6
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES7
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES8
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSALES9
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY1
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY10
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY11
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY12
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY2
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY3
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY4
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY5
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY6
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY7
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY8
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MONTHLYSHEETCAPACITY9
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANCODE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PLANTNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTLINEANDSPECIFICATION
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RESOLUTIONRATIO
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SHIPPINGFORM
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn YEARNO
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationAnnualBudgetData
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_ANNUALBUDGETDATA
|
OutputTable: Global_MappingAnnualBudgetData
|
EDIColumnMatch { InputColumn: BUSINESSSORT OutputColumn: BusinessSort }
|
EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
|
EDIColumnMatch { InputColumn: CAPACITYEQUIVALENT OutputColumn: CapacityEquivalent }
|
EDIColumnMatch { InputColumn: CUTSNUMBER OutputColumn: CutsNumber }
|
EDIColumnMatch { InputColumn: DISPLAYTECHSORT OutputColumn: DisplayTechSort }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: MASKNUMBER OutputColumn: MaskNumber }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY1 OutputColumn: MonthlyModCapacity1 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY10 OutputColumn: MonthlyModCapacity10 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY11 OutputColumn: MonthlyModCapacity11 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY12 OutputColumn: MonthlyModCapacity12 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY2 OutputColumn: MonthlyModCapacity2 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY3 OutputColumn: MonthlyModCapacity3 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY4 OutputColumn: MonthlyModCapacity4 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY5 OutputColumn: MonthlyModCapacity5 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY6 OutputColumn: MonthlyModCapacity6 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY7 OutputColumn: MonthlyModCapacity7 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY8 OutputColumn: MonthlyModCapacity8 }
|
EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY9 OutputColumn: MonthlyModCapacity9 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES1 OutputColumn: MonthlySales1 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES10 OutputColumn: MonthlySales10 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES11 OutputColumn: MonthlySales11 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES12 OutputColumn: MonthlySales12 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES2 OutputColumn: MonthlySales2 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES3 OutputColumn: MonthlySales3 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES4 OutputColumn: MonthlySales4 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES5 OutputColumn: MonthlySales5 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES6 OutputColumn: MonthlySales6 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES7 OutputColumn: MonthlySales7 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES8 OutputColumn: MonthlySales8 }
|
EDIColumnMatch { InputColumn: MONTHLYSALES9 OutputColumn: MonthlySales9 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY1 OutputColumn: MonthlySheetCapacity1 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY10 OutputColumn: MonthlySheetCapacity10 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY11 OutputColumn: MonthlySheetCapacity11 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY12 OutputColumn: MonthlySheetCapacity12 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY2 OutputColumn: MonthlySheetCapacity2 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY3 OutputColumn: MonthlySheetCapacity3 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY4 OutputColumn: MonthlySheetCapacity4 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY5 OutputColumn: MonthlySheetCapacity5 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY6 OutputColumn: MonthlySheetCapacity6 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY7 OutputColumn: MonthlySheetCapacity7 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY8 OutputColumn: MonthlySheetCapacity8 }
|
EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY9 OutputColumn: MonthlySheetCapacity9 }
|
EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
|
EDIColumnMatch { InputColumn: ORGANNAME OutputColumn: OrganName }
|
EDIColumnMatch { InputColumn: PLANTNAME OutputColumn: PlantName }
|
EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: PRODUCTLINEANDSPECIFICATION OutputColumn: ProductLineAndSpecification }
|
EDIColumnMatch { InputColumn: RESOLUTIONRATIO OutputColumn: ResolutionRatio }
|
EDIColumnMatch { InputColumn: SHIPPINGFORM OutputColumn: ShippingForm }
|
EDIColumnMatch { InputColumn: YEARNO OutputColumn: YearNo }
|
}
|
}
|
}
|
