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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SC10 — Stock Parameters 1

Таблица / 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 Currency Code 1 for Price List      
SC10003 NVARCHAR VSTRING 2 0 2 Curr2FoPrLst Currency Code 2 for Price List      
SC10004 NVARCHAR VSTRING 2 0 2 Curr3FoPrLst Currency Code 3 for Price List      
SC10005 NVARCHAR VSTRING 2 0 2 Curr4FoPrLst Currency Code 4 for Price List      
SC10006 NVARCHAR VSTRING 2 0 2 Curr5FoPrLst Currency Code 5 for Price List      
SC10007 NVARCHAR VSTRING 2 0 2 Curr6FoPrLst Currency Code 6 for Price List      
SC10008 NVARCHAR VSTRING 2 0 2 Curr7FoPrLst Currency Code 7 for Price List      
SC10009 NVARCHAR VSTRING 2 0 2 Curr8FoPrLst Currency Code 8 for Price List      
SC10010 NVARCHAR VSTRING 2 0 2 Curr9FoPrLst Currency Code 9 for Price List      
SC10011 NCHAR STRING 2 0 2 Spare Spare      
SC10012 NVARCHAR VSTRING 6 0 6 NoOfWarehous Number of Warehouses      
SC10013 INT INTEGER 0 0 1 DecInLocPri Number of Decimals in Prices      
SC10014 INT INTEGER 0 0 1 DecimInQty Number of Decimals in Quantities      
SC10015 INT INTEGER 0 0 2 NotUsed Not Used      
SC10016 INT INTEGER 0 0 4 MaxNoBOMlev Maximum Number of BOM Levels      
SC10017 INT INTEGER 0 0 1 DefAccCode Default Accounting Code      
SC10018 NUMERIC X_NUMERIC 14 8 6 ExtrSalTax1 % for Other Tax 1      
SC10019 NUMERIC X_NUMERIC 14 8 6 ExtrSalTax2 % for Other Tax 2      
SC10020 NUMERIC X_NUMERIC 14 8 6 ExtrSalTax3 % for Other Tax 3      
SC10021 INT INTEGER 0 0 1 StockValuMod Stock Valuation Model      
SC10022 INT INTEGER 0 0 1 NoDecShipQty Number of Decimals for Packaged Units      
SC10023 INT INTEGER 0 0 2 NoDecWeight Number of Decimals in Weight      
SC10024 INT INTEGER 0 0 1 AcceLevAdjus Access Level Adjustment      
SC10025 INT INTEGER 0 0 1 DecInPriUnit Number of Decimals in Price Multiples      
SC10026 INT INTEGER 0 0 1 NoDecInMesur Number of Decimals in Measurements      
SC10027 INT INTEGER 0 0 2 DispNoteCopy Number of Copies for Internal Delivery Notes      
SC10028 NCHAR STRING 1 0 1 IntDisNotCou Number of Internal Dispatch Note      
SC10029 INT INTEGER 0 0 10 StValModConCur Stock Valuation Model for Consolidation 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 Spare      
SC10034 NCHAR STRING 10 0 10 Spare Spare      
SC10035 INT INTEGER 0 0 1 NoOfDecInVol Number of Decimals in Volume      
SC10036 INT INTEGER 0 0 2 MaxNoStrLev Maximum Number of BOM Levels      
SC10037 NCHAR STRING 1 0 1 GLTransNo GL Transaction Number      
SC10038 NCHAR STRING 1 0 1 SCTransNo SC Transaction Number      
SC10039 NCHAR STRING 1 0 1 BatchNo Batch Number      
SC10040 NUMERIC X_NUMERIC 14 8 6 PurcOnCharge Purchase On-Charge %      
SC10041 NVARCHAR VSTRING 2 0 2 ConsCurrCode Consolidation Currency Code      
SC10042 NCHAR STRING 1 0 1 PriceInclVAT Price Include Tax Flag      
SC10043 NCHAR STRING 1 0 1 IntegrWithGL Integrated to GL      
SC10044 NCHAR STRING 1 0 1 UseGLTranNo Use GL Transaction Number      
SC10045 NCHAR STRING 1 0 1 UseCCGlcons Use Consolidation Currency for GL Consolidation      
SC10046 NCHAR STRING 1 0 1 SecondLine Use 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 Spare      
SC10051 NVARCHAR VSTRING 1 0 1 Spare Spare      
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 No for GL Transactions      
SC10064 NVARCHAR VSTRING 6 0 6 CostTypeCurrDiff Cost Type for currency difference Left 2 characters for the currency difference cost type    
SC10065 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC10066 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC10067 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC10068 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC10069 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC10070 NVARCHAR VSTRING 6 0 6 Spare Spare      
SC10071 NCHAR STRING 35 0 35 UserInfo0 Description for User defined Field 0      
SC10072 NCHAR STRING 35 0 35 UserInfo1 Description for User defined Field 1      
SC10073 NCHAR STRING 35 0 35 UserInfo2 Description for User defined Field 2      
SC10074 NCHAR STRING 35 0 35 UserInfo3 Description for User defined Field 3      
SC10075 NCHAR STRING 35 0 35 UserInfo4 Description for User defined Field 4      
SC10076 NCHAR STRING 35 0 35 UserInfo5 Description for User defined Field 5      
SC10077 NCHAR STRING 35 0 35 UserInfo6 Description for User defined Field 6      
SC10078 NCHAR STRING 35 0 35 UserInfo7 Description for User defined Field 7      
SC10079 NCHAR STRING 35 0 35 UserInfo8 Description for User defined Field 8      
SC10080 NCHAR STRING 35 0 35 UserInfo9 Description for User defined Field 9      
SC10081 NVARCHAR VSTRING 10 0 10 AdditParam1 Additional Parameter 1      
SC10082 NVARCHAR VSTRING 10 0 10 AdditParam2 Additional Parameter 2      
SC10083 NVARCHAR VSTRING 10 0 10 AdditParam3 Additional Parameter 3      
SC10084 NVARCHAR VSTRING 10 0 10 AdditParam4 Additional Parameter 4      
SC10085 NVARCHAR VSTRING 10 0 10 AdditParam5 Additional Parameter 5      
SC10086 NVARCHAR VSTRING 10 0 10 AdditParam6 Additional Parameter 6      
SC10087 NVARCHAR VSTRING 10 0 10 AdditParam7 Additional Parameter 7      
SC10088 NVARCHAR VSTRING 10 0 10 AdditParam8 Additional Parameter 8      
SC10089 NVARCHAR VSTRING 10 0 10 AdditParam9 Additional Parameter 9      
SC10090 NVARCHAR VSTRING 10 0 10 AdditParam10 Additional Parameter 10      
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 Display Batch Information      
SC10094 NCHAR STRING 2 0 2 CostTypeDepreciation Cost Type for Depreciation      
SC10095 NCHAR SWITCH 1 0 1 FlagLockCount Lock Flag for Cycle 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 for Length Unit Measurement      
SC10099 NVARCHAR VSTRING 10 0 10 UOMDescription2 Description for Weight Unit Measurement      
SC10100 NVARCHAR VSTRING 10 0 10 UOMDescription3 Description for Volume Unit Measurement      
SC10101 NCHAR STRING 1 0 1 CostAccAllocToSuppStock Cost Accounting for Supplier Stock      
SC10102 NCHAR STRING 1 0 1 RevenueAccAllocSuppStock SL Invoice Journal Accounting for 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 GL 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 Minimum Number of Counts for Cycle Counting Minimun number of counts befor Stock Taking result entry    
SC10108 INT INTEGER 0 0 2 NumOfConsecutiveCounts Number of Consecutive Counts with Same Result Number of necessary consecutive counts with same result    
SC10109 NCHAR STRING 1 0 1 CostAccAllocToVendorManagedWH Cost Accounting for Vendor Managed Warehouses      
SC10110 NCHAR STRING 1 0 1 RevenueAccAllocVendorMngWH SL Invoice Journal Accounting for Vendor Managed Warehouses      
SC10111 NCHAR SWITCH 1 0 1 DisableTransVendor Disable Manual Stock Transactions for Vendor Managed Warehouses      
SC10112 INT INTEGER 0 0 2 CycleCountingListSorting Type of Cycle Counting List Sorting      
SC10113 INT INTEGER 0 0 3 ExcludeUnusedBinBatch Exclude Unused Bins/Batches      
SC10114 NCHAR SWITCH 1 0 1 DelayLockUntilPrinting Delay Lock Unit Printing      
SC10115 INT INTEGER 0 0 4 STOLineIncrement Stock Transfer Order Number      
SC10116 INT INTEGER 0 0 4 STODelLineIncrement Stock Transfer Order Delivery Lines Number Interval      
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 for Picking List      
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 for Intangibles      
SC10123 NVARCHAR VSTRING 4 0 4 DefaultRejectionCode Default Rejection Code      
SC10124 NCHAR STRING 1 0 1 SerialNumberScrap Use Scrapped Serial Numbers Flag      
SC10125 INT INTEGER 0 0 1 EnforceItemBatchRule Enforce Item/Batch Rule Flag      
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 Flag      
SC10129 NCHAR SWITCH 1 0 1 IncludeSCTransConsumptCalc Include Stock Transfer Transaction into Consumption Calculation      
SC10130 NCHAR SWITCH 1 0 1 SeparateClassCalcPerWH Separate Class Calculation per Warehouse      
SC10131 INT INTEGER 0 0 1 BEDateinGLJournal BE Date in GL Journal      
SC10132 NVARCHAR VSTRING 3 0 3 LongDescLan Long Description Language      

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