Таблица: 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