Таблица / Table: SC10 — «Stock Parameters 1». Маска имени таблицы / Table name mask: «SC10%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
SC10001 | NCHAR | STRING | 2 | 0 | 2 | Year_ | Year | 1 | Да / Yes | |
SC10002 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr1FoPrLst | (obsolete) | |||
SC10003 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr2FoPrLst | (obsolete) | |||
SC10004 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr3FoPrLst | (obsolete) | |||
SC10005 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr4FoPrLst | (obsolete) | |||
SC10006 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr5FoPrLst | (obsolete) | |||
SC10007 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr6FoPrLst | (obsolete) | |||
SC10008 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr7FoPrLst | (obsolete) | |||
SC10009 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr8FoPrLst | (obsolete) | |||
SC10010 | NVARCHAR | VSTRING | 2 | 0 | 2 | Curr9FoPrLst | (obsolete) | |||
SC10011 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SC10012 | NVARCHAR | VSTRING | 6 | 0 | 6 | NoOfWarehous | No of Warehouses | |||
SC10013 | INT | INTEGER | 0 | 0 | 1 | DecInLocPri | Decimals in Local Prices | |||
SC10014 | INT | INTEGER | 0 | 0 | 1 | DecimInQty | Decimals in Quantities | |||
SC10015 | INT | INTEGER | 0 | 0 | 2 | MaxLngStoCod | Maximum Length of Stock Item Code | |||
SC10016 | INT | INTEGER | 0 | 0 | 4 | MaxNoBOMlev | Maximum BOM Levels | |||
SC10017 | INT | INTEGER | 0 | 0 | 1 | DefAccCode | Default Accounting Code | |||
SC10018 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | ExtrSalTax1 | Extra Sales Tax 1 % | |||
SC10019 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | ExtrSalTax2 | Extra Sales Tax 2 % | |||
SC10020 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | ExtrSalTax3 | Extra Sales Tax 3 % | |||
SC10021 | INT | INTEGER | 0 | 0 | 1 | StockValuMod | Stock Valuation Model | |||
SC10022 | INT | INTEGER | 0 | 0 | 1 | NoDecShipQty | Number of Decimals in Shipping Quantity | |||
SC10023 | INT | INTEGER | 0 | 0 | 2 | NoDecWeight | Number of Decimals in Weight | |||
SC10024 | INT | INTEGER | 0 | 0 | 1 | AcceLevAdjus | Access Level Adjustments | |||
SC10025 | INT | INTEGER | 0 | 0 | 1 | DecInPriUnit | Number of Decimals in Price Unit | |||
SC10026 | INT | INTEGER | 0 | 0 | 1 | NoDecInMesur | Number of Decimals in Measurements | |||
SC10027 | INT | INTEGER | 0 | 0 | 2 | DispNoteCopy | Number of Internal Delivery Note Copies | |||
SC10028 | NCHAR | STRING | 1 | 0 | 1 | IntDisNotCou | (obsolete) | |||
SC10029 | INT | INTEGER | 0 | 0 | 10 | StValModConCur | Stock Valuation Model Alternative Currency | |||
SC10030 | NCHAR | STRING | 10 | 0 | 10 | Spare | Period for 8-days Rule (Greece) | |||
SC10031 | NCHAR | STRING | 10 | 0 | 10 | Spare | Period for 10-days Rule (Greece) | |||
SC10032 | NCHAR | STRING | 10 | 0 | 10 | Spare | (obsolete) | |||
SC10033 | NCHAR | STRING | 10 | 0 | 10 | Spare | (obsolete) | |||
SC10034 | NCHAR | STRING | 10 | 0 | 10 | Spare | (obsolete) | |||
SC10035 | INT | INTEGER | 0 | 0 | 1 | NoOfDecInVol | Number of Decimals in Volume | |||
SC10036 | INT | INTEGER | 0 | 0 | 2 | MaxNoStrLev | (obsolete) | |||
SC10037 | NCHAR | STRING | 1 | 0 | 1 | GLTransNo | (obsolete) | |||
SC10038 | NCHAR | STRING | 1 | 0 | 1 | SCTransNo | (obsolete) | |||
SC10039 | NCHAR | STRING | 1 | 0 | 1 | BatchNo | (obsolete) | |||
SC10040 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | PurcOnCharge | Estimated On-charge % | |||
SC10041 | NVARCHAR | VSTRING | 2 | 0 | 2 | ConsCurrCode | Currency Code Alternative Valuation | |||
SC10042 | NCHAR | STRING | 1 | 0 | 1 | PriceInclVAT | Prices Including VAT | |||
SC10043 | NCHAR | STRING | 1 | 0 | 1 | IntegrWithGL | Integrated with General Ledger | |||
SC10044 | NCHAR | STRING | 1 | 0 | 1 | UseGLTranNo | (obsolete) | |||
SC10045 | NCHAR | STRING | 1 | 0 | 1 | UseCCGlcons | Use Alternative Currency for Consolidation | |||
SC10046 | NCHAR | STRING | 1 | 0 | 1 | SecondLine | Display Second Description Line on Query | |||
SC10047 | NCHAR | STRING | 1 | 0 | 1 | OverDeliveryControl | Over Delivery Control | |||
SC10048 | NCHAR | STRING | 1 | 0 | 1 | ValidateDates | Validate Dates | |||
SC10049 | NVARCHAR | VSTRING | 1 | 0 | 1 | AccMapping | Accounting Mapping from Stock Items | |||
SC10050 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Keep Hard-Allocation History | |||
SC10051 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SC10052 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc0 | Use Dictionary for User Field 0 | |||
SC10053 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc1 | Use Dictionary for User Field 1 | |||
SC10054 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc2 | Use Dictionary for User Field 2 | |||
SC10055 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc3 | Use Dictionary for User Field 3 | |||
SC10056 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc4 | Use Dictionary for User Field 4 | |||
SC10057 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc5 | Use Dictionary for User Field 5 | |||
SC10058 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc6 | Use Dictionary for User Field 6 | |||
SC10059 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc7 | Use Dictionary for User Field 7 | |||
SC10060 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc8 | Use Dictionary for User Field 8 | |||
SC10061 | NCHAR | SWITCH | 1 | 0 | 1 | UserFldSwtc9 | Use Dictionary for User Field 9 | |||
SC10062 | NVARCHAR | VSTRING | 6 | 0 | 6 | MainWarehInf | Main Warehouse | |||
SC10063 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | Journal Code for Stock Transactions | |||
SC10064 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10065 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10066 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10067 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10068 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10069 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10070 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SC10071 | NCHAR | STRING | 35 | 0 | 35 | UserInfo0 | Description User Field 0 | |||
SC10072 | NCHAR | STRING | 35 | 0 | 35 | UserInfo1 | Description User Field 1 | |||
SC10073 | NCHAR | STRING | 35 | 0 | 35 | UserInfo2 | Description User Field 2 | |||
SC10074 | NCHAR | STRING | 35 | 0 | 35 | UserInfo3 | Description User Field 3 | |||
SC10075 | NCHAR | STRING | 35 | 0 | 35 | UserInfo4 | Description User Field 4 | |||
SC10076 | NCHAR | STRING | 35 | 0 | 35 | UserInfo5 | Description User Field 5 | |||
SC10077 | NCHAR | STRING | 35 | 0 | 35 | UserInfo6 | Description User Field 6 | |||
SC10078 | NCHAR | STRING | 35 | 0 | 35 | UserInfo7 | Description User Field 7 | |||
SC10079 | NCHAR | STRING | 35 | 0 | 35 | UserInfo8 | Description User Field 8 | |||
SC10080 | NCHAR | STRING | 35 | 0 | 35 | UserInfo9 | Description User Field 9 | |||
SC10081 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam1 | (obsolete) | |||
SC10082 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam2 | (obsolete) | |||
SC10083 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam3 | (obsolete) | |||
SC10084 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam4 | (obsolete) | |||
SC10085 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam5 | (obsolete) | |||
SC10086 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam6 | (obsolete) | |||
SC10087 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam7 | (obsolete) | |||
SC10088 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam8 | (obsolete) | |||
SC10089 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam9 | (obsolete) | |||
SC10090 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam10 | (obsolete) | |||
SC10091 | INT | INTEGER | 0 | 0 | 2 | OpenFromPeriod | Open From Period | |||
SC10092 | NCHAR | STRING | 1 | 0 | 1 | AvailableLongDescr | Use Dictionary for Long Description | |||
SC10093 | INT | INTEGER | 0 | 0 | 1 | DisplayBatchInfo | Batch Information Displayed | |||
SC10094 | NCHAR | STRING | 2 | 0 | 2 | CostTypeDepreciation | Cost Type for Depreciation | |||
SC10095 | NCHAR | SWITCH | 1 | 0 | 1 | FlagLockCount | Lock for Counting | |||
SC10096 | NCHAR | STRING | 6 | 0 | 6 | CountTollerancePercent | Counting Tolerance Percentage | |||
SC10097 | INT | INTEGER | 0 | 0 | 1 | BinPlacementViaLF | Bin Placement via Logistic Forms | |||
SC10098 | NVARCHAR | VSTRING | 10 | 0 | 10 | UOMDescription1 | Description Length Unit of Measurements | |||
SC10099 | NVARCHAR | VSTRING | 10 | 0 | 10 | UOMDescription2 | Description Weight Unit of Measurements | |||
SC10100 | NVARCHAR | VSTRING | 10 | 0 | 10 | UOMDescription3 | Description Volume Unit of Measurements | |||
SC10101 | NCHAR | STRING | 1 | 0 | 1 | CostAccAllocToSuppStock | Cost Accounting when Allocated to Supplier Stock | |||
SC10102 | NCHAR | STRING | 1 | 0 | 1 | RevenueAccAllocSuppStock | Revenue Accounting when Allocated to Supplier Stock | |||
SC10103 | NCHAR | STRING | 1 | 0 | 1 | CreateConsumptionNote | Create Consumption Note | |||
SC10104 | NCHAR | STRING | 2 | 0 | 2 | DSSuppSelRuleType | Drop Shipment Supplier Selection Rule | |||
SC10105 | INT | INTEGER | 0 | 0 | 1 | StockClosingPeriodType | Type of Stock Closing Period | |||
SC10106 | NVARCHAR | VSTRING | 40 | 0 | 40 | DetailedGLTransFromSC | Detailed General Ledger Transactions | Defines the type of transactions that shall be updated with details when creating accounting transactions for general ledger. The following character are used in the string and the value can be 0 for summarized transactions and 1 for detailed transaction: Character 1 : Incoming goods (transaction type 00) Character 3 : Outgoing goods (transaction type 01) Character 5 : Stock taking difference (transaction type 02) Character 7 : Cost (transaction type 03) Character 9 : Warehouse movements (transaction type 04) Character 11 : Price difference (transaction type 05) Character 13 : Costs items (transaction type 06) Character 15 : Non-allocated cost (transaction type 07) Character 17 : Cost adjustment (transaction type 08) Character 19 : Bin movement (transaction type 09) Character 21 : Unallocated cost (transaction type 10) |
||
SC10107 | INT | INTEGER | 0 | 0 | 2 | MinNumOfCounts | Minimun number of counts | Minimun number of counts befor Stock Taking result entry | ||
SC10108 | INT | INTEGER | 0 | 0 | 2 | NumOfConsecutiveCounts | Number of necessary consecutive counts | Number of necessary consecutive counts with same result | ||
SC10109 | NCHAR | STRING | 1 | 0 | 1 | CostAccAllocToVendorManagedWH | Cost Accounting when Allocated to Vendor Managed warehouses | |||
SC10110 | NCHAR | STRING | 1 | 0 | 1 | RevenueAccAllocVendorMngWH | Revenue Accounting when Allocated to Vendor Managed warehouses | |||
SC10111 | NCHAR | SWITCH | 1 | 0 | 1 | DisableTransVendor | Disable manual stock transactions for Vendor Managed warehouse | |||
SC10112 | INT | INTEGER | 0 | 0 | 2 | CycleCountingListSorting | control how CC List should be sorted | |||
SC10113 | INT | INTEGER | 0 | 0 | 3 | ExcludeUnusedBinBatch | Exclude bins/batches not used for | |||
SC10114 | NCHAR | SWITCH | 1 | 0 | 1 | DelayLockUntilPrinting | Delay Lock Until Printing | |||
SC10115 | INT | INTEGER | 0 | 0 | 4 | STOLineIncrement | Stock Transfer Order Lines Number Increment | |||
SC10116 | INT | INTEGER | 0 | 0 | 4 | STODelLineIncrement | Stock Transfer Order Delivery Lines Number Increment | |||
SC10117 | INT | INTEGER | 0 | 0 | 4 | LeadTimePick | Lead time for picking | |||
SC10118 | INT | INTEGER | 0 | 0 | 4 | LeadTimeShip | Lead time for shipping | |||
SC10119 | NCHAR | SWITCH | 1 | 0 | 1 | OneDNPerPicking | One delivery note per picking | |||
SC10120 | NCHAR | SWITCH | 1 | 0 | 1 | ItemSuppIDDefFromItem | Item/Supplier Id default from Item | |||
SC10121 | NCHAR | SWITCH | 1 | 0 | 1 | ItemCustIDDefFromItem | Item/Customer Id default from Item | |||
SC10122 | NVARCHAR | VSTRING | 25 | 0 | 25 | DefNomenclNo | Default Nomenclature Number | |||
SC10123 | NVARCHAR | VSTRING | 4 | 0 | 4 | DefaultRejectionCode | Default Rejection Code | |||
SC10124 | NCHAR | STRING | 1 | 0 | 1 | SerialNumberScrap | Serial Number, Scrap | |||
SC10125 | INT | INTEGER | 0 | 0 | 1 | EnforceItemBatchRule | Enforce item/batch rule? | |||
SC10126 | INT | INTEGER | 0 | 0 | 1 | ExportStatus | Default stock item export status | |||
SC10127 | INT | INTEGER | 0 | 0 | 1 | NumOfClassificationLevels | Number of classification levels | |||
SC10128 | NCHAR | SWITCH | 1 | 0 | 1 | KeepUnusedBoxes | Keep unused boxes? | |||
SC10129 | NCHAR | SWITCH | 1 | 0 | 1 | IncludeSCTransConsumptCalc | Include stock transfer transactions into consumption calculation | |||
SC10130 | NCHAR | SWITCH | 1 | 0 | 1 | SeparateClassCalcPerWH | Separate class calculation per warehouse |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»