From 23c26913c2bc793889198babc9f82055f3eddbe2 Mon Sep 17 00:00:00 2001
From: xiaoding721 <33130084+xiaoding721@users.noreply.github.com>
Date: 星期一, 06 十一月 2023 18:14:35 +0800
Subject: [PATCH] CustomerOrder中间表添加字段
---
_Main/BL/Type_Global_MappingForecast/Attribute_SegmentPriority.qbl | 8 ++++++++
_Main/BL/Type_Global_MappingForecast/Attribute_SheetProfitability.qbl | 8 ++++++++
_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl | 12 ++++++++++++
_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl | 18 ++++++++++++++++++
_Main/BL/Type_Global_MappingForecast/Attribute_ProductGrade.qbl | 8 ++++++++
5 files changed, 54 insertions(+), 0 deletions(-)
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl
index c405497..c0a1573 100644
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl
+++ b/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl
@@ -54,6 +54,10 @@
OthersMayUpdateColumn: true
ValueType: String
}
+ EDIODBCLinkColumn CHECKMSG
+ {
+ ValueType: String
+ }
EDIODBCLinkColumn CURRENCYID
{
OthersMayUpdateColumn: true
@@ -79,6 +83,14 @@
OthersMayUpdateColumn: true
ValueType: String
}
+ EDIODBCLinkColumn ISCHECKED
+ {
+ ValueType: Number
+ }
+ EDIODBCLinkColumn ISPASS
+ {
+ ValueType: Number
+ }
EDIODBCLinkColumn ORDERDATE
{
OthersMayUpdateColumn: true
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl
index 5d2e4f1..785463b 100644
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl
+++ b/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl
@@ -18,9 +18,12 @@
EDIMLColumn ID { Attribute: ID 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 StartDate { Attribute: StartDate ValueType: Date }
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
@@ -45,6 +48,10 @@
OthersMayUpdateColumn: true
ValueType: String
}
+ EDIODBCLinkColumn CHECKMSG
+ {
+ ValueType: String
+ }
EDIODBCLinkColumn CURRENCYID
{
OthersMayUpdateColumn: true
@@ -59,6 +66,14 @@
{
OthersMayUpdateColumn: true
ValueType: String
+ }
+ EDIODBCLinkColumn ISCHECKED
+ {
+ ValueType: Number
+ }
+ EDIODBCLinkColumn ISPASS
+ {
+ ValueType: Number
}
EDIODBCLinkColumn PRICE
{
@@ -146,9 +161,12 @@
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
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: STARTDATE
diff --git a/_Main/BL/Type_Global_MappingForecast/Attribute_ProductGrade.qbl b/_Main/BL/Type_Global_MappingForecast/Attribute_ProductGrade.qbl
new file mode 100644
index 0000000..8badfce
--- /dev/null
+++ b/_Main/BL/Type_Global_MappingForecast/Attribute_ProductGrade.qbl
@@ -0,0 +1,8 @@
+Quintiq file version 2.0
+#parent: #root
+Attribute ProductGrade
+{
+ #keys: '3[414996.0.21578321][414996.0.21578320][414996.0.21578322]'
+ Description: '浜у搧绛夌骇'
+ ValueType: String
+}
diff --git a/_Main/BL/Type_Global_MappingForecast/Attribute_SegmentPriority.qbl b/_Main/BL/Type_Global_MappingForecast/Attribute_SegmentPriority.qbl
new file mode 100644
index 0000000..0a38886
--- /dev/null
+++ b/_Main/BL/Type_Global_MappingForecast/Attribute_SegmentPriority.qbl
@@ -0,0 +1,8 @@
+Quintiq file version 2.0
+#parent: #root
+Attribute SegmentPriority
+{
+ #keys: '3[414996.0.21578344][414996.0.21578343][414996.0.21578345]'
+ Description: '缁嗗垎甯傚満浼樺厛绾�'
+ ValueType: String
+}
diff --git a/_Main/BL/Type_Global_MappingForecast/Attribute_SheetProfitability.qbl b/_Main/BL/Type_Global_MappingForecast/Attribute_SheetProfitability.qbl
new file mode 100644
index 0000000..244baca
--- /dev/null
+++ b/_Main/BL/Type_Global_MappingForecast/Attribute_SheetProfitability.qbl
@@ -0,0 +1,8 @@
+Quintiq file version 2.0
+#parent: #root
+Attribute SheetProfitability
+{
+ #keys: '3[414996.0.21578334][414996.0.21578333][414996.0.21578335]'
+ Description: '澶у紶鐩堝埄'
+ ValueType: String
+}
--
Gitblit v1.9.3