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 ST13 ST13001 SearchIndex STRING 10 10 0 Index Key
ST13 ST13002 TransactType BINSTRING 1 1 0 Transaction Type 0 - Contract Lines
1 - Service Order Time Activity Line
2 - Service Order Cost Activity Line
3 - Service Order Material Line
4 - Service Order Head
ST13 ST13003 ServiceNo STRING 10 10 0 Service Order Number
ST13 ST13004 MasterOrdNo STRING 10 10 0 Master Order Number
ST13 ST13005 OrderType STRING 6 6 0 Order Type
ST13 ST13006 Salesman STRING 3 3 0 Salesman
ST13 ST13007 AnalysisCode VSTRING 15 15 0 Analysis Code
ST13 ST13008 DelivNoteNo VSTRING 20 20 0 Delivery Note Number
ST13 ST13009 SerCalLogDat DATE 8 0 0 Service Call Date Logged
ST13 ST13010 SerCalLogTim VSTRING 5 5 0 Service Call Time Logged
ST13 ST13011 SerCalOpeDat DATE 8 0 0 Service Call Date Opened
ST13 ST13012 SerCalOpeTim VSTRING 5 5 0 Service Call Time Opened
ST13 ST13013 SerCalComDat DATE 8 0 0 Service Call Date Committed
ST13 ST13014 SerCalComTim VSTRING 5 5 0 Service Call Time Committed
ST13 ST13015 SerCalCloDat DATE 8 0 0 Service Call Date Closed
ST13 ST13016 SerCalCloTim VSTRING 5 5 0 Service Call Time Closed
ST13 ST13017 SerCalTADate DATE 8 0 0 Service Call TA Date
ST13 ST13018 SerCalTATime VSTRING 5 5 0 Service Call TA Time
ST13 ST13019 CustomerCode VSTRING 10 10 0 Customer Code
ST13 ST13020 CustomerName VSTRING 25 25 0 Customer Name
ST13 ST13021 CustCategory STRING 4 4 0 Customer Category
ST13 ST13022 District STRING 2 2 0 Customer District
ST13 ST13023 AdvertisCode STRING 2 2 0 Customer Advertising Area
ST13 ST13024 CityCode STRING 4 4 0 Customer Area Code
ST13 ST13025 SNICode STRING 5 5 0 Customer Trade Code
ST13 ST13026 Site STRING 4 4 0 Site Code
ST13 ST13027 SiteName STRING 4 4 0 Site Name
ST13 ST13028 InternSiteNo VSTRING 12 12 0 Internal Site Number
ST13 ST13029 ObjStockCode VSTRING 35 35 0 Service Object Stock Item
ST13 ST13030 Discription1 VSTRING 25 25 0 Service Object Description Line 1
ST13 ST13031 Discription2 VSTRING 25 25 0 Service Object Description Line 2
ST13 ST13032 ObjProduGrp STRING 4 4 0 Service Object Product Group
ST13 ST13033 ObjAltProGrp STRING 4 4 0 Service Object Alternative Product Group
ST13 ST13034 ObjSerialNo VSTRING 20 20 0 Service Object Serial Number
ST13 ST13035 ServContraNo VSTRING 10 10 0 Service Contract Number
ST13 ST13036 ContractCode STRING 3 3 0 Contract Type
ST13 ST13037 CustCodeInv VSTRING 10 10 0 Customer Code Invoice
ST13 ST13038 CustNameInv VSTRING 25 25 0 Customer Name Invoice
ST13 ST13039 CustCategoryInv STRING 4 4 0 Customer Category Invoice
ST13 ST13040 TermsOfPaym STRING 2 2 0 Payment Terms
ST13 ST13041 HoursLogTA VSTRING 7 7 0 Hours Logged to TA
ST13 ST13042 HourLogCompl VSTRING 7 7 0 Hours Logged to Completed
ST13 ST13043 InvoiceNo VSTRING 15 15 0 Invoice Number
ST13 ST13044 InvoceDate DATE 8 0 0 Invoice Date
ST13 ST13045 StkCosActCod VSTRING 35 35 0 Activity/Cost/Stock Item Code
ST13 ST13046 Description VSTRING 35 35 0 Order Line Description
ST13 ST13047 ProductGroup STRING 4 4 0 Product Group Material Line Stock Item
ST13 ST13048 AltProdGroup STRING 4 4 0 Alternative Product Group Material Line Stock Item
ST13 ST13049 FldEngineer VSTRING 10 10 0 Field Engineer
ST13 ST13050 WH STRING 6 6 0 Warehouse
ST13 ST13051 LnStProdCode VSTRING 35 35 0 Material Line Product Code
ST13 ST13052 LnStatModule VSTRING 35 35 0 Material Line Module
ST13 ST13053 LineStatPos VSTRING 7 7 0 Material Line Position
ST13 ST13054 LnStatMatCod VSTRING 35 35 0 Material Line Material Code
ST13 ST13055 LnStFoultCod VSTRING 7 7 0 Error Code
ST13 ST13056 AccntString ACCSTR 120 120 0 Accounting String
ST13 ST13057 Quantity X_NUMERIC 12 20 8 Quantity
ST13 ST13058 PriceLCU MONEY 20 28 8 Unit Price (Local Currency)
ST13 ST13059 Discount MONEY 20 28 8 Discount
ST13 ST13060 UsedQty X_NUMERIC 12 20 8 Used Quantity
ST13 ST13061 CostPriceQty MONEY 20 28 8 Unit Cost Price (Local Currency)
ST13 ST13062 BudgetQty X_NUMERIC 12 20 8 Budgeted Quantity
ST13 ST13063 BudgetPriLCU MONEY 20 28 8 Budgeted Unit Price (Local Currency)
ST13 ST13064 BudgetCstLCU MONEY 20 28 8 Budgeted Unit Cost Price (Local Currency)
ST13 ST13065 CommissionWitheldCost MONEY 20 28 8 Commission Witheld Cost