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
ST02 ST02001 CustomerCode VSTRING 10 10 0 Customer Code Delivery
ST02 ST02002 CustomCateg VSTRING 4 4 0 Customer Category
ST02 ST02003 District VSTRING 2 2 0 Customer District
ST02 ST02004 AdvertisCode VSTRING 2 2 0 Customer Advertising Area
ST02 ST02005 CityCode VSTRING 4 4 0 Customer Area Code
ST02 ST02006 SNICode VSTRING 5 5 0 Customer Trade Code
ST02 ST02007 Salesman VSTRING 3 3 0 Salesman
ST02 ST02008 CustCodeInv VSTRING 10 10 0 Customer Code Invoice
ST02 ST02009 OrderNumber VSTRING 10 10 0 Order Number
ST02 ST02010 OrderType INTEGER 1 0 0 Order Type 0 - Quotation
1 - Normal Order
2 - Invoice Order
3 - Direct Order
4 - Back Order
5 - Repeat Order
6 - Work Order
7 - Direct Credit Order
8 - Credit Order
9 - Re-invoice Order
ST02 ST02011 AccCodeStrin ACCSTR 120 120 0 Accounting String
ST02 ST02012 Spare VSTRING 10 10 0 Product Category
ST02 ST02013 Spare VSTRING 20 20 0 Extended Product Group
ST02 ST02014 InvoiceNo VSTRING 15 15 0 Invoice Number
ST02 ST02015 InvoicOrdDat DATE 8 0 0 Order Date
ST02 ST02016 ActuaDelDate DATE 8 0 0 Actual Delivery Date
ST02 ST02017 StockCode VSTRING 35 35 0 Stock Item Code
ST02 ST02018 ProductGroup VSTRING 4 4 0 Product Group
ST02 ST02019 AlternProdGr VSTRING 4 4 0 Alternative Product Group
ST02 ST02020 Qty X_NUMERIC 12 20 8 Quantity
ST02 ST02021 PriceLCU MONEY 20 28 8 Unit Price (Local Currency)
ST02 ST02022 Discount X_NUMERIC 6 14 8 Discount
ST02 ST02023 CostPriceLCU MONEY 20 28 8 Unit Cost Price (Local Currency)
ST02 ST02024 BudgetQty X_NUMERIC 12 20 8 Budgeted Quantity
ST02 ST02025 BudgPriceLCU MONEY 20 28 8 Budgeted Unit Price (Local Currency)
ST02 ST02026 CostPric2LCU MONEY 20 28 8 Standard Cost Price (Local Currency)
ST02 ST02027 DelDatCommit DATE 8 0 0 Delivery Date Committed
ST02 ST02028 ServiceLevel VSTRING 1 1 0 Service Level
ST02 ST02029 Warehouse VSTRING 6 6 0 Warehouse
ST02 ST02030 FullyShipped SWITCH 1 1 0 Fully Shipped
ST02 ST02031 DelDateRequ DATE 8 0 0 Delivery Date Requested
ST02 ST02032 AmountOCU MONEY 20 28 8 Unit Price (Order Currency)
ST02 ST02033 CurrCode VSTRING 2 2 0 Currency Code Order
ST02 ST02034 CustCodeOrd VSTRING 10 10 0 Customer Code Order
ST02 ST02035 OrdCancelCde VSTRING 4 4 0 Cancellation Code
1 ST02 ST02036 SearcIndAuto STRING 8 8 0 Index Key
ST02 ST02037 BatchIDDel STRING 12 12 0 Batch ID Delivery
ST02 ST02038 EDIContractSwitch SWITCH 1 1 0 EDI-Contract
ST02 ST02039 CostPriceCCU MONEY 20 28 8 Cost Unit Price (Alternative Currency)
ST02 ST02040 LineAmtLCU MONEY 20 28 8 Line Amount (Local Currency) Line amount is the order line total before discount, it's calculated with rounding logic as defined for the currency.
ST02 ST02041 LineAmtOCU MONEY 20 28 8 Line Amount (Order Currency) Line amount is the order line total before discount, it's calculated with rounding logic as defined for the currency.
ST02 ST02042 StandardVPC MONEY 20 28 8 Standard-Variable Product Cost (Local Currency) This field is only used with the feature factory price
ST02 ST02043 RealVPC MONEY 20 28 8 Real-Variable Product Cost (Local Currency) This field is only used with the feature factory price
ST02 ST02044 FreightOption SWITCH 1 1 0 Freight Option This field is only used with the feature factory price:
0 - Freight is Include in VPC Cost
1 - Freight is not Include in VPC Cost
ST02 ST02045 GLUpdateFlag SWITCH 1 1 0 General Ledger Updated This field is only used with the feature factory price
ST02 ST02046 DiscountSchemeCode INTEGER 9 0 0 Discount Scheme Code
ST02 ST02047 DiscountGroupCode INTEGER 9 0 0 Discount Group Code
ST02 ST02048 AllowanceAmnt MONEY 20 28 8 Allowance Amount (Local Currency)
ST02 ST02049 SurchargeAmnt MONEY 20 28 8 Surcharge Amount (Local Currency)
ST02 ST02050 POSStatFlag SWITCH 1 1 0 POS Statistics Flag
ST02 ST02051 POSImportFileName VSTRING 40 40 0 POS Import File Name
ST02 ST02052 POSCurrentAverageCostLCU] MONEY 20 28 8 POS Current Average Cost (Local Currency)
ST02 ST02053 POSCalculationMethod INTEGER 1 0 0 POS Calculation Method
ST02 ST02054 POSProductCategory SWITCH 1 1 0 POS Product Category
ST02 ST02055 CWHCompanyCode VSTRING 2 2 0 Central Warehouse Company Code
ST02 ST02056 CWHCustomerCode VSTRING 10 10 0 Central Warehouse Customer Code
ST02 ST02057 Spare MONEY 20 28 8 (obsolete)
ST02 ST02058 Spare INTEGER 2 0 0 (obsolete)
ST02 ST02059 CWHPickinglist VSTRING 10 10 0 Central Warehouse Picking List
ST02 ST02060 CWHTypeOfInvoice VSTRING 1 1 0 Central Warehouse Type of Invoice
ST02 ST02061 CWHIntercompanyInvoice VSTRING 15 15 0 Central Warehouse Inter-company Invoice Number
ST02 ST02062 SalesOrderLine STRING 6 6 0 Sales Order Line Number
ST02 ST02063 SalesOrderSubline STRING 6 6 0 Sales Order Sub-Line Number
ST02 ST02064 SalesReturnReasonCode INTEGER 1 0 0 Sales Return Reason Code
ST02 ST02065 RMAReference NUMERICSTRING 10 10 0 RMA Reference
ST02 ST02066 CommissionWithheldCost MONEY 20 28 8 Commission Withheld Cost
ST02 ST02067 TransactionDate DATE 8 0 0 Transaction Date