Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SLI1 - «Payment Term Instalments SL Header». Маска имени таблицы: «SLI1%cc00»
| Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| SLI1001 | NVARCHAR | VSTRING | 2 | 0 | 2 | PaymentTerm | PaymentTerm | 1 | Да | |
| SLI1002 | NVARCHAR | VSTRING | 1 | 0 | 1 | InstalmentType | Instalment Type | |||
| SLI1003 | INT | INTEGER | 0 | 0 | 3 | NumberOfInstalments | Number Of Instalments | |||
| SLI1004 | NCHAR | STRING | 1 | 0 | 1 | Percentage | Percentage | 0 – Equal, including tax
1 – Equal, excluding tax which is included in the first instalment 2 – User defined, including tax 3 – User defined, excluding tax which is included in the first instalment |
||
| SLI1005 | INT | INTEGER | 0 | 0 | 3 | Interval | Interval | |||
| SLI1006 | NCHAR | STRING | 1 | 0 | 1 | UnitInterval | UnitInterval | D – Days
W – Weeks M - Month |
||
| SLI1007 | NVARCHAR | VSTRING | 6 | 0 | 6 | InterestPercent | Interest% | 0.00 – 100.00 | ||
| SLI1008 | NVARCHAR | VSTRING | 6 | 0 | 6 | NewInterestPercent | NewInterest% | |||
| SLI1009 | DATETIME | DATE | 0 | 0 | 8 | ActivateNewInterest | ActivateNewInterest | |||
| SLI1010 | INT | INTEGER | 0 | 0 | 3 | PeriodOfGrace | PeriodOfGrace | |||
| SLI1011 | NCHAR | STRING | 1 | 0 | 1 | UnitPeriodOfGrace | UnitPeriodOfGrace | D – Days
W – Weeks M - Month |
||
| SLI1012 | NCHAR | SWITCH | 1 | 0 | 1 | EndOfMonthPerGrace | EndOfMonthPerGrace | |||
| SLI1013 | INT | INTEGER | 0 | 0 | 3 | PlusNumberOfUnit | PlusNumberOfUnit | |||
| SLI1014 | NUMERIC | MONEY | 28 | 8 | 20 | FinancialCharge | FinancialCharge | |||
| SLI1015 | NCHAR | SWITCH | 1 | 0 | 1 | UseTotalRounding | UseTotalRounding | |||
| SLI1016 | NCHAR | STRING | 6 | 0 | 6 | InterestTaxCode | InterestTaxCode | |||
| SLI1017 | NCHAR | STRING | 6 | 0 | 6 | FinTaxCode | FinTaxCode | |||
| SLI1018 | NCHAR | SWITCH | 1 | 0 | 1 | WayOfPaymentPerInstlmnts | WayOfPaymentPerInstlmnts |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Payment Term Instalments SL Header
/* */