Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
sca_trg_Audit_SL01 Audit trigger for SL01 table Company sca_trg_Audit_SL010100
sca_trg_Audit_SL03 Audit trigger for SL03 table Company sca_trg_Audit_SL030100
sca_trg_Audit_SL08 Audit trigger for SL08 table Company Year sca_trg_Audit_SL080112
sca_trg_Audit_SL14 Audit trigger for SL14 table Company sca_trg_Audit_SL140100
sca_trg_Audit_SL45 Audit trigger for SL45 table Company sca_trg_Audit_SL450100
sca_trg_Audit_SLM0 Audit trigger for SLM0 table Company sca_trg_Audit_SLM00100
SL01 Customer File Company SL010100
SL03 Sales Ledger Invoices Company SL030100
SL04 Sales Ledger Invoice Journal Company Year SL040112
SL05 Sales Ledger Payment Journal Company Year SL050112
SL07 Interest Charged Company SL070100
SL08 Sales Ledger Parameters Company Year SL080112
SL09 Automatic Accounting SL Company Year SL090112
SL10 Payment Ledger (not used) Company SL100100
SL11 Payment Ledger Proposal Company SL110100
SL12 Customer Payment Proposal Header Company SL120100
SL14 Customer Delivery Addresses Company SL140100
SL15 Customer Commissions Company SL150100
SL16 Due Commissions Company SL160100
SL17 VAT Transactions Company SL170100
SL18 Invoice Consolidation Company SL180100
SL19 Customer Templates Company SL190100
SL21 Sales Ledger Payments Company SL210100
SL22 Payment Terms SL Company SL220100
SL23 Payment Terms Descriptions Company SL230100
SL24 Sales Statement Tax Variance File Company SL240100
SL25 Sales Statement Proposal Lines Company SL250100
SL26 Sales Statement Proposal References Table Company SL260100
SL27 Sales Statement Company SL270100
SL28 Billing Proposal Company SL280100
SL29 Invoice Consolidation History Company SL290100
SL30 Company SL300100
SL31 Company SL310100
SL32 Company SL320100
SL33 Company SL330100
SL34 Company SL340100
SL35 Company SL350100
SL36 Link Prepayment/Advance Invoices to SO Company SL360100
SL39 Delivery Tax Allocation Lines Company SL390100
SL40 Payment Methods Company SL400100
SL45 Extended Bank Info Company SL450100
SL46 Invoice Template Header Company SL460100
SL47 Invoice Template Lines Company SL470100
SL48 Invoice Template Field definitions Company SL480100
SL97 Work File for Ledger Statement SL970000
SL98 Work File for EC Tax Reports SL980000
SLA1 SL account exceptions for revaluation procedure Company SLA10100
SLB1 Company SLB10100
SLB4 Tax Note Description Company SLB40100
SLB5 Company SLB50100
SLC1 Credit Check permission levels Company SLC10100
SLCM Company SLCM0100
SLCS Credit Control Status Configuration Company SLCS0100
SLD1 Payment Ledger Proposal History Company SLD10100
SLD2 Customer Payment Proposal Header History Company SLD20100
SLD3 Payment Proposal Header 2 History Company SLD30100
SLDD Payment Proposal Header 2 Company SLDD0100
SLDS Company SLDS0100
SLE0 Drafts Company SLE00100
SLE1 Remittance Header Company SLE10100
SLE2 Remittance Details Company SLE20100
SLE3 Bank/Agent Company SLE30100
SLE4 Draft Transactions Company SLE40100
SLE5 Sales Ledger Payment Provisional Company Year SLE50112
SLE7 Extended Payment Company SLE70100
SLE8 Advanced Sales Ledger Parameters Company Year SLE80112
SLE9 Advanced Automatic Accounting Codes Company Year SLE90112
SLER Remittance Work File Company SLER0100
SLF1 Exposed Customer Company SLF10100
SLH1 Invoice Header History Company SLH10100
SLH2 Invoice Issuer/Recipient History Company SLH20100
SLH3 Recharge Invoice Accounts Receivable Header SLH30000
SLH4 Recharge Invoice Accounts Receivable Transaction Lines SLH40000
SLH5 Company SLH50100
SLH6 Invoice Lines Details History Company SLH60100
SLH7 Invoice Texts Linked to Generic Invoices Company SLH70100
SLH8 Invoice Bank Info Company SLH80100
SLI1 Payment Term Instalments SL Header Company SLI10100
SLI2 Payment Term Instalments SL Lines Company SLI20100
SLI3 Payment Term Instalments SL Company SLI30100
SLI9 RIBA Payment proposals Company SLI90100
SLIN Invoice Based Intrastat SL Company SLIN0100
SLL1 Customer Tax Exemptions Company SLL10100
SLL2 Customer Payment Balances Company SLL20100
SLM0 Company SLM00100
SLMH Company SLMH0100
SLR4 SL Reversed Transaction Company Year SLR40112
SLT7 Company SLT70100
SLUL Advanced credit control utilized amounts Company SLUL0100
SLXX Customer Statement work file SLXX0000
SLXY Customer ABC and Frequency Analysis work file SLXY0000
SLXZ Customer Statement by Date work file SLXZ0000
SYSM Report 347 format parameters Company SYSM0100

Fields
PK Table Name Description Type Length Precision Note
1 SL17 SL17001 InvoiceNo VSTRING 25 25 0 Invoice Number
2 SL17 SL17002 CustomerCode VSTRING 10 10 0 Customer Code
3 SL17 SL17003 TransactType VSTRING 1 1 0 Transaction Type X - Tax transaction created at the time of invoice (To be used for non cash tax method).
Y - Tax transaction created at the time of payment. (To be used for cash tax method).
Z - Tax transaction for tax portion of discount for early payments.
(Note that both X and Y transaction type are created regardless if you use cash method or not).
6 SL17 SL17004 VATCode VSTRING 2 2 0 VAT Code
7 SL17 SL17005 TransactDate DATE 8 0 0 Transaction Date
SL17 SL17006 InvoiceDate DATE 8 0 0 Invoice Date
SL17 SL17007 BaseAmount MONEY 20 28 8 Base Amount (Local Currency)
SL17 SL17008 TaxAmount MONEY 20 28 8 Tax Amount (Local Currency)
SL17 SL17009 Remark VSTRING 4 4 0 Remark
8 SL17 SL17010 TransactioNo VSTRING 9 9 0 Transaction Number
SL17 SL17011 CashMethod VSTRING 1 1 0 Cash Method
SL17 SL17012 OrderLineId VSTRING 60 60 0 Order Line plus Subline or CostId Also is used to store invoice line ID
SL17 SL17013 InvoiceDateOld DATE 8 0 0 Invoice Date Old (Italian Cash Method)
SL17 SL17014 IntVersOfFile VSTRING 1 1 0 Internal Table Version Used internally in earlier versions of Scala to specify the version of the table.
SL17 SL17015 ExpandedMacro VSTRING 1 1 0 Expanded Macro Indicates if the transaction has expanded as a result of a VAT macro. This will be done when printing the VAT statement.
SL17 SL17016 Reported VSTRING 1 1 0 Reported
SL17 SL17017 TransNature VSTRING 1 1 0 Transaction Nature 0 - Goods
1 - Service
SL17 SL17018 SalesTaxPercent VSTRING 8 8 0 Tax Percent
4 SL17 SL17019 TaxCode STRING 6 6 0 Tax Code
5 SL17 SL17020 TaxType STRING 6 6 0 Tax Type
9 SL17 SL17021 TransactLineNo STRING 7 7 0 Line Number
SL17 SL17022 TaxLiability STRING 6 6 0 Tax Liability Code
SL17 SL17023 TaxClassifCode STRING 2 2 0 Tax Classification Code
SL17 SL17024 TaxCertificate STRING 15 15 0 Tax Certificate
SL17 SL17025 PaymentNumber STRING 2 2 0 Payment Number
SL17 SL17026 StockItem VSTRING 35 35 0 Stock Item Code
SL17 SL17027 OrigBatchNumber VSTRING 12 12 0 Batch Number
SL17 SL17028 TaxCalculMethod INTEGER 2 0 0 Tax Calculation Method Used for tax engine 1 and 2 (see SYL1003 for details)
SL17 SL17029 RateType STRING 1 1 0 Rate Type Used for tax engine 1 and 2 (see SYL1006 for details)
SL17 SL17030 TaxBase INTEGER 2 0 0 Tax Base Type Used for tax engine 1 and 2 (see SYL1004 for details)
SL17 SL17031 TaxExemption STRING 2 2 0 Tax Exemption Type Used for tax engine 1 and 2 (see SLL1006 for details)
SL17 SL17032 TaxExemptionRate X_NUMERIC 12 20 8 Tax Exemption Rate
SL17 SL17033 TaxRate X_NUMERIC 8 16 8 Tax Rate
SL17 SL17034 TributarySitCode VSTRING 10 10 0 Tributary Situation Code
SL17 SL17035 CVFCode VSTRING 10 10 0 CVF Code
SL17 SL17036 SalesOrderNo VSTRING 10 10 0 Sales Order Number
SL17 SL17037 FiscTextCode VSTRING 10 10 0 Fiscal Text Code
SL17 SL17038 STBase MONEY 20 28 8 Exemption Amount (Local Currency)
SL17 SL17039 STAmount MONEY 20 28 8 Tributary Substitution Amount (Local Currency)
SL17 SL17040 TaxCategory VSTRING 10 10 0 Tax Category Only used in brazil and Argentina, to classify the type of tax.
SL17 SL17041 OriginalCompany VSTRING 2 2 0 Original Company
SL17 SL17042 MarginPercent X_NUMERIC 12 20 8 Margin %
SL17 SL17043 FixedPrice MONEY 20 28 8 Fixed Price (Local Currency)
SL17 SL17044 AcceptedDifference X_NUMERIC 12 20 8 Accepted Difference %
SL17 SL17045 ResolutionName VSTRING 40 40 0 Resolution Name
SL17 SL17046 ResolutionDate DATE 8 0 0 Resolution Date
SL17 SL17047 InvoiceRefer VSTRING 25 25 0 InvoiceRefer This field can be filled in the records related to the Prepayments.
The reference to Invoice for the same customer code must be added for all “compensative” prepayment tax records.
SL17 SL17048 OrigCurrCode VSTRING 2 2 0 Original Currency Code This field should contain the invoice currency code.
SL17 SL17049 BaseAmountOCU MONEY 20 28 8 Base Amount (Original Currency) This field should contain the base amount in original currency.
SL17 SL17050 VATType VSTRING 6 6 0 VAT Type This field should contain the VAT type.
SL17 SL17051 AccountingInfo ACCSTR 120 120 0 Accounting Info
SL17 SL17052 LineRefSL04 VSTRING 7 7 0 Line Ref SL04
SL17 SL17053 FinYear VSTRING 4 4 0 Financial Year
SL17 SL17054 RefGL06 VSTRING 9 9 0 Ref GL06
SL17 SL17055 DirectfromGL VSTRING 1 1 0 Direct from GL
SL17 SL17056 SurchTaxCode VSTRING 6 6 0 Surcharge Tax Code This field should contain the surcharge tax code linked to usual VAT
SL17 SL17057 AASCode VSTRING 25 25 0 AAS code
SL17 SL17058 OrderLineNo STRING 12 12 0 Order Line Number Order Line Number
SL17 SL17059 ReferPLInvoice VSTRING 25 25 0 Reference to PL Invoice
SL17 SL17060 ReferPLSupplier VSTRING 10 10 0 ReferPLSupplier ReferPLSupplier for Italian VAT self-invoices
SL17 SL17061 ActualTaxBase MONEY 20 28 8 Actual Tax Base
SL17 SL17062 FreightTaxAmount MONEY 20 28 8 Freight Tax Amount
SL17 SL17063 DestinationRate X_NUMERIC 8 16 8 Destination Rate
SL17 SL17064 TaxDescription VSTRING 30 30 0 Tax Description
SL17 SL17065 InvoiceLineNo VSTRING 6 6 0 Invoice Line No
SL17 SL17066 TaxAmountOCU MONEY 20 28 8 Tax Amount OCU
SL17 SL17067 HMRCPeriodKey VSTRING 4 4 0 HMRC Period Key Key of HMRC period to which this transaction line is included.
SL17 SL17068 TaxRegCountry STRING 3 3 0 Tax Registration Country
SL17 SL17069 Specification STRING 3 3 0 Specification
SL17 SL17070 Notification STRING 3 3 0 Notification