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 DI01 DI01001 StockCode STRING 35 35 0 Stock Item Code
DI01 DI01002 DescrLang0 VSTRING 25 25 0 Description
DI01 DI01003 StockCateg VSTRING 4 4 0 Category
DI01 DI01004 Pricelist0 MONEY 20 28 8 Unit Price
DI01 DI01005 CalcCostLCU MONEY 20 28 8 Calculate Unit Cost
DI01 DI01006 BudgetQty X_NUMERIC 12 20 8 Budgeted Quantity
DI01 DI01007 BudgetVolume X_NUMERIC 12 20 8 Budgeted Turnover
DI01 DI01008 QtySoldPeriod X_NUMERIC 12 20 8 Quantity Sold Current Period
DI01 DI01009 QtySoldYTD X_NUMERIC 12 20 8 Quantity Sold Current Year
DI01 DI01010 QtySoldPyear X_NUMERIC 12 20 8 Quantity Sold Previous Year
DI01 DI01011 VolumePeriod X_NUMERIC 12 20 8 Turnover Current Period
DI01 DI01012 VolumeYTD X_NUMERIC 12 20 8 Turnover Current Year
DI01 DI01013 VolumePyear X_NUMERIC 12 20 8 Turnover Previous Year
DI01 DI01014 ProfitPeriod MONEY 20 28 8 Profit Current Period
DI01 DI01015 ProfitYTD MONEY 20 28 8 Profit Current Year
DI01 DI01016 ProfitPyear MONEY 20 28 8 Profit Previous Year
DI01 DI01017 AccCode STRING 2 2 0 Accounting Code
DI01 DI01018 VATCode VSTRING 6 6 0 VAT Code This field should contain the Tax Code for stock item
DI01 DI01019 ExtraTaxCode INTEGER 1 0 0 Extra Tax Code
DI01 DI01020 FrequencyC VSTRING 1 1 0 Frequency Code
DI01 DI01021 ABCCode VSTRING 1 1 0 ABC Code
DI01 DI01022 InterActFlag VSTRING 1 1 0 Update Frequency Code Indicates if frequency code shall be shifted up or down:
0 - The stock item has NOT been sold since last time frequency analysis was executed.
1 - The stock item has been sold since last time frequency analysis was executed.
DI01 DI01023 LatestDelivD DATE 8 0 0 Last Delivery Date to Customer
DI01 DI01024 AccString ACCSTR 120 120 0 Accounting String
DI01 DI01025 VolNextPeriod X_NUMERIC 12 20 8 Turnover Next Period
DI01 DI01026 VolNextYTD X_NUMERIC 12 20 8 Turnover Next Year
DI01 DI01027 ProfNextPer MONEY 20 28 8 Profit Next Period
DI01 DI01028 ProfNextYTD MONEY 20 28 8 Profit Next Year
DI01 DI01029 QtySoldNPer X_NUMERIC 12 20 8 Quantity Sold Next Period
DI01 DI01030 QtySoldNYTD X_NUMERIC 12 20 8 Quantity Sold Next Year