Таблица: SC10 - «Stock Parameters 1». Маска имени таблицы: «SC10%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 User_Info_0 Description User Field 0      
SC10072 NCHAR STRING 35 0 35 User_Info_1 Description User Field 1      
SC10073 NCHAR STRING 35 0 35 User_Info_2 Description User Field 2      
SC10074 NCHAR STRING 35 0 35 User_Info_3 Description User Field 3      
SC10075 NCHAR STRING 35 0 35 User_Info_4 Description User Field 4      
SC10076 NCHAR STRING 35 0 35 User_Info_5 Description User Field 5      
SC10077 NCHAR STRING 35 0 35 User_Info_6 Description User Field 6      
SC10078 NCHAR STRING 35 0 35 User_Info_7 Description User Field 7      
SC10079 NCHAR STRING 35 0 35 User_Info_8 Description User Field 8      
SC10080 NCHAR STRING 35 0 35 User_Info_9 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 CostType_Depreciation Cost Type for Depreciation      
SC10095 NCHAR SWITCH 1 0 1 Flag_Lock_Count Lock for Counting      
SC10096 NCHAR STRING 6 0 6 Count_Tollerance_Percent Counting Tolerance Percentage      
SC10097 INT INTEGER 0 0 1 Bin Placement via LF Bin Placement via Logistic Forms      
SC10098 NVARCHAR VSTRING 10 0 10 UOM Description 1 Description Length Unit of Measurements      
SC10099 NVARCHAR VSTRING 10 0 10 UOM Description 2 Description Weight Unit of Measurements      
SC10100 NVARCHAR VSTRING 10 0 10 UOM Description 3 Description Volume Unit of Measurements      
SC10101 NCHAR STRING 1 0 1 Cost accounting for allocated to supplier stock Cost Accounting when Allocated to Supplier Stock      
SC10102 NCHAR STRING 1 0 1 Revenue Accounting for allocated to supplier stock Revenue Accounting when Allocated to Supplier Stock      
SC10103 NCHAR STRING 1 0 1 Create consumption note Create Consumption Note      
SC10104 NCHAR STRING 2 0 2 DSSupplier_selection_rule_type Drop Shipment Supplier Selection Rule      
SC10105 INT INTEGER 0 0 1 Stock Closing Period Type Type of Stock Closing Period      
SC10106 NVARCHAR VSTRING 40 0 40 Detailed GL transactions from SC 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 Min number of counts Minimun number of counts Minimun number of counts befor Stock Taking result entry    
SC10108 INT INTEGER 0 0 2 Number consecutive counts Number of necessary consecutive counts Number of necessary consecutive counts with same result    
SC10109 NCHAR STRING 1 0 1 Cost accounting for allocated to Vendor Managed warehouses Cost Accounting when Allocated to Vendor Managed warehouses      
SC10110 NCHAR STRING 1 0 1 Revenue Accounting for allocated to Vendor Managed warehouses Revenue Accounting when Allocated to Vendor Managed warehouses      
SC10111 NCHAR SWITCH 1 0 1 'Disable transactions for Vendor Disable manual stock transactions for Vendor Managed warehouse      
SC10112 INT INTEGER 0 0 2 Cycle Counting List Sorting control how CC List should be sorted      
SC10113 INT INTEGER 0 0 3 Exclude bins/batches not used for        
SC10114 NCHAR SWITCH 1 0 1 Delay Lock Until Printing        
SC10115 INT INTEGER 0 0 4 Stock Transfer Order Lines Number Increment Stock Transfer Order Lines Number Increment      
SC10116 INT INTEGER 0 0 4 Stock Transfer Order Delivery Lines Number Increment Stock Transfer Order Delivery Lines Number Increment      
SC10117 INT INTEGER 0 0 4 Lead time for picking Lead time for picking      
SC10118 INT INTEGER 0 0 4 Lead time for shipping Lead time for shipping      
SC10119 NCHAR SWITCH 1 0 1 One delivery note per picking One delivery note per picking      
SC10120 NCHAR SWITCH 1 0 1 Item/Supplier Id default from Item Item/Supplier Id default from Item      
SC10121 NCHAR SWITCH 1 0 1 Item/Customer Id default from Item Item/Customer Id default from Item      
SC10122 NVARCHAR VSTRING 25 0 25 DefNomenclNo Default Nomenclature Number      
SC10123 NVARCHAR VSTRING 4 0 4 Default Rejection Code Default Rejection Code      

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