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 ST20 ST20001 OrderNo STRING 10 10 0 Purchase Order Number
2 ST20 ST20002 OrderLine STRING 6 6 0 Purchase Order Line Number
3 ST20 ST20003 OrderSubLine STRING 6 6 0 Purchase Order Sub-line Number
4 ST20 ST20004 DeliveryLine STRING 6 6 0 Purchase Order Delivery Line Number
5 ST20 ST20005 OrderType SWITCH 1 1 0 Order Type 0 - Purchase Order Proposal / Request for Quotation
1 - Normal Order
2 - Back Order
3 - Direct Delivery to Customer
4 - Replenishment Order
6 ST20 ST20006 Counter INTEGER 10 0 0 Line Counter
ST20 ST20007 ScaUser STRING 8 8 0 User
ST20 ST20008 TransactionDate DATE 8 0 0 Transaction Date
ST20 ST20009 TransactionTime STRING 8 8 0 Transaction Time
ST20 ST20010 TransactionType STRING 2 2 0 Transaction Type 10 - Created
20 - Updated
60 - Deleted
ST20 ST20011 QtyPCUnits X_NUMERIC 12 20 8 Quantity (Purchase Unit)
ST20 ST20012 QtySCUnits X_NUMERIC 12 20 8 Quantity (Stock Unit)
ST20 ST20013 PriceOrderCurrency MONEY 20 28 8 Unit Price (Invoice Currency)
ST20 ST20014 PriceLCU MONEY 20 28 8 Unit Price (Local Currency)
ST20 ST20015 DiscLinePercent X_NUMERIC 6 14 8 Discount Line %
ST20 ST20016 DiscOrdPercent X_NUMERIC 6 14 8 Discount Order %
ST20 ST20017 InvoiceNo STRING 25 25 0 Invoice Number
ST20 ST20018 DateInvoice DATE 8 0 0 Date Invoiced
ST20 ST20019 InvoiceCurrCode STRING 2 2 0 Currency Code Invoice
ST20 ST20020 FlagActive SWITCH 1 1 0 Active
ST20 ST20021 CommodityCode VSTRING 35 35 0 Commodity code