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 ST07 ST07001 no STRING 2 2 0 Index Key
ST07 ST07002 ComOrdTurnover0 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 0
ST07 ST07003 ComOrdTurnover1 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 1
ST07 ST07004 ComOrdTurnover2 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 2
ST07 ST07005 ComOrdTurnover3 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 3
ST07 ST07006 ComOrdTurnover4 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 4
ST07 ST07007 ComOrdTurnover5 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 5
ST07 ST07008 ComOrdTurnover6 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 6
ST07 ST07009 ComOrdTurnover7 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 7
ST07 ST07010 ComOrdTurnover8 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 8
ST07 ST07011 ComOrdTurnover9 X_NUMERIC 5 13 8 Order Commission on Turnover Rate 9
ST07 ST07012 ComOrdGrProfit0 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 0
ST07 ST07013 ComOrdGrProfit1 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 1
ST07 ST07014 ComOrdGrProfit2 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 2
ST07 ST07015 ComOrdGrProfit3 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 3
ST07 ST07016 ComOrdGrProfit4 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 4
ST07 ST07017 ComOrdGrProfit5 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 5
ST07 ST07018 ComOrdGrProfit6 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 6
ST07 ST07019 ComOrdGrProfit7 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 7
ST07 ST07020 ComOrdGrProfit8 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 8
ST07 ST07021 ComOrdGrProfit9 X_NUMERIC 5 13 8 Order Commission on Gross Profit Rate 9
ST07 ST07022 ComInvTurnover0 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 0
ST07 ST07023 ComInvTurnover1 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 1
ST07 ST07024 ComInvTurnover2 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 2
ST07 ST07025 ComInvTurnover3 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 3
ST07 ST07026 ComInvTurnover4 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 4
ST07 ST07027 ComInvTurnover5 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 5
ST07 ST07028 ComInvTurnover6 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 6
ST07 ST07029 ComInvTurnover7 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 7
ST07 ST07030 ComInvTurnover8 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 8
ST07 ST07031 ComInvTurnover9 X_NUMERIC 5 13 8 Invoice commission on Turnover Rate 9
ST07 ST07032 ComInvGrProfit0 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 0
ST07 ST07033 ComInvGrProfit1 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 1
ST07 ST07034 ComInvGrProfit2 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 2
ST07 ST07035 ComInvGrProfit3 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 3
ST07 ST07036 ComInvGrProfit4 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 4
ST07 ST07037 ComInvGrProfit5 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 5
ST07 ST07038 ComInvGrProfit6 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 6
ST07 ST07039 ComInvGrProfit7 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 7
ST07 ST07040 ComInvGrProfit8 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 8
ST07 ST07041 ComInvGrProfit9 X_NUMERIC 5 13 8 Invoice commission on Gross Profit Rate 9