Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SMD2 - «Drop Shipment Extended Order Line». Маска имени таблицы: «SMD2%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SMD2001 | NCHAR | STRING | 10 | 0 | 10 | Service Order Number | 1 | Да | ||
SMD2002 | NCHAR | STRING | 6 | 0 | 6 | Service Order Line Number | 2 | Да | ||
SMD2003 | NCHAR | STRING | 6 | 0 | 6 | Service Order Sub-line Number | 3 | Да | ||
SMD2004 | DATETIME | DATE | 0 | 0 | 8 | Delivery Date Purchase Order | ||||
SMD2005 | DATETIME | DATE | 0 | 0 | 8 | Purchase Date | ||||
SMD2006 | NVARCHAR | VSTRING | 1 | 0 | 1 | Purchase Order Receipt Option | ||||
SMD2007 | NCHAR | STRING | 1 | 0 | 1 | Purchase Order Adjustment | ||||
SMD2008 | NUMERIC | X_NUMERIC | 22 | 8 | 14 | Margin % | ||||
SMD2009 | NVARCHAR | VSTRING | 1 | 0 | 1 | Margin Rule | ||||
SMD2010 | NVARCHAR | VSTRING | 1 | 0 | 1 | Text Rule | ||||
SMD2011 | DATETIME | DATE | 0 | 0 | 8 | Drop Shipment Created Date | ||||
SMD2012 | NCHAR | STRING | 6 | 0 | 6 | Drop Shipment Create Time | ||||
SMD2013 | NVARCHAR | VSTRING | 10 | 0 | 10 | Supplier Code | ||||
SMD2014 | NVARCHAR | VSTRING | 6 | 0 | 6 | Purchaser Code | ||||
SMD2015 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | ||||
SMD2016 | INT | INTEGER | 0 | 0 | 4 | Type | ||||
SMD2017 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Purchase Price (Purchase Currency) | ||||
SMD2018 | NVARCHAR | VSTRING | 2 | 0 | 2 | Currency Code Purchase | ||||
SMD2019 | NVARCHAR | VSTRING | 1 | 0 | 1 | Create Drop Shipment | ||||
SMD2020 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Purchase Quantity | ||||
SMD2021 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Stock Quantity | ||||
SMD2022 | NVARCHAR | VSTRING | 8 | 0 | 8 | User ID | ||||
SMD2023 | NCHAR | STRING | 6 | 0 | 6 | ChildLineNum | Service Order Child-line Number | 4 | Да | |
SMD2024 | INT | INTEGER | 0 | 0 | 1 | ORReceiptRule | Original Receipt Rule | |||
SMD2025 | NVARCHAR | VSTRING | 1 | 0 | 1 | DSType | DS Type |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Order Drop Shipment Lines