Таблица | Table: SC03 - «Warehouse File». Маска имени таблицы | Table Name Mask: «SC03%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?
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 Taking Difference      
SC03008 INT INTEGER 0 0 3 DelTimeToWH Delivery Time to Warehouse      
SC03009 DATETIME DATE 0 0 8 StockTakDate Last 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 StockTakDiff Stock Taking Difference Value (Local Currency)      
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 (obsolete)      
SC03025 NUMERIC MONEY 28 8 20 StockTakDiffCCU (obsolete)      
SC03026 NVARCHAR VSTRING 2 0 2 CurrCodPurch (obsolete)      
SC03027 NVARCHAR VSTRING 3 0 3 CountOfOrig (obsolete)      
SC03028 NCHAR SWITCH 1 0 1 FLAGDiffSupp Supplier Specified for Warehouse      
SC03029 NUMERIC MONEY 28 8 20 FIFOValue1 FIFO Value (Local Currency)      
SC03030 NVARCHAR VSTRING 5 0 5 Spare (obsolete)      
SC03031 NVARCHAR VSTRING 5 0 5 Spare (obsolete)      
SC03032 NVARCHAR VSTRING 10 0 10 Spare (obsolete)      
SC03033 DATETIME DATE 0 0 8 StdCostLaCaD Last Standard Cost Calculation Date      
SC03034 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
SC03035 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
SC03036 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
SC03037 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
SC03038 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
SC03039 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
SC03040 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
SC03041 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
SC03042 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
SC03043 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
SC03044 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
SC03045 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
SC03046 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
SC03047 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
SC03048 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
SC03049 NVARCHAR VSTRING 1 0 1 More standard cost investigation needed More Standard Cost Investigation Needed      
SC03050 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SC03051 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SC03052 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SC03053 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SC03054 DATETIME DATE 0 0 8 DelDateSuppl Last Delivery Date from Suppliers      
SC03055 DATETIME DATE 0 0 8 DelDateCust Last Delivery Date to Customers      
SC03056 DATETIME DATE 0 0 8 OrdDateSuppl Last Order Date from 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 (obsolete)      
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 (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.    
SC03067 NUMERIC MONEY 28 8 20 LowesPurchPr 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 QC_OnHand QC On-hand      
SC03073 NCHAR STRING 1 0 1 ABC_Categ ABC-Category      
SC03074 NCHAR STRING 3 0 3 ABC_Group ABC-Group      
SC03075 NCHAR STRING 3 0 3 BOA_Number BOA-number      
SC03076 NUMERIC MONEY 28 8 20 ABC_Cost1 ABC-Cost 1      
SC03077 NUMERIC MONEY 28 8 20 ABC_Cost2 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 Years 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 MPS_Planned MPS Planned      
SC03084 NCHAR STRING 1 0 1 MRP_Planned 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 Last Cost Calculation      
SC03098 NUMERIC X_NUMERIC 20 8 12 MaxStockQty Maximum 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 (obsolete)      
SC03105 NCHAR STRING 3 0 3 Spare (obsolete)      
SC03106 NCHAR STRING 3 0 3 Spare (obsolete)      
SC03107 NCHAR STRING 1 0 1 Spare (obsolete)      
SC03108 NCHAR STRING 1 0 1 Spare (obsolete)      
SC03109 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
SC03110 NUMERIC X_NUMERIC 20 8 12 Spare (obsolete)      
SC03111 NUMERIC MONEY 28 8 20 Spare Stock Taking Difference Value (Alternative Currency)      
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 Delivery Lead Time      
SC03115 INT INTEGER 0 0 1 DelLeadTimeUnit Delivery Lead Time Unit      
SC03116 INT INTEGER 0 0 1 POAdjustment Purchase Order Adjustment      
SC03117 INT INTEGER 0 0 1 DelMarginRule Delivery Margin Rule      
SC03118 NUMERIC X_NUMERIC 14 8 6 DelMargin Delivery Margin %      
SC03119 NCHAR SWITCH 1 0 1 Flag_Use_DS_Properties Use Warehouse Drop Shipment Rules      
SC03120 NUMERIC X_NUMERIC 28 8 20 BOM Cost BOM Cost      

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