One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SM63 — Service Order Automatic Accounting Coding Schedule

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM63001 NCHAR STRING 2 0 2 CustAccCode Accounting Code Customer   1 Да / Yes
SM63002 NCHAR STRING 2 0 2 SOAccCode Accounting Code Service Order   2 Да / Yes
SM63003 NCHAR STRING 2 0 2 ActAccCode Accounting Code Activity   3 Да / Yes
SM63004 NCHAR STRING 1 0 1 AcrType Activity Type 0 — Cost activity

1 — Time activity

2 — Material activity
4 Да / Yes
SM63005 NCHAR STRING 1 0 1 ResourceCode Resource Type 0 — Local human resource

1 — Resource group

2 — External resource

3 — Machinery resource
5 Да / Yes
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)      

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