Таблица: SC37 - «Standard Stock Items». Маска имени таблицы: «SC37%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC37001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Template Code   1 Да
SC37002 NVARCHAR VSTRING 25 0 25 Description1 Description Line 1      
SC37003 NVARCHAR VSTRING 25 0 25 Description2 Description Line 1      
SC37004 NUMERIC MONEY 28 8 20 PriceLocCurr Price (Local Currency)      
SC37005 NUMERIC MONEY 28 8 20 NewPriceLCU New Price (Local Currency)      
SC37006 DATETIME DATE 0 0 8 DateNewPrice Date to Activate New Price      
SC37007 NUMERIC X_NUMERIC 18 8 10 Lenght Length      
SC37008 NUMERIC X_NUMERIC 18 8 10 Width Width      
SC37009 NUMERIC X_NUMERIC 18 8 10 Height Height      
SC37010 NVARCHAR VSTRING 10 0 10 UserDefined1 User Defined Field 1      
SC37011 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
SC37012 NVARCHAR VSTRING 8 0 8 UserDefined3 User Defined Field 3      
SC37013 NVARCHAR VSTRING 6 0 6 UserDefined4 User Defined Field 4      
SC37014 NVARCHAR VSTRING 4 0 4 UserDefined5 User Defined Field 5      
SC37015 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
SC37016 NVARCHAR VSTRING 2 0 2 UserDefined7 User Defined Field 7      
SC37017 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
SC37018 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
SC37019 NVARCHAR VSTRING 2 0 2 UserDefine10 User Defined Field 10      
SC37020 NCHAR SWITCH 1 0 1 AllowNegQty Allow Negative Balances      
SC37021 INT INTEGER 0 0 1 TestSNqty Test Serial Number Quantity      
SC37022 NCHAR SWITCH 1 0 1 AllwAlphaSN Allow Alphanumeric Serial Numbers      
SC37023 NVARCHAR VSTRING 20 0 20 ExtProdGroup Extended Product Group      
SC37024 NVARCHAR VSTRING 25 0 25 AlphSerchKey Alpha Search Key      
SC37025 NVARCHAR VSTRING 10 0 10 UnConvSalPr (obsolete)      
SC37026 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
SC37027 NVARCHAR VSTRING 3 0 3 Planner Planner      
SC37028 NVARCHAR VSTRING 27 0 27 SC0128SPARE (obsolete)      
SC37029 NVARCHAR VSTRING 8 0 8 SC0129SPARE (obsolete)      
SC37030 NVARCHAR VSTRING 1 0 1 ReplacemItem Replacement Item      
SC37031 INT INTEGER 0 0 2 DiscountCode Discount Code      
SC37032 NCHAR SWITCH 1 0 1 FLAGusesBatc Batch Controlled      
SC37033 INT INTEGER 0 0 1 ExtraTaxCode Extra Tax Code      
SC37034 INT INTEGER 0 0 1 DistCharCode Distribution Charge Code      
SC37035 NCHAR STRING 2 0 2 AccountCode Accounting Code      
SC37036 NVARCHAR VSTRING 4 0 4 DelCalenCode (obsolete)      
SC37037 NVARCHAR VSTRING 4 0 4 ProductGroup Product Group      
SC37038 NVARCHAR VSTRING 4 0 4 AltProdGroup Alternative Product Group      
SC37039 NVARCHAR ACCSTR 50 0 50 AccCodeStrg Accounting String      
SC37040 NUMERIC X_NUMERIC 20 8 12 MinPurchQty Minimum Purchase Quantity      
SC37041 NUMERIC X_NUMERIC 20 8 12 MaxPurchQty Maximum Purchase Quantity      
SC37042 NUMERIC X_NUMERIC 20 8 12 StockBalance Stock Balance Total balance for all warehouses    
SC37043 NUMERIC X_NUMERIC 20 8 12 ReservedQty Reserved Quantity Total reserved quantity for all warehouses    
SC37044 NUMERIC X_NUMERIC 20 8 12 BackOrdeQty Back-Ordered Quantity Total back-ordered quantity for all warehouses    
SC37045 NUMERIC X_NUMERIC 20 8 12 SCQtyOrder Quantity Ordered Quantity Total quantity ordered from supplier, for all warehouses    
SC37046 NUMERIC X_NUMERIC 20 8 12 StockTakDiff Stock Tacking Difference Total stocktaking difference in quantity, for all warehouses    
SC37047 NVARCHAR VSTRING 2 0 2 UnitCodSalPr (obsolete)      
SC37048 DATETIME DATE 0 0 8 StockTakDate Latest Stock Taking Date      
SC37049 DATETIME DATE 0 0 8 DelDateSuppl Last Delivery Date from Suppliers      
SC37050 DATETIME DATE 0 0 8 DelDateCust Last Delivery Date to Customers      
SC37051 DATETIME DATE 0 0 8 OrdDateSuppl Last Order Date from Suppliers      
SC37052 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.    
SC37053 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.    
SC37054 NUMERIC X_NUMERIC 20 8 12 QtyRecSuppl Quantity Received from Suppliers      
SC37055 NUMERIC MONEY 28 8 20 PurchasePric Purchase Price (Purchase Currency)      
SC37056 NVARCHAR VSTRING 2 0 2 CurrCodePurc Currency Code Purchase      
SC37057 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.    
SC37058 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
SC37059 NVARCHAR VSTRING 10 0 10 AlternSuppl Alternative Supplier Code      
SC37060 NVARCHAR VSTRING 35 0 35 SupplStockCo Supplier Stock Code      
SC37061 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.    
SC37062 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.    
SC37063 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.    
SC37064 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.    
SC37065 INT INTEGER 0 0 1 BudgetModel Budget Model      
SC37066 INT INTEGER 0 0 1 ArticlStatus Stock Item Status      
SC37067 NVARCHAR VSTRING 3 0 3 CountOfOrgin Country of Origin      
SC37068 INT INTEGER 0 0 1 DelTimeUnit Delivery Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
   
SC37069 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
SC37070 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
SC37071 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SC37072 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDel Items per Package (Purchase)      
SC37073 NUMERIC X_NUMERIC 18 8 10 QtyUniOutDel Items per Package (Sales)      
SC37074 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
SC37075 NVARCHAR VSTRING 1 0 1 FrequenCode Frequency Code      
SC37076 NCHAR SWITCH 1 0 1 AttachedFlag Frequency Flag      
SC37077 NUMERIC MONEY 28 8 20 ProfitLCUPer Profit Period (Local Currency)      
SC37078 NUMERIC MONEY 28 8 20 ProfitLCUYTD Profit YTD (Local Currency)      
SC37079 NUMERIC MONEY 28 8 20 ProYTDPrevYr Profit YTD Previous Year (Local Currency)      
SC37080 NUMERIC MONEY 28 8 20 ProfYTDPrYr1 Profit YTD Previous Year - 1 (Local Currency)      
SC37081 NUMERIC MONEY 28 8 20 SalesLCUPer Sales Period (Local Currency)      
SC37082 NUMERIC MONEY 28 8 20 SalesLCUYTD Sales YTD (Local Currency)      
SC37083 NUMERIC MONEY 28 8 20 SalYTDPrevYr Sales YTD Previous Year (Local Currency)      
SC37084 NUMERIC MONEY 28 8 20 SaleYTDPrYr1 Sales YTD Previous Year - 1 (Local Currency)      
SC37085 NUMERIC X_NUMERIC 20 8 12 QtyLCUPeriod Quantity Sold Period      
SC37086 NUMERIC X_NUMERIC 20 8 12 QtyLCUYTD Quantity Sold YTD      
SC37087 NUMERIC X_NUMERIC 20 8 12 QtyYTDPreYr Quantity Sold Previous Year      
SC37088 NUMERIC X_NUMERIC 20 8 12 QtyYTDPrYr1 Quantity Sold Previous Year - 1      
SC37089 NVARCHAR VSTRING 35 0 35 ReplStocCode Replacement Stock Code      
SC37090 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.
   
SC37091 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
   
SC37092 DATETIME DATE 0 0 8 DesNewPrice Date to Deactivate New Price      
SC37093 NVARCHAR VSTRING 25 0 25 InternRem1 Internal Remark Line 1      
SC37094 NVARCHAR VSTRING 25 0 25 InternRem2 Internal Remark Line 2      
SC37095 INT INTEGER 0 0 1 CommissCode Commission Code 1 Related to commission setup in statistic module and are used for calculating commissions for salesmen.    
SC37096 INT INTEGER 0 0 1 StructurFlag BOM Flag      
SC37097 INT INTEGER 0 0 1 QueryQueNo Query Queue Number      
SC37098 NUMERIC X_NUMERIC 18 8 10 SellPricMult Selling Price Multiple      
SC37099 NUMERIC X_NUMERIC 18 8 10 PurcPricMult Cost Price Multiple      
SC37100 NVARCHAR VSTRING 14 0 14 StatCodeExte Statistical Code Extended      
SC37101 INT INTEGER 0 0 3 CustWarrMont Customer Warranty      
SC37102 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.
   
SC37103 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.
   
SC37104 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.    
SC37105 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.    
SC37106 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.    
SC37107 NVARCHAR VSTRING 1 0 1 ServiceLevel Service Level      
SC37108 NUMERIC MONEY 28 8 20 PrfLCUNxtPer Profit Next Period (Local Currency)      
SC37109 NUMERIC MONEY 28 8 20 PrfLCUNetYTD Profit Next YTD (Local Currency)      
SC37110 NUMERIC MONEY 28 8 20 SalLCUNxtPer Sales Next Period (Local Currency)      
SC37111 NUMERIC MONEY 28 8 20 SalLCUNxtYTD Sales Next YTD (Local Currency)      
SC37112 NUMERIC X_NUMERIC 20 8 12 QtyLCUNxtPer Quantity Sold Next Period      
SC37113 NUMERIC X_NUMERIC 20 8 12 QtyLCUNxtYTD Quantity Sold Next YTD      
SC37114 NVARCHAR VSTRING 6 0 6 DefaultBinNo Default Bin Code      
SC37115 NVARCHAR VSTRING 1 0 1 MaintContCod Maintenance Contract Code      
SC37116 DATETIME DATE 0 0 8 RecCreatDate Date Created      
SC37117 NCHAR SWITCH 1 0 1 ContrDistrib Controlled Distribution      
SC37118 DATETIME DATE 0 0 8 StarContDist Start Date Controlled Distribution      
SC37119 DATETIME DATE 0 0 8 EndContDist End Date Controlled Distribution      
SC37120 NCHAR SWITCH 1 0 1 HoldStatus Product on Hold      
SC37121 DATETIME DATE 0 0 8 HldStaSrtDat Hold Status Start Date      
SC37122 DATETIME DATE 0 0 8 HldStaEndDat Hold Status End Date      
SC37123 DATETIME DATE 0 0 8 EndOfLifeDat End of Life Date      
SC37124 DATETIME DATE 0 0 8 ObsoleteDate Obsolete Date      
SC37125 DATETIME DATE 0 0 8 ReplacemDate Replacement Date      
SC37126 NVARCHAR VSTRING 35 0 35 EquiStckCode Equivalent Stock Code      
SC37127 INT INTEGER 0 0 1 SerNoStatus Serial Number Status      
SC37128 NVARCHAR VSTRING 10 0 10 ProductCateg Product Category      
SC37129 INT INTEGER 0 0 1 BudgetMode Service Priorities      
SC37130 NVARCHAR VSTRING 2 0 2 ApplicCode1 Application Code 1      
SC37131 NVARCHAR VSTRING 2 0 2 ApplicCode2 Application Code 2      
SC37132 NVARCHAR VSTRING 35 0 35 EANCode EAN Code      
SC37133 INT INTEGER 0 0 2 UnitCodeStoc Unit Code Stock      
SC37134 INT INTEGER 0 0 2 UnitCodePurc Unit Code Purchase      
SC37135 INT INTEGER 0 0 2 UnitCodeSale Unit Code Sales      
SC37136 INT INTEGER 0 0 2 UnitCodeMPC Unit Code MPC      
SC37137 INT INTEGER 0 0 2 UnitCodeSpar Unit Code Other      
SC37138 NVARCHAR VSTRING 4 0 4 SPARE (obsolete)      
SC37139 NUMERIC X_NUMERIC 22 8 14 UnitConvStoc Unit Factor for Stock Unit      
SC37140 NUMERIC X_NUMERIC 22 8 14 UnitConvPurc Unit Factor for Purchase Unit      
SC37141 NUMERIC X_NUMERIC 22 8 14 UnitConvSale Unit Factor for Sales Unit      
SC37142 NUMERIC X_NUMERIC 22 8 14 UnitConvMPC Unit Factor for MPC Unit      
SC37143 NUMERIC X_NUMERIC 22 8 14 UnitConvSpar Unit Factor for Other Unit      
SC37144 INT INTEGER 0 0 2 VATCode1 VAT Code 1      
SC37145 INT INTEGER 0 0 2 VATCode2 VAT Code 2      
SC37146 NUMERIC MONEY 28 8 20 StandRepCost Standard Repair Cost (Local Currency)      
SC37147 NCHAR SWITCH 1 0 1 FlagReparab Reparable      
SC37148 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.)
   
SC37149 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.)
   
SC37150 NVARCHAR VSTRING 35 0 35 ComplStockIt Complementary Stock Item      
SC37151 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.
   
SC37152 NCHAR STRING 2 0 2 BatcNoPrefix Batch Number Prefix      
SC37153 NUMERIC NUMBER 20 0 6 BatchNumber Batch Number      
SC37154 NUMERIC NUMBER 20 0 3 BatcNOSuffix Batch Number Suffix      
SC37155 NUMERIC X_NUMERIC 20 8 12 QC_OnHand QC On-hand      
SC37156 NCHAR STRING 3 0 3 BOA_Number BOA-number      
SC37157 NUMERIC MONEY 28 8 20 ABC_Cost1 ABC-Cost 1 (Local Currency)      
SC37158 NUMERIC MONEY 28 8 20 ABC_Cost2 ABC-Cost 2 (Local Currency)      
SC37159 NUMERIC MONEY 28 8 20 DirectCost Direct Cost      
SC37160 NCHAR STRING 2 0 2 DistrComp01 Distribution Company      
SC37161 NCHAR STRING 2 0 2 DistrComp02 Distribution Company      
SC37162 NCHAR STRING 2 0 2 DistrComp03 Distribution Company      
SC37163 NCHAR STRING 2 0 2 DistrComp04 Distribution Company      
SC37164 NCHAR STRING 2 0 2 DistrComp05 Distribution Company      
SC37165 NCHAR STRING 2 0 2 DistrComp06 Distribution Company      
SC37166 NCHAR STRING 2 0 2 DistrComp07 Distribution Company      
SC37167 NCHAR STRING 2 0 2 DistrComp08 Distribution Company      
SC37168 NCHAR STRING 2 0 2 DistrComp09 Distribution Company      
SC37169 NCHAR STRING 2 0 2 DistrComp10 Distribution Company      
SC37170 NCHAR STRING 2 0 2 DistrComp11 Distribution Company      
SC37171 NCHAR STRING 2 0 2 DistrComp12 Distribution Company      
SC37172 NCHAR STRING 2 0 2 DistrComp13 Distribution Company      
SC37173 NCHAR STRING 2 0 2 DistrComp14 Distribution Company      
SC37174 NCHAR STRING 2 0 2 DistrComp15 Distribution Company      
SC37175 NCHAR STRING 2 0 2 DistrComp16 Distribution Company      
SC37176 NCHAR STRING 2 0 2 DistrComp17 Distribution Company      
SC37177 NCHAR STRING 2 0 2 DistrComp18 Distribution Company      
SC37178 NCHAR STRING 2 0 2 DistrComp19 Distribution Company      
SC37179 NCHAR STRING 2 0 2 DistrComp20 Distribution Company      
SC37180 INT INTEGER 0 0 1 DelMarginRule Delivery Margin Rule      
SC37181 NUMERIC X_NUMERIC 14 8 6 DelMargin Delivery Margin %      
SC37182 NUMERIC X_NUMERIC 20 8 12 OverDeliveryQty (obsolete)      
SC37183 NUMERIC X_NUMERIC 20 8 12 AllocatedQty Allocated Quantity Total quantity allocated to orders, for all warehouses    
SC37184 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
   
SC37185 NVARCHAR VSTRING 1 0 1 POReceipt Purchase Order Receipt Rule, Drop Shipment 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
   
SC37186 INT INTEGER 0 0 3 DelLeadTime Delivery Lead Time      
SC37187 INT INTEGER 0 0 1 DelLeadTimeUnit Delivery Lead Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
   
SC37188 INT INTEGER 0 0 1 POAdjustment Purchase Order Adjustment, Drop Shipment      
SC37189 INT INTEGER 0 0 1 AvailableServices Available Services      
SC37190 NCHAR STRING 25 0 25 RepairCostRange Repair Cost Range      
SC37191 NCHAR STRING 25 0 25 RepairCostRange Repair Cost Range      
SC37192 INT INTEGER 0 0 1 CostProposalRequiredFlag Cost Proposal Required      
SC37193 NCHAR STRING 2 0 2 DefaultExchangePriceList Default Exchange Price List      
SC37194 NCHAR STRING 10 0 10 DefaultEngineer Default Engineer      
SC37195 NCHAR STRING 10 0 10 DefaultWarrantyCustShopOrders Default Warranty Customer Shop Orders      
SC37196 INT INTEGER 0 0 1 ATP check Item ATP Check Item      
SC37197 NCHAR SWITCH 1 0 1 QualityControl? Quality Control      
SC37198 NCHAR SWITCH 1 0 1 DangerousGoods? Dangerous Goods      
SC37199 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
   
SC37200 INT INTEGER 0 0 2 RentalTime_Unit_Default Default Rental Time Unit 1 - Years
2 - Month
3 - Weeks
4 - Days
5 - Hours
6 - Minutes
   
SC37201 INT INTEGER 0 0 1 EC VAT Exempt Flag EC VAT Exempt      
SC37202 INT INTEGER 0 0 1 Bin Control Bin Controlled      
SC37203 INT INTEGER 0 0 1 Item/Branch Placement 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.
   
SC37204 INT INTEGER 0 0 3 Min Temperature Minimum Storage Temperature      
SC37205 INT INTEGER 0 0 3 Max Temperature Maximum Storage Temperature      
SC37206 INT INTEGER 0 0 3 Min Humidity Minimum Storage Humidity      
SC37207 INT INTEGER 0 0 3 Max Humidity Maximum Storage Humidity      
SC37208 NCHAR STRING 1 0 1 Storage Type 1 Storage Type 1      
SC37209 NCHAR STRING 1 0 1 Storage Type 2 Storage Type 2      
SC37210 NCHAR STRING 1 0 1 Storage Type 3 Storage Type 3      
SC37211 NCHAR STRING 1 0 1 Storage Type 4 Storage Type 4      
SC37212 NVARCHAR VSTRING 4 0 4 Bin Location Rule Type Bin Location Rule Type      
SC37213 NCHAR STRING 2 0 2 DSSupplier_selection_rule_type 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.
   
SC37214 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
   
SC37215 NCHAR STRING 35 0 35 ConfigurationCode Configuration Code      
SC37216 NCHAR STRING 1 0 1 SaveConfigurationHistory Save Configuration History      
SC37217 INT INTEGER 0 0 1 IssueExpiredBatch Allow Issue from Expired Batches      
SC37218 NCHAR STRING 6 0 6 TaxCode Stock Item Tax Code      
SC37219 NCHAR SWITCH 1 0 1 FEFOOrder FEFO Order      
SC37220 NUMERIC X_NUMERIC 28 8 20 Portion Size Portion Size      
SC37221 NUMERIC X_NUMERIC 28 8 20 Multiple Factor Multiple Factor      
SC37222 NUMERIC X_NUMERIC 28 8 20 Calorific Value Calorific Value      
SC37223 NUMERIC X_NUMERIC 28 8 20 Protein Value Protein Value      
SC37224 NUMERIC X_NUMERIC 28 8 20 Fat Value Fat Value      
SC37225 NUMERIC X_NUMERIC 28 8 20 Carbohydrate Value Carbohydrate Value      
SC37226 NVARCHAR VSTRING 12 0 12 P&L Account P&L Account      
SC37227 INT INTEGER 0 0 2 BOM default UOM code BOM default UOM code      
SC37228 NUMERIC X_NUMERIC 26 8 18 BOM default UOM factor BOM default UOM factor      
SC37229 NVARCHAR VSTRING 10 0 10 Spare Spare      
SC37230 NVARCHAR VSTRING 10 0 10 Spare Spare      
SC37231 NCHAR STRING 1 0 1 OriginCode Origin Code      
SC37232 NVARCHAR VSTRING 25 0 25 NomenclatureNo Nomenclature No      
SC37233 NCHAR STRING 2 0 2 Goods type Goods Type      
SC37234 NVARCHAR VSTRING 1 0 1 Stock Valuation Model Valuation Model      
SC37235 NVARCHAR VSTRING 1 0 1 Stock Valuation Model for CC Valuation Model for Alternative Currency      
SC37236 NVARCHAR VSTRING 1 0 1 BOM discount method BOM discount method      
SC37237 NCHAR STRING 6 0 6 LTM Group OR LTM Group OR      
SC37238 NCHAR STRING 6 0 6 LTM Group PC LTM Group PC      
SC37239 NUMERIC X_NUMERIC 28 8 20 BOM Cost BOM Cost      
SC37240 NVARCHAR VSTRING 35 0 35 GTIN GTIN      
SC37241 NVARCHAR VSTRING 150 0 150 Udef Barcode identities Udef Barcode identities      
SC37242 INT INTEGER 0 0 3 DTF Demand Time Fence      
SC37243 NCHAR SWITCH 1 0 1 Incoming Properties Control Incoming Properties Control      
SC37244 INT INTEGER 0 0 1 Temperature required flag Temperature required flag      
SC37245 INT INTEGER 0 0 1 Humidity required flag Humidity required flag      
SC37246 INT INTEGER 0 0 1 Temperature enforce flag Temperature enforce flag      
SC37247 INT INTEGER 0 0 1 Humidity enforce flag Humidity enforce flag      
SC37248 INT INTEGER 0 0 2 Temperature unit code Temperature unit code      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Stock Item Templates