Таблица | Table: SMD3 - «Drop Shipment Extended Order Line History». Маска имени таблицы | Table Name Mask: «SMD3%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SMD3001 NCHAR STRING 10 0 10 Service Order Number     1 Да / Yes
SMD3002 NCHAR STRING 6 0 6 Service Order Line Number     2 Да / Yes
SMD3003 NCHAR STRING 6 0 6 Service Order Sub-line Number     3 Да / Yes
SMD3004 NCHAR STRING 4 0 4 Line Number     5 Да / Yes
SMD3005 DATETIME DATE 0 0 8 History Date        
SMD3006 NCHAR STRING 6 0 6 History Time        
SMD3007 DATETIME DATE 0 0 8 Delivery Date Purchase Order        
SMD3008 DATETIME DATE 0 0 8 Purchase Date        
SMD3009 NVARCHAR VSTRING 1 0 1 Purchase Order Receipt Option        
SMD3010 NVARCHAR VSTRING 1 0 1 Purchase Order Adjustment        
SMD3011 NUMERIC X_NUMERIC 22 8 14 Margin %        
SMD3012 NVARCHAR VSTRING 1 0 1 Margin Rule        
SMD3013 NVARCHAR VSTRING 1 0 1 Text Rule        
SMD3014 DATETIME DATE 0 0 8 Drop Shipment Created Date        
SMD3015 NCHAR STRING 6 0 6 Drop Shipment Create Time        
SMD3016 NVARCHAR VSTRING 10 0 10 Supplier Code Supplier Code      
SMD3017 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
SMD3018 NVARCHAR VSTRING 6 0 6 Warehouse        
SMD3019 INT INTEGER 0 0 4 Type        
SMD3020 NUMERIC X_NUMERIC 28 8 20 Purchase Price (Purchase Currency)        
SMD3021 NVARCHAR VSTRING 2 0 2 Currency Code Purchase        
SMD3022 NVARCHAR VSTRING 1 0 1 Create Drop Shipment        
SMD3023 NUMERIC X_NUMERIC 28 8 20 Purchase Quantity        
SMD3024 NUMERIC X_NUMERIC 28 8 20 Stock Quantity        
SMD3025 NVARCHAR VSTRING 8 0 8 User ID        
SMD3026 NCHAR STRING 10 0 10 Purchase Order Number        
SMD3027 NCHAR STRING 6 0 6 Purchase Order Line Number        
SMD3028 NCHAR STRING 6 0 6 Purchase Order Sub-line Number        
SMD3029 NCHAR STRING 6 0 6 Service Order Child-line Number     4 Да / Yes
SMD3030 INT INTEGER 0 0 1 Original Receipt Rule Original Receipt Rule      
SMD3031 NVARCHAR VSTRING 1 0 1 DSType DS Type      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Order Drop Shipment Lines History