Таблица: SM71 - «Service Contract Deferrals History». Маска имени таблицы: «SM71%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 | IncomeAccStr | Accounting string for sales/interest income | |||
SM71019 | NCHAR | STRING | 50 | 0 | 50 | DeferralsAccStr | Accounting string for deferred/accrued revenue | |||
SM71020 | NVARCHAR | VSTRING | 20 | 0 | 20 | HistoryLineCounter | HistoryLineCounter | 5 | Да | |
SM71021 | NVARCHAR | VSTRING | 20 | 0 | 20 | InvoiceNumber | Invoice number | |||
SM71022 | NVARCHAR | VSTRING | 20 | 0 | 20 | LineNumber | LineNumber | 2 | Да | |
SM71023 | NVARCHAR | VSTRING | 25 | 0 | 25 | IncomeAASCode | AAS code for sales/interest income acc string | |||
SM71024 | NVARCHAR | VSTRING | 25 | 0 | 25 | DeferralsAASCode | AAS code for deferred/accrued revenue acc string | |||
SM71025 | INT | INTEGER | 0 | 0 | 1 | DeferralsType | Deferrals Type | |||
SM71026 | NCHAR | STRING | 6 | 0 | 6 | InvoicePlanLineNumber | Invoice Plan Line Number |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Service Contract Deferrals Booking History