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 ST25 ST25001 Counter STRING 12 12 0 Counter
ST25 ST25002 Contractnumber STRING 10 10 0 Contract number
ST25 ST25003 MasterContractNum STRING 10 10 0 Master contract number
ST25 ST25004 InvoiceNumber STRING 15 15 0 Invoice number
ST25 ST25005 InvDate DATE 8 0 0 Invoice date
ST25 ST25006 InvFromDate DATE 8 0 0 Invoice from date
ST25 ST25007 InvToDate DATE 8 0 0 Invoice to date
ST25 ST25008 ContractTerm INTEGER 1 0 0 Contract term
ST25 ST25009 CancellationDate DATE 8 0 0 Cancelation date
ST25 ST25010 InvCustomer VSTRING 10 10 0 Invoice customer
ST25 ST25011 InvCustCategory VSTRING 4 4 0 Invoice customer category
ST25 ST25012 InvCustGlobalID VSTRING 25 25 0 Invoice customer global ID
ST25 ST25013 ContractType VSTRING 3 3 0 Contract type
ST25 ST25014 CustomerPONumber VSTRING 30 30 0 Customer PO Number
ST25 ST25015 Salesman VSTRING 3 3 0 Salesman
ST25 ST25016 District VSTRING 2 2 0 District
ST25 ST25017 Advertisingcode VSTRING 2 2 0 Advertising code
ST25 ST25018 CityCode VSTRING 4 4 0 City code
ST25 ST25019 CNICode VSTRING 5 5 0 CNI code
ST25 ST25020 Manager VSTRING 6 6 0 Manager
ST25 ST25021 LineType INTEGER 2 0 0 Line type
ST25 ST25022 LineNumber STRING 6 6 0 Line number
ST25 ST25023 SubLineNum STRING 6 6 0 Subline number
ST25 ST25024 SubstructLineNum STRING 6 6 0 Substructure line number
ST25 ST25025 LineGroupCode VSTRING 6 6 0 Line group code
ST25 ST25026 MasterAssetStockCode VSTRING 35 35 0 Master asset/Stock code
ST25 ST25027 SerNum VSTRING 20 20 0 Serial number
ST25 ST25028 ValueComponent VSTRING 10 10 0 Value component
ST25 ST25029 LeaseGroupProdGrp VSTRING 6 6 0 Lease Group/Product group
ST25 ST25030 InstallationCustomer VSTRING 10 10 0 Installation customer
ST25 ST25031 InstallationCustCategory VSTRING 4 4 0 Installation customer category
ST25 ST25032 Site STRING 4 4 0 Site
ST25 ST25033 LineWH VSTRING 6 6 0 Line WH
ST25 ST25034 LineResource VSTRING 10 10 0 Line Resource
ST25 ST25035 LineStartDate DATE 8 0 0 Line start date
ST25 ST25036 LineEndDate DATE 8 0 0 Line end date
ST25 ST25037 LineInvoiceFromdate DATE 8 0 0 Line Invoice From date
ST25 ST25038 RequestedQtyOR X_NUMERIC 12 20 8 Requested Qty Sales units
ST25 ST25039 RequestedDate DATE 8 0 0 Requested Date
ST25 ST25040 InvoicedQtySalesunits X_NUMERIC 12 20 8 Invoiced Qty Sales units
ST25 ST25041 DeliveredQtySalesUnits X_NUMERIC 12 20 8 Delivered Qty Sales Units
ST25 ST25042 DeliveryDate DATE 8 0 0 Delivery Date
ST25 ST25043 ReturnedQtySalesUnits X_NUMERIC 12 20 8 Returned Qty Sales Units
ST25 ST25044 ReturnedDate DATE 8 0 0 Returned Date
ST25 ST25045 SoldQtySalesunits X_NUMERIC 12 20 8 Sold Qty Sales units
ST25 ST25046 SaleDate DATE 8 0 0 Sale Date
ST25 ST25047 ScrappedQtyOR X_NUMERIC 12 20 8 Scrapped Qty sales units
ST25 ST25048 ScrapDate DATE 8 0 0 Scrap Date
ST25 ST25049 QtySalesUnitcode INTEGER 4 0 0 Qty Sales Unit code
ST25 ST25050 PriceType INTEGER 1 0 0 Price Type
ST25 ST25051 PriceList STRING 2 2 0 Price List
ST25 ST25052 PricePerTimeUnitCCU MONEY 20 28 8 Price per time unit (CCU)
ST25 ST25053 TimeUnit INTEGER 2 0 0 Time Unit
ST25 ST25054 ContractCurrency STRING 2 2 0 Contract Currency
ST25 ST25055 InvoiceCurrency STRING 2 2 0 Invoice Currency
ST25 ST25056 NetLineAmntCapPartICU MONEY 20 28 8 Net Line Amount / Capital part (ICU)
ST25 ST25057 NetLineAmntCapPartLCU MONEY 20 28 8 Net Line Amount / Capital part (LCU)
ST25 ST25058 ChangeValueInterestICU MONEY 20 28 8 Change Value / Interest part (ICU)
ST25 ST25059 ChangeValueInterestLCU MONEY 20 28 8 Change Value / Interest part (LCU)
ST25 ST25060 TotalLineDiscICU MONEY 20 28 8 Total line discount (ICU)
ST25 ST25061 TotalLineDiscLCU MONEY 20 28 8 Total line discount (LCU)
ST25 ST25062 TotalLineCostLCU MONEY 20 28 8 Total line cost (LCU)
ST25 ST25063 AccString ACCSTR 120 120 0 Accounting string
ST25 ST25064 IncludedFixPrice SWITCH 1 1 0 Included into fixed price