Таблица: SM03 - «Service Order Activity Lines» («Заказы на обслуживание Стр. раб. »)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
SM03001 | STRING | 10 | ServOrderNo | Да |
SM03002 | STRING | 4 | ItemNo | Да |
SM03003 | STRING | 1 | LineType | |
SM03004 | STRING | 8 | ActivityCode | |
SM03005 | VSTRING | 25 | Description | |
SM03006 | STRING | 10 | FldEngineer | |
SM03007 | X_NUMERIC | 12 | PlannedHours | |
SM03008 | X_NUMERIC | 12 | ActualHours | |
SM03009 | MONEY | 20 | PlannedAmntOcu | |
SM03010 | MONEY | 20 | ActualAmntOcu | |
SM03011 | MONEY | 20 | BudgCostLCU | |
SM03012 | MONEY | 20 | ActuaCostLCU | |
SM03013 | STRING | 4 | Spare | |
SM03014 | MONEY | 20 | ProposInvAmoOcu | |
SM03015 | MONEY | 20 | ActualInvAmoOcu | |
SM03016 | STRING | 2 | VATCode1 | |
SM03017 | STRING | 2 | AccountCode | |
SM03018 | STRING | 6 | CostType | |
SM03019 | STRING | 6 | CoveredByContract | |
SM03020 | STRING | 6 | Spare | |
SM03021 | SWITCH | 1 | IncludFixPr | |
SM03022 | STRING | 10 | CustCodeInv | |
SM03023 | DATE | 8 | InvoiceDate | |
SM03024 | STRING | 10 | InvoiceNo | |
SM03025 | MONEY | 20 | PlannedAmountICU | |
SM03026 | DATE | 8 | TransactDate | |
SM03027 | X_NUMERIC | 7 | DiscountLabour | |
SM03028 | X_NUMERIC | 12 | HoursInvoice | |
SM03029 | STRING | 2 | PricelistNo | |
SM03030 | SWITCH | 1 | ChangeCustomer | |
SM03031 | INTEGER | 1 | InvUpdStat | |
SM03032 | STRING | 2 | Spare | |
SM03033 | STRING | 8 | PriceTabell | |
SM03034 | ACCSTR | 50 | AccString | |
SM03035 | STRING | 2 | VATCode2 | |
SM03036 | DATE | 8 | ActivStrDate | |
SM03037 | X_NUMERIC | 5 | ActivStrTime | |
SM03038 | DATE | 8 | ActivEndDate | |
SM03039 | X_NUMERIC | 5 | ActivEndTime | |
SM03040 | INTEGER | 1 | Spare | |
SM03041 | STRING | 2 | OrderCurrencyCode | |
SM03042 | X_NUMERIC | 20 | CurrExchRate | |
SM03043 | MONEY | 20 | PlannedAmountLcu | |
SM03044 | MONEY | 20 | ActualAmountICU | |
SM03045 | MONEY | 20 | ActualAmountLCU | |
SM03046 | MONEY | 20 | PropInvAmountIcu | |
SM03047 | MONEY | 20 | PropInvAmountLcu | |
SM03048 | MONEY | 20 | ActInvAmountIcu | |
SM03049 | MONEY | 20 | ActInvAmountLCU | |
SM03050 | STRING | 2 | InvoiceCurrency | |
SM03051 | SWITCH | 1 | StatusSwitch0 | |
SM03052 | SWITCH | 1 | StatusSwitch1 | |
SM03053 | SWITCH | 1 | StatusSwitch2 | |
SM03054 | SWITCH | 1 | StatusSwitch3 | |
SM03055 | SWITCH | 1 | StatusSwitch4 | |
SM03056 | SWITCH | 1 | StatusSwitch5 |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Service Order Management (Управление Заказами на Обслуживание) | Service Order Activity Lines (Заказы на обслуживание Стр. раб. )