Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SC10 - «Stock Parameters 1». Маска имени таблицы: «SC10%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SC10001 | NCHAR | STRING | 2 | 0 | 2 | Year_ | Year | 1 | Да | |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Stock Parameters 1