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 SC03 — Item Warehouse

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC03001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
SC03002 NVARCHAR VSTRING 6 0 6 LocationID Warehouse   2 Да / Yes
SC03003 NUMERIC X_NUMERIC 20 8 12 StockBalance Stock balance      
SC03004 NUMERIC X_NUMERIC 20 8 12 ReservedQty Reserved quantity      
SC03005 NUMERIC X_NUMERIC 20 8 12 BackOrdQty Back-Ordered quantity      
SC03006 NUMERIC X_NUMERIC 20 8 12 QtyOrdered1 Quantity Ordered      
SC03007 NUMERIC X_NUMERIC 20 8 12 StockTakDiff Stock Tacking Difference quantity      
SC03008 INT INTEGER 0 0 3 DelTimeToWH Delivery Time to Warehouse      
SC03009 DATETIME DATE 0 0 8 StockTakDate Latest Stock Taking Date      
SC03010 NUMERIC X_NUMERIC 20 8 12 ReOrderLevel Re-order Level      
SC03011 NUMERIC X_NUMERIC 20 8 12 OptPurchQty Economic Order Quantity      
SC03012 NUMERIC X_NUMERIC 20 8 12 BudgQtyYear Budgeted Ship Quantity per Year      
SC03013 NVARCHAR VSTRING 6 0 6 DefaultBinNo Default Bin      
SC03014 NUMERIC MONEY 28 8 20 LowesPurchPr Lowest Purchase Price (Local Currency)      
SC03015 NUMERIC X_NUMERIC 20 8 12 LockedQty Locked quantity      
SC03016 NUMERIC X_NUMERIC 20 8 12 AllocQty Allocated quantity      
SC03017 NUMERIC MONEY 28 8 20 StockTakDiffLCU Stock Taking Difference Value      
SC03018 NUMERIC X_NUMERIC 20 8 12 MinPurchQty Minimum Purchase Quantity      
SC03019 NUMERIC X_NUMERIC 20 8 12 MaxPurchQty Maximum Purchase Quantity      
SC03020 INT INTEGER 0 0 1 DelTimeUnit Delivery Time Unit 2 — Days

3 — Weeks

4 — Month

5 — Years
   
SC03021 NVARCHAR VSTRING 4 0 4 DelCalenCode Delivery Calendar Code      
SC03022 NVARCHAR VSTRING 10 0 10 Supplier Supplier Code      
SC03023 NVARCHAR VSTRING 10 0 10 AlternSuppli Alternative Supplier Code      
SC03024 NVARCHAR VSTRING 35 0 35 SuppStocCode Supplier Stock Code      
SC03025 NUMERIC MONEY 28 8 20 StockTakDiffCCU Purchase Price      
SC03026 NVARCHAR VSTRING 2 0 2 CurrCodPurch Currency Code Purchase      
SC03027 NVARCHAR VSTRING 3 0 3 CountOfOrig Country of Origin      
SC03028 NCHAR SWITCH 1 0 1 FLAGDiffSupp Supplier Specified for Warehouse      
SC03029 NUMERIC MONEY 28 8 20 FIFOValue1 FIFO Value LCU      
SC03030 NVARCHAR VSTRING 5 0 5 Spare Spare      
SC03031 NVARCHAR VSTRING 5 0 5 Spare Spare      
SC03032 NVARCHAR VSTRING 10 0 10 Spare Spare      
SC03033 DATETIME DATE 0 0 8 StdCostLaCaD Latest Calculation Date for Standard Cost (MPC)      
SC03034 NVARCHAR VSTRING 8 0 8 Spare Spare      
SC03035 NVARCHAR VSTRING 8 0 8 Spare Spare      
SC03036 NVARCHAR VSTRING 8 0 8 Spare Spare      
SC03037 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC03038 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC03039 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC03040 NVARCHAR VSTRING 4 0 4 Spare Spare      
SC03041 NVARCHAR VSTRING 4 0 4 Spare Spare      
SC03042 NVARCHAR VSTRING 4 0 4 Spare Spare      
SC03043 NVARCHAR VSTRING 4 0 4 Spare Spare      
SC03044 NVARCHAR VSTRING 2 0 2 Spare Spare      
SC03045 NVARCHAR VSTRING 2 0 2 Spare Spare      
SC03046 NVARCHAR VSTRING 2 0 2 Spare Spare      
SC03047 NVARCHAR VSTRING 2 0 2 Spare Spare      
SC03048 NVARCHAR VSTRING 2 0 2 Spare Spare      
SC03049 NVARCHAR VSTRING 1 0 1 MoveStdCostInvestigationNeeded More standard cost investigation needed      
SC03050 NVARCHAR VSTRING 1 0 1 Spare Spare      
SC03051 NVARCHAR VSTRING 1 0 1 Spare Spare      
SC03052 NVARCHAR VSTRING 1 0 1 Spare Spare      
SC03053 NVARCHAR VSTRING 1 0 1 Spare Spare      
SC03054 DATETIME DATE 0 0 8 DelDateSuppl Latest Delivery Date from supplier      
SC03055 DATETIME DATE 0 0 8 DelDateCust Latest Delivery Date to customer      
SC03056 DATETIME DATE 0 0 8 OrdDateSuppl Latest order Date to supplier      
SC03057 NUMERIC X_NUMERIC 28 8 20 AverCostPrc2 Average Cost (Local Currency)      
SC03058 NUMERIC MONEY 28 8 20 StdCostPrc2 Standard Cost (Local Currency)      
SC03059 NUMERIC MONEY 28 8 20 LandedCost Landed Cost (Local Currency)      
SC03060 NUMERIC X_NUMERIC 14 8 6 PurchSurchar Estimated On-cost %      
SC03061 INT INTEGER 0 0 1 BudgetModel Budget Model      
SC03062 NUMERIC X_NUMERIC 20 8 12 QtyOrdered2 Quantity Ordered      
SC03063 NVARCHAR VSTRING 20 0 20 UnAllocCosts Spare      
SC03064 NUMERIC X_NUMERIC 28 8 20 AverCostPric Average Cost (Alternative Currency) Value in alternative (consolidated) currency is used for keeping stock accounting in a parallel currency where the second currency is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.    
SC03065 NUMERIC MONEY 28 8 20 StdCostPrice Standard Cost (Alternative Currency) Value in alternative (consolidated) currency is used for keeping stock accounting in a parallel currency where the second currency is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.    
SC03066 NUMERIC MONEY 28 8 20 FIFOValue2 FIFO Value CC Value in alternative (consolidated) currency is used for keeping stock accounting in a parallel currency where the second currency is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.    
SC03067 NUMERIC MONEY 28 8 20 LowestPurchPriceCCU Lowest Purchase Price (Alternative Currency) Value in alternative (consolidated) currency is used for keeping stock accounting in a parallel currency where the second currency is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.    
SC03068 NCHAR STRING 2 0 2 BatcNoPrefix Batch number prefix      
SC03069 NUMERIC NUMBER 20 0 6 BatchNumber Batch number      
SC03070 NUMERIC NUMBER 20 0 3 BatcNoSuffix Batch number suffix      
SC03071 NCHAR STRING 1 0 1 FixBinLocat Fixed Bin Location      
SC03072 NUMERIC NUMBER 20 0 12 QCOnHand QC On-hand      
SC03073 NCHAR STRING 1 0 1 ABCCateg ABC-Category      
SC03074 NCHAR STRING 3 0 3 ABCGroup ABC-Group      
SC03075 NCHAR STRING 3 0 3 BOANumber BOA-number      
SC03076 NUMERIC MONEY 28 8 20 ABCCost1 ABC-Cost 1      
SC03077 NUMERIC MONEY 28 8 20 ABCCost2 ABC-Cost 2      
SC03078 NUMERIC MONEY 28 8 20 DirectCost Direct Cost      
SC03079 NUMERIC MONEY 28 8 20 PrevStdCost Previous Standard cost      
SC03080 NUMERIC MONEY 28 8 20 NxtYrStdCost Next Year Standard cost      
SC03081 NUMERIC MONEY 28 8 20 SimuStdCost Simulated Standard cost      
SC03082 NUMERIC X_NUMERIC 20 8 12 CostingQty Costing Quantity      
SC03083 NCHAR STRING 1 0 1 MPSPlanned MPS-planned      
SC03084 NCHAR STRING 1 0 1 MRPPlanned MRP-planned      
SC03085 NCHAR STRING 1 0 1 MRPNeed MRP Need      
SC03086 INT INTEGER 0 0 3 NoOfDays Number of days      
SC03087 INT INTEGER 0 0 3 TimeBucket Time Bucket      
SC03088 NCHAR STRING 1 0 1 PlanMethod Planning method      
SC03089 NVARCHAR VSTRING 15 0 15 Planner Planner      
SC03090 NCHAR STRING 1 0 1 LotSizeMeth Lot Size Method      
SC03091 NCHAR STRING 6 0 6 Multiple Multiple      
SC03092 NUMERIC X_NUMERIC 20 8 12 SafetyStock Safety Stock      
SC03093 NUMERIC X_NUMERIC 20 8 12 Forecast1 Forecast 1      
SC03094 NUMERIC X_NUMERIC 20 8 12 Forecast2 Forecast 2      
SC03095 NUMERIC X_NUMERIC 20 8 12 Forecast3 Forecast 3      
SC03096 NUMERIC X_NUMERIC 20 8 12 Forecast4 Forecast 4      
SC03097 DATETIME DATE 0 0 8 LatestConsol Latest cost calculation date      
SC03098 NUMERIC X_NUMERIC 20 8 12 MaxStockQty Max stock quantity      
SC03099 NUMERIC X_NUMERIC 20 8 12 Turnover Turnover      
SC03100 NCHAR STRING 1 0 1 SettPricType Settlement Price Type      
SC03101 NCHAR STRING 3 0 3 SettPricList Settlement Price List      
SC03102 NCHAR STRING 3 0 3 CurrencyCode Currency Code      
SC03103 NUMERIC X_NUMERIC 20 8 12 QtyOnPickLis Quantity on Picking List      
SC03104 NCHAR STRING 3 0 3 Spare Spare field 1      
SC03105 NCHAR STRING 3 0 3 Spare Spare field 2      
SC03106 NCHAR STRING 3 0 3 Spare Spare field 1      
SC03107 NCHAR STRING 1 0 1 Spare Spare field 3      
SC03108 NCHAR STRING 1 0 1 Spare Spare field 4      
SC03109 NVARCHAR VSTRING 8 0 8 Spare Spare field 5      
SC03110 NUMERIC X_NUMERIC 20 8 12 Spare Spare field 6      
SC03111 NUMERIC MONEY 28 8 20 Spare Stock Taking Difference Value CC      
SC03112 NVARCHAR VSTRING 1 0 1 DropShipment Drop Shipment Rule 0 — No drop shipment

1 — Manually select drop shipment at time of order

2 — Automatically create drop shipment order

3 — Optional drop shipment
   
SC03113 NVARCHAR VSTRING 1 0 1 POReceipt Drop Shipment Issue/Receipt Rule 0 — Receive into Inventory

1 — Receive into Inventory and hard allocate to sales/service order

2 — Receive into Inventory and issue to sales/service order

3 — Issue to sales/service order without inventory update
   
SC03114 INT INTEGER 0 0 3 DelLeadTime Drop Shipment Delivery Lead Time      
SC03115 INT INTEGER 0 0 1 DelLeadTimeUnit Drop Shipment Delivery Lead Time Unit      
SC03116 INT INTEGER 0 0 1 POAdjustment PO Adjustment (Drop Shipment)      
SC03117 INT INTEGER 0 0 1 DelMarginRule Delivery Margin Rule (Drop Shipment)      
SC03118 NUMERIC X_NUMERIC 14 8 6 DelMargin Delivery Margin % (Drop Shipment)      
SC03119 NCHAR SWITCH 1 0 1 FlagUseDSProperties Use Warehouse Drop Shipment Rules      
SC03120 NUMERIC X_NUMERIC 28 8 20 BOMCost BOM Cost      

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