One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Stock Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SC01 — Stock Item Master Table

Таблица: SC01 — «Stock Item File». Маска имени таблицы: «SC01%cc00»

История изменения структуры таблицы / Table structure changes history:

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC01001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да
SC01002 NVARCHAR VSTRING 25 0 25 Description1 Description Line 1      
SC01003 NVARCHAR VSTRING 25 0 25 Description2 Description Line 1      
SC01004 NUMERIC MONEY 28 8 20 PriceLocCurr Price (Local Currency)      
SC01005 NUMERIC MONEY 28 8 20 NewPriceLCU New Price (Local Currency)      
SC01006 DATETIME DATE 0 0 8 DateNewPrice Date to Activate New Price      
SC01007 NUMERIC X_NUMERIC 18 8 10 Lenght Length      
SC01008 NUMERIC X_NUMERIC 18 8 10 Width Width      
SC01009 NUMERIC X_NUMERIC 18 8 10 Height Height      
SC01010 NVARCHAR VSTRING 10 0 10 UserDefined1 User Defined Field 1      
SC01011 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
SC01012 NVARCHAR VSTRING 8 0 8 UserDefined3 User Defined Field 3      
SC01013 NVARCHAR VSTRING 6 0 6 UserDefined4 User Defined Field 4      
SC01014 NVARCHAR VSTRING 4 0 4 UserDefined5 User Defined Field 5      
SC01015 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
SC01016 NVARCHAR VSTRING 2 0 2 UserDefined7 User Defined Field 7      
SC01017 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
SC01018 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
SC01019 NVARCHAR VSTRING 2 0 2 UserDefine10 User Defined Field 10      
SC01020 NCHAR SWITCH 1 0 1 AllowNegQty Allow Negative Balances      
SC01021 INT INTEGER 0 0 1 TestSNqty Test Serial Number Quantity      
SC01022 NCHAR SWITCH 1 0 1 AllwAlphaSN Allow Alphanumeric Serial Numbers      
SC01023 NVARCHAR VSTRING 20 0 20 ExtProdGroup Extended Product Group      
SC01024 NVARCHAR VSTRING 25 0 25 AlphSerchKey Alpha Search Key      
SC01025 NVARCHAR VSTRING 10 0 10 UnConvSalPr (obsolete)      
SC01026 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
SC01027 NVARCHAR VSTRING 3 0 3 Planner Planner      
SC01028 NVARCHAR VSTRING 27 0 27 SC0128SPARE (obsolete)      
SC01029 NVARCHAR VSTRING 8 0 8 SC0129SPARE (obsolete)      
SC01030 NVARCHAR VSTRING 1 0 1 ReplacemItem Replacement Item      
SC01031 INT INTEGER 0 0 2 DiscountCode Discount Code      
SC01032 NCHAR SWITCH 1 0 1 FLAGusesBatc Batch Controlled      
SC01033 INT INTEGER 0 0 1 ExtraTaxCode Extra Tax Code      
SC01034 INT INTEGER 0 0 1 DistCharCode Distribution Charge Code      
SC01035 NCHAR STRING 2 0 2 AccountCode Accounting Code      
SC01036 NVARCHAR VSTRING 4 0 4 DelCalenCode (obsolete)      
SC01037 NVARCHAR VSTRING 4 0 4 ProductGroup Product Group      
SC01038 NVARCHAR VSTRING 4 0 4 AltProdGroup Alternative Product Group      
SC01039 NVARCHAR ACCSTR 50 0 50 AccCodeStrg Accounting String      
SC01040 NUMERIC X_NUMERIC 20 8 12 MinPurchQty Minimum Purchase Quantity      
SC01041 NUMERIC X_NUMERIC 20 8 12 MaxPurchQty Maximum Purchase Quantity      
SC01042 NUMERIC X_NUMERIC 20 8 12 StockBalance Stock Balance Total balance for all warehouses    
SC01043 NUMERIC X_NUMERIC 20 8 12 ReservedQty Reserved Quantity Total reserved quantity for all warehouses    
SC01044 NUMERIC X_NUMERIC 20 8 12 BackOrdeQty Back-Ordered Quantity Total back-ordered quantity for all warehouses    
SC01045 NUMERIC X_NUMERIC 20 8 12 SCQtyOrder Quantity Ordered Quantity Total quantity ordered from supplier, for all warehouses    
SC01046 NUMERIC X_NUMERIC 20 8 12 StockTakDiff Stock Tacking Difference Total stocktaking difference in quantity, for all warehouses    
SC01047 NVARCHAR VSTRING 2 0 2 UnitCodSalPr (obsolete)      
SC01048 DATETIME DATE 0 0 8 StockTakDate Latest Stock Taking Date      
SC01049 DATETIME DATE 0 0 8 DelDateSuppl Last Delivery Date from Suppliers      
SC01050 DATETIME DATE 0 0 8 DelDateCust Last Delivery Date to Customers      
SC01051 DATETIME DATE 0 0 8 OrdDateSuppl Last Order Date from Suppliers      
SC01052 NUMERIC X_NUMERIC 28 8 20 AverCostPri1 Average Cost Price (Local Currency) Average cost price in base currency, this is always the same as for the standard warehouse defined in the stock control parameters.    
SC01053 NUMERIC MONEY 28 8 20 StdCostPric1 Standard Cost Price (Local Currency) Standard cost price in base currency, this is always the same as for the standard warehouse defined in the stock control parameters. It will also be used as default standard cost for new warehouses.    
SC01054 NUMERIC X_NUMERIC 20 8 12 QtyRecSuppl Quantity Received from Suppliers      
SC01055 NUMERIC MONEY 28 8 20 PurchasePric Purchase Price (Purchase Currency)      
SC01056 NVARCHAR VSTRING 2 0 2 CurrCodePurc Currency Code Purchase      
SC01057 NUMERIC X_NUMERIC 14 8 6 CalcSurcharg Estimated On-cost % Purchase surcharge expressed as a percentage, this increase the stock value when receiving goods and represents shipping, customs etc… The value on the stock item is only used as default value that will be inherited by new warehouse, the actual percentage used is defined on the warehouse.    
SC01058 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
SC01059 NVARCHAR VSTRING 10 0 10 AlternSuppl Alternative Supplier Code      
SC01060 NVARCHAR VSTRING 35 0 35 SupplStockCo Supplier Stock Code      
SC01061 NUMERIC X_NUMERIC 20 8 12 ReOrdLevel Re-order Level This value will only be used as default value that will be inherited for new warehouses, the actual value used when calculating purchase proposals is the value defined on the warehouse.    
SC01062 INT INTEGER 0 0 3 DelTimeWeek Delivery Time This value will only be used as default value that will be inherited for new warehouses, the actual value used when calculating delivery time is the value defined on the warehouse.    
SC01063 NUMERIC X_NUMERIC 20 8 12 OptPurchQty Economic Order Quantity This value will only be used as default value that will be inherited for new warehouses, the actual value used when calculating purchase proposals is the value defined on the warehouse.    
SC01064 NUMERIC X_NUMERIC 20 8 12 BudgQTYYear Budgeted Ship Quantity per Year This is the total budgeted quantity to ship per year and it includes budget from all warehouses.    
SC01065 INT INTEGER 0 0 1 BudgetModel Budget Model      
SC01066 INT INTEGER 0 0 1 ArticlStatus Stock Item Status      
SC01067 NVARCHAR VSTRING 3 0 3 CountOfOrgin Country of Origin      
SC01068 INT INTEGER 0 0 1 DelTimeUnit Delivery Time Unit 2 — Days
3 — Weeks
4 — Month
5 — Years
   
SC01069 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
SC01070 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
SC01071 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SC01072 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDel Items per Package (Purchase)      
SC01073 NUMERIC X_NUMERIC 18 8 10 QtyUniOutDel Items per Package (Sales)      
SC01074 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
SC01075 NVARCHAR VSTRING 1 0 1 FrequenCode Frequency Code      
SC01076 NCHAR SWITCH 1 0 1 AttachedFlag Frequency Flag      
SC01077 NUMERIC MONEY 28 8 20 ProfitLCUPer Profit Period (Local Currency)      
SC01078 NUMERIC MONEY 28 8 20 ProfitLCUYTD Profit YTD (Local Currency)      
SC01079 NUMERIC MONEY 28 8 20 ProYTDPrevYr Profit YTD Previous Year (Local Currency)      
SC01080 NUMERIC MONEY 28 8 20 ProfYTDPrYr1 Profit YTD Previous Year — 1 (Local Currency)      
SC01081 NUMERIC MONEY 28 8 20 SalesLCUPer Sales Period (Local Currency)      
SC01082 NUMERIC MONEY 28 8 20 SalesLCUYTD Sales YTD (Local Currency)      
SC01083 NUMERIC MONEY 28 8 20 SalYTDPrevYr Sales YTD Previous Year (Local Currency)      
SC01084 NUMERIC MONEY 28 8 20 SaleYTDPrYr1 Sales YTD Previous Year — 1 (Local Currency)      
SC01085 NUMERIC X_NUMERIC 20 8 12 QtyLCUPeriod Quantity Sold Period      
SC01086 NUMERIC X_NUMERIC 20 8 12 QtyLCUYTD Quantity Sold YTD      
SC01087 NUMERIC X_NUMERIC 20 8 12 QtyYTDPreYr Quantity Sold Previous Year      
SC01088 NUMERIC X_NUMERIC 20 8 12 QtyYTDPrYr1 Quantity Sold Previous Year — 1      
SC01089 NVARCHAR VSTRING 35 0 35 ReplStocCode Replacement Stock Code      
SC01090 INT INTEGER 0 0 1 PurchRoule Purchase Rule 0 — Purchase proposals are based on entered sales orders
1 — Purchase proposals are based on budgeted quantity.
   
SC01091 INT INTEGER 0 0 1 ShipmRoule Shipment Rule 0 — No test of the stock balance.
1 — Test on positive stock balance.
2 — Closed stock item, blocked for orders.
3 — Direct delivery from Supplier to customers (no stock transactions/planning is created)
4 — No over delivery allowed
5 — Back delivery to purchase control
   
SC01092 DATETIME DATE 0 0 8 DesNewPrice Date to Deactivate New Price      
SC01093 NVARCHAR VSTRING 25 0 25 InternRem1 Internal Remark Line 1      
SC01094 NVARCHAR VSTRING 25 0 25 InternRem2 Internal Remark Line 2      
SC01095 INT INTEGER 0 0 1 CommissCode Commission Code 1 Related to commission setup in statistic module and are used for calculating commissions for salesmen.    
SC01096 INT INTEGER 0 0 1 StructurFlag BOM Flag      
SC01097 INT INTEGER 0 0 1 QueryQueNo Query Queue Number      
SC01098 NUMERIC X_NUMERIC 18 8 10 SellPricMult Selling Price Multiple      
SC01099 NUMERIC X_NUMERIC 18 8 10 PurcPricMult Cost Price Multiple      
SC01100 NVARCHAR VSTRING 14 0 14 StatCodeExte Statistical Code Extended      
SC01101 INT INTEGER 0 0 3 CustWarrMont Customer Warranty      
SC01102 NCHAR STRING 4 0 4 InspecInterv Inspection Interval Used in service order and defines the interval between inspections for this stock item. The value is used as default for new serial numbers but can be changed on each item.
The leading character specifies the time unit used where ‘W’ stands for weeks, ‘M’ for month and no leading character for number of days.
   
SC01103 NCHAR STRING 4 0 4 MaintenInter Maintenance Interval Used in service order and defines the maintenance interval for this stock item. The value is used as default for new serial numbers but can be changed on each item.
The leading character specifies the time unit used where ‘W’ stands for weeks, ‘M’ for month and no leading character for number of days.
   
SC01104 INT INTEGER 0 0 2 AccrualCode Bonus Code Used for calculating bonus for customers. The value can be between 0 and 99 and this is combined in a matrix with bonus code on the customer to determine the percentage to use.    
SC01105 INT INTEGER 0 0 2 CommisCode2 Commission Code 2 Used for calculating commissions to salesmen. The value can be between 0 and 99 and this is combined in a matrix with bonus code on the customer to determine the percentage to use.    
SC01106 NUMERIC MONEY 28 8 20 LandedCost Landed Cost (Local Currency) Landed cost in base currency, this is always the same as for the standard warehouse defined in the stock control parameters. It will also be used as default landed cost for new warehouses.    
SC01107 NVARCHAR VSTRING 1 0 1 ServiceLevel Service Level      
SC01108 NUMERIC MONEY 28 8 20 PrfLCUNxtPer Profit Next Period (Local Currency)      
SC01109 NUMERIC MONEY 28 8 20 PrfLCUNetYTD Profit Next YTD (Local Currency)      
SC01110 NUMERIC MONEY 28 8 20 SalLCUNxtPer Sales Next Period (Local Currency)      
SC01111 NUMERIC MONEY 28 8 20 SalLCUNxtYTD Sales Next YTD (Local Currency)      
SC01112 NUMERIC X_NUMERIC 20 8 12 QtyLCUNxtPer Quantity Sold Next Period      
SC01113 NUMERIC X_NUMERIC 20 8 12 QtyLCUNxtYTD Quantity Sold Next YTD      
SC01114 NVARCHAR VSTRING 6 0 6 DefaultBinNo Default Bin Code      
SC01115 NVARCHAR VSTRING 1 0 1 MaintContCod Maintenance Contract Code      
SC01116 DATETIME DATE 0 0 8 RecCreatDate Date Created      
SC01117 NCHAR SWITCH 1 0 1 ContrDistrib Controlled Distribution      
SC01118 DATETIME DATE 0 0 8 StarContDist Start Date Controlled Distribution      
SC01119 DATETIME DATE 0 0 8 EndContDist End Date Controlled Distribution      
SC01120 NCHAR SWITCH 1 0 1 HoldStatus Product on Hold      
SC01121 DATETIME DATE 0 0 8 HldStaSrtDat Hold Status Start Date      
SC01122 DATETIME DATE 0 0 8 HldStaEndDat Hold Status End Date      
SC01123 DATETIME DATE 0 0 8 EndOfLifeDat End of Life Date      
SC01124 DATETIME DATE 0 0 8 ObsoleteDate Obsolete Date      
SC01125 DATETIME DATE 0 0 8 ReplacemDate Replacement Date      
SC01126 NVARCHAR VSTRING 35 0 35 EquiStckCode Equivalent Stock Code      
SC01127 INT INTEGER 0 0 1 SerNoStatus Serial Number Status      
SC01128 NVARCHAR VSTRING 10 0 10 ProductCateg Product Category      
SC01129 INT INTEGER 0 0 1 BudgetMode Service Priorities      
SC01130 NVARCHAR VSTRING 2 0 2 ApplicCode1 Application Code 1      
SC01131 NVARCHAR VSTRING 2 0 2 ApplicCode2 Application Code 2      
SC01132 NVARCHAR VSTRING 35 0 35 EANCode EAN Code      
SC01133 INT INTEGER 0 0 4 UnitCodeStoc Unit Code Stock      
SC01134 INT INTEGER 0 0 4 UnitCodePurc Unit Code Purchase      
SC01135 INT INTEGER 0 0 4 UnitCodeSale Unit Code Sales      
SC01136 INT INTEGER 0 0 4 UnitCodeMPC Unit Code MPC      
SC01137 INT INTEGER 0 0 4 UnitCodeSpar Unit Code Other      
SC01138 NVARCHAR VSTRING 4 0 4 SPARE (obsolete)      
SC01139 NUMERIC X_NUMERIC 22 8 14 UnitConvStoc Unit Factor for Stock Unit      
SC01140 NUMERIC X_NUMERIC 22 8 14 UnitConvPurc Unit Factor for Purchase Unit      
SC01141 NUMERIC X_NUMERIC 22 8 14 UnitConvSale Unit Factor for Sales Unit      
SC01142 NUMERIC X_NUMERIC 22 8 14 UnitConvMPC Unit Factor for MPC Unit      
SC01143 NUMERIC X_NUMERIC 22 8 14 UnitConvSpar Unit Factor for Other Unit      
SC01144 INT INTEGER 0 0 2 SalesTaxCodeSTE Sales Tax Code STE      
SC01145 INT INTEGER 0 0 2 PurchaseTaxCodeSTE Purchase Tax Code STE      
SC01146 NUMERIC MONEY 28 8 20 StandRepCost Standard Repair Cost (Local Currency)      
SC01147 NCHAR SWITCH 1 0 1 FlagReparab Reparable      
SC01148 NUMERIC MONEY 28 8 20 StanCostPric Standard Cost Price (Alternative Currency) Average cost price in alternative currency, this is always the same as for the standard warehouse defined in the stock control parameters.
(Alternative currency is used for keeping stock accounting values if two currencies where the alternative is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.)
   
SC01149 NUMERIC MONEY 28 8 20 AverCostPric Average Cost Price (Alternative Currency) Standard cost price in alternative currency, this is always the same as for the standard warehouse defined in the stock control parameters. It will also be used as default standard cost for new warehouses.
(Alternative currency is used for keeping stock accounting values if two currencies where the alternative is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.)
   
SC01150 NVARCHAR VSTRING 35 0 35 ComplStockIt Complementary Stock Item      
SC01151 INT INTEGER 0 0 1 FlagExchRule Exchange Rule 0 — No test is performed for exchange items.
1 — Test for exchange items is performed when releasing service orders.
2 — Exchange item must be in stock before releasing service orders.
   
SC01152 NCHAR STRING 2 0 2 BatcNoPrefix Batch Number Prefix      
SC01153 NUMERIC NUMBER 20 0 6 BatchNumber Batch Number      
SC01154 NUMERIC NUMBER 20 0 3 BatcNOSuffix Batch Number Suffix      
SC01155 NUMERIC X_NUMERIC 20 8 12 QCOnHand QC On-hand      
SC01156 NCHAR STRING 3 0 3 BOANumber BOA-number      
SC01157 NUMERIC MONEY 28 8 20 ABCCost1 ABC-Cost 1 (Local Currency)      
SC01158 NUMERIC MONEY 28 8 20 ABCCost2 ABC-Cost 2 (Local Currency)      
SC01159 NUMERIC MONEY 28 8 20 DirectCost Direct Cost      
SC01160 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Ext. User defined field 1      
SC01161 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Ext. User defined field 2      
SC01162 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Ext. User defined field 3      
SC01163 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Ext. User defined field 4      
SC01164 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Ext. User defined field 5      
SC01165 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Ext. User defined field 6      
SC01166 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Ext. User defined field 7      
SC01167 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Ext. User defined field 8      
SC01168 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Ext. User defined field 9      
SC01169 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Ext. User defined field 10      
SC01170 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Ext. User defined field 11      
SC01171 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Ext. User defined field 12      
SC01172 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Ext. User defined field 13      
SC01173 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Ext. User defined field 14      
SC01174 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Ext. User defined field 15      
SC01175 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Ext. User defined field 16      
SC01176 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Ext. User defined field 17      
SC01177 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Ext. User defined field 18      
SC01178 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Ext. User defined field 19      
SC01179 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Ext. User defined field 20      
SC01180 INT INTEGER 0 0 1 DelMarginRule Delivery Margin Rule      
SC01181 NUMERIC X_NUMERIC 14 8 6 DelMargin Delivery Margin %      
SC01182 NUMERIC X_NUMERIC 20 8 12 OverDeliveryQty (obsolete)      
SC01183 NUMERIC X_NUMERIC 20 8 12 AllocatedQty Allocated Quantity Total quantity allocated to orders, for all warehouses    
SC01184 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
   
SC01185 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
   
SC01186 INT INTEGER 0 0 3 DelLeadTime Delivery Lead Time      
SC01187 INT INTEGER 0 0 1 DelLeadTimeUnit Delivery Lead Time Unit 2 — Days
3 — Weeks
4 — Month
5 — Years
   
SC01188 INT INTEGER 0 0 1 POAdjustment Purchase Order Adjustment, Drop Shipment      
SC01189 INT INTEGER 0 0 1 AvailableServices Available Services      
SC01190 NCHAR STRING 25 0 25 RepairCostRange Repair Cost Range      
SC01191 NCHAR STRING 25 0 25 RepairCostRange2 Repair Cost Range      
SC01192 INT INTEGER 0 0 1 CostProposalRequiredFlag Cost Proposal Required      
SC01193 NCHAR STRING 2 0 2 DefaultExchangePriceList Default Exchange Price List      
SC01194 NCHAR STRING 10 0 10 DefaultEngineer Default Engineer      
SC01195 NCHAR STRING 10 0 10 DefaultWarrantyCustShopOrders Default Warranty Customer Shop Orders      
SC01196 INT INTEGER 0 0 1 ATPcheckItem ATP Check Item      
SC01197 NCHAR SWITCH 1 0 1 QualityControl Quality Control      
SC01198 NCHAR SWITCH 1 0 1 DangerousGoods Dangerous Goods      
SC01199 INT INTEGER 0 0 1 BatchPickingOrder Batch Picking Order 0 — FIFO order (first in first out)
1 — LIFO order (last in first out)
2 — FEFO order (first expire first out)
3 — Best before date order
4 — Bin number order
   
SC01200 INT INTEGER 0 0 2 RentalTimeUnitDefault Default Rental Time Unit 1 — Years
2 — Month
3 — Weeks
4 — Days
5 — Hours
6 — Minutes
   
SC01201 INT INTEGER 0 0 1 ECVATExemptFlag EC VAT Exempt      
SC01202 INT INTEGER 0 0 1 BinControl Bin Controlled      
SC01203 INT INTEGER 0 0 1 ItemBranchPlacement Item/Branch Placement 0 — No restrictions
1 — One stock item per bin
2 — One batch per bin
3 — One batch per stock item and bin, but different stock items allowed.
   
SC01204 INT INTEGER 0 0 3 MinTemperature Minimum Storage Temperature      
SC01205 INT INTEGER 0 0 3 MaxTemperature Maximum Storage Temperature      
SC01206 INT INTEGER 0 0 3 MinHumidity Minimum Storage Humidity      
SC01207 INT INTEGER 0 0 3 MaxHumidity Maximum Storage Humidity      
SC01208 NCHAR STRING 1 0 1 StorageType1 Storage Type 1      
SC01209 NCHAR STRING 1 0 1 StorageType2 Storage Type 2      
SC01210 NCHAR STRING 1 0 1 StorageType3 Storage Type 3      
SC01211 NCHAR STRING 1 0 1 StorageType4 Storage Type 4      
SC01212 NVARCHAR VSTRING 4 0 4 BinLocationRuleType Bin Location Rule Type      
SC01213 NCHAR STRING 2 0 2 DSSuppSelRuleType Drop Shipment Supplier Selection Rule 0 — Supplier from stock item is used.
1 — Supplier with the lowest purchase price is used.
2 — Supplier with the shortest delivery time is used.
3 — If stock item has no defined supplier the supplier with the lowest purchase price is used.
4 — If stock item has no defined supplier the supplier with the shortest delivery time is used.
   
SC01214 INT INTEGER 0 0 1 CreateConfiguration Create Configuration 0 — System will not create a configuration with the current stock item as a top one
1 — System will ask whether if should create a configuration with the current stock item as a top one
2 — System will always create a configuration with the current stock item as a top one
   
SC01215 NCHAR STRING 35 0 35 ConfigurationCode Configuration Code      
SC01216 NCHAR STRING 1 0 1 SaveConfigurationHistory Save Configuration History      
SC01217 INT INTEGER 0 0 1 IssueExpiredBatch Allow Issue from Expired Batches      
SC01218 NCHAR STRING 6 0 6 SalesTaxCodeATE Sales Tax Code ATE      
SC01219 NCHAR SWITCH 1 0 1 SC01217 (obsolete)      
SC01220 NUMERIC X_NUMERIC 28 8 20 PortionSize Portion Size      
SC01221 NUMERIC X_NUMERIC 28 8 20 MultipleFactor Multiple Factor      
SC01222 NUMERIC X_NUMERIC 28 8 20 CalorificValue Calorific Value      
SC01223 NUMERIC X_NUMERIC 28 8 20 ProteinValue Protein Value      
SC01224 NUMERIC X_NUMERIC 28 8 20 FatValue Fat Value      
SC01225 NUMERIC X_NUMERIC 28 8 20 CarbohydrateValue Carbohydrate Value      
SC01226 NVARCHAR VSTRING 12 0 12 PLAccount P&L Account      
SC01227 INT INTEGER 0 0 4 BOMDefaultUOMCode BOM default UOM code      
SC01228 NUMERIC X_NUMERIC 26 8 18 BOMDefaultUOMFactor BOM default UOM factor      
SC01229 NVARCHAR VSTRING 10 0 10 ItemType Item Type Item Type    
SC01230 NVARCHAR VSTRING 25 0 25 TariffNo Tariff Number Tariff Number    
SC01231 NCHAR STRING 1 0 1 OriginCode Origin Code      
SC01232 NVARCHAR VSTRING 25 0 25 NomenclatureNo Nomenclature Number      
SC01233 NCHAR STRING 2 0 2 GoodsType Goods Type      
SC01234 NVARCHAR VSTRING 1 0 1 StockValuationModel Valuation Model      
SC01235 NVARCHAR VSTRING 1 0 1 StockValModelCC Valuation Model for Alternative Currency      
SC01236 NVARCHAR VSTRING 1 0 1 BOMDiscountMethod BOM discount method      
SC01237 NCHAR STRING 6 0 6 LTMGroupOR LTM Group — OR      
SC01238 NCHAR STRING 6 0 6 LTMGroupPC LTM Group — PC      
SC01239 NUMERIC X_NUMERIC 28 8 20 BOMCost BOM Cost      
SC01240 NVARCHAR VSTRING 35 0 35 GTIN GTIN      
SC01241 NVARCHAR VSTRING 150 0 150 UDefBarCodeIdent Udef Barcode identities      
SC01242 INT INTEGER 0 0 3 DTF Demand Time Fence      
SC01243 NCHAR SWITCH 1 0 1 IncomingPropertiesControl Incoming Properties Control      
SC01244 INT INTEGER 0 0 1 TemperatureRequiredFlag Temperature required flag      
SC01245 INT INTEGER 0 0 1 Humidityrequiredflag Humidity required flag      
SC01246 INT INTEGER 0 0 1 TemperatureEnforceFlag Temperature enforce flag      
SC01247 INT INTEGER 0 0 1 HumidityEnforce Humidity enforce flag      
SC01248 INT INTEGER 0 0 2 TemperatureUnit Temperature unit code      
SC01249 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
SC01250 INT INTEGER 0 0 1 ExportStatus Export Status      
SC01251 NCHAR SWITCH 1 0 1 ChargeCostForPackMtrl Charge Cost for Packaging Materials?      
SC01252 NCHAR SWITCH 1 0 1 FixedChargeWeight Fixed charge per weight?      
SC01253 NUMERIC MONEY 28 8 20 PackageTaxAmntPerKg Packaging Tax Amount per kg      
SC01254 NVARCHAR VSTRING 35 0 35 CommodityCode Commodity code      
SC01255 NVARCHAR VSTRING 8 0 8 CreatedBy Created By      
SC01256 NCHAR STRING 6 0 6 PurchaseTaxCodeATE Purchase Tax Code ATE      
SC01257 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
SC01258 NVARCHAR VSTRING 45 0 45 REACHUUID REACH UUID      
SC01259 NUMERIC X_NUMERIC 18 8 10 REACHWeight REACH Weight      
SC01260 INT INTEGER 0 0 4 REACHWeightUnit REACH Weight Unit      
SC01261 DATETIME DATE 0 0 8 REACHFromDate REACH From Date      
SC01262 DATETIME DATE 0 0 8 REACHToDate REACH To Date      
Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SC01133 0 2 0 2 0 4 0 4 0 4 0 4 0 4
SC01134 0 2 0 2 0 4 0 4 0 4 0 4 0 4
SC01135 0 2 0 2 0 4 0 4 0 4 0 4 0 4
SC01136 0 2 0 2 0 4 0 4 0 4 0 4 0 4
SC01137 0 2 0 2 0 4 0 4 0 4 0 4 0 4
SC01160 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01161 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01162 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01163 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01164 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01165 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01166 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01167 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01168 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01169 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01170 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01171 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01172 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01173 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01174 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01175 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01176 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01177 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01178 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01179 2 2 2 2 2 2 50 50 50 50 50 50 150 150
SC01227 0 2 0 2 0 4 0 4 0 4 0 4 0 4
SC01230 10 10 10 10 25 25 25 25 25 25 25 25 25 25
SC01232 10 10 25 25 25 25 25 25 25 25 25 25 25 25
SC01237 6 6 6 6 6 6 6 6 6 6 6 6
SC01238 6 6 6 6 6 6 6 6 6 6 6 6
SC01239 28 20 28 20 28 20 28 20 28 20 28 20
SC01240 35 35 35 35 35 35 35 35 35 35 35 35
SC01241 150 150 150 150 150 150 150 150 150 150 150 150
SC01242 0 3 0 3 0 3 0 3 0 3 0 3
SC01243 1 1 1 1 1 1 1 1 1 1 1 1
SC01244 0 1 0 1 0 1 0 1 0 1 0 1
SC01245 0 1 0 1 0 1 0 1 0 1 0 1
SC01246 0 1 0 1 0 1 0 1 0 1 0 1
SC01247 0 1 0 1 0 1 0 1 0 1 0 1
SC01248 0 2 0 2 0 2 0 2 0 2 0 2
SC01249 2 2 2 2 2 2 2 2 2 2
SC01250 0 1 0 1 0 1 0 1
SC01251 1 1 1 1 1 1
SC01252 1 1 1 1 1 1
SC01253 28 20 28 20 28 20
SC01254 35 35 35 35 35 35
SC01255 8 8 8 8
SC01256 6 6 6 6
SC01257 10 10 10 10
SC01258 45 45
SC01259 18 10
SC01260 0 4
SC01261 0 8
SC01262 0 8
SC01263 0 1
SC01264 12 12
SC01265 0 1

Навигация: