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 SC37 — Stock Item Templates

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC37001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Template Code   1 Да / Yes
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 120 0 120 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 4 UnitCodeStoc Unit Code Stock      
SC37134 INT INTEGER 0 0 4 UnitCodePurc Unit Code Purchase      
SC37135 INT INTEGER 0 0 4 UnitCodeSale Unit Code Sales      
SC37136 INT INTEGER 0 0 4 UnitCodeMPC Unit Code MPC      
SC37137 INT INTEGER 0 0 4 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 SalesTaxCodeSTE Sales Tax Code STE      
SC37145 INT INTEGER 0 0 2 PurchaseTaxCodeSTE Purchase Tax Code STE      
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 QCOnHand QC On-hand      
SC37156 NCHAR STRING 3 0 3 BOANumber BOA-number      
SC37157 NUMERIC MONEY 28 8 20 ABCCost1 ABC-Cost 1 (Local Currency)      
SC37158 NUMERIC MONEY 28 8 20 ABCCost2 ABC-Cost 2 (Local Currency)      
SC37159 NUMERIC MONEY 28 8 20 DirectCost Direct Cost      
SC37160 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Ext. User defined field 1      
SC37161 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Ext. User defined field 2      
SC37162 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Ext. User defined field 3      
SC37163 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Ext. User defined field 4      
SC37164 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Ext. User defined field 5      
SC37165 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Ext. User defined field 6      
SC37166 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Ext. User defined field 7      
SC37167 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Ext. User defined field 8      
SC37168 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Ext. User defined field 9      
SC37169 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Ext. User defined field 10      
SC37170 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Ext. User defined field 11      
SC37171 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Ext. User defined field 12      
SC37172 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Ext. User defined field 13      
SC37173 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Ext. User defined field 14      
SC37174 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Ext. User defined field 15      
SC37175 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Ext. User defined field 16      
SC37176 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Ext. User defined field 17      
SC37177 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Ext. User defined field 18      
SC37178 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Ext. User defined field 19      
SC37179 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Ext. User defined field 20      
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 RepairCostRange2 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 ATPcheckItem 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 RentalTimeUnitDefault Default Rental Time Unit 1 — Years

2 — Month

3 — Weeks

4 — Days

5 — Hours

6 — Minutes
   
SC37201 INT INTEGER 0 0 1 ECVATExemptFlag EC VAT Exempt      
SC37202 INT INTEGER 0 0 1 BinControl Bin Controlled      
SC37203 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.
   
SC37204 INT INTEGER 0 0 3 MinTemperature Minimum Storage Temperature      
SC37205 INT INTEGER 0 0 3 MaxTemperature Maximum Storage Temperature      
SC37206 INT INTEGER 0 0 3 MinHumidity Minimum Storage Humidity      
SC37207 INT INTEGER 0 0 3 MaxHumidity Maximum Storage Humidity      
SC37208 NCHAR STRING 1 0 1 StorageType1 Storage Type 1      
SC37209 NCHAR STRING 1 0 1 StorageType2 Storage Type 2      
SC37210 NCHAR STRING 1 0 1 StorageType3 Storage Type 3      
SC37211 NCHAR STRING 1 0 1 StorageType4 Storage Type 4      
SC37212 NVARCHAR VSTRING 4 0 4 BinLocationRuleType Bin Location Rule Type      
SC37213 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.
   
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 SalesTaxCodeATE Sales Tax Code ATE      
SC37219 NCHAR SWITCH 1 0 1 FEFOOrder FEFO Order      
SC37220 NUMERIC X_NUMERIC 28 8 20 PortionSize Portion Size      
SC37221 NUMERIC X_NUMERIC 28 8 20 MultipleFactor Multiple Factor      
SC37222 NUMERIC X_NUMERIC 28 8 20 CalorificValue Calorific Value      
SC37223 NUMERIC X_NUMERIC 28 8 20 ProteinValue Protein Value      
SC37224 NUMERIC X_NUMERIC 28 8 20 FatValue Fat Value      
SC37225 NUMERIC X_NUMERIC 28 8 20 CarbohydrateValue Carbohydrate Value      
SC37226 NVARCHAR VSTRING 12 0 12 PLAccount P&L Account      
SC37227 INT INTEGER 0 0 4 BOMDefaultUOMCode BOM default UOM code      
SC37228 NUMERIC X_NUMERIC 26 8 18 BOMDefaultUOMFactor BOM default UOM factor      
SC37229 NVARCHAR VSTRING 10 0 10 ItemType Item Type Item Type    
SC37230 NVARCHAR VSTRING 25 0 25 TariffNo Tariff Number Tariff Number    
SC37231 NCHAR STRING 1 0 1 OriginCode Origin Code      
SC37232 NVARCHAR VSTRING 25 0 25 NomenclatureNo Nomenclature No      
SC37233 NCHAR STRING 2 0 2 GoodsType Goods Type      
SC37234 NVARCHAR VSTRING 1 0 1 StockValModel Valuation Model      
SC37235 NVARCHAR VSTRING 1 0 1 StockValModelForCC Valuation Model for Alternative Currency      
SC37236 NVARCHAR VSTRING 1 0 1 BOMDiscountMethod BOM discount method      
SC37237 NCHAR STRING 6 0 6 LTMGroupOR LTM Group OR      
SC37238 NCHAR STRING 6 0 6 LTMGroupPC LTM Group PC      
SC37239 NUMERIC X_NUMERIC 28 8 20 BOMCost BOM Cost      
SC37240 NVARCHAR VSTRING 35 0 35 GTIN GTIN      
SC37241 NVARCHAR VSTRING 150 0 150 UDefBarCodeIdent Udef Barcode identities      
SC37242 INT INTEGER 0 0 3 DTF Demand Time Fence      
SC37243 NCHAR SWITCH 1 0 1 IncomingPropertiesControl Incoming Properties Control      
SC37244 INT INTEGER 0 0 1 TemperatureRequiredFlag Temperature required flag      
SC37245 INT INTEGER 0 0 1 Humidityrequiredflag Humidity required flag      
SC37246 INT INTEGER 0 0 1 TemperatureEnforceFlag Temperature enforce flag      
SC37247 INT INTEGER 0 0 1 HumidityEnforce Humidity enforce flag      
SC37248 INT INTEGER 0 0 2 TemperatureUnit Temperature unit code      
SC37249 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
SC37250 INT INTEGER 0 0 1 ExportStatus Export Status      
SC37251 NCHAR SWITCH 1 0 1 ChargeCostForPackMtrl Charge Cost per Packaging Materials?      
SC37252 NCHAR SWITCH 1 0 1 FixedChargeWeight Fixed charge per weight?      
SC37253 NUMERIC MONEY 28 8 20 PackageTaxAmntPerKg Packaging Tax Amount per kg      
SC37254 NVARCHAR VSTRING 35 0 35 CommodityCode Commodity Code      
SC37255 NVARCHAR VSTRING 8 0 8 CreatedBy Created By      
SC37256 NCHAR STRING 6 0 6 PurchaseTaxCodeATE Purchase Tax Code ATE      
SC37257 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
SC37258 NVARCHAR VSTRING 45 0 45 REACHUUID REACH UUID      
SC37259 NUMERIC X_NUMERIC 18 8 10 REACHWeight REACH Weight      
SC37260 INT INTEGER 0 0 4 REACHWeightUnit REACH Weight Unit      
SC37261 DATETIME DATE 0 0 8 REACHFromDate REACH From Date      
SC37262 DATETIME DATE 0 0 8 REACHToDate REACH To Date      
SC37263 INT INTEGER 0 0 1 AssetPurchase Asset Purchase      
SC37264 NVARCHAR VSTRING 12 0 12 AssetAccount Asset Account      
SC37265 INT INTEGER 0 0 1 AssetPerUnit Asset Per Unit      
SC37266 NCHAR STRING 3 0 3 TaxReasonCode Tax Reason Code      

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