One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SCW1 — Central Warehouse Definition

Таблица / Table: SCW1 — «Central Warehouse Def». Маска имени таблицы / Table name mask: «SCW10000»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCW1001 NCHAR STRING 2 0 2 OwnerCompany 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 PickinglistCounter Picking List Counter      
SCW1005 NCHAR STRING 10 0 10 InvoiceCounter Invoice Counter      
SCW1006 NVARCHAR VSTRING 2 0 2 NotUsed 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 AllowNonAllocDelivery Allow Non-Allocated Deliveries      
SCW1008 NCHAR SWITCH 1 0 1 CreateInvStat Create Invoice Statistics      
SCW1009 NCHAR SWITCH 1 0 1 AllocFromBatch Allocate from Batch      
SCW1010 INT INTEGER 0 0 1 DocCode Document Layout      
SCW1011 NVARCHAR VSTRING 4 0 4 NotUsed (obsolete)      
SCW1012 NCHAR SWITCH 1 0 1 CreditCheckOwnOrders Credit Check Customer      
SCW1013 NCHAR SWITCH 1 0 1 BlockZeroLimit Block when Limit is Zero      
SCW1014 NCHAR SWITCH 1 0 1 MergePickLists Merge Picking Lists      
SCW1015 NCHAR SWITCH 1 0 1 BinSortedPickList Bin Sorted Picking List      
SCW1016 NCHAR SWITCH 1 0 1 BinFromBatch Use Bin from Batch      
SCW1017 NCHAR STRING 10 0 10 MergedPickListCounter Merged Picking List Counter      
SCW1018 INT INTEGER 0 0 1 AccCodeSource Accounting Code Source      
SCW1019 INT INTEGER 0 0 1 AccSegmentSource Accounting Segment Source      
SCW1020 NCHAR STRING 10 0 10 NextLogNumber Next Log-number      
SCW1021 NCHAR STRING 6 0 6 NextDNNumber Next Delivery Note Number      
SCW1022 NCHAR SWITCH 1 0 1 UNCodeSortedPickList UN-code Sorted Picking List      
SCW1023 INT INTEGER 0 0 2 UNCodeFld User Defined Field for UN-code      
SCW1024 NCHAR STRING 10 0 10 CreditNoteNumber Credit Note Number      
SCW1025 NCHAR STRING 1 0 1 AllocationPriority Allocation Priority      
SCW1026 NCHAR STRING 1 0 1 Spare Spare      
SCW1027 NCHAR STRING 1 0 1 Spare Spare      

Навигация / Navigation: