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 SL08 SL08001 IndexID VSTRING 1 1 0 Index ID
SL08 SL08002 InternIntRate X_NUMERIC 1 9 8 Internal Interest Rate %
SL08 SL08003 PaymTransNo X_NUMERIC 1 9 8 Payment Transaction Number
SL08 SL08004 TransacNoInv X_NUMERIC 1 9 8 Invoice Transaction Number
SL08 SL08005 TransNoPayJournal X_NUMERIC 1 9 8 Transaction Number Payment Journal
SL08 SL08006 TransNoInvJournal X_NUMERIC 1 9 8 Transaction Number Invoice Journal
SL08 SL08007 InterCalcModel X_NUMERIC 1 9 8 Interest Calculation Model
SL08 SL08008 InterestRate X_NUMERIC 7 15 8 Penalty Interest Rate
SL08 SL08009 MinInterAmnt X_NUMERIC 7 15 8 Minimum Interest Amount (Local Currency)
SL08 SL08010 InvCntrInterest X_NUMERIC 6 14 8 Interest Invoice Number
SL08 SL08011 IntInvCopies X_NUMERIC 2 10 8 Number of Interest Invoice Copies
SL08 SL08012 PaymentTerm X_NUMERIC 2 10 8 Payment Term for Interest Invoices
SL08 SL08013 InvFeeInterest X_NUMERIC 7 15 8 Invoicing Fee for Interest Invoices
SL08 SL08014 RemindHoldDay X_NUMERIC 2 10 8 Reminder Hold Days
SL08 SL08015 ReminderPers X_NUMERIC 2 10 8 Period Between Reminders
SL08 SL08016 ReminderCopies X_NUMERIC 2 10 8 Number of Reminder Copies
SL08 SL08017 StatementPeriod X_NUMERIC 2 10 8 Statement Period
SL08 SL08018 RemAmntQuest X_NUMERIC 7 15 8 Allowed Difference for Question
SL08 SL08019 RemAmntAutomat X_NUMERIC 7 15 8 Allowed Difference for Automatic Accept
SL08 SL08020 AverageMargin X_NUMERIC 6 14 8 Average Margin %
SL08 SL08021 DeductGracePeriod SWITCH 1 1 0 Deduct Grace Period from Interest Calculation
SL08 SL08022 VATRate2 X_NUMERIC 1 9 8 VAT Rate 2
SL08 SL08023 VATRate3 X_NUMERIC 1 9 8 VAT Rate 3
SL08 SL08024 VATRate4 X_NUMERIC 1 9 8 VAT Rate 4
SL08 SL08025 VATRate5 X_NUMERIC 1 9 8 VAT Rate 5
SL08 SL08026 VATRate6 X_NUMERIC 1 9 8 VAT Rate 6
SL08 SL08027 VATRate7 X_NUMERIC 1 9 8 VAT Rate 7
SL08 SL08028 VATRate8 X_NUMERIC 1 9 8 VAT Rate 8
SL08 SL08029 VATRate9 X_NUMERIC 1 9 8 VAT Rate 9
SL08 SL08030 RateDate1 DATE 8 0 0 Rate Date 1
SL08 SL08031 InteresRate1 X_NUMERIC 6 14 8 Interest Rate 1
SL08 SL08032 RateDate2 DATE 8 0 0 Rate Date 2
SL08 SL08033 InteresRate2 X_NUMERIC 6 14 8 Interest Rate 2
SL08 SL08034 RateDate3 DATE 8 0 0 Rate Date 3
SL08 SL08035 InteresRate3 X_NUMERIC 6 14 8 Interest Rate 3
SL08 SL08036 CntrPremCust X_NUMERIC 1 9 8 Counter for Customer Codes (Permanent Customers)
SL08 SL08037 CntrTempCust X_NUMERIC 1 9 8 Counter for Customer Codes (Temporary Customers)
SL08 SL08038 InterestChrg X_NUMERIC 3 11 8 Interest Charged per Period in Days
SL08 SL08039 ReminderChrg X_NUMERIC 7 15 8 Reminder Fee (Local Currency)
SL08 SL08040 AccessLevel X_NUMERIC 1 9 8 Access Level to enter/adjust Customer File
SL08 SL08041 AccntYear X_NUMERIC 2 10 8 Financial Year Common Sales Ledger
SL08 SL08042 MergerInvoices X_NUMERIC 6 14 8 Number for Consolidated invoices
SL08 SL08043 SalesTaxCode X_NUMERIC 2 10 8 Sales Tax Code On-Account Payment
SL08 SL08044 InfFldCusQuery X_NUMERIC 3 11 8 Information Field on Customer Query
SL08 SL08045 NoReminders X_NUMERIC 1 9 8 Number of Reminder Copies
SL08 SL08046 GracePeriod X_NUMERIC 3 11 8 Interest Grace Period
SL08 SL08047 CashMethod INTEGER 1 0 0 Use Cash Method for Tax Accounting
SL08 SL08048 UpdateVolume INTEGER 1 0 0 Update Statistics on Direct Entry
SL08 SL08049 BasedInvDate INTEGER 1 0 0 Statement Based on Invoice Date
SL08 SL08050 CreditInterest INTEGER 1 0 0 Credit Interest on Early Payments
SL08 SL08051 PrintDueInterest INTEGER 1 0 0 Show Interest Due on Reminders
SL08 SL08052 UpdGLPaymJrn INTEGER 1 0 0 Update GL with Payment Journal Totals
SL08 SL08053 UpdGLInvJrn INTEGER 1 0 0 Update GL with Invoice Journal Totals
SL08 SL08054 IntegratedGL INTEGER 1 0 0 Integrated with General Ledger
SL08 SL08055 AutoVouchNo INTEGER 1 0 0 Automatic Transaction Numbers
SL08 SL08056 UseGLVouCntr INTEGER 1 0 0 Use General Ledger Transaction Number
SL08 SL08057 InclCreditNotes INTEGER 1 0 0 Credit Note Included in Due Amounts
SL08 SL08058 InclPaidInv INTEGER 1 0 0 Include Paid Invoices in Statement
SL08 SL08059 CustCodInvNo INTEGER 1 0 0 Customer Code + Invoice No as Transaction Text
SL08 SL08060 CentralLedger INTEGER 1 0 0 Common Sales Ledger
SL08 SL08061 OrdAmntCredCheck INTEGER 1 0 0 Include Ordered not Shipped Amount in Credit Check
SL08 SL08062 SaveVatTrans INTEGER 1 0 0 Save Tax Transactions
SL08 SL08063 ExtPaymInfo INTEGER 1 0 0 Extended Payment Info
SL08 SL08064 ConnentedAVP INTEGER 1 0 0 Connected to AVP
SL08 SL08065 TaxJurisdCode INTEGER 1 0 0 Coding on Auto Payment Collection
SL08 SL08066 cussw20 INTEGER 1 0 0 Tax Jurisdiction Code
SL08 SL08067 PrepaymentTax INTEGER 1 0 0 Prepayment Tax
SL08 SL08068 TaxPoint INTEGER 1 0 0 Point for Cash Method of Tax Accounting
SL08 SL08069 cussw23 INTEGER 1 0 0 23
SL08 SL08070 cussw24 INTEGER 1 0 0 24
SL08 SL08071 cusjou0 VSTRING 6 6 0 Invoices Journal Code
SL08 SL08072 cusjou1 VSTRING 6 6 0 Credit Notes Journal Code
SL08 SL08073 cusjou2 VSTRING 6 6 0 Internal Invoices Journal Code
SL08 SL08074 cusjou3 VSTRING 6 6 0 Periodical Transactions Journal Code
SL08 SL08075 cusjou4 VSTRING 6 6 0 Payments Journal Code
SL08 SL08076 DaysPerYear INTEGER 3 0 0 Days per Year (Interest Calculation)
SL08 SL08077 RoundOffTolerance MONEY 20 28 8 Rounding Tolerance Amount
SL08 SL08078 RoundOffProfitAcc VSTRING 12 12 0 Rounding Tolerance Profit Account
SL08 SL08079 RoundOffLossAcc VSTRING 12 12 0 Rounding Tolerance Loss Account
SL08 SL08080 PaymPropCounter VSTRING 6 6 0 (obsolete)
SL08 SL08081 SalesStatSerNo X_NUMERIC 10 18 8 Billing Statement Number
SL08 SL08082 TAXVarianceSerNo X_NUMERIC 10 18 8 Tax Correctional Invoice Number
SL08 SL08083 BillingProposCounter X_NUMERIC 6 14 8 Billing Statement Number
SL08 SL08084 TaxCodeInvFee STRING 6 6 0 Tax Code for Invoicing Fee
SL08 SL08085 DefaultTaxCodeInsurance STRING 6 6 0 Default Tax Code for Insurance
SL08 SL08086 DefaultTaxCodePacking STRING 6 6 0 Default Tax Code for Packing
SL08 SL08087 TaxCodeInterest STRING 6 6 0 Default Tax Code for Interest
SL08 SL08088 SalesTransactionType INTEGER 4 0 0 Sales Transaction Type
SL08 SL08089 AccDiscCust STRING 12 12 0 Account Discount Customer
SL08 SL08090 AccDiscChann STRING 12 12 0 Account Discount Chanel
SL08 SL08091 AccDiscGroup1 STRING 12 12 0 Account Discount Customer/Product Group 1
SL08 SL08092 AccDiscGroup2 STRING 12 12 0 Account Discount Customer/Product Group 2
SL08 SL08093 AccDiscPromot STRING 12 12 0 Account Discount Temporary (Promotional)
SL08 SL08094 AccDiscLogist STRING 12 12 0 Account Discount Logistics
SL08 SL08095 DefTaxCodeDist STRING 6 6 0 Default Tax Code Distribution
SL08 SL08096 DefTaxCodeAllow STRING 6 6 0 Default Tax Code Allowance
SL08 SL08097 DefTaxCodeSurch STRING 6 6 0 Default Tax Code Surcharge
SL08 SL08098 AccGainsLosses INTEGER 1 0 0 Accounting of Currency Exchange Gains/Losses 0 = Only recognise gains/losses when invoices are fully settled, using current value
1 = Only recognise gains/losses when invoices are fully settled, using original value
2 = Recognise gains/losses on partial payment as unrealized.
3 = Recognise gains/losses on partial payment as realized.
SL08 SL08099 PrpTaxAllocRule INTEGER 1 0 0 Prepayment Tax Allocation Rule
SL08 SL08100 DedRulePartInv INTEGER 1 0 0 Deduction Rule
SL08 SL08101 DedRuleFinalInv INTEGER 1 0 0 Deduction Rule - Partial Invoice
SL08 SL08102 TaxInfoInTransText INTEGER 1 0 0 Print Tax Code and Base Amount as text
SL08 SL08103 SalesTransType INTEGER 1 0 0 Type of Sales Transaction
SL08 SL08104 DefaultTaxCode STRING 6 6 0 Default Tax Code
SL08 SL08105 TaxNoteNo VSTRING 15 15 0 Tax Note Number Counter
SL08 SL08106 TaxNoteNoFlag INTEGER 1 0 0 Tax Note Number Flag
SL08 SL08107 MinAmntForFOCitems MONEY 20 28 8 Minimum Amount for FOC Items Minimum amount for FOC items
SL08 SL08108 TaxIntrFlag INTEGER 1 0 0 Tax on Interest Flag
SL08 SL08109 LiabilityCodeIntr VSTRING 6 6 0 Tax Liability Code for Interest
SL08 SL08110 LicenseFlag SWITCH 1 1 0 Default Customer License Flag
SL08 SL08111 LicensedFrom DATE 8 0 0 Customer Licensed from
SL08 SL08112 LicensedTo DATE 8 0 0 Customer Licensed to
SL08 SL08113 TaxNoteDailyCounterFlag INTEGER 1 0 0 Use Daily Based Counter for Tax Notes Use Daily based counter for Tax Notes
SL08 SL08114 AdvInvoiceAmntApportionRule INTEGER 1 0 0 Advance Invoice Amount Apportion Rule
SL08 SL08115 BalanceInCredCheck SWITCH 1 1 0 Use Customer Balance in Credit Check
SL08 SL08116 OrdTaxInCredCheck SWITCH 1 1 0 Use Order Tax in Credit Check
SL08 SL08117 AddCostInCredCheck SWITCH 1 1 0 Use Additional Costs in Credit Check
SL08 SL08118 AddCostTaxInCrCheck SWITCH 1 1 0 Use Taxes on Additional Costs on Order in Credit Check
SL08 SL08119 AllcInCrCheck SWITCH 1 1 0 Use Allocated Amount in Credit Check
SL08 SL08120 AllcTaxInCrCheck SWITCH 1 1 0 Use Taxes on Allocated Amount in Credit Check
SL08 SL08121 DelivInCrCheck SWITCH 1 1 0 Use Shipped Amount in Credit Check
SL08 SL08122 DlvTaxInCrCheck SWITCH 1 1 0 Use Taxes on Shipped Amount in Credit Check
SL08 SL08123 AddShipCostInCredCheck SWITCH 1 1 0 Use Additional Costs on Order (Shipped) in Credit Check
SL08 SL08124 AddShipCostTaxInCrCheck SWITCH 1 1 0 Use Taxes On Additional Costs on Order (Shipped) in Credit Check
SL08 SL08125 FreightTaxMode STRING 1 1 0 Tax Mode for Freight
SL08 SL08126 MaxAcceptableCRCStatus INTEGER 2 0 0 Maximum Acceptable Credit Control Status
SL08 SL08127 MultiLevelCRC SWITCH 1 1 0 Multi-Level Credit Control Approval
SL08 SL08128 AuthApprGroup VSTRING 8 8 0 Credit Control Approval Group
SL08 SL08129 CrLimitBoundary INTEGER 1 0 0 Credit Limit Boundary
SL08 SL08130 OverdueBoundary INTEGER 1 0 0 Overdue Boundary
SL08 SL08131 MultiLevelCRCLine SWITCH 1 1 0 Multi-level Approval on Line Level
SL08 SL08132 CancelToleranceAmnt X_NUMERIC 20 28 8 Tolerance for Cancel of Approval, Amount
SL08 SL08133 CancelTolerancePrc X_NUMERIC 6 14 8 Tolerance for Cancel of Approval, Percent
SL08 SL08134 FixedApprGroup VSTRING 8 8 0 Fixed Level Credit Control Approval Group
SL08 SL08135 CurrExchRateDate STRING 1 1 0 Currency Exchange Rate Date
SL08 SL08136 DefaultCustomerLifeCycleStatus INTEGER 1 0 0 Default Customer Life Cycle Status
SL08 SL08137 LateAssignmentOfTransactionNumber SWITCH 1 1 0 Late Assignment Of Transaction Number
SL08 SL08138 DefaultInvoiceSplit INTEGER 1 0 0 Default Invoice Split
SL08 SL08139 ExportCodeGCCVAT INTEGER 1 0 0 Export code GCC VAT implementing states