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
ST08 ST08001 SupplierCode VSTRING 10 10 0 Order Supplier Code
ST08 ST08002 SuppCategory VSTRING 4 4 0 Supplier Category
ST08 ST08003 OrderNo VSTRING 10 10 0 Purchase Order Number
ST08 ST08004 OrderType VSTRING 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
ST08 ST08005 AccCodeStrin ACCSTR 120 120 0 Accounting String
ST08 ST08006 Spare VSTRING 6 6 0 (obsolete)
ST08 ST08007 Spare VSTRING 6 6 0 (obsolete)
ST08 ST08008 InvoiceDate DATE 8 0 0 Invoice Date
ST08 ST08009 DeliveryDate DATE 8 0 0 Delivery Date
ST08 ST08010 DeliveryTime VSTRING 6 6 0 Delivery Variance Request vs. Actual
ST08 ST08011 StockCode VSTRING 35 35 0 Stock Item Code
ST08 ST08012 ProductGroup VSTRING 4 4 0 Product Group
ST08 ST08013 AltProdGroup VSTRING 4 4 0 Alternative Product Group
ST08 ST08014 PurchaseQty X_NUMERIC 12 20 8 Purchased Quantity
ST08 ST08015 PriceLCU MONEY 20 28 8 Purchase Price (Local Currency)
ST08 ST08016 Price MONEY 20 28 8 Purchase Price (Invoice Currency)
ST08 ST08017 Warehouse VSTRING 6 6 0 Warehouse
ST08 ST08018 FullyShipp01 SWITCH 1 1 0 Fully Shipped
ST08 ST08019 DelDateReq DATE 8 0 0 Delivery Date Requested
1 ST08 ST08020 SearchIndex STRING 8 8 0 Index Key
ST08 ST08021 QtySC X_NUMERIC 12 20 8 Purchased Quantity (Stock Units)
ST08 ST08022 BatchIDDeliv VSTRING 12 12 0 Batch ID
ST08 ST08023 CurrencyCode VSTRING 2 2 0 Currency Code Invoice
ST08 ST08024 InvoiceNo VSTRING 25 25 0 Invoice Number
ST08 ST08025 AutoDelNoteNo VSTRING 10 10 0 Goods Received Note Number
ST08 ST08026 Pickinglist VSTRING 10 10 0 Picking List
ST08 ST08027 OrderingCustomer VSTRING 10 10 0 Customer Code Order
ST08 ST08028 InvCustomer VSTRING 10 10 0 Customer Code Invoice
ST08 ST08029 DeliveryCustomer VSTRING 10 10 0 Customer Code Delivery
ST08 ST08030 InvType VSTRING 1 1 0 Type of Invoice
ST08 ST08031 QtyRejected X_NUMERIC 12 20 8 Rejected quantity
ST08 ST08032 RejectionCode VSTRING 4 4 0 Rejection Code
ST08 ST08033 OriginalRequestedDeliveryDate DATE 8 0 0 Original Requested Delivery Date
ST08 ST08034 InvSupplCode STRING 10 10 0 Invoice Supplier Code