One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of 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
SL36 SL36%cc00 SL36 — Link Prepayment/Advance Invoices to SO
SL39 SL39%cc00 SL39 — Delivery Tax Allocation Lines
SL40 SL40%cc00 SL40 — Payment Methods
SL45 SL45%cc00 SL45 — Extended Bank Info
SL46 SL46%cc00 SL46 — Invoice Template Header
SL47 SL47%cc00 SL47 — Invoice Template Lines
SL48 SL48%cc00 SL48 — Invoice Template Field definitions
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
SLCM SLCM%cc00 SLCM — Approval Matrix
SLCS SLCS%cc00 SLCS — Credit Control Status Configuration
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
SLH1 SLH1%cc00 SLH1 — Invoice Header History
SLH2 SLH2%cc00 SLH2 — Invoice Issuer/Recipient History
SLH3 SLH30000 SLH3 — Recharge Invoice Accounts Receivable Header
SLH4 SLH40000 SLH4 — Recharge Invoice Accounts Receivable Transaction Lines
SLH5 SLH5%cc00 SLH5 — Invoice Lines History
SLH6 SLH6%cc00 SLH6 — Invoice Lines Details History
SLH7 SLH7%cc00 SLH7 — Invoice Texts Linked to Generic Invoices
SLH8 SLH8%cc00 SLH8 — Invoice Bank Info
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

Навигация / Navigation: