Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SLI1 - «Payment Term Instalments SL Header». Маска имени таблицы: «SLI1%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 | Interest% | Interest% | 0.00 – 100.00 | ||
SLI1008 | NVARCHAR | VSTRING | 6 | 0 | 6 | NewInterest% | 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 2.3 SR1 - 2.03.8155 | Sales Ledger | Payment Term Instalments SL Header