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
DI01 Stock Items Company DI010100
DI02 Stock Item Foreign Descriptions Company DI020100
DI03 Invoicing Parameters Company DI030100
DI04 Stock Item Price List Company DI040100
DI05 Invoice Texts Company DI050100
DI08 Invoice Templates Company DI080100
DI10 Invoice Head Company DI100100
DI11 Invoice Lines Company DI110100
DIH0 Company DIH00100
DIH1 Company DIH10100
DIXX Temp. DI table DIXX0000
DIXY Workf.close Inv DIXY0000

Fields
PK Table Name Description Type Length Precision Note
1 DIH0 DIH0001 InvoiceNo STRING 15 15 0 InvoiceNo
DIH0 DIH0002 CustCode VSTRING 10 10 0 CustCode
DIH0 DIH0003 OurReference VSTRING 35 35 0 OurReference
DIH0 DIH0004 YourReference VSTRING 35 35 0 YourReference
DIH0 DIH0005 AccString ACCSTR 120 120 0 AccString
DIH0 DIH0006 PriceList VSTRING 2 2 0 PriceList
DIH0 DIH0007 PaymentTerm VSTRING 2 2 0 PaymentTerm
DIH0 DIH0008 InvoiceFee X_NUMERIC 15 23 8 InvoiceFee
DIH0 DIH0009 Freight X_NUMERIC 15 23 8 Freight
DIH0 DIH0010 Discount X_NUMERIC 6 14 8 Discount
DIH0 DIH0011 DocStatus INTEGER 1 0 0 DocStatus
DIH0 DIH0012 CurrencyCode VSTRING 2 2 0 CurrencyCode
DIH0 DIH0013 SalesPerson VSTRING 3 3 0 SalesPerson
DIH0 DIH0014 InvoiceDate DATE 8 0 0 InvoiceDate
DIH0 DIH0015 DueDate DATE 8 0 0 DueDate
DIH0 DIH0016 ExportCode VSTRING 1 1 0 ExportCode
DIH0 DIH0017 CurrContract SWITCH 1 1 0 CurrContract
DIH0 DIH0018 FixedExcRate X_NUMERIC 10 18 8 FixedExcRate
DIH0 DIH0019 ContractNo VSTRING 15 15 0 ContractNo
DIH0 DIH0020 LanguageCode VSTRING 3 3 0 LanguageCode
DIH0 DIH0021 InterestBlock SWITCH 1 1 0 InterestBlock
DIH0 DIH0022 InterLatePmt VSTRING 6 6 0 InterLatePmt
DIH0 DIH0023 BEDate DATE 8 0 0 BEDate
DIH0 DIH0024 FixedExchgRate2 X_NUMERIC 10 18 8 FixedExchgRate2
DIH0 DIH0025 FixedExchgAlgtm STRING 3 3 0 FixedExchgAlgtm
DIH0 DIH0026 OrigTermsPayment VSTRING 2 2 0 OrigTermsPayment
DIH0 DIH0027 TaxLiabilityCode VSTRING 6 6 0 TaxLiabilityCode
DIH0 DIH0028 OperationType VSTRING 10 10 0 OperationType
DIH0 DIH0029 FiscalOperationCode VSTRING 10 10 0 FiscalOperationCode
DIH0 DIH0030 OwnBankCode1 STRING 2 2 0 Own Bank Code 1
DIH0 DIH0031 OwnBankCode2 STRING 2 2 0 Own Bank Code 2
DIH0 DIH0032 BankCode1 VSTRING 10 10 0 Bank Code 1
DIH0 DIH0033 BankAccount1 VSTRING 34 34 0 Bank Account 1
DIH0 DIH0034 BankCode2 VSTRING 10 10 0 Bank Code 2
DIH0 DIH0035 BankAccount2 VSTRING 34 34 0 Bank Account 2
DIH0 DIH0036 TaxRegCountry STRING 3 3 0 Tax Registration Country