Таблица | Table: SCW1 - «Central Warehouse Def». Маска имени таблицы | Table Name Mask: «SCW10000»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SCW1001 NCHAR STRING 2 0 2 Owner Company Owner Company   1 Да / Yes
SCW1002 NCHAR STRING 6 0 6 Warehouse Warehouse Warehouse for which ownership is defined 2 Да / Yes
SCW1003 NVARCHAR VSTRING 20 0 20 Description Description      
SCW1004 NCHAR STRING 10 0 10 Pickinglist Counter Picking List Counter      
SCW1005 NCHAR STRING 10 0 10 Invoice Counter Invoice Counter      
SCW1006 NVARCHAR VSTRING 2 0 2 Not used Check Batch Items 1 - Picking list lines with batch-controlled items must be checked before delivery.
0 - No check has to take place before delivery		    
SCW1007 NCHAR SWITCH 1 0 1 Allow non-allocated deliveries Allow Non-Allocated Deliveries      
SCW1008 NCHAR SWITCH 1 0 1 Create invoice statistics Create Invoice Statistics      
SCW1009 NCHAR SWITCH 1 0 1 Allocate from Batch Allocate from Batch      
SCW1010 INT INTEGER 0 0 1 Document Code Document Layout      
SCW1011 NVARCHAR VSTRING 4 0 4 Not used (obsolete)      
SCW1012 NCHAR SWITCH 1 0 1 Credit check own orders Credit Check Customer      
SCW1013 NCHAR SWITCH 1 0 1 Block when limit is zero Block when Limit is Zero      
SCW1014 NCHAR SWITCH 1 0 1 Merge pickinglists Merge Picking Lists      
SCW1015 NCHAR SWITCH 1 0 1 Bin sorted pickinglist Bin Sorted Picking List      
SCW1016 NCHAR SWITCH 1 0 1 Bin from batch Use Bin from Batch      
SCW1017 NCHAR STRING 10 0 10 Merged pickinglist counter Merged Picking List Counter      
SCW1018 INT INTEGER 0 0 1 Accounting code source Accounting Code Source      
SCW1019 INT INTEGER 0 0 1 Accounting segment source Accounting Segment Source      
SCW1020 NCHAR STRING 10 0 10 Next lognumber Next Log-number      
SCW1021 NCHAR STRING 6 0 6 Next delivery note number Next Delivery Note Number      
SCW1022 NCHAR SWITCH 1 0 1 UN code sorted pickinglist UN-code Sorted Picking List      
SCW1023 INT INTEGER 0 0 2 UN code field User Defined Field for UN-code      
SCW1024 NCHAR STRING 10 0 10 Credit note number Credit Note Number      
SCW1025 NCHAR STRING 1 0 1 Spare Spare      
SCW1026 NCHAR STRING 1 0 1 Spare Spare      
SCW1027 NCHAR STRING 1 0 1 Spare Spare      

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