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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SC23 — Warehouse Master Table

Таблица / Table: SC23 — «Warehouse Addresses». Маска имени таблицы / Table name mask: «SC23%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 SPARE SPARE      
SC23009 NVARCHAR VSTRING 1 0 1 SPARE SPARE      
SC23010 NVARCHAR ACCSTR 120 0 120 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 SPARE SPARE      
SC23018 NCHAR STRING 3 0 3 SPARE SPARE      
SC23019 NUMERIC MONEY 28 8 20 SPARE SPARE      
SC23020 NCHAR STRING 1 0 1 SPARE SPARE      
SC23021 NCHAR STRING 1 0 1 SPARE SPARE      
SC23022 NUMERIC NUMBER 20 0 10 SPARE SPARE      
SC23023 NUMERIC NUMBER 20 0 10 SPARE SPARE      
SC23024 NUMERIC X_NUMERIC 18 8 10 SPARE SPARE      
SC23025 NCHAR STRING 3 0 3 ExcludeLockedBatches ATP Include Exclude Locked Batches      
SC23026 NCHAR STRING 8 0 8 SPARE SPARE      
SC23027 NVARCHAR VSTRING 1 0 1 Depot Depot      
SC23028 NVARCHAR VSTRING 10 0 10 InternalCustomerDepot Internal Customer, Depot      
SC23029 NVARCHAR VSTRING 1 0 1 ATPInclFPO ATP Include Firmed Purchase Order      
SC23030 NVARCHAR VSTRING 1 0 1 ATPInclFirmedOrd ATP Include Firmed Order      
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 Confirmed 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 CalendarColRef Calendar Collection      
SC23055 NCHAR STRING 2 0 2 WHType Warehouse Type 00 — Regular warehouse

01 — Consignment warehouse (Suppliers)
   
SC23056 NCHAR STRING 10 0 10 CustSuppCode 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 StockValuationModel Valuation Model      
SC23060 INT INTEGER 0 0 1 StockValuationModelPriority Valuation Model Priority      
SC23061 NVARCHAR VSTRING 1 0 1 StockValModelCC Valuation Model for Alternative Currency      
SC23062 INT INTEGER 0 0 1 StockValuationModelPriorityforCC Valuation Model Priority for Alternative Currency      
SC23063 NCHAR STRING 6 0 6 DelivNoteIssuer Delivery Note Issuer      
SC23064 INT INTEGER 0 0 9 CalendarCollectionCC Cycle Counting Calendar Collection      
SC23065 DATETIME X_DATETIME 0 0 17 NumOfWorkHoursCC Cycle Counting Number of Working Hours      
SC23066 NCHAR SWITCH 1 0 1 UseCPL Use Common picking      
SC23067 NCHAR SWITCH 1 0 1 AllocFromPickList Allocate from picking list      
SC23068 NCHAR SWITCH 1 0 1 UseReleaseForShipment Use Release for picking      
SC23069 NCHAR SWITCH 1 0 1 UseMergedCPL Use merged picking lists      
SC23070 NCHAR SWITCH 1 0 1 MergeDiffDest Merge different destination      
SC23071 NCHAR SWITCH 1 0 1 MergeDiffPlannedPickDates Merge different planned picking dates      
SC23072 NCHAR STRING 1 0 1 SortOption Sort option      
SC23073 INT INTEGER 0 0 3 CreatePickListDirect Direct creation of picking request      
SC23074 NCHAR SWITCH 1 0 1 PrintAfterCreation Print after creation      
SC23075 INT INTEGER 0 0 2 NumOfCopiesPickList No of copies, picking list      
SC23076 INT INTEGER 0 0 2 NumOfCopiesDN 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 CountryCode      
SC23082 NVARCHAR VSTRING 1 0 1 CreateStockAccDepot Create stock accounting, Depot      
SC23083 INT INTEGER 0 0 1 StandardCostPooling Standard Cost Pooling      
SC23084 NCHAR SWITCH 1 0 1 AllowNegBalanceMPC Allow negative balance in MPC module      
SC23085 NVARCHAR VSTRING 6 0 6 PrimaryWarehouse 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 MPCCreateDNEvent MPC, Create Delivery note event      
SC23089 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
SC23090 NVARCHAR VSTRING 6 0 6 AverageCostGroupCode Average Cost Group Code      
SC23091 INT INTEGER 0 0 1 LandedCostPooling Landed Cost Pooling      
SC23092 NVARCHAR VSTRING 6 0 6 LandedCostPrimaryWarehouse Landed Cost Primary Warehouse      
SC23093 INT INTEGER 0 0 1 Blocked Blocked      

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