Таблица / Table: SL08 — «Sales Ledger Parameters». Маска имени таблицы / Table name mask: «SL08%cc%yy»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
SL08001 | NVARCHAR | VSTRING | 1 | 0 | 1 | IndexID | Index ID | 1 | Да / Yes | |
SL08002 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | InternIntRate | Internal Interest Rate % | |||
SL08003 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | PaymTransNo | (obsolete) | |||
SL08004 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | TransacNoInv | (obsolete) | |||
SL08005 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | TransNoPayJournal | (obsolete) | |||
SL08006 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | TransNoInvJournal | (obsolete) | |||
SL08007 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | InterCalcModel | Interest Calculation Model | |||
SL08008 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | InterestRate | Interest Rate % | |||
SL08009 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | MinInterAmnt | Minimum Interest Amount (Local Currency) | |||
SL08010 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InvCntrInterest | (obsolete) | |||
SL08011 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | IntInvCopies | Number of Interest Invoice Copies | |||
SL08012 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | PaymentTerm | Payment Terms Interest Invoices | |||
SL08013 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | InvFeeInterest | Invoicing Fee Interest Invoices (Local Currency) | |||
SL08014 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | RemindHoldDay | Reminder Hold Days | |||
SL08015 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | ReminderPers | Reminder Period | |||
SL08016 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | ReminderCopies | Number of Reminder Copies | |||
SL08017 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | StatementPeriod | Statement Period | |||
SL08018 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | RemAmntQuest | Remaining Amount for Question (Local Currency) | |||
SL08019 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | RemAmntAutomat | Remaining Amount for Automatic (Local Currency) | |||
SL08020 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | AverageMargin | Average Margin % | |||
SL08021 | NCHAR | SWITCH | 1 | 0 | 1 | DeductGracePeriod | Deduct Grace Period | |||
SL08022 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate2 | (obsolete) | |||
SL08023 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate3 | (obsolete) | |||
SL08024 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate4 | (obsolete) | |||
SL08025 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate5 | (obsolete) | |||
SL08026 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate6 | (obsolete) | |||
SL08027 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate7 | (obsolete) | |||
SL08028 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate8 | (obsolete) | |||
SL08029 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VATRate9 | (obsolete) | |||
SL08030 | DATETIME | DATE | 0 | 0 | 8 | RateDate1 | Rate From Date 1 | |||
SL08031 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InteresRate1 | Interest Rate 1 | |||
SL08032 | DATETIME | DATE | 0 | 0 | 8 | RateDate2 | Rate From Date 2 | |||
SL08033 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InteresRate2 | Interest Rate 2 | |||
SL08034 | DATETIME | DATE | 0 | 0 | 8 | RateDate3 | Rate From Date 3 | |||
SL08035 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InteresRate3 | Interest Rate 3 | |||
SL08036 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | CntrPremCust | (obsolete) | |||
SL08037 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | CntrTempCust | (obsolete) | |||
SL08038 | NUMERIC | X_NUMERIC | 11 | 8 | 3 | InterestChrg | Interest Charged per Period in Days | |||
SL08039 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | ReminderChrg | Reminder Fee (Local Currency) | |||
SL08040 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | AccessLevel | Access Level | |||
SL08041 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | AccntYear | Accounting Year for Central Ledger | |||
SL08042 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | MergerInvoices | (obsolete) | |||
SL08043 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | SalesTaxCode | VAT Code on Account Invoices | |||
SL08044 | NUMERIC | X_NUMERIC | 11 | 8 | 3 | InfFldCusQuery | Information Field on Customer Query | |||
SL08045 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | NoReminders | Number of Reminders | |||
SL08046 | NUMERIC | X_NUMERIC | 11 | 8 | 3 | GracePeriod | Interest Grace Period | |||
SL08047 | INT | INTEGER | 0 | 0 | 1 | CashMethod | Use Cash Method for Tax | |||
SL08048 | INT | INTEGER | 0 | 0 | 1 | UpdateVolume | Update Volume on Ledger Entry | |||
SL08049 | INT | INTEGER | 0 | 0 | 1 | BasedInvDate | Statement Based on Invoice Date | |||
SL08050 | INT | INTEGER | 0 | 0 | 1 | CreditInterest | Credit Interest on early Payments | |||
SL08051 | INT | INTEGER | 0 | 0 | 1 | PrintDueInterest | Print Due Interest on Remainders | |||
SL08052 | INT | INTEGER | 0 | 0 | 1 | UpdGLPaymJrn | Update GL with Payment Journal | |||
SL08053 | INT | INTEGER | 0 | 0 | 1 | UpdGLInvJrn | Update GL with Invoice Journal | |||
SL08054 | INT | INTEGER | 0 | 0 | 1 | IntegratedGL | Integrated to General Ledger | |||
SL08055 | INT | INTEGER | 0 | 0 | 1 | AutoVouchNo | Automatic Transaction Numbers | |||
SL08056 | INT | INTEGER | 0 | 0 | 1 | UseGLVouCntr | Use General Ledger Transaction Number | |||
SL08057 | INT | INTEGER | 0 | 0 | 1 | InclCreditNotes | Credit Notes Included in Due Amount | |||
SL08058 | INT | INTEGER | 0 | 0 | 1 | InclPaidInv | Paid Invoiced included on Statement | |||
SL08059 | INT | INTEGER | 0 | 0 | 1 | CustCodInvNo | Customer Code + Invoice No as Transaction text | |||
SL08060 | INT | INTEGER | 0 | 0 | 1 | CentralLedger | Central Ledger | |||
SL08061 | INT | INTEGER | 0 | 0 | 1 | OrdAmntCredCheck | Include ordered not shipped amount in credit check | |||
SL08062 | INT | INTEGER | 0 | 0 | 1 | SaveVatTrans | Save Vat Transactions | |||
SL08063 | INT | INTEGER | 0 | 0 | 1 | ExtPaymInfo | Extended Payment Info | |||
SL08064 | INT | INTEGER | 0 | 0 | 1 | ConnentedAVP | Connected to AVP (US TAX) | |||
SL08065 | INT | INTEGER | 0 | 0 | 1 | TaxJurisdCode | Coding on Auto Payment Collection | |||
SL08066 | INT | INTEGER | 0 | 0 | 1 | cussw20 | Tax Jurisdiction Code | |||
SL08067 | INT | INTEGER | 0 | 0 | 1 | PrepaymentTax | Prepayment VAT | |||
SL08068 | INT | INTEGER | 0 | 0 | 1 | TaxPoint | (obsolete) | |||
SL08069 | INT | INTEGER | 0 | 0 | 1 | cussw23 | (obsolete) | |||
SL08070 | INT | INTEGER | 0 | 0 | 1 | cussw24 | (obsolete) | |||
SL08071 | NVARCHAR | VSTRING | 6 | 0 | 6 | cusjou0 | (obsolete) | |||
SL08072 | NVARCHAR | VSTRING | 6 | 0 | 6 | cusjou1 | (obsolete) | |||
SL08073 | NVARCHAR | VSTRING | 6 | 0 | 6 | cusjou2 | (obsolete) | |||
SL08074 | NVARCHAR | VSTRING | 6 | 0 | 6 | cusjou3 | (obsolete) | |||
SL08075 | NVARCHAR | VSTRING | 6 | 0 | 6 | cusjou4 | (obsolete) | |||
SL08076 | INT | INTEGER | 0 | 0 | 3 | DaysPerYear | Days per Year Interest Calculation | |||
SL08077 | NUMERIC | MONEY | 28 | 8 | 20 | RoundOffTolerance | Rounding Tolerance limit (Local Currency) | |||
SL08078 | NVARCHAR | VSTRING | 12 | 0 | 12 | RoundOffProfitAcc | Rounding Tolerance Profit Account | |||
SL08079 | NVARCHAR | VSTRING | 12 | 0 | 12 | RoundOffLossAcc | Rounding Tolerance Loss Account | |||
SL08080 | NVARCHAR | VSTRING | 6 | 0 | 6 | PaymPropCounter | (obsolete) | |||
SL08081 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | SalesStatSerNo | (obsolete) | |||
SL08082 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | TAXVarianceSerNo | (obsolete) | |||
SL08083 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | BillingProposCounter | (obsolete) | |||
SL08084 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeInvFee | Tax Code Invoice Fee | |||
SL08085 | NCHAR | STRING | 6 | 0 | 6 | DefaultTaxCodeInsurance | Default Tax Code Insurance | |||
SL08086 | NCHAR | STRING | 6 | 0 | 6 | DefaultTaxCodePacking | Default Tax Code Packing | |||
SL08087 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeInterest | Tax Code Interest | |||
SL08088 | INT | INTEGER | 0 | 0 | 4 | SalesTransactionType | Sales Transaction Type | |||
SL08089 | NCHAR | STRING | 12 | 0 | 12 | AccDiscCust | Account Discount Customer | |||
SL08090 | NCHAR | STRING | 12 | 0 | 12 | AccDiscChann | Account Discount Channel | |||
SL08091 | NCHAR | STRING | 12 | 0 | 12 | AccDiscGroup1 | Account Discount Product Group 1 | |||
SL08092 | NCHAR | STRING | 12 | 0 | 12 | AccDiscGroup2 | Account Discount Product Group 2 | |||
SL08093 | NCHAR | STRING | 12 | 0 | 12 | AccDiscPromot | Account Discount Promotional | |||
SL08094 | NCHAR | STRING | 12 | 0 | 12 | AccDiscLogist | Account Discount Logistics | |||
SL08095 | NCHAR | STRING | 6 | 0 | 6 | DefTaxCodeDist | Default Tax Code Distribution Fees | |||
SL08096 | NCHAR | STRING | 6 | 0 | 6 | DefTaxCodeAllow | Default Tax Code Allowance | |||
SL08097 | NCHAR | STRING | 6 | 0 | 6 | DefTaxCodeSurch | Default Tax Code Surcharge | |||
SL08098 | INT | INTEGER | 0 | 0 | 1 | AccGainsLosses | Accounting of Currency Gains/Losses | 0 = Only recognise gains/losses when invoices are fully settled, using current value 1 = Only recognise gains/losses when invoices are fully settled, using original value 2 = Recognise gains/losses on partial payment as unrealized. 3 = Recognise gains/losses on partial payment as realized. |
||
SL08099 | INT | INTEGER | 0 | 0 | 1 | PrpTaxAllocRule | Prepayment tax allocation rule | |||
SL08100 | INT | INTEGER | 0 | 0 | 1 | DedRulePartInv | Deduction Rule — Partial Invoice | |||
SL08101 | INT | INTEGER | 0 | 0 | 1 | DedRuleFinalInv | Deduction Rule — Final Invoice | |||
SL08102 | INT | INTEGER | 0 | 0 | 1 | TaxInfoInTransText | Tax Information in Transaction Text | |||
SL08103 | INT | INTEGER | 0 | 0 | 1 | SalesTransType | Sales Transaction Type | |||
SL08104 | NCHAR | STRING | 6 | 0 | 6 | DefaultTaxCode | DefaultTaxCode | |||
SL08105 | NVARCHAR | VSTRING | 15 | 0 | 15 | TaxNoteNo | TaxNoteNo | Counter | ||
SL08106 | INT | INTEGER | 0 | 0 | 1 | TaxNoteNoFlag | TaxNoteNoFlag | |||
SL08107 | NUMERIC | MONEY | 28 | 8 | 20 | MinAmntForFOCitems | Min amount for FOC items | Minimum amount for FOC items | ||
SL08108 | INT | INTEGER | 0 | 0 | 1 | TaxIntrFlag | Tax on Interest Flag | |||
SL08109 | NVARCHAR | VSTRING | 6 | 0 | 6 | LiabilityCodeIntr | Liability Code Interest | |||
SL08110 | NCHAR | SWITCH | 1 | 0 | 1 | LicenseFlag | Default customer license flag | |||
SL08111 | DATETIME | DATE | 0 | 0 | 8 | LicensedFrom | New customer licensed from | |||
SL08112 | DATETIME | DATE | 0 | 0 | 8 | LicensedTo | New customer licensed to | |||
SL08113 | INT | INTEGER | 0 | 0 | 1 | TaxNoteDailyCounterFlag | Tax Note Use Daily Counter Flag | Use Daily based counter for Tax Notes | ||
SL08114 | INT | INTEGER | 0 | 0 | 1 | AdvInvoiceAmntApportionRule | Advance Invoice Amount Apportion Rule | |||
SL08115 | NCHAR | SWITCH | 1 | 0 | 1 | BalanceInCredCheck | Use customer balance in credit check | |||
SL08116 | NCHAR | SWITCH | 1 | 0 | 1 | OrdTaxInCredCheck | Use order tax in credit check | |||
SL08117 | NCHAR | SWITCH | 1 | 0 | 1 | AddCostInCredCheck | Use additional costs in credit check | |||
SL08118 | NCHAR | SWITCH | 1 | 0 | 1 | AddCostTaxInCrCheck | Use taxes on additional costs on order in credit check | |||
SL08119 | NCHAR | SWITCH | 1 | 0 | 1 | AllcInCrCheck | Use allocated amount in credit check | |||
SL08120 | NCHAR | SWITCH | 1 | 0 | 1 | AllcTaxInCrCheck | Use taxes on allocated amount in credit check | |||
SL08121 | NCHAR | SWITCH | 1 | 0 | 1 | DelivInCrCheck | Use shipped amount in credit check | |||
SL08122 | NCHAR | SWITCH | 1 | 0 | 1 | DlvTaxInCrCheck | Use taxes on shipped amount in credit check | |||
SL08123 | NCHAR | SWITCH | 1 | 0 | 1 | AddShipCostInCredCheck | Use additional costs on order (shipped) in credit check | |||
SL08124 | NCHAR | SWITCH | 1 | 0 | 1 | AddShipCostTaxInCrCheck | Use taxes on additional costs on order (shipped) in credit check | |||
SL08125 | NCHAR | STRING | 1 | 0 | 1 | FreightTaxMode | Taxes for Freight | |||
SL08126 | INT | INTEGER | 0 | 0 | 2 | MaxAcceptableCRCStatus | Maximum acceptable credit control status | |||
SL08127 | NCHAR | SWITCH | 1 | 0 | 1 | MultiLevelCRC | Multi-level credit control approval | |||
SL08128 | NVARCHAR | VSTRING | 8 | 0 | 8 | AuthApprGroup | Authorize approval group ID | |||
SL08129 | INT | INTEGER | 0 | 0 | 1 | CrLimitBoundary | Credit Limit Boundary | |||
SL08130 | INT | INTEGER | 0 | 0 | 1 | OverdueBoundary | Overdue Boundary | |||
SL08131 | NCHAR | SWITCH | 1 | 0 | 1 | MultiLevelCRCLine | Multi-level approval on line level | |||
SL08132 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | CancelToleranceAmnt | Tolerance for cancel of approval, amount | |||
SL08133 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | CancelTolerancePrc | Tolerance for cancel of approval, percent | |||
SL08134 | NVARCHAR | VSTRING | 8 | 0 | 8 | FixedApprGroup | Fixed level credit control approval group |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / 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 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»