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
ST24 ST24001 ContractNumber STRING 10 10 0 Contract Number
ST24 ST24002 ContractLineNumber STRING 6 6 0 Contract Line Number
ST24 ST24003 DeliveryScheduleLineNumber STRING 6 6 0 Delivery Schedule Line Number
ST24 ST24004 ContractCustomer STRING 10 10 0 Contract Customer
ST24 ST24005 TransactionType STRING 1 1 0 Transaction Type
ST24 ST24006 StockCode VSTRING 35 35 0 Stock Code
ST24 ST24007 Warehouse STRING 6 6 0 Warehouse
ST24 ST24008 Quantity X_NUMERIC 13 21 8 Quantity
ST24 ST24009 UnitPriceLCU X_NUMERIC 13 21 8 Unit Price LCU
ST24 ST24010 UnitPriceOCU X_NUMERIC 13 21 8 Unit Price OCU
ST24 ST24011 Discount X_NUMERIC 13 21 8 Discount
ST24 ST24012 CurrencyCode STRING 2 2 0 Currency Code
ST24 ST24013 LineAmountLCU X_NUMERIC 13 21 8 Line Amount LCU
ST24 ST24014 LineAmountOCU X_NUMERIC 13 21 8 Line Amount OCU
ST24 ST24015 SalesOrderNumber STRING 10 10 0 Sales Order Number
ST24 ST24016 SalesOrderLine STRING 6 6 0 Sales Order Line Number
ST24 ST24017 SalesOrderSubLine STRING 6 6 0 Sales Order Sub Line Number
ST24 ST24018 TransactionDate DATE 8 0 0 Transaction Date
ST24 ST24019 AcceptedDate DATE 8 0 0 Accepted Date
ST24 ST24020 ExpirationDate DATE 8 0 0 Expiration Date
ST24 ST24021 LastUsedDate DATE 8 0 0 Last Used Date
ST24 ST24022 Status STRING 1 1 0 Status
1 ST24 ST24023 SearchIndex STRING 10 10 0 Search Index