Структура таблиц / Tables structure of Epicor iScala 2.3 SR3 - 2.03.12787 :: Список таблиц модуля / List of tables of the module «Sales Ledger»
| Название Таблицы / Table Name | Маска Таблицы / Table Mask | Описание Таблицы / Table Description |
| SL01 | SL01%cc00 | SL01 - Customer File |
| SL03 | SL03%cc00 | SL03 - Sales Ledger Invoices |
| SL04 | SL04%cc%yy | SL04 - Sales Ledger Invoice Journal |
| SL05 | SL05%cc%yy | SL05 - Sales Ledger Payment Journal |
| SL07 | SL07%cc00 | SL07 - Interest Charged |
| SL08 | SL08%cc%yy | SL08 - Sales Ledger Parameters |
| SL09 | SL09%cc%yy | SL09 - Automatic Accounting SL |
| SL10 | SL10%cc00 | SL10 - Payment Ledger (not used) |
| SL11 | SL11%cc00 | SL11 - Payment Ledger Proposal |
| SL12 | SL12%cc00 | SL12 - Customer Payment Proposal Header |
| SL14 | SL14%cc00 | SL14 - Customer Delivery Addresses |
| SL15 | SL15%cc00 | SL15 - Customer Commissions |
| SL16 | SL16%cc00 | SL16 - Due Commissions |
| SL17 | SL17%cc00 | SL17 - VAT Transactions |
| SL18 | SL18%cc00 | SL18 - Invoice Consolidation |
| SL19 | SL19%cc00 | SL19 - Customer Templates |
| SL21 | SL21%cc00 | SL21 - Sales Ledger Payments |
| SL22 | SL22%cc00 | SL22 - Payment Terms SL |
| SL23 | SL23%cc00 | SL23 - Payment Terms Descriptions |
| SL24 | SL24%cc00 | SL24 - Sales Statement Tax Variance File |
| SL25 | SL25%cc00 | SL25 - Sales Statement Proposal Lines |
| SL26 | SL26%cc00 | SL26 - Sales Statement Proposal References Table |
| SL27 | SL27%cc00 | SL27 - Sales Statement |
| SL28 | SL28%cc00 | SL28 - Billing Proposal |
| SL29 | SL29%cc00 | SL29 - Invoice Consolidation History |
| SL30 | SL30%cc00 | SL30 - Tax details for Payments |
| SL31 | SL31%cc00 | SL31 - Prepayment Allocation Lines |
| SL32 | SL32%cc00 | SL32 - Prepayment Tax Base Lines |
| SL33 | SL33%cc00 | SL33 - Prepayment Tax Details |
| SL34 | SL34%cc00 | SL34 - Prepayment Deductions |
| SL35 | SL35%cc00 | SL35 - Multiply Payment Periods |
| SL61 | SL61%cc00 | SL61 - Reminder Proposal |
| SL97 | SL970000 | SL97 - Work File for Ledger Statement |
| SL98 | SL980000 | SL98 - Work File for EC Tax Reports |
| SLA1 | SLA1%cc00 | SLA1 - SL account exceptions for revaluation procedure |
| SLB1 | SLB1%cc00 | SLB1 - Bank Note Records |
| SLB4 | SLB4%cc00 | SLB4 - Tax Note Description |
| SLB5 | SLB5%cc00 | SLB5 - Tax Note lines details |
| SLC1 | SLC1%cc00 | SLC1 - Credit Check permission levels |
| SLE0 | SLE0%cc00 | SLE0 - Drafts |
| SLE1 | SLE1%cc00 | SLE1 - Remittance Header |
| SLE2 | SLE2%cc00 | SLE2 - Remittance Details |
| SLE3 | SLE3%cc00 | SLE3 - Bank/Agent |
| SLE4 | SLE4%cc00 | SLE4 - Draft Transactions |
| SLE5 | SLE5%cc%yy | SLE5 - Sales Ledger Payment Provisional |
| SLE7 | SLE7%cc00 | SLE7 - Extended Payment |
| SLE8 | SLE8%cc%yy | SLE8 - Advanced Sales Ledger Parameters |
| SLE9 | SLE9%cc%yy | SLE9 - Advanced Automatic Accounting Codes |
| SLER | SLER%cc00 | SLER - Remittance Work File |
| SLF1 | SLF1%cc00 | SLF1 - Exposed Customer |
| SLH3 | SLH30000 | SLH3 - Recharge Invoice Accounts Receivable Header |
| SLH4 | SLH40000 | SLH4 - Recharge Invoice Accounts Receivable Transaction Lines |
| SLH5 | SLH5%cc00 | SLH5 - Invoice Lines History |
| SLI1 | SLI1%cc00 | SLI1 - Payment Term Instalments SL Header |
| SLI2 | SLI2%cc00 | SLI2 - Payment Term Instalments SL Lines |
| SLI3 | SLI3%cc00 | SLI3 - Payment Term Instalments SL |
| SLI9 | SLI9%cc00 | SLI9 - RIBA Payment proposals |
| SLIN | SLIN%cc00 | SLIN - Invoice Based Intrastat SL |
| SLL1 | SLL1%cc00 | SLL1 - Customer Tax Exemptions |
| SLL2 | SLL2%cc00 | SLL2 - Customer Payment Balances |
| SLR4 | SLR4%cc%yy | SLR4 - SL Reversed Transaction |
| SLT7 | SLT7%cc00 | SLT7 - Temporary tax table for autopayments |
| SLXX | SLXX0000 | SLXX - Customer Statement work file |
| SLXY | SLXY0000 | SLXY - Customer ABC and Frequency Analysis work file |
| SLXZ | SLXZ0000 | SLXZ - Customer Statement by Date work file |
Навигация / Shortcut: Структура БД iScala / iScala DB Structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Ledger
/* */