Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SCW2001 NCHAR STRING 2 0 2 UserCompany User Company   1 Да
SCW2002 NCHAR STRING 6 0 6 TransactionWH Local Warehouse   2 Да
SCW2003 NCHAR STRING 2 0 2 CWHOwnerCompany Central Owner Company      
SCW2004 NCHAR STRING 6 0 6 CWH Central Warehouse      
SCW2005 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
SCW2006 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
SCW2007 NVARCHAR VSTRING 2 0 2 Pricelist Price List      
SCW2008 NVARCHAR VSTRING 3 0 3 LanCode Language      
SCW2009 NVARCHAR VSTRING 4 0 4 NotUsed (obsolete)      
SCW2010 NCHAR SWITCH 1 0 1 CreditCheck 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 AllowOrders 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 BlockZeroLimit 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 AccCodeSource 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 AccSegmentSource 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 BatchFromCWH Batch ID from Central Warehouse      
SCW2016 NCHAR SWITCH 1 0 1 SplitProfit Split Profit      
SCW2017 NUMERIC X_NUMERIC 13 8 5 SplitPercent Split Profit Percentage for Selling Company      
SCW2018 NUMERIC X_NUMERIC 13 8 5 ICPAddOnPercent Percentage add-on for ICP Prices      
SCW2019 INT INTEGER 0 0 1 MergeOption 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 CountryCode Country Code      
SCW2021 INT INTEGER 0 0 1 VATHandlingOpt VAT Handling Option      
SCW2022 INT INTEGER 0 0 1 DocCode Document Layout      
SCW2023 NCHAR SWITCH 1 0 1 CreatePurchStat Create Purchase Statistics      
SCW2024 NVARCHAR VSTRING 10 0 10 NotUsed (obsolete)      
SCW2025 NVARCHAR VSTRING 6 0 6 NotUsed (obsolete)      
SCW2026 NCHAR STRING 12 0 12 BatchCounter Batch Counter      
SCW2027 INT INTEGER 0 0 2 PriceListCurr Currency Code Price List      
SCW2028 NCHAR SWITCH 1 0 1 NoStockUpdate No stock update      
SCW2029 NCHAR SWITCH 1 0 1 GenerateCostTrans 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 3.00 (x64) - 3.00.02254 | Stock Control | Transaction Warehouse Definition