Таблица: SM63 - «Service Management Automatic Accounting Coding Schedule». Маска имени таблицы: «SM63%cc%yy»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM63001 NCHAR STRING 2 0 2 CustAccCode Accounting Code Customer   1 Да
SM63002 NCHAR STRING 2 0 2 SOAccCode Accounting Code Service Order   2 Да
SM63003 NCHAR STRING 2 0 2 ActAccCode Accounting Code Activity   3 Да
SM63004 NCHAR STRING 1 0 1 AcrType Activity Type 0 - Cost activity
1 - Time activity
2 - Material activity
4 Да
SM63005 NCHAR STRING 1 0 1 ResourceCode Resource Type 0 - Local human resource
1 - Resource group
2 - External resource
3 - Machinery resource
5 Да
SM63006 NVARCHAR VSTRING 12 0 12 SalesIncVATEx Sales Income VAT 0      
SM63007 NVARCHAR VSTRING 12 0 12 SalIncVAT1 Sales Income VAT 1      
SM63008 NVARCHAR VSTRING 12 0 12 SalIncVAT2 Sales Income VAT 2      
SM63009 NVARCHAR VSTRING 12 0 12 SalIncVAT3 Sales Income VAT 3-99      
SM63010 NVARCHAR VSTRING 12 0 12 SalIncExp Sales Income Export      
SM63011 NVARCHAR VSTRING 12 0 12 SalIncExpEC Sales Income Export EC      
SM63012 NVARCHAR VSTRING 12 0 12 SalIncInternal Sales Income Internal      
SM63013 NVARCHAR VSTRING 12 0 12 WIPAccount WIP Account      
SM63014 NVARCHAR VSTRING 12 0 12 WIPContraAcc WIP Contra Account      
SM63015 NVARCHAR VSTRING 12 0 12 CostOfSalesAcc Cost of Sales Account      
SM63016 NVARCHAR VSTRING 12 0 12 CostContraAcc Cost Contra Account      
SM63017 NVARCHAR VSTRING 12 0 12 CostAdvOfSalAcc Cost Reallocation (Resources)      
SM63018 NVARCHAR VSTRING 12 0 12 CostAdvContraAcc Cost Reallocation (Service Order)      
SM63019 NVARCHAR VSTRING 12 0 12 DiscountVATEx Discount VAT 0      
SM63020 NVARCHAR VSTRING 12 0 12 DiscountVAT1 Discount VAT 1      
SM63021 NVARCHAR VSTRING 12 0 12 DiscountVAT2 Discount VAT 2      
SM63022 NVARCHAR VSTRING 12 0 12 DiscountVAT3 Discount VAT 3-99      
SM63023 NVARCHAR VSTRING 12 0 12 DiscountExport Discount Export      
SM63024 NVARCHAR VSTRING 12 0 12 DiscountExportEC Discount Export EC      
SM63025 NVARCHAR VSTRING 12 0 12 DiscountInternal Discount Internal      
SM63026 NVARCHAR VSTRING 12 0 12 Reserved Customer Advances Income VAT 0      
SM63027 NVARCHAR VSTRING 12 0 12 Reserved Customer Advances Income VAT 1      
SM63028 NVARCHAR VSTRING 12 0 12 Reserved Customer Advances Income VAT 2      
SM63029 NVARCHAR VSTRING 12 0 12 Reserved Customer Advances Income VAT 3-99      
SM63030 NVARCHAR VSTRING 12 0 12 Reserved Customer Advances Income Export      
SM63031 NVARCHAR VSTRING 12 0 12 Reserved Customer Advances Income Export EC      
SM63032 NVARCHAR VSTRING 12 0 12 Reserved Internal Advances Income      
SM63033 NVARCHAR VSTRING 12 0 12 Reserved (obsolete)      
SM63034 NVARCHAR VSTRING 12 0 12 Reserved (obsolete)      
SM63035 NVARCHAR VSTRING 12 0 12 Reserved (obsolete)      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Service Order Automatic Accounting Coding Schedule