Таблица | Table: SC23 - «Warehouse Addresses». Маска имени таблицы | Table Name Mask: «SC23%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SC23001 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse   1 Да / Yes
SC23002 NVARCHAR VSTRING 35 0 35 InternalName Name      
SC23003 NVARCHAR VSTRING 35 0 35 AddressName Address Name      
SC23004 NVARCHAR VSTRING 35 0 35 AddressLine1 Address Line 1      
SC23005 NVARCHAR VSTRING 35 0 35 AddressLine2 Address Line 2      
SC23006 NVARCHAR VSTRING 35 0 35 AddressLine3 Address Line 3      
SC23007 NVARCHAR VSTRING 35 0 35 AddressLine4 Address Line 4      
SC23008 NVARCHAR VSTRING 1 0 1 FLAGWHClosed (obsolete)      
SC23009 NVARCHAR VSTRING 1 0 1 FLAGWHUsage (obsolete)      
SC23010 NVARCHAR ACCSTR 50 0 50 AccessLevWH Accounting String      
SC23011 NVARCHAR VSTRING 12 0 12 AccStrStkIss Account Stock Issues      
SC23012 NVARCHAR VSTRING 12 0 12 AccStrStkRec Account Stock Receives      
SC23013 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
SC23014 NVARCHAR VSTRING 20 0 20 TelephoneNo Telephone Number      
SC23015 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
SC23016 NVARCHAR VSTRING 6 0 6 ConnBadWHous Connected Bad Warehouse      
SC23017 NCHAR STRING 2 0 2 OwnCompCode Owner Company Code      
SC23018 NCHAR STRING 3 0 3 CurrencyCode Currency Code      
SC23019 NUMERIC MONEY 28 8 20 CurrExchRate Currency Exchange Rate      
SC23020 NCHAR STRING 1 0 1 AccessLevel Access level      
SC23021 NCHAR STRING 1 0 1 VAT VAT      
SC23022 NUMERIC NUMBER 20 0 10 PickListCoun Picking List Counter      
SC23023 NUMERIC NUMBER 20 0 10 SettlemCoun Settlement Counter      
SC23024 NUMERIC X_NUMERIC 18 8 10 CurrExchgRate2 (obsolete)      
SC23025 NCHAR STRING 3 0 3 CurrExchgAlgtm (obsolete)      
SC23026 NCHAR STRING 8 0 8 UserGroup User Group      
SC23027 NVARCHAR VSTRING 1 0 1 Depot Depot      
SC23028 NVARCHAR VSTRING 10 0 10 Internal Customer, Depot Internal Customer, Depot      
SC23029 NVARCHAR VSTRING 1 0 1 SPARE SPARE      
SC23030 NVARCHAR VSTRING 1 0 1 SPARE SPARE      
SC23031 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23032 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23033 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23034 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23035 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23036 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23037 NVARCHAR VSTRING 12 0 12 SPARE SPARE      
SC23038 NCHAR SWITCH 1 0 1 ATPOverRide Possible to Override ATP Proposal      
SC23039 NCHAR SWITCH 1 0 1 ATPCheckOrderL ATP Check Order Lines      
SC23040 NCHAR SWITCH 1 0 1 InclLateDel ATP Include Delayed Receipts      
SC23041 NCHAR SWITCH 1 0 1 InclSchedPurch ATP Include Scheduled Purchase Orders      
SC23042 NCHAR SWITCH 1 0 1 InclConfPurch ATP Include Scheduled Purchase Orders      
SC23043 NCHAR SWITCH 1 0 1 InclWorkOrd ATP Include Work Orders      
SC23044 NCHAR SWITCH 1 0 1 InclWOProp ATP Include Work Order Proposals      
SC23045 NCHAR SWITCH 1 0 1 InclMPS ATP Include Master Planning Schedule      
SC23046 NCHAR SWITCH 1 0 1 InclMRPPurchP ATP Include MRP Purchase Proposals      
SC23047 NCHAR SWITCH 1 0 1 InclSalesOrder ATP Include Sales Order      
SC23048 NCHAR SWITCH 1 0 1 InclServiceOrder ATP Include Service Order      
SC23049 NCHAR SWITCH 1 0 1 InclWOMtrl ATP Include Work Order Material      
SC23050 NCHAR SWITCH 1 0 1 InclWOPropMtrl ATP Include Work Order Proposal Material      
SC23051 NCHAR SWITCH 1 0 1 InclForecast ATP Include Forecast      
SC23052 NCHAR SWITCH 1 0 1 InclBudget ATP Include Budget      
SC23053 NCHAR SWITCH 1 0 1 InclGrossReq ATP Include Gross Requirement      
SC23054 INT INTEGER 0 0 9 Calendar_Collection_Reference Calendar Collection      
SC23055 NCHAR STRING 2 0 2 Warehouse type Warehouse Type 00 - Regular warehouse
01 - Consignment warehouse (Suppliers)		    
SC23056 NCHAR STRING 10 0 10 Customer/Supplier Code Supplier Code      
SC23057 NVARCHAR VSTRING 1 0 1 FlagZeroingAllowed Allow Zeroing      
SC23058 NVARCHAR VSTRING 10 0 10 CityCode City Code      
SC23059 NVARCHAR VSTRING 1 0 1 Stock Valuation Model Valuation Model      
SC23060 INT INTEGER 0 0 1 Stock Valuation Model Priority Valuation Model Priority      
SC23061 NVARCHAR VSTRING 1 0 1 Stock Valuation Model for CC Valuation Model for Alternative Currency      
SC23062 INT INTEGER 0 0 1 Stock Valuation Model Priority for CC Valuation Model Priority for Alternative Currency      
SC23063 NCHAR STRING 6 0 6 DelivNoteIssuer Delivery Note Issuer      
SC23064 INT INTEGER 0 0 9 Cycle Counting: Calendar Collection Cycle Counting: Calendar Collection      
SC23065 DATETIME X_DATETIME 0 0 17 Cycle Counting: Number of Working Hours Cycle Counting: Number of Working Hours      
SC23066 NCHAR SWITCH 1 0 1 Use Common picking Use Common picking      
SC23067 NCHAR SWITCH 1 0 1 Allocate from picking list Allocate from picking list      
SC23068 NCHAR SWITCH 1 0 1 Use Release for picking Use Release for picking      
SC23069 NCHAR SWITCH 1 0 1 Use merged picking lists Use merged picking lists      
SC23070 NCHAR SWITCH 1 0 1 Merge different destination Merge different destination      
SC23071 NCHAR SWITCH 1 0 1 Merge different planned picking dates Merge different planned picking dates      
SC23072 NCHAR STRING 1 0 1 Sort option Sort option      
SC23073 INT INTEGER 0 0 3 Direct creation of picking request Direct creation of picking request      
SC23074 NCHAR SWITCH 1 0 1 Print after creation Print after creation      
SC23075 INT INTEGER 0 0 2 No of copies, picking list No of copies, picking list      
SC23076 INT INTEGER 0 0 2 No of copies, Delivery note No of copies, Delivery note      
SC23077 NCHAR SWITCH 1 0 1 InclCustRes ATP include Customer Reservations      
SC23078 NCHAR SWITCH 1 0 1 InclContrRes ATP include Contract Reservations      
SC23079 NCHAR SWITCH 1 0 1 InclSTOIn ATP include Stock Transfer Order Receipts      
SC23080 NCHAR SWITCH 1 0 1 InclSTOOut ATP include Stock Transfer Order Issues      
SC23081 NVARCHAR VSTRING 3 0 3 CountryCode        
SC23082 NVARCHAR VSTRING 1 0 1 Create stock accounting, Depot Create stock accounting, Depot      
SC23083 INT INTEGER 0 0 1 Standard Cost Pooling Standard Cost Pooling      
SC23084 NCHAR SWITCH 1 0 1 Allow negative balance in MPC module Allow negative balance in MPC module      
SC23085 NVARCHAR VSTRING 6 0 6 Primary Warehouse Primary Warehouse      
SC23086 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
SC23087 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
SC23088 NCHAR SWITCH 1 0 1 MPC, Create Delivery note event MPC, Create Delivery note event      
SC23089 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
SC23090 NVARCHAR VSTRING 6 0 6 Average Cost Group Code Average Cost Group Code      
SC23091 INT INTEGER 0 0 1 Landed Cost Pooling Landed Cost Pooling      
SC23092 NVARCHAR VSTRING 6 0 6 Landed Cost Primary Warehouse Landed Cost Primary Warehouse      

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