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 DI10 DI10001 InvoiceNo STRING 15 15 0 Invoice Number
DI10 DI10002 CustCode VSTRING 10 10 0 Customer Code
DI10 DI10003 OurReference VSTRING 35 35 0 Our Reference
DI10 DI10004 YourReference VSTRING 35 35 0 Your Reference
DI10 DI10005 AccString ACCSTR 120 120 0 Accounting String
DI10 DI10006 PriceList VSTRING 2 2 0 Price List
DI10 DI10007 PaymentTerm VSTRING 2 2 0 Payment Terms
DI10 DI10008 InvoiceFee X_NUMERIC 15 23 8 Invoice Fee
DI10 DI10009 Freight X_NUMERIC 15 23 8 Freight
DI10 DI10010 Discount X_NUMERIC 6 14 8 Discount Invoice
DI10 DI10011 DocStatus INTEGER 1 0 0 Document Status/Type Includes status of document and the type of document:
0 - Normal invoice (not printed)
1 - Credit note (not printed)
2 - Internal invoice (not printed)
3 - Normal invoice (printed)
4 - Credit note (printed)
5 - Internal invoice (printed)
DI10 DI10012 CurrencyCode VSTRING 2 2 0 Currency Code
DI10 DI10013 SalesPerson VSTRING 3 3 0 Salesman
DI10 DI10014 InvoiceDate DATE 8 0 0 Invoice Date
DI10 DI10015 DueDate DATE 8 0 0 Due Date
DI10 DI10016 ExportCode VSTRING 1 1 0 Export Code
DI10 DI10017 CurrContract SWITCH 1 1 0 Currency Contract
DI10 DI10018 FixedExcRate X_NUMERIC 10 18 8 Fixed Currency Exchange Rate 1
DI10 DI10019 ContractNo VSTRING 15 15 0 Currency Contract Number
DI10 DI10020 LanguageCode VSTRING 3 3 0 Language
DI10 DI10021 InterestBlock SWITCH 1 1 0 Interest Blocked
DI10 DI10022 InterLatePmt VSTRING 6 6 0 Interest Late Payment
DI10 DI10023 BEDate DATE 8 0 0 Book-Entry Date
DI10 DI10024 FixedExchgRate2 X_NUMERIC 10 18 8 Fixed Currency Exchange Rate 2
DI10 DI10025 FixedExchgAlgtm STRING 3 3 0 Fixed Currency Exchange Rate Algorithm
DI10 DI10026 OrigTermsPayment VSTRING 2 2 0 Orig Terms Payment
DI10 DI10027 TaxLiabilityCode VSTRING 6 6 0 TaxLiabilityCode This field should contain the Tax Liability Code for invoice
DI10 DI10028 OperationType VSTRING 10 10 0 OperationType This field should contain the Operation Type for invoice header
DI10 DI10029 FiscalOperationCode VSTRING 10 10 0 FiscalOperationCode This field should contain the Fiscal Operation Code for invoice header
DI10 DI10030 OwnBankCode1 STRING 2 2 0 Own Bank Code 1
DI10 DI10031 OwnBankCode2 STRING 2 2 0 Own Bank Code 2
DI10 DI10032 BankCode1 VSTRING 10 10 0 Bank Code 1
DI10 DI10033 BankAccount1 VSTRING 34 34 0 Bank Account 1
DI10 DI10034 BankCode2 VSTRING 10 10 0 Bank Code 2
DI10 DI10035 BankAccount2 VSTRING 34 34 0 Bank Account 2
DI10 DI10036 TaxRegCountry STRING 3 3 0 Tax Registration Country