One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SMD3 — Service Order Drop Shipment Lines History

Таблица / Table: SMD3 — «Drop Shipment Extended Order Line History». Маска имени таблицы / Table name mask: «SMD3%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SMD3001 NCHAR STRING 10 0 10 ServiceOrderNumber Service Order Number   1 Да / Yes
SMD3002 NCHAR STRING 6 0 6 ServiceOrderLineNumber Service Order Line Number   2 Да / Yes
SMD3003 NCHAR STRING 6 0 6 ServiceOrderSublineNumber Service Order Sub-line Number   3 Да / Yes
SMD3004 NCHAR STRING 4 0 4 LineNumber Line Number   5 Да / Yes
SMD3005 DATETIME DATE 0 0 8 HistoryDate History Date      
SMD3006 NCHAR STRING 6 0 6 HistoryTime History Time      
SMD3007 DATETIME DATE 0 0 8 DeliveryDatePurchaseOrder Delivery Date Purchase Order      
SMD3008 DATETIME DATE 0 0 8 PurchaseDate Purchase Date      
SMD3009 NVARCHAR VSTRING 1 0 1 PurchaseOrderReceiptOption Purchase Order Receipt Option      
SMD3010 NVARCHAR VSTRING 1 0 1 PurchaseOrderAdjustment Purchase Order Adjustment      
SMD3011 NUMERIC X_NUMERIC 22 8 14 MarginPercent Margin %      
SMD3012 NVARCHAR VSTRING 1 0 1 MarginRule Margin Rule      
SMD3013 NVARCHAR VSTRING 1 0 1 TextRule Text Rule      
SMD3014 DATETIME DATE 0 0 8 DropShipmentCreatedDate Drop Shipment Created Date      
SMD3015 NCHAR STRING 6 0 6 DropShipmentCreateTime Drop Shipment Create Time      
SMD3016 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
SMD3017 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
SMD3018 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
SMD3019 INT INTEGER 0 0 4 Type Type      
SMD3020 NUMERIC X_NUMERIC 28 8 20 PurchasePricePurchaseCurrency Purchase Price (Purchase Currency)      
SMD3021 NVARCHAR VSTRING 2 0 2 CurrencyCodePurchase Currency Code Purchase      
SMD3022 NVARCHAR VSTRING 1 0 1 CreateDropShipment Create Drop Shipment      
SMD3023 NUMERIC X_NUMERIC 28 8 20 PurchaseQuantity Purchase Quantity      
SMD3024 NUMERIC X_NUMERIC 28 8 20 StockQuantity Stock Quantity      
SMD3025 NVARCHAR VSTRING 8 0 8 UserID User ID      
SMD3026 NCHAR STRING 10 0 10 PurchaseOrder Purchase Order Number      
SMD3027 NCHAR STRING 6 0 6 PurchaseOrderLineNumber Purchase Order Line Number      
SMD3028 NCHAR STRING 6 0 6 PurchaseOrderSublineNumber Purchase Order Sub-line Number      
SMD3029 NCHAR STRING 6 0 6 ServiceOrderChildlineNumber Service Order Child-line Number   4 Да / Yes
SMD3030 INT INTEGER 0 0 1 OrigReceiptRule Original Receipt Rule      
SMD3031 NVARCHAR VSTRING 1 0 1 DSType DS Type      

Навигация / Navigation: