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 SL03 SL03001 CustomerCode VSTRING 10 10 0 Customer Code
2 SL03 SL03002 InvoiceNo VSTRING 25 25 0 Invoice Number
SL03 SL03003 TransactNo VSTRING 9 9 0 Transaction Number
SL03 SL03004 InvoiceDate DATE 8 0 0 Invoice Date
SL03 SL03005 BookEntryDate DATE 8 0 0 Book-Entry Date
SL03 SL03006 DueDate DATE 8 0 0 Due Date
SL03 SL03007 DiscntDate1 DATE 8 0 0 Discount Date 1
SL03 SL03008 Discount1 VSTRING 5 5 0 Discount 1 %
SL03 SL03009 DiscntDate2 DATE 8 0 0 Discount Date 2
SL03 SL03010 Discount VSTRING 5 5 0 Discount 2 %
SL03 SL03011 DiscntDate3 DATE 8 0 0 Discount Date 3
SL03 SL03012 Discount3 VSTRING 5 5 0 Discount 3 %
SL03 SL03013 InvAmoLocCur MONEY 20 28 8 Invoice Amount (Local Currency)
SL03 SL03014 InvAmoOriCur MONEY 20 28 8 Invoice Amount (Invoice Currency)
SL03 SL03015 CurrencyCode VSTRING 2 2 0 Currency Code Invoice
SL03 SL03016 SalesTaxAmo MONEY 20 28 8 Sales Tax Amount (Local Currency)
SL03 SL03017 AccntString ACCSTR 120 120 0 Accounting String
SL03 SL03018 SalesTaxPercent VSTRING 10 10 0 Sales Tax Percentage Only used for US (country code 1)
SL03 SL03019 VATPaidLCU MONEY 20 28 8 VAT payed LCU
SL03 SL03020 Spare VSTRING 2 2 0 Spare
SL03 SL03021 InterestBlck VSTRING 1 1 0 Interest Blocked
SL03 SL03022 ReminderBlck VSTRING 1 1 0 Reminder Blocked
SL03 SL03023 ReminderSent VSTRING 2 2 0 Number of Reminders Sent
SL03 SL03024 CommentaryTx VSTRING 50 50 0 Text
SL03 SL03025 StornoInvoice 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).
SL03 SL03026 USTaxType VSTRING 1 1 0 Tax type Only used for US (country code 1) in interface with external tax application.
SL03 SL03027 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
SL03 SL03028 InvTypeFlag2 VSTRING 1 1 0 Invoice type, part 2
SL03 SL03029 ExclFormBillingFlag VSTRING 1 1 0 Included into Billing
SL03 SL03030 InvoicePaidFlag VSTRING 1 1 0 Invoice paid
SL03 SL03031 InvTypeFlag3 VSTRING 1 1 0 Invoice type, part 3
SL03 SL03032 Spare VSTRING 1 1 0 Spare
SL03 SL03033 TaxDiscFlag VSTRING 1 1 0 Tax discount flag
SL03 SL03034 Spare VSTRING 1 1 0 Spare
SL03 SL03035 SourceForInv VSTRING 1 1 0 Source for invoice Invoice created by:
1 - Sales order
2 - On-account invoice for service order
4 - Project
5 - Service order
6 - Contract invoice
8 - Merge invoice in sales ledger
SL03 SL03036 OrderNumber VSTRING 12 12 0 Object number Order number is assigned depending on the source of the invoice, it might be a sales order number, service order number, project number or contract number.
SL03 SL03037 UseField51 VSTRING 1 1 0 [USE FIELD 51]
SL03 SL03038 LatestIntDate DATE 8 0 0 Last interest date
SL03 SL03039 TotIntOriCur VSTRING 20 20 0 Interest charge
SL03 SL03040 TransactType VSTRING 1 1 0 Transaction type 0 - Normal invoice
1 - Interest invoice
9 - Temporary value assigned during entry of invoices, indicates that entry of invoice has not been completed.
SL03 SL03041 Salesman VSTRING 3 3 0 Salesman
SL03 SL03042 CollectInvoice VSTRING 1 1 0 Collection Invoice Indicates if the invoice has been sent for collection or not.
0 - Invoice has not been sent for collection.
1 - Invoice is in collection status.
SL03 SL03043 OrigCompComp VSTRING 2 2 0 Original company code Used for central sales ledger to specify the company where the invoice was created.
SL03 SL03044 ClearNLAC VSTRING 12 12 0 Clearing Nominal ledger account Used for central sales ledger to specify the clearing account that was used as debt to the subsidiary company.
SL03 SL03045 CurrContract VSTRING 1 1 0 Forward cover
SL03 SL03046 FixExchRate X_NUMERIC 10 18 8 Fixed Exchange Rate
SL03 SL03047 ContractNo VSTRING 15 15 0 Currency Contract Number
SL03 SL03048 Spare VSTRING 1 1 0 Spare
SL03 SL03049 Insoluto VSTRING 1 1 0 Insoluto Flag Insoluto (Bill in Suspense)
SL03 SL03050 Spare VSTRING 1 1 0 Spare
SL03 SL03051 PaymentLedger VSTRING 1 1 0 Automatic Payment
SL03 SL03052 SalesTaxCode VSTRING 2 2 0 Tax Code
SL03 SL03053 TotPaydAmLCU MONEY 20 28 8 Paid Amount (Local Currency)
SL03 SL03054 TotPaydAmORG MONEY 20 28 8 Paid Amount (Invoice Currency)
SL03 SL03055 LastPaymDate DATE 8 0 0 Last Payment Date
SL03 SL03056 InterLatePayment VSTRING 6 6 0 Interest %
SL03 SL03057 WayOfPayment STRING 2 2 0 Way of Payment
SL03 SL03058 DTASentAmount MONEY 20 28 8 DTA sent amount
SL03 SL03059 FixedExchgRate2 X_NUMERIC 10 18 8 Fixed exchange rate 2
SL03 SL03060 FixedExchgAlgtm STRING 3 3 0 Fixed exchange rate algorithm
SL03 SL03061 ExchgRate1ByAmo X_NUMERIC 10 18 8 Exchange Rate
SL03 SL03062 ExchgRate2ByAmo X_NUMERIC 10 18 8 Exchange rate 2
SL03 SL03063 ExchgAlgtm STRING 3 3 0 Exchange rate algorithm
SL03 SL03064 EDIContractSwitch SWITCH 1 1 0 EDI Contract switch
SL03 SL03065 ReferenceNumber VSTRING 25 25 0 Reference Number
SL03 SL03066 RepCurrCode INTEGER 2 0 0 Reporting currency code
SL03 SL03067 SalesOrdAmount MONEY 20 28 8 Purchase order amount
SL03 SL03068 AmPaidPNLoc MONEY 20 28 8 Total paid by PN/PDC LCU
SL03 SL03069 AmPaidPNOrig MONEY 20 28 8 Total paid by PN/PDC ICU
SL03 SL03070 PaymPropNo VSTRING 6 6 0 Payment proposal number
SL03 SL03071 SalStatNo VSTRING 10 10 0 Statement number
SL03 SL03072 RefToInvNo VSTRING 25 25 0 Periodic Billing - Reference
SL03 SL03073 RefToStatNo VSTRING 10 10 0 Reference to statement number
SL03 SL03074 UnrealizedPrLoss MONEY 20 28 8 Unrealized Profit/Loss
SL03 SL03075 Spare MONEY 20 28 8 Spare
SL03 SL03076 HistInvDate DATE 8 0 0 Historical Invoice Date(Billing)
SL03 SL03077 HistDueDate DATE 8 0 0 Historical Due Date(Billing)
SL03 SL03078 HistDiscDate1 DATE 8 0 0 Historical Discount Date 1(Billing)
SL03 SL03079 HistDisc1 VSTRING 5 5 0 Historical Discount 1 [%](Billing)
SL03 SL03080 HistDiscDate2 DATE 8 0 0 Historical Discount Date 2(Billing)
SL03 SL03081 HistDisc2 VSTRING 5 5 0 Historical Discount 2 [%](Billing)
SL03 SL03082 HistDiscDate3 DATE 8 0 0 Historical Discount Date 3(Billing)
SL03 SL03083 HistDisc3 VSTRING 5 5 0 Historical Discount 3 [%](Billing)
SL03 SL03084 GlobalLocationCode VSTRING 15 15 0 Global Location Code
SL03 SL03085 SubObjectNo STRING 6 6 0 Sub-Project Number
SL03 SL03086 OrigTransNum VSTRING 9 9 0 Original Transaction Number
SL03 SL03087 InvOrdCust VSTRING 10 10 0 Order Customer Code
SL03 SL03088 DocumentType STRING 3 3 0 Document Type
SL03 SL03089 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
SL03 SL03090 CFOPCode VSTRING 10 10 0 CFOP Code
SL03 SL03091 OperationType VSTRING 10 10 0 Operation Type
SL03 SL03092 FiscalTextCode VSTRING 10 10 0 CFOP Fiscal Text Code
SL03 SL03093 SerialCode VSTRING 10 10 0 Serial Code
SL03 SL03094 CityCode VSTRING 10 10 0 City
SL03 SL03095 Detail VSTRING 1 1 0 Detail
SL03 SL03096 CashMethod VSTRING 1 1 0 Cash Method
SL03 SL03097 WithholdTaxLocCur MONEY 20 28 8 With-holding Tax Amount LCU
SL03 SL03098 WithholdTaxOriCur MONEY 20 28 8 With-holding Tax Amount ICU
SL03 SL03099 BankNoteNo VSTRING 20 20 0 Bank note number
SL03 SL03100 NetInvAmntLCU MONEY 20 28 8 Net Invoice Amount in Local Currency
SL03 SL03101 NetInvAmntOCU MONEY 20 28 8 Net Invoice Amount in Invoice Currency
SL03 SL03102 Instalments SWITCH 1 1 0 Instalments
SL03 SL03103 SalesReturnReasonCode INTEGER 1 0 0 Sales Return Reason Code
SL03 SL03104 TaxNoteNo VSTRING 25 25 0 Tax Note Number
SL03 SL03105 FinOperationCode2 VSTRING 10 10 0 Financial Operation Code 2
SL03 SL03106 EDIStatus STRING 1 1 0 EDI Status
SL03 SL03107 NumberOfPages INTEGER 3 0 0 Number Of Pages
SL03 SL03108 IssuerExtCode VSTRING 16 16 0 Issuer External Code
SL03 SL03109 IssuerExpDate DATE 8 0 0 Issuer validity Date
SL03 SL03110 POSMachine STRING 1 1 0 POS Machine
SL03 SL03111 TaxNoteRegDate DATE 8 0 0 Tax Note Register Date The date of tax note registration.
SL03 SL03112 IssuerCode STRING 6 6 0 Invoice Issuer Code
SL03 SL03113 CommisionBase MONEY 20 28 8 Commission Base
SL03 SL03114 CommisionWithheldCost MONEY 20 28 8 Commission Withheld Cost
SL03 SL03115 CommissionDistrMethod VSTRING 1 1 0 Commission Distribution Method
SL03 SL03116 DueDateDefinition INTEGER 1 0 0 Due Date Definition
SL03 SL03117 PaymentTermCode VSTRING 2 2 0 Payment Term
SL03 SL03118 LockPaymentsInvoices INTEGER 1 0 0 Lock Payments for Invoices 0 – Default. Payment can be matched against invoices or Sales Orders.
1 – Payment is ‘locked’ for linking to Sales Order or to matching against invoices.
SL03 SL03119 CorrectionNumber INTEGER 3 0 0 Correction Number Number of corrective Tax Note for Corrective Tax Notes.
SL03 SL03120 FiscalReference VSTRING 50 50 0 Fiscal Reference
SL03 SL03121 SpesometroForms VSTRING 12 12 0 Include in Spesometro Form
SL03 SL03122 ReminderDate DATE 8 0 0 Reminder Date
SL03 SL03123 PO3Subtype STRING 2 2 0 PO3 Sub Type
SL03 SL03124 PaymentCode STRING 3 3 0 Payment Code
SL03 SL03125 TaxRegStatus STRING 1 1 0 Tax Registration Status
SL03 SL03126 PublicProcuremCode1 VSTRING 20 20 0 Public Procurement Code1
SL03 SL03127 PublicProcuremCode2 VSTRING 20 20 0 Public Procurement Code2
SL03 SL03128 AdvPrepFlag STRING 2 2 0 Advance/Prepayment Flag
SL03 SL03129 AdvPrepDedAmntLCU MONEY 20 28 8 Deducted Advance/Prepayment Amount LCU
SL03 SL03130 AdvPrepDedAmntOCU MONEY 20 28 8 Deducted Advance/Prepayment Amount ICU
SL03 SL03131 OwnBankCode1 STRING 2 2 0 Own Bank Code 1
SL03 SL03132 OwnBankCode2 STRING 2 2 0 Own Bank Code 2
SL03 SL03133 BankCode1 VSTRING 10 10 0 Bank Code 1
SL03 SL03134 BankAccount1 VSTRING 34 34 0 Bank Account 1
SL03 SL03135 BankCode2 VSTRING 10 10 0 Bank Code 2
SL03 SL03136 BankAccount2 VSTRING 34 34 0 Bank Account 2
SL03 SL03137 TaxRegDate DATE 8 0 0 Tax Registration Date
SL03 SL03138 TaxRegNo VSTRING 9 9 0 Tax Registration No
SL03 SL03139 TaxRegCountry STRING 3 3 0 Tax Registration Country