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

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SC01 — Stock Item Master Table

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC01001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
SC01002 NVARCHAR VSTRING 25 0 25 Description1 Description Line 1      
SC01003 NVARCHAR VSTRING 25 0 25 Description2 Description Line 2      
SC01004 NUMERIC MONEY 28 8 20 PriceLocCurr Selling Price (Local Currency)      
SC01005 NUMERIC MONEY 28 8 20 NewPriceLCU New Selling 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 Unit Convert for SALES PRICES      
SC01026 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
SC01027 NVARCHAR VSTRING 3 0 3 Planner Planner      
SC01028 NVARCHAR VSTRING 27 0 27 SC0128SPARE Spare      
SC01029 NVARCHAR VSTRING 8 0 8 SC0129SPARE Spare      
SC01030 NVARCHAR VSTRING 1 0 1 ReplacemItem Replacement Item flag      
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 Other 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 Delivery Calendar Code      
SC01037 NVARCHAR VSTRING 4 0 4 ProductGroup Product Group      
SC01038 NVARCHAR VSTRING 4 0 4 AltProdGroup Alternative Product Group      
SC01039 NVARCHAR ACCSTR 120 0 120 AccCodeStrg Accounting String      
SC01040 NUMERIC X_NUMERIC 20 8 12 MinPurchQty Min purchase quantity      
SC01041 NUMERIC X_NUMERIC 20 8 12 MaxPurchQty Max 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 stock 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 Purchase order quantity Total quantity ordered from supplier, for all warehouses    
SC01046 NUMERIC X_NUMERIC 20 8 12 StockTakDiff Stock taking difference Total stocktaking difference in quantity, for all warehouses    
SC01047 NVARCHAR VSTRING 2 0 2 UnitCodSalPr Sales price unit code      
SC01048 DATETIME DATE 0 0 8 StockTakDate Latest stock taking date      
SC01049 DATETIME DATE 0 0 8 DelDateSuppl Latest date stock received      
SC01050 DATETIME DATE 0 0 8 DelDateCust Latest date stock issue      
SC01051 DATETIME DATE 0 0 8 OrdDateSuppl Latest purchase order date      
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      
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 Attached flag      
SC01077 NUMERIC MONEY 28 8 20 ProfitLCUPer Gross profit period      
SC01078 NUMERIC MONEY 28 8 20 ProfitLCUYTD Gross profit YTD      
SC01079 NUMERIC MONEY 28 8 20 ProYTDPrevYr Gross profit previous year      
SC01080 NUMERIC MONEY 28 8 20 ProfYTDPrYr1 Gross profit previous year -1      
SC01081 NUMERIC MONEY 28 8 20 SalesLCUPer Turnover period      
SC01082 NUMERIC MONEY 28 8 20 SalesLCUYTD Turnover YTD      
SC01083 NUMERIC MONEY 28 8 20 SalYTDPrevYr Turnover previous year      
SC01084 NUMERIC MONEY 28 8 20 SaleYTDPrYr1 Turnover previous year -1      
SC01085 NUMERIC X_NUMERIC 20 8 12 QtyLCUPeriod Delivered quantity period      
SC01086 NUMERIC X_NUMERIC 20 8 12 QtyLCUYTD Delivered quantity YTD      
SC01087 NUMERIC X_NUMERIC 20 8 12 QtyYTDPreYr Delivered quantity previous year      
SC01088 NUMERIC X_NUMERIC 20 8 12 QtyYTDPrYr1 Delivered quantity 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 Remark 1      
SC01094 NVARCHAR VSTRING 25 0 25 InternRem2 Remark 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 Structure 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 Warranty Month      
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 Gross profit next period      
SC01109 NUMERIC MONEY 28 8 20 PrfLCUNetYTD Gross profit next year      
SC01110 NUMERIC MONEY 28 8 20 SalLCUNxtPer Turnover next period      
SC01111 NUMERIC MONEY 28 8 20 SalLCUNxtYTD Turnover next year      
SC01112 NUMERIC X_NUMERIC 20 8 12 QtyLCUNxtPer Delivery quantity next period      
SC01113 NUMERIC X_NUMERIC 20 8 12 QtyLCUNxtYTD Delivery quantity next year      
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 Usage      
SC01128 NVARCHAR VSTRING 10 0 10 ProductCateg Product Category      
SC01129 INT INTEGER 0 0 1 BudgetMode Service Priority      
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 Spare      
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 balance      
SC01156 NCHAR STRING 3 0 3 BOANumber BOA Number      
SC01157 NUMERIC MONEY 28 8 20 ABCCost1 ABC-Cost 1      
SC01158 NUMERIC MONEY 28 8 20 ABCCost2 ABC-Cost 2      
SC01159 NUMERIC MONEY 28 8 20 DirectCost Direct Cost      
SC01160 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Extended User defined 1      
SC01161 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Extended User defined 2      
SC01162 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Extended User defined 3      
SC01163 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Extended User defined 4      
SC01164 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Extended User defined 5      
SC01165 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Extended User defined 6      
SC01166 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Extended User defined 7      
SC01167 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Extended User defined 8      
SC01168 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Extended User defined 9      
SC01169 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Extended User defined 10      
SC01170 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Extended User defined 11      
SC01171 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Extended User defined 12      
SC01172 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Extended User defined 13      
SC01173 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Extended User defined 14      
SC01174 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Extended User defined 15      
SC01175 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Extended User defined 16      
SC01176 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Extended User defined 17      
SC01177 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Extended User defined 18      
SC01178 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Extended User defined 19      
SC01179 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Extended User defined 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 Over delivered quantity      
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 Drop Shipment Delivery Lead Time      
SC01187 INT INTEGER 0 0 1 DelLeadTimeUnit Drop Shipment Delivery Lead Time Unit 2 — Days

3 — Weeks

4 — Month

5 — Years
   
SC01188 INT INTEGER 0 0 1 POAdjustment PO Adjustment, Drop Shipment      
SC01189 INT INTEGER 0 0 1 AvailableServices Available service      
SC01190 NCHAR STRING 25 0 25 RepairCostRange Repair Cost Range 1      
SC01191 NCHAR STRING 25 0 25 RepairCostRange2 Repair Cost Range 2      
SC01192 INT INTEGER 0 0 1 CostProposalRequiredFlag Cost Proposal Required Flag      
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      
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 Controlled 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 Exemption      
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 FEFO Order      
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 NCM Code Item Type    
SC01230 NVARCHAR VSTRING 25 0 25 TariffNo NCM Sub Code 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 Code      
SC01241 NVARCHAR VSTRING 150 0 150 UDefBarCodeIdent Barcode identities      
SC01242 INT INTEGER 0 0 3 DTF DTF      
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      
SC01263 INT INTEGER 0 0 1 AssetPurchase Asset Purchase      
SC01264 NVARCHAR VSTRING 12 0 12 AssetAccount Asset Account      
SC01265 INT INTEGER 0 0 1 AssetPerUnit Asset Per Unit      
SC01266 NCHAR STRING 3 0 3 TaxReasonCode Reason Code for Non-Standard Taxation      

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