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 SLH3 SLH3001 OriginatingCompany STRING 2 2 0 Originating Company
2 SLH3 SLH3002 MainInvSupplCode STRING 10 10 0 Main Invoice Supplier Code
3 SLH3 SLH3003 MainInvNumber STRING 25 25 0 Main Invoice Number
4 SLH3 SLH3004 TargetEntity STRING 6 6 0 Target Company
SLH3 SLH3005 UpdatedFlag SWITCH 1 1 0 Updated
SLH3 SLH3006 CreatedFlag SWITCH 1 1 0 Created
SLH3 SLH3007 RechargeAmount MONEY 20 28 8 Recharge Amount
SLH3 SLH3008 RechargeServiceFee MONEY 20 28 8 Recharge Service Fee
SLH3 SLH3009 CustomerCode VSTRING 10 10 0 Customer Code
SLH3 SLH3010 InvoiceNo VSTRING 25 25 0 Invoice Number
SLH3 SLH3011 TransactNo VSTRING 9 9 0 Transaction Number
SLH3 SLH3012 InvoiceDate DATE 8 0 0 Invoice Date
SLH3 SLH3013 BookEntryDate DATE 8 0 0 Book-Entry Date
SLH3 SLH3014 DueDate DATE 8 0 0 Due Date
SLH3 SLH3015 DiscDate1 DATE 8 0 0 Discount Date 1
SLH3 SLH3016 Disc1 VSTRING 5 5 0 Discount 1 %
SLH3 SLH3017 DiscDate2 DATE 8 0 0 Discount Date 2
SLH3 SLH3018 Disc2 VSTRING 5 5 0 Discount 2 %
SLH3 SLH3019 DiscDate3 DATE 8 0 0 Discount Date 3
SLH3 SLH3020 Disc3 VSTRING 5 5 0 Discount 3 %
SLH3 SLH3021 InvAmoLocCur MONEY 20 28 8 Invoice Amount (Local Currency)
SLH3 SLH3022 InvAmoOriCur MONEY 20 28 8 Invoice Amount (Invoice Currency)
SLH3 SLH3023 CurrencyCode VSTRING 2 2 0 Currency Code Invoice
SLH3 SLH3024 SalesTaxAmo MONEY 20 28 8 Sales Tax Amount
SLH3 SLH3025 AccntString ACCSTR 120 120 0 Accounting String
SLH3 SLH3026 SalesTaxPerc VSTRING 10 10 0 Sales Tax Percentage
SLH3 SLH3027 VATPaidLCU MONEY 20 28 8 Paid VAT Amount (Local Currency)
SLH3 SLH3028 Spare VSTRING 2 2 0 (obsolete)
SLH3 SLH3029 InterestBlck VSTRING 1 1 0 Interest Blocked
SLH3 SLH3030 ReminderBlck VSTRING 1 1 0 Reminder Blocked
SLH3 SLH3031 ReminderSent VSTRING 2 2 0 Number of Reminders Sent
SLH3 SLH3032 CommentaryTx VSTRING 50 50 0 Commentary Text
SLH3 SLH3033 Spare VSTRING 1 1 0 Storno Invoice Indicates if the invoice was created by reversing a previously entered invoice, in this case the accounting transactions created for the invoice is booked with reversed sign (negative amounts are booked as debit and positive amounts are booked as credit).
0 - The invoice is a normally entered/created invoice.
1 - The invoice was created as a storno invoice (booked with reversed sings).
SLH3 SLH3034 Spare VSTRING 1 1 0 Point of Title Passage Only used for US (country code 1) in interface with external tax application.
SLH3 SLH3035 InvTypeFlag1 VSTRING 1 1 0 Invoice Type Used in combination with periodic billing statements:
0 - Regular invoice
1 - Credit note
2 - Re-invoice
3 - Discount
4 - Other Discount
SLH3 SLH3036 InvTypeFlag2 VSTRING 1 1 0 (obsolete)
SLH3 SLH3037 ExclFormBillingFlag VSTRING 1 1 0 Excluded from Billing
SLH3 SLH3038 InvoicePaidFlag VSTRING 1 1 0 Invoice Paid
SLH3 SLH3039 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3040 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3041 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3042 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3043 SourceForInv VSTRING 1 1 0 Source for Invoice
SLH3 SLH3044 OrderNumber VSTRING 12 12 0 Order Number
SLH3 SLH3045 UseField51 VSTRING 1 1 0 (obsolete)
SLH3 SLH3046 LatestIntDate DATE 8 0 0 Last Interest Date
SLH3 SLH3047 TotIntOriCur VSTRING 20 20 0 Total Interest Charged (Invoice Currency)
SLH3 SLH3048 TransactType VSTRING 1 1 0 Transaction Type
SLH3 SLH3049 Salesman VSTRING 3 3 0 Salesman
SLH3 SLH3050 CollectInvoice VSTRING 1 1 0 Collection Invoice
SLH3 SLH3051 OrigCompComp VSTRING 2 2 0 Original Company Code
SLH3 SLH3052 ClearNLAC VSTRING 12 12 0 Clearing Account
SLH3 SLH3053 CurrContract VSTRING 1 1 0 Currency Contract
SLH3 SLH3054 FixExchRate X_NUMERIC 10 18 8 Fixed Exchange Rate
SLH3 SLH3055 ContractNo VSTRING 15 15 0 Currency Contract Number
SLH3 SLH3056 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3057 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3058 Spare VSTRING 1 1 0 (obsolete)
SLH3 SLH3059 PaymentLedger VSTRING 1 1 0 (obsolete)
SLH3 SLH3060 SalesTaxCode VSTRING 2 2 0 VAT Code
SLH3 SLH3061 TotPaidAmLCU MONEY 20 28 8 Paid Amount (Local Currency)
SLH3 SLH3062 TotPaidAmORG MONEY 20 28 8 Paid Amount (Document Currency)
SLH3 SLH3063 LastPaymDate DATE 8 0 0 Last Payment Date
SLH3 SLH3064 InterLatePayment VSTRING 6 6 0 Interest Late Payment %
SLH3 SLH3065 WayOfPayment STRING 2 2 0 Way of Payment
SLH3 SLH3066 DTASentAmount MONEY 20 28 8 Sent Payment Amount (Local Currency)
SLH3 SLH3067 FixedExchgRate2 X_NUMERIC 10 18 8 Fixed Exchange Rate 2
SLH3 SLH3068 FixedExchgAlgtm STRING 3 3 0 Fixed Exchange Algorithm
SLH3 SLH3069 ExchgRate1ByAmo X_NUMERIC 10 18 8 Exchange Rate 1
SLH3 SLH3070 ExchgRate2ByAmo X_NUMERIC 10 18 8 Exchange Rate 2
SLH3 SLH3071 ExchgAlgtm STRING 3 3 0 Exchange Algorithm
SLH3 SLH3072 EDIContractSwitch SWITCH 1 1 0 EDI-Contract
SLH3 SLH3073 ReferenceNumber STRING 20 20 0 Reference Number
SLH3 SLH3074 RepCurrCode INTEGER 2 0 0 Currency Code Reporting
SLH3 SLH3075 SalesOrdAmount MONEY 20 28 8 Purchase Order Amount
SLH3 SLH3076 AmPaidPNLoc MONEY 20 28 8 Total Paid by PN/PDC (Local Currency)
SLH3 SLH3077 AmPaidPNOrig MONEY 20 28 8 Total Paid by PN/PDC (Document Currency)
SLH3 SLH3078 PaidPropNo VSTRING 6 6 0 Payment Proposal Number
SLH3 SLH3079 SalStatNo VSTRING 10 10 0 Periodic Billing - Statement Number
SLH3 SLH3080 RefToInvNo VSTRING 25 25 0 Periodic Billing - Reference
SLH3 SLH3081 RefToStatNo VSTRING 10 10 0 Reference to Statement Number
SLH3 SLH3082 UnrealizedPrLoss MONEY 20 28 8 Unrealized Profit/Loss (Local Currency)
SLH3 SLH3083 Spare MONEY 20 28 8 (obsolete)
SLH3 SLH3084 HistInvDate DATE 8 0 0 Historical Invoice Date
SLH3 SLH3085 HistDueDate DATE 8 0 0 Historical Due Date
SLH3 SLH3086 HistDiscDate1 DATE 8 0 0 Historical Discount Date 1
SLH3 SLH3087 HistDisc1 VSTRING 5 5 0 Historical Discount 1
SLH3 SLH3088 HistDiscDate2 DATE 8 0 0 Historical Discount Date 2
SLH3 SLH3089 HistDisc2 VSTRING 5 5 0 Historical Discount 2
SLH3 SLH3090 HistDiscDate3 DATE 8 0 0 Historical Discount Date 3
SLH3 SLH3091 HistDisc3 VSTRING 5 5 0 Historical Discount 3
SLH3 SLH3092 GlobalLocationCode VSTRING 15 15 0 Global Location Code
SLH3 SLH3093 SubObjectNo STRING 6 6 0 Sub-object Number
SLH3 SLH3094 OrigTransNum VSTRING 9 9 0 Original Transaction Number
SLH3 SLH3095 InvOrdCust VSTRING 10 10 0 Customer Code Order
SLH3 SLH3096 DocumentType STRING 3 3 0 Document Type
SLH3 SLH3097 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
SLH3 SLH3098 CFOPCode VSTRING 10 10 0 CFOP Code
SLH3 SLH3099 OperationType VSTRING 10 10 0 Operation Code
SLH3 SLH3100 FiscalTextCode VSTRING 10 10 0 Fiscal Text Code
SLH3 SLH3101 SerialCode VSTRING 10 10 0 Serial Invoice Prefix
SLH3 SLH3102 CityCode VSTRING 10 10 0 City Code
SLH3 SLH3103 Detail VSTRING 1 1 0 Detail
SLH3 SLH3104 CashMethod STRING 1 1 0 CashMethod
SLH3 SLH3105 WithholdTaxLocCur MONEY 20 28 8 WithholdTaxLocCur
SLH3 SLH3106 WithholdTaxOriCur MONEY 20 28 8 WithholdTaxOriCur
SLH3 SLH3107 BankNoteNo VSTRING 20 20 0 BankNoteNo
SLH3 SLH3108 NetInvAmntLCU MONEY 20 28 8 NetInvAmntLCU
SLH3 SLH3109 NetInvAmntOCU MONEY 20 28 8 NetInvAmntOCU
SLH3 SLH3110 Instalments SWITCH 1 1 0 Instalments
SLH3 SLH3111 SalesReturnReasonCode INTEGER 1 0 0 SalesReturnReasonCode
SLH3 SLH3112 TaxNoteNo VSTRING 25 25 0 TaxNoteNo
SLH3 SLH3113 FinOperationCode2 VSTRING 10 10 0 FinOperationCode2
SLH3 SLH3114 EDIStatus STRING 1 1 0 EDIStatus
SLH3 SLH3115 NumberOfPages INTEGER 3 0 0 NumberOfPages
SLH3 SLH3116 IssuerExtCode VSTRING 16 16 0 IssuerExtCode
SLH3 SLH3117 IssuerExpDate DATE 8 0 0 IssuerExpDate
SLH3 SLH3118 POSMachine STRING 1 1 0 POSMachine
SLH3 SLH3119 TaxNoteRegDate DATE 8 0 0 TaxNoteRegDate
SLH3 SLH3120 IssuerCode STRING 6 6 0 Issuer Code
SLH3 SLH3121 CommisionBase MONEY 20 28 8 Commision Base
SLH3 SLH3122 CommisionWithheldCost MONEY 20 28 8 Commision Withheld Cost
SLH3 SLH3123 CommissionDistrMethod STRING 1 1 0 Commision Distribution Method
SLH3 SLH3124 DueDateDefinition INTEGER 1 0 0 Due Date Definition
SLH3 SLH3125 PaymentTermCode STRING 2 2 0 Payment Term Code
SLH3 SLH3126 LockPaymentsInvoices INTEGER 1 0 0 LockPaymentsInvoices
SLH3 SLH3127 CorrectionNumber INTEGER 3 0 0 CorrectionNumber
SLH3 SLH3128 FiscalReference VSTRING 50 50 0 Fiscal Reference
SLH3 SLH3129 SpesometroForms VSTRING 12 12 0 Spesometro Forms
SLH3 SLH3130 ReminderDate DATE 8 0 0 Reminder Date
SLH3 SLH3131 PO3Subtype STRING 2 2 0 PO3 Sub type
SLH3 SLH3132 PaymentCode STRING 3 3 0 Payment Code
SLH3 SLH3133 TaxRegStatus STRING 1 1 0 TaxRegStatus
SLH3 SLH3134 PublicProcuremCode1 VSTRING 20 20 0 Public Procurement Code1
SLH3 SLH3135 PublicProcuremCode2 VSTRING 20 20 0 Public Procurement Code2