Таблица | Table: SLI1 - «Payment Term Instalments SL Header». Маска имени таблицы | Table Name Mask: «SLI1%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SLI1001 NVARCHAR VSTRING 2 0 2 PaymentTerm PaymentTerm   1 Да / Yes
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      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Ledger | Payment Term Instalments SL Header