пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: SL22 - «Payment Terms SL». Маска имени таблицы: «SL22%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL22001 NVARCHAR VSTRING 1 0 1 RecordType Record Type 0 - Payment term
1 - Delivery term
2 - Delivery Method
1 Да
SL22002 NVARCHAR VSTRING 2 0 2 PayTerDelWay Code   2 Да
SL22003 NVARCHAR VSTRING 1 0 1 FreeDeliMnth Free Delivery Months      
SL22004 NCHAR STRING 1 0 1 DueDateInvDelBilSum Due Date per Invoice/Delivery Date Specifies which date calculation of due date shall be based on:
0 - Invoice date
1 - Delivery date
2 - Billing date
3 - Summarized date
   
SL22005 NVARCHAR VSTRING 3 0 3 CreditDays Credit Days      
SL22006 NVARCHAR VSTRING 1 0 1 EndOfMonth End of Month      
SL22007 NVARCHAR VSTRING 3 0 3 DayAfEndMnth Number of Days after End of Month      
SL22008 NVARCHAR VSTRING 3 0 3 DayCashDisc1 No of Days for Cash Discount 1      
SL22009 NVARCHAR VSTRING 6 0 6 CashDiscount Cash Discount 1 %      
SL22010 NVARCHAR VSTRING 3 0 3 DayCashDisc2 No of Days for Cash Discount 2      
SL22011 NVARCHAR VSTRING 6 0 6 CashDiscount2 Cash Discount 2 %      
SL22012 NVARCHAR VSTRING 3 0 3 DayCashDisc3 No of Days for Cash Discount 3      
SL22013 NVARCHAR VSTRING 6 0 6 CashDiscount3 Cash Discount 3 %      
SL22014 NCHAR STRING 1 0 1 UpdCasInvLed Update Cash Invoices in Ledger      
SL22015 NVARCHAR VSTRING 12 0 12 AccNoCashInv Account for Cash Invoice      
SL22016 NVARCHAR VSTRING 2 0 2 DocumentType Type of Document      
SL22017 NVARCHAR VSTRING 2 0 2 VATCode VAT Code      
SL22018 NVARCHAR VSTRING 2 0 2 MentionedDate Mentioned Date      
SL22019 NCHAR STRING 6 0 6 TaxCode Tax Code      
SL22020 NVARCHAR VSTRING 2 0 2 MultPaymentPeriods Multiply Payment Periods      
SL22021 NVARCHAR VSTRING 2 0 2 DayOfPeriod Day of Period      
SL22022 NUMERIC MONEY 28 8 20 AmountBasis AmountBasis AmountBasis    
SL22023 NVARCHAR VSTRING 2 0 2 AltPaymentTerm AltPaymentTerm AltPaymentTerm    
SL22024 NCHAR SWITCH 1 0 1 Instalments Instalments Instalments    
SL22025 NVARCHAR VSTRING 1 0 1 FixedPaymDays FixedPaymDays      
SL22026 NVARCHAR VSTRING 2 0 2 FixedPaymentDay FixedPaymentDay      
SL22027 NVARCHAR VSTRING 2 0 2 WayOfPayment WayOfPayment      
SL22028 INT INTEGER 0 0 1 DueDateDefinition DueDateDefinition      
SL22029 NUMERIC X_NUMERIC 20 8 12 StatFactor Statistical factor      
SL22030 NVARCHAR VSTRING 12 0 12 DepositAccount Deposit Account      
SL22031 INT INTEGER 0 0 2 MonthExcluded1 Month excluded 1      
SL22032 INT INTEGER 0 0 2 MonthExcluded2 Month excluded 2      
SL22033 INT INTEGER 0 0 2 FixedPaymDayForExclMonth Fixed Payment Day for excluded month      
SL22034 NCHAR SWITCH 1 0 1 MinCoinRounding Min Coin Rounding      
SL22035 NVARCHAR VSTRING 2 0 2 CrNotePaymTerm Credit Note Payment Term Payment Term for Credit Notes    
SL22036 NCHAR SWITCH 1 0 1 InvCashDisc Invoice Cash Discount Switch      
SL22037 NVARCHAR VSTRING 100 0 100 BoxTranspDoc Box Transport documents (00-99) Box Transport documents (00-99)    
SL22038 NCHAR SWITCH 1 0 1 NoPayment No Payment      
SL22039 NCHAR SWITCH 1 0 1 CashPaymentFlag Cash Payment Flag      
SL22040 NCHAR STRING 2 0 2 Spare Spare      
SL22041 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Payment Terms SL

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.