Таблица | Table: SCW9 - «Central Warehouse Order Line Extension». Маска имени таблицы | Table Name Mask: «SCW90000»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SCW9001 NCHAR STRING 2 0 2 Order company Order Company   1 Да / Yes
SCW9002 NCHAR STRING 10 0 10 Order number Order Number   3 Да / Yes
SCW9003 NCHAR STRING 6 0 6 Order line Order Line Number   4 Да / Yes
SCW9004 NCHAR STRING 6 0 6 Structure line Order Sub-line Number   5 Да / Yes
SCW9005 NCHAR STRING 2 0 2 Warehouse owner company Company Warehouse Owner      
SCW9006 NCHAR STRING 6 0 6 Warehouse ID Warehouse      
SCW9007 NVARCHAR VSTRING 35 0 35 Stock code Stock Item Code      
SCW9008 NUMERIC X_NUMERIC 20 8 12 Ordered quantity Ordered Quantity (Sales Unit)      
SCW9009 NUMERIC X_NUMERIC 20 8 12 Delivered quantity Delivered Quantity (Sales Unit)      
SCW9010 DATETIME DATE 0 0 8 Delivery date Delivery Date      
SCW9011 NVARCHAR VSTRING 10 0 10 Pickinglist number Picking List Number      
SCW9012 NCHAR SWITCH 1 0 1 Changes allowed Changes Allowed      
SCW9013 NVARCHAR VSTRING 30 0 30 Priority Priority      
SCW9014 NUMERIC MONEY 28 8 20 Unit price for credit check Amount for Credit Check      
SCW9015 NUMERIC MONEY 28 8 20 Amount ICP Amount ICP      
SCW9016 NUMERIC X_NUMERIC 20 8 12 Allocated OR Allocated Quantity (Sales Unit)      
SCW9017 NUMERIC X_NUMERIC 20 8 12 Allocated SC Allocated Quantity (Stock Unit)      
SCW9018 NVARCHAR VSTRING 10 0 10 Not used (obsolete)      
SCW9019 NVARCHAR VSTRING 10 0 10 Not used (obsolete)      
SCW9020 NVARCHAR VSTRING 8 0 8 Not used (obsolete)      
SCW9021 NVARCHAR VSTRING 8 0 8 Not used (obsolete)      
SCW9022 NVARCHAR VSTRING 6 0 6 Not used (obsolete)      
SCW9023 NVARCHAR VSTRING 6 0 6 Not used (obsolete)      
SCW9024 NVARCHAR VSTRING 2 0 2 Pricelist ICP Price List ICP      
SCW9025 NVARCHAR VSTRING 2 0 2 Not used (obsolete)      
SCW9026 NCHAR SWITCH 1 0 1 Not used (obsolete)      
SCW9027 NCHAR SWITCH 1 0 1 Not used (obsolete)      
SCW9028 NCHAR STRING 1 0 1 Source of request Source of request   2 Да / Yes
SCW9029 INT INTEGER 0 0 4 Unit Code Unit Code      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Central Warehouse Order Line Extension