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
ST01 Salesmen Company ST010100
ST02 Sales Order Entry Statistics Company ST020100
ST03 Sales Order Invoicing Statistics Company ST030100
ST05 Sales Districts Company ST050100
ST06 Workfile for budgets ST060000
ST07 Commission Rates Company ST070100
ST08 Purchase Statistics Company ST080100
ST10 Bookings Company ST100100
ST11 Selected Bookings Company ST110100
ST12 Yearly Booking File Company ST120100
ST13 Service Statistics Company ST130100
ST14 Query On Statistics ST140000
ST15 Purchase Order Header Statistics Company ST150100
ST16 Purchase Order Line Statistics Company ST160100
ST17 Purchase Order Ordering Statistics Company ST170100
ST18 Purchase Order Confirmation Statistics Company ST180100
ST19 Purchase Order Goods Receipt Statistics Company ST190100
ST20 Purchase Order Invoice Statistics Company ST200100
ST22 Sales Order Entry Statistics Advanced Discounts Company ST220100
ST23 Sales Order Invoice Statistics Advanced Discounts Company ST230100
ST24 Sales Contract Statistics Company ST240100
ST25 Lease Statistics Company ST250100
ST40 Company ST400100
STCS Company STCS0100
STST Company STST0100

Fields
PK Table Name Description Type Length Precision Note
1 ST01 ST01001 SalesmanNo STRING 3 3 0 Salesman
ST01 ST01002 Name VSTRING 25 25 0 Name
ST01 ST01003 LatestOrDate DATE 8 0 0 Last Order Date
ST01 ST01004 VolumePeriod MONEY 20 28 8 Volume Period
ST01 ST01005 ProfitPeriod MONEY 20 28 8 Profit Period
ST01 ST01006 NoOfOrPeriod INTEGER 4 0 0 No of Orders Period
ST01 ST01007 VolumeYTD MONEY 20 28 8 Volume YTD
ST01 ST01008 ProfitYTD MONEY 20 28 8 Profit YTD
ST01 ST01009 NoOfOrderYTD INTEGER 4 0 0 No of Orders YTD
ST01 ST01010 VolumeCommis X_NUMERIC 5 13 8 Volume Commission %
ST01 ST01011 CommLimitVol MONEY 20 28 8 Volume Commission Limit
ST01 ST01012 ProfitCommis X_NUMERIC 5 13 8 Profit Commission %
ST01 ST01013 CommLimiProf MONEY 20 28 8 Profit Commission Limit
ST01 ST01014 CommPaidYTD MONEY 20 28 8 Commission Paid YTD
ST01 ST01015 VolNextPeriod MONEY 20 28 8 Volume Next Period
ST01 ST01016 ProfiNextPer MONEY 20 28 8 Profit Next Period
ST01 ST01017 NoOfOrNexPer INTEGER 4 0 0 No of Orders Next Period
ST01 ST01018 VolNextYTD MONEY 20 28 8 Volume Next YTD
ST01 ST01019 ProfNextYTD MONEY 20 28 8 Profit Next YTD
ST01 ST01020 NoOfOrNexYTD INTEGER 4 0 0 Number of Orders Next YTD
ST01 ST01021 AccCodeStrin ACCSTR 120 120 0 Accounting String
ST01 ST01022 Spare VSTRING 6 6 0 (obsolete)
ST01 ST01023 Spare VSTRING 6 6 0 (obsolete)
ST01 ST01024 District VSTRING 2 2 0 District
ST01 ST01025 AdvertisingCode VSTRING 2 2 0 Advertising Code
ST01 ST01026 CityCode VSTRING 4 4 0 City Code
ST01 ST01027 SNICode VSTRING 5 5 0 SNI Code
ST01 ST01028 ProductGroup VSTRING 4 4 0 Product Group
ST01 ST01029 AlternativeProductGroup VSTRING 4 4 0 Alternative Product Group
ST01 ST01030 DiscountCode VSTRING 2 2 0 Discount Code
ST01 ST01031 Agent VSTRING 1 1 0 Agent
ST01 ST01032 EmailAddress VSTRING 200 200 0 Email Address