Таблица: ST01 - «Salesmen». Маска имени таблицы: «ST01%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST01001 | NCHAR | STRING | 3 | 0 | 3 | SalesmanNo | Salesman | 1 | Да | |
ST01002 | NVARCHAR | VSTRING | 25 | 0 | 25 | Name | Name | |||
ST01003 | DATETIME | DATE | 0 | 0 | 8 | LatestOrDate | Last Order Date | |||
ST01004 | NUMERIC | MONEY | 28 | 8 | 20 | VolumePeriod | Volume Period | |||
ST01005 | NUMERIC | MONEY | 28 | 8 | 20 | ProfitPeriod | Profit Period | |||
ST01006 | INT | INTEGER | 0 | 0 | 4 | NoOfOrPeriod | No of Orders Period | |||
ST01007 | NUMERIC | MONEY | 28 | 8 | 20 | VolumeYTD | Volume YTD | |||
ST01008 | NUMERIC | MONEY | 28 | 8 | 20 | ProfitYTD | Profit YTD | |||
ST01009 | INT | INTEGER | 0 | 0 | 4 | NoOfOrderYTD | No of Orders YTD | |||
ST01010 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | VolumeCommis | Volume Commission % | |||
ST01011 | NUMERIC | MONEY | 28 | 8 | 20 | CommLimitVol | Volume Commission Limit | |||
ST01012 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ProfitCommis | Profit Commission % | |||
ST01013 | NUMERIC | MONEY | 28 | 8 | 20 | CommLimiProf | Profit Commission Limit | |||
ST01014 | NUMERIC | MONEY | 28 | 8 | 20 | CommPaidYTD | Commission Paid YTD | |||
ST01015 | NUMERIC | MONEY | 28 | 8 | 20 | VolNextPeriod | Volume Next Period | |||
ST01016 | NUMERIC | MONEY | 28 | 8 | 20 | ProfiNextPer | Profit Next Period | |||
ST01017 | INT | INTEGER | 0 | 0 | 4 | NoOfOrNexPer | No of Orders Next Period | |||
ST01018 | NUMERIC | MONEY | 28 | 8 | 20 | VolNextYTD | Volume Next YTD | |||
ST01019 | NUMERIC | MONEY | 28 | 8 | 20 | ProfNextYTD | Profit Next YTD | |||
ST01020 | INT | INTEGER | 0 | 0 | 4 | NoOfOrNexYTD | Number of Orders Next YTD | |||
ST01021 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccCodeStrin | Accounting String | |||
ST01022 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
ST01023 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Statistics | Salesmen