Структура таблиц Epicor iScala 3.00 (x64) - 3.00.02254 :: Список таблиц модуля «Sales Ledger»
Название Таблицы | Маска Таблицы | Описание Таблицы |
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 |
SL39 | SL39%cc00 | SL39 - Delivery Tax Allocation Lines |
SL40 | SL40%cc00 | SL40 - Payment Methods |
SL45 | SL45%cc00 | SL45 - Extended Bank Info |
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 |
SLD1 | SLD1%cc00 | SLD1 - Payment Ledger Proposal History |
SLD2 | SLD2%cc00 | SLD2 - Customer Payment Proposal Header History |
SLD3 | SLD3%cc00 | SLD3 - Payment Proposal Header 2 History |
SLDD | SLDD%cc00 | SLDD - Payment Proposal Header 2 |
SLDS | SLDS%cc00 | SLDS - Portuguese Digital Signature |
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 |
SLM0 | SLM0%cc00 | SLM0 - Mandate |
SLMH | SLMH%cc00 | SLMH - Mandate history |
SLR4 | SLR4%cc%yy | SLR4 - SL Reversed Transaction |
SLT7 | SLT7%cc00 | SLT7 - Temporary tax table for autopayments |
SLUL | SLUL%cc00 | SLUL - Advanced credit control utilized amounts |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger