Таблица: SM71 - «Service Contract Deferrals History». Маска имени таблицы: «SM71%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM71001 | NCHAR | STRING | 10 | 0 | 10 | ContractNum | Service Contract Number | 1 | Да | |
SM71002 | DATETIME | DATE | 0 | 0 | 8 | InvoicePeriodStart | Start Date of the Invoicing Period | 3 | Да | |
SM71003 | INT | INTEGER | 0 | 0 | 2 | AccPeriodNum | GL Accounting Period number | 4 | Да | |
SM71004 | NCHAR | STRING | 4 | 0 | 4 | FinanceYear | Financial year of the transaction | |||
SM71005 | DATETIME | DATE | 0 | 0 | 8 | TransactionDate | Transaction Date | |||
SM71006 | DATETIME | DATE | 0 | 0 | 8 | BEDate | Book Entry Date | |||
SM71007 | NUMERIC | MONEY | 28 | 8 | 20 | AmountToInvoiceICU | Amount to Invoice (invoice currency) | |||
SM71008 | NUMERIC | MONEY | 28 | 8 | 20 | AmountToInvoiceLCU | Amount to Invoice (local currency) | |||
SM71009 | NUMERIC | MONEY | 28 | 8 | 20 | InvoicedAmountICU | Invoiced Amount (invoice currency) | |||
SM71010 | NUMERIC | MONEY | 28 | 8 | 20 | InvoicedAmountLCU | Invoiced Amount (local currency) | |||
SM71011 | NUMERIC | MONEY | 28 | 8 | 20 | DeferredAmountICU | Deferred Amount (invoice currency) | |||
SM71012 | NUMERIC | MONEY | 28 | 8 | 20 | DeferredAmountLCU | Deferred Amount (local currency) | |||
SM71013 | NUMERIC | MONEY | 28 | 8 | 20 | ReversedDeferralAmountICU | Reversed Deferral Amount (invoice currency) | |||
SM71014 | NUMERIC | MONEY | 28 | 8 | 20 | ReversedDeferralAmountLCU | Reversed Deferral Amount (local currency) | |||
SM71015 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchangeRate1 | Currency Exchange Rate 1 | |||
SM71016 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchangeRate2 | Currency Exchange Rate 2 | |||
SM71017 | NCHAR | STRING | 3 | 0 | 3 | ExchangeAlgorithm | Currency Exchange Algorithm | |||
SM71018 | NCHAR | STRING | 50 | 0 | 50 | RevenueAccStr | Accounting String for Revenue account | |||
SM71019 | NCHAR | STRING | 50 | 0 | 50 | AccrualAccStr | Accounting String for Accrual account | |||
SM71020 | NVARCHAR | VSTRING | 20 | 0 | 20 | HistoryLineCounter | HistoryLineCounter | 5 | Да | |
SM71021 | NVARCHAR | VSTRING | 20 | 0 | 20 | TransactionStamp | Transaction Stamp | |||
SM71022 | NVARCHAR | VSTRING | 20 | 0 | 20 | LineNumber | LineNumber | 2 | Да | |
SM71023 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | Reserved for extra data |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | Service Contract Deferrals Booking History