Таблица: SCW2 - «Transaction warehouse definition». Маска имени таблицы: «SCW20000»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SCW2001 NCHAR STRING 2 0 2 User Company User Company   1 Да
SCW2002 NCHAR STRING 6 0 6 Transaction warehouse Local Warehouse   2 Да
SCW2003 NCHAR STRING 2 0 2 Central warehouse owner Central Owner Company      
SCW2004 NCHAR STRING 6 0 6 Central warehouse Central Warehouse      
SCW2005 NVARCHAR VSTRING 10 0 10 Supplier code Supplier Code      
SCW2006 NVARCHAR VSTRING 10 0 10 Customer code Customer Code      
SCW2007 NVARCHAR VSTRING 2 0 2 Pricelist Price List      
SCW2008 NVARCHAR VSTRING 3 0 3 Language code Language      
SCW2009 NVARCHAR VSTRING 4 0 4 Not used (obsolete)      
SCW2010 NCHAR SWITCH 1 0 1 Credit check Credit Check Customer 1 - Customers will be credit checked during the picking list creation.
0 - No credit check will take place.		    
SCW2011 NCHAR SWITCH 1 0 1 Allow orders Ready to Use 1 - Order lines can be entered to this warehouse from the company defined
0 - Order lines can not be entered to this warehouse from the company defined		    
SCW2012 NCHAR SWITCH 1 0 1 Block when limit is zero Block When Limit is Zero 1 - Zero is treated as an actual credit limit.
0 - Zero is treated as an infinite credit limit.		    
SCW2013 INT INTEGER 0 0 1 Accounting code source Accounting Code Source Decides how accounting code will be created for stock transactions.
0 - From stock item.
1 - The sum of stock item accounting code and supplier accounting code.		    
SCW2014 INT INTEGER 0 0 1 Accounting segment source Accounting Segment Source Decides how accounting string will be created for stock transactions.
0 - From stock item.
1 - Segments missing in stock item accounting string will be taken from supplier accounting string.		    
SCW2015 NCHAR SWITCH 1 0 1 Batch from cwh Batch ID from Central Warehouse      
SCW2016 NCHAR SWITCH 1 0 1 Split profit Split Profit      
SCW2017 NUMERIC X_NUMERIC 13 8 5 Split percentage Split Profit Percentage for Selling Company      
SCW2018 NUMERIC X_NUMERIC 13 8 5 ICP add on percentage Percentage add-on for ICP Prices      
SCW2019 INT INTEGER 0 0 1 Merge option Merged Picking List Option 0 - Merge Picking Lists are not created for this warehouse
1 - Merge Picking Lists will be created for this warehouse
2 - Parameter set in 'CWH definition' decides whether Merge PLs are created.		    
SCW2020 NVARCHAR VSTRING 3 0 3 Country Code Country Code      
SCW2021 INT INTEGER 0 0 1 VAT handling code VAT Handling Option      
SCW2022 INT INTEGER 0 0 1 Document code Document Layout      
SCW2023 NCHAR SWITCH 1 0 1 Create purchase statistics Create Purchase Statistics      
SCW2024 NVARCHAR VSTRING 10 0 10 Not used (obsolete)      
SCW2025 NVARCHAR VSTRING 6 0 6 Not used (obsolete)      
SCW2026 NCHAR STRING 12 0 12 Batch counter Batch Counter      
SCW2027 INT INTEGER 0 0 2 Pricelist currency Currency Code Price List      
SCW2028 NCHAR SWITCH 1 0 1 No stock update        
SCW2029 NCHAR SWITCH 1 0 1 Generate cost transactions        
SCW2030 NCHAR STRING 1 0 1 Spare Spare      
SCW2031 NCHAR STRING 1 0 1 Spare Spare      
SCW2032 NCHAR STRING 1 0 1 Spare Spare      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Transaction Warehouse Definition