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 SLH6 SLH6001 CustomerCode VSTRING 10 10 0 Customer Code
2 SLH6 SLH6002 InvoiceNo VSTRING 25 25 0 Invoice No
3 SLH6 SLH6003 InvoiceLineNo VSTRING 6 6 0 Invoice Line No
SLH6 SLH6004 ObjectType INTEGER 4 0 0 Object Type as per SAFT object types
SLH6 SLH6005 ObjectNo VSTRING 12 12 0 Object No
SLH6 SLH6006 SubObjectNo VSTRING 6 6 0 Sub-Object No Subproject code (used for projects only)
SLH6 SLH6007 InvoicePlanLineNo VSTRING 6 6 0 Invoice Plan Line No
SLH6 SLH6008 LineType INTEGER 4 0 0 Line Type as per SAFT line types
SLH6 SLH6009 LineNumber VSTRING 6 6 0 Line Number
SLH6 SLH6010 Extended Line number VSTRING 50 50 0 Extended Line number
SLH6 SLH6011 StockActivityCode VSTRING 35 35 0 Stock/Activity Code
SLH6 SLH6012 Description1 VSTRING 50 50 0 Description 1
SLH6 SLH6013 Description2 VSTRING 50 50 0 Description 2
SLH6 SLH6014 Qty X_NUMERIC 12 20 8 Qty
SLH6 SLH6015 UnitOfMeasure_Code INTEGER 4 0 0 Unit Of Measure (Code)
SLH6 SLH6016 UnitOfMeasure_Description VSTRING 25 25 0 Unit Of Measure (Description)
SLH6 SLH6017 Price per Unit OCU MONEY 20 28 8 Price per Unit OCU
SLH6 SLH6018 Price per Unit LCU MONEY 20 28 8 Price per Unit LCU
SLH6 SLH6019 GrossLineDiscountOCU MONEY 20 28 8 Gross Line Discount OCU
SLH6 SLH6020 GrossLineDiscountLCU MONEY 20 28 8 Gross Line Discount LCU
SLH6 SLH6021 NetLineAmountOCU MONEY 20 28 8 Net Line Amount OCU
SLH6 SLH6022 NetLineAmountLCU MONEY 20 28 8 Net Line Amount LCU
SLH6 SLH6023 GrossLineAmountOCU MONEY 20 28 8 Gross Line Amount OCU
SLH6 SLH6024 GrossLineAmountLCU MONEY 20 28 8 Gross Line Amount LCU
SLH6 SLH6025 TaxCode VSTRING 6 6 0 Tax Code
SLH6 SLH6026 TaxPercentage VSTRING 6 6 0 Tax Percentage
SLH6 SLH6027 TaxAmountOCU MONEY 20 28 8 Tax Amount OCU
SLH6 SLH6028 TaxAmountLCU MONEY 20 28 8 Tax Amount LCU
SLH6 SLH6029 UserDefined1 VSTRING 120 120 0 User Defined 1
SLH6 SLH6030 UserDefined2 VSTRING 120 120 0 User Defined 2
SLH6 SLH6031 UserDefined3 VSTRING 120 120 0 User Defined 3
SLH6 SLH6032 UserDefined4 VSTRING 120 120 0 User Defined 4
SLH6 SLH6033 UserDefined5 VSTRING 120 120 0 User Defined 5
SLH6 SLH6034 UserDefined6 VSTRING 120 120 0 User Defined 6
SLH6 SLH6035 UserDefined7 VSTRING 120 120 0 User Defined 7
SLH6 SLH6036 UserDefined8 VSTRING 120 120 0 User Defined 8
SLH6 SLH6037 UserDefined9 VSTRING 120 120 0 User Defined 9
SLH6 SLH6038 UserDefined10 VSTRING 120 120 0 User Defined 10
SLH6 SLH6039 UserDefined11 VSTRING 120 120 0 User Defined 11
SLH6 SLH6040 UserDefined12 VSTRING 120 120 0 User Defined 12
SLH6 SLH6041 UserDefined13 VSTRING 120 120 0 User Defined 13
SLH6 SLH6042 UserDefined14 VSTRING 120 120 0 User Defined 14
SLH6 SLH6043 UserDefined15 VSTRING 120 120 0 User Defined 15
SLH6 SLH6044 UserDefined16 VSTRING 120 120 0 User Defined 16
SLH6 SLH6045 UserDefined17 VSTRING 120 120 0 User Defined 17
SLH6 SLH6046 UserDefined18 VSTRING 120 120 0 User Defined 18
SLH6 SLH6047 UserDefined19 VSTRING 120 120 0 User Defined 19
SLH6 SLH6048 UserDefined20 VSTRING 120 120 0 User Defined 20
SLH6 SLH6049 WithholdingTaxAmountOCU MONEY 20 28 8 Withholding Tax Amount OCU
SLH6 SLH6050 WithholdingTaxAmountLCU MONEY 20 28 8 Withholding Tax Amount LCU
SLH6 SLH6051 DeliveryDateFrom DATE 8 0 0 Delivery Date From
SLH6 SLH6052 DeliveryDateTo DATE 8 0 0 Delivery Date To
SLH6 SLH6053 TaxBEDate DATE 8 0 0 Tax BE Date
SLH6 SLH6054 TaxLiability STRING 6 6 0 Tax Liability
SLH6 SLH6055 FinancialOperationType VSTRING 10 10 0 Financial Operation Type
SLH6 SLH6056 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
SLH6 SLH6057 SourceCityCode VSTRING 10 10 0 Source City Code
SLH6 SLH6058 DestinationCityCode VSTRING 10 10 0 Destination City Code
SLH6 SLH6059 UserDefined21 VSTRING 120 120 0 User Defined 21
SLH6 SLH6060 UserDefined22 VSTRING 120 120 0 User Defined 22
SLH6 SLH6061 UserDefined23 VSTRING 120 120 0 User Defined 23
SLH6 SLH6062 UserDefined24 VSTRING 120 120 0 User Defined 24
SLH6 SLH6063 UserDefined25 VSTRING 120 120 0 User Defined 25
SLH6 SLH6064 UserDefined26 VSTRING 120 120 0 User Defined 26
SLH6 SLH6065 UserDefined27 VSTRING 120 120 0 User Defined 27
SLH6 SLH6066 UserDefined28 VSTRING 120 120 0 User Defined 28
SLH6 SLH6067 UserDefined29 VSTRING 120 120 0 User Defined 29
SLH6 SLH6068 UserDefined30 VSTRING 120 120 0 User Defined 30
SLH6 SLH6069 DeductByInvNo VSTRING 25 25 0 Deducted by Invoice No
SLH6 SLH6070 Spare VSTRING 10 10 0 Spare
SLH6 SLH6071 Spare VSTRING 10 10 0 Spare
SLH6 SLH6072 NetLineDiscountOCU MONEY 20 28 8 Net Line Discount OCU
SLH6 SLH6073 NetLineDiscountLCU MONEY 20 28 8 Net Line Discount LCU