Таблица: SM24 - «Service Order Activity Files Descriptions». Маска имени таблицы: «SM24%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM24001 | NCHAR | STRING | 8 | 0 | 8 | ActivityCode | Activity Code | 1 | Да | |
SM24002 | NVARCHAR | VSTRING | 25 | 0 | 25 | DescrLang0 | Description | |||
SM24003 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24004 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24005 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24006 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24007 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24008 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24009 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24010 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24011 | NVARCHAR | VSTRING | 25 | 0 | 25 | Spare | (obsolete) | |||
SM24012 | NCHAR | SWITCH | 1 | 0 | 1 | HourlyType01 | Activity Type | 0 - Cost Activity
1 - Time Activity |
||
SM24013 | NCHAR | STRING | 1 | 0 | 1 | CostCategory | Cost Category | |||
SM24014 | NCHAR | STRING | 1 | 0 | 1 | SalesTaxCode | (obsolete) | |||
SM24015 | NCHAR | STRING | 2 | 0 | 2 | AccCode | Accounting Code | |||
SM24016 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SM24017 | NCHAR | STRING | 6 | 0 | 6 | PayrollCode | Wage Type | |||
SM24018 | NCHAR | STRING | 3 | 0 | 3 | SkillCode | Skill Code | |||
SM24019 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SM24020 | NCHAR | STRING | 1 | 0 | 1 | MaintenaCode | Maintenance Contract Code | |||
SM24021 | NCHAR | STRING | 8 | 0 | 8 | PriceTabell | Activity as Price Table | Specifies the activity that will be used for retrieving price information for current activity (can be the same activity code). | ||
SM24022 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM24023 | NCHAR | STRING | 6 | 0 | 6 | SalesTaxCode | VAT Code |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Order Activities