Структура таблиц 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