Таблица: DI01 - «Stock Item File» («Файл Позиций запасов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| DI01001 | STRING | 35 | StockCode | Да |
| DI01002 | VSTRING | 25 | DescrLang0 | |
| DI01003 | VSTRING | 4 | StockCateg | |
| DI01004 | MONEY | 20 | Pricelist0 | |
| DI01005 | MONEY | 20 | CalcCostLCU | |
| DI01006 | X_NUMERIC | 12 | BudgetQty | |
| DI01007 | X_NUMERIC | 12 | BudgetVolume | |
| DI01008 | X_NUMERIC | 12 | QtySoldPeriod | |
| DI01009 | X_NUMERIC | 12 | QtySoldYTD | |
| DI01010 | X_NUMERIC | 12 | QtySoldPyear | |
| DI01011 | X_NUMERIC | 12 | VolumePeriod | |
| DI01012 | X_NUMERIC | 12 | VolumeYTD | |
| DI01013 | X_NUMERIC | 12 | VolumePyear | |
| DI01014 | MONEY | 20 | ProfitPeriod | |
| DI01015 | MONEY | 20 | ProfitYTD | |
| DI01016 | MONEY | 20 | ProfitPyear | |
| DI01017 | INTEGER | 2 | AccCode | |
| DI01018 | VSTRING | 2 | VATCode | |
| DI01019 | INTEGER | 1 | ExtraTaxCode | |
| DI01020 | VSTRING | 1 | FrequencyC | |
| DI01021 | VSTRING | 1 | ABCCode | |
| DI01022 | VSTRING | 1 | InterActFlag | |
| DI01023 | DATE | 8 | LatestDelivD | |
| DI01024 | ACCSTR | 50 | AccString | |
| DI01025 | X_NUMERIC | 12 | VolNextPeriod | |
| DI01026 | X_NUMERIC | 12 | VolNextYTD | |
| DI01027 | MONEY | 20 | ProfNextPer | |
| DI01028 | MONEY | 20 | ProfNextYTD | |
| DI01029 | X_NUMERIC | 12 | QtySoldNPer | |
| DI01030 | X_NUMERIC | 12 | QtySoldNYTD |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Direct Invoicing (Прямая выписка счетов-фактур) | Stock Item File (Файл Позиций запасов)
/* */