На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SL22 — Payment Terms SL

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL22001 NVARCHAR VSTRING 1 0 1 RecordType Record Type 0 — Payment term

1 — Delivery term

2 — Delivery Method		 1 Да / Yes
SL22002 NVARCHAR VSTRING 2 0 2 PayTerDelWay Code   2 Да / Yes
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      

Навигация / Navigation: