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
ORT1 Sales Order Tax Transactions Company ORT10100
SM01 Service Order Master Table Company SM010100
SM02 Service Order Status History Company SM020100
SM03 Service Order Activity Lines Company SM030100
SM04 Service Order Invoice Customers Company SM040100
SM05 Service Order Cost Lines Company SM050100
SM06 Service Order Delivery Lines Company SM060100
SM07 Service Order Material Lines Company SM070100
SM08 Service Order Internal Invoice Summary Company SM080100
SM09 Service Order Text Storage Company SM090100
SM10 Service Order Type Parameter Company SM100100
SM23 Service Order Planning Calendar Company SM230100
SM24 Service Order Activities Company SM240100
SM25 Service Order Activity & Cost Prices Company SM250100
SM26 Service Order Parameters Company SM260100
SM27 Service Order Document Texts (not used) Company SM270100
SM28 Service Order Phrase Texts Company SM280100
SM29 Service Order Templates Company SM290100
SM2A Service Order Material Lead Time Details History Company SM2A0100
SM2D Service Order Activity Descriptions Company SM2D0100
SM30 WIP Transaction Control Table Company SM300100
SM32 Service Job Description Company SM320100
SM33 Company Year SM330112
SM37 Service Order Pager Company SM370100
SM38 Standard Accessories Company SM380100
SM39 Accounting Rules Company SM390100
SM3H Company SM3H0100
SM3L Service Order Material Lead Time Details Company SM3L0100
SM3T Service Job Description Texts Company SM3T0100
SM41 Service Order Head History Company SM410100
SM42 History Service Order Status History Company SM420100
SM43 Service Order Activity Lines History Company SM430100
SM44 Service Order Cost Lines History Company SM440100
SM45 Service Order Material Lines History Company SM450100
SM46 Service Management Texts History Company SM460100
SM47 Service Order Delivery Lines History Company SM470100
SM48 Service Order Invoice Customers History Company SM480100
SM50 Warranty Extension Company SM500100
SM51 Service Order Discount Lines Company SM510100
SM52 Service Order Discount Lines History Company SM520100
SM61 Service Order Error Key (not used) Company SM610100
SM62 Service Order Errors (not used) Company SM620100
SM63 Service Order Automatic Accounting Coding Schedule Company Year SM630112
SM64 Company Year SM640112
SM68 Service Order External Program List Company SM680100
SM72 Service Invoice Sort File Company SM720100
SM73 Picking Locations Company SM730100
SM74 Picking Locations Lines Company SM740100
SM80 Help Desk Header Company SM800100
SM81 Help Desk Solution Code Company SM810100
SM82 Help Desk Instructions Company SM820100
SM83 Service Order User Def Tables (not used) Company SM830100
SM84 Service Order User Def Fields (not used) Company SM840100
SM90 Service Order Image Implementation Company SM900100
SM91 WIP Labour History Company SM910100
SM92 WIP Cost History Company SM920100
SM93 WIP Material History Company SM930100
SM94 Export Document Parameters Company SM940100
SM95 Service Order Transport Document Parameters Company SM950100
SM96 Service Order Transport Documents Company SM960100
SM97 Master Suborder Link Table Company SM970100
SM98 Master Suborder Links History Company SM980100
SMAC Work file for accounting summary Company SMAC0100
SMB1 Service Order BOM Node Company SMB10100
SMB2 Service BOM Node Name Company SMB20100
SMB3 Service Order BOM Link Company SMB30100
SMB4 Service Order BOM Branch Company SMB40100
SMC1 Check List Company SMC10100
SMC2 Check List Lines Company SMC20100
SMD0 Drop Shipment Templates Company SMD00100
SMD2 Service Order Drop Shipment Lines Company SMD20100
SMD3 Service Order Drop Shipment Lines History Company SMD30100
SMDW Work File for Documents Company SMDW0100
SMEX Extended Order Header Company SMEX0100
SMF2 Filter Shop Company SMF20100
SMH1 Service Order BOM Nodes History Company SMH10100
SMH2 Service Order BOM Node Names History Company SMH20100
SMH3 Service Order BOM Links History Company SMH30100
SMH4 Service Order BOM Branches History Company SMH40100
SMHA Service Order Cost and Time History Transactions Company SMHA0100
SMHM Service Order Material History Transactions Company SMHM0100
SMHS Company SMHS0100
SMI2 Service Order Instalment Lines Company SMI20100
SMI4 Service Order Instalment Lines History Company SMI40100
SMMT Business Transaction Type Service Order Mapping Company SMMT0100
SMP1 Preventive Maintenance Plan Company SMP10100
SMP2 Exception Pricing Plan Company SMP20100
SMP3 Actual Usage Company SMP30100
SMP4 Preventive Maintenance Proposal Company SMP40100
SMP5 Exceptional Invoicing Proposal Company SMP50100
SMP6 Conflicting Jobs Company SMP60100
SMT3 Service Order Activity Line Texts Company SMT30100
SMT5 Service Order Cost Line Texts Company SMT50100
SMT7 Service Order Material Line Texts Company SMT70100
SMTA Service Order Cost and Time Transactions Company SMTA0100
SMTM Service Order Material Transactions Company SMTM0100
SMU3 Service Order Activity Line Texts History Company SMU30100
SMU4 Service Order Cost Line Texts History Company SMU40100
SMU5 Service Order Material Line Texts History Company SMU50100
SMUW Mass Update Work file SMUW0000
SMX2 Work File for Time Planning Company SMX20100
SMX3 Work File for Closing Service Invoices Company SMX30100
SMXX Work File for External Update Company SMXX0100
SYS3 Selection Form Template Company SYS30100

Fields
PK Table Name Description Type Length Precision Note
1 SM44 SM44001 ServiceOrdNo STRING 10 10 0 Service Order
2 SM44 SM44002 ItemNo STRING 4 4 0 Order Line Number
SM44 SM44003 LineType STRING 1 1 0 Line Type 0 - Normal activity line
5 - Linked picture
9 - Text line
SM44 SM44004 CostCode STRING 8 8 0 Cost Activity Code
SM44 SM44005 Description VSTRING 35 35 0 Description
SM44 SM44006 SPARE MONEY 20 28 8 SPARE
SM44 SM44007 SPARE MONEY 20 28 8 SPARE
SM44 SM44008 BudgCostLCU MONEY 20 28 8 Unit Cost Planned (Local Currency)
SM44 SM44009 ActuCostLCU MONEY 20 28 8 Unit Cost Actual (Local Currency)
SM44 SM44010 PropInvAmntOcu MONEY 20 28 8 Unit Price Proposed for Invoice (Invoice Currency)
SM44 SM44011 ActuInvAmntOcu MONEY 20 28 8 Unit Price Actual Invoiced (Invoice Currency)
SM44 SM44012 VATCode1 STRING 6 6 0 VAT Code 1
SM44 SM44013 AccCode STRING 2 2 0 Accounting Code
SM44 SM44014 Spare STRING 6 6 0 (obsolete)
SM44 SM44015 Spare STRING 6 6 0 (obsolete)
SM44 SM44016 Spare STRING 6 6 0 (obsolete)
SM44 SM44017 InclFixedPr SWITCH 1 1 0 Included in Fixed Price
SM44 SM44018 CustCodeInv STRING 10 10 0 Customer Code Invoice
SM44 SM44019 InvoiceDate DATE 8 0 0 Invoice Date
3 SM44 SM44020 InvoiceNo STRING 15 15 0 Invoice Number
SM44 SM44021 PlannedPriceOCU MONEY 20 28 8 Unit Price Planned (Order Currency)
SM44 SM44022 TransactDate DATE 8 0 0 Transaction Date
SM44 SM44023 PlannedQty X_NUMERIC 12 20 8 Quantity Planned
SM44 SM44024 ActualQty X_NUMERIC 12 20 8 Quantity Actual
SM44 SM44025 DiscountCosts X_NUMERIC 7 15 8 Discount %
SM44 SM44026 PricelistNo STRING 2 2 0 Price List
SM44 SM44027 ChangeInvCustomer SWITCH 1 1 0 Calculate Price Option used internally to indicate if price needs to be recalculated on the cost line.
1 - The price on the cost line has not been recalculated after change of customer
2 - The price on the cost line has already been calculated for the customer on the order line
SM44 SM44028 FldEngineer STRING 10 10 0 Resource Code Engineer
SM44 SM44029 InvQtyNew X_NUMERIC 12 20 8 Quantity to Invoice
SM44 SM44030 InvUpdStatus INTEGER 1 0 0 Invoice Status 0/1 - The line has not been sent on a invoice
2 - The activity line has been sent/included in a invoice.
SM44 SM44031 InvCurrencyCode STRING 2 2 0 Currency Code Invoice
SM44 SM44032 AccString ACCSTR 120 120 0 Accounting String
SM44 SM44033 VATCode2 STRING 6 6 0 VAT Code 2
SM44 SM44034 CostDate DATE 8 0 0 Cost Date
SM44 SM44035 CostTime X_NUMERIC 5 13 8 Cost Time
SM44 SM44036 IncludedInCurrencyClause INTEGER 1 0 0 Included in Currency Clause
SM44 SM44037 OrderCurrencyCode STRING 2 2 0 Currency Code Order
SM44 SM44038 CurrExchRate X_NUMERIC 20 28 8 Currency Exchange Rate
SM44 SM44039 SPARE MONEY 20 28 8 SPARE
SM44 SM44040 ActualPriceOCU MONEY 20 28 8 Unit Price Actual (Order Currency)
SM44 SM44041 SPARE MONEY 20 28 8 SPARE
SM44 SM44042 PropInvAmountICU MONEY 20 28 8 Unit Price Proposed for Invoice (Invoice Currency)
SM44 SM44043 PropInvAmountLCU MONEY 20 28 8 Unit Price Proposed for Invoice (Local Currency)
SM44 SM44044 ActlInvAmountICU MONEY 20 28 8 Unit Price Actual Invoiced (Invoice Currency)
SM44 SM44045 ActInvAmountLCU MONEY 20 28 8 Unit Price Actual Invoiced (Local Currency)
SM44 SM44046 StatusSwitch0 SWITCH 1 1 0 Line Status 1
SM44 SM44047 StatusSwitch1 SWITCH 1 1 0 Line Status 2
SM44 SM44048 StatusSwitch2 SWITCH 1 1 0 Line Status 3
SM44 SM44049 StatusSwitch3 SWITCH 1 1 0 Line Status 4
SM44 SM44050 StatusSwitch4 SWITCH 1 1 0 Line Status 5
SM44 SM44051 StatusSwitch5 SWITCH 1 1 0 Marked for Invoice Applies only to long term order:
0 - The activity line is not marked as ready for invoice
1 - The activity line is ready for invoice
SM44 SM44052 PlanSpendDate DATE 8 0 0 Cost Date Planned
SM44 SM44053 ActualSpendDate DATE 8 0 0 Cost Date Actual
SM44 SM44054 Predecessors STRING 150 150 0 Predecessors MS Project Reserved for use when integrating with MS project
SM44 SM44055 ReportedCurrencyCode STRING 2 2 0 Currency Code Reporting
SM44 SM44056 ReportedAmountRCU MONEY 20 28 8 Reported Amount (Reporting Currency)
SM44 SM44057 LedgerInvoiceNumber STRING 25 25 0 Cost Invoice Number
SM44 SM44058 SupplierCode STRING 10 10 0 Cost Supplier Code
SM44 SM44059 GLTransNum STRING 9 9 0 General Ledger Transaction Number
SM44 SM44060 JobNo STRING 6 6 0 Job Number
SM44 SM44061 CheckLineID STRING 10 10 0 Check List ID
SM44 SM44062 FlagCreatedByJob SWITCH 1 1 0 Was Created from Job
SM44 SM44063 ExpenceAmount X_NUMERIC 13 21 8 Expense Amount (Expense Currency)
SM44 SM44064 ExpenceCurrency STRING 2 2 0 Currency Code Expense
SM44 SM44065 ExpenceDate DATE 8 0 0 Expense Date
SM44 SM44066 CustomICURate SWITCH 1 1 0 Use Custom Invoice Currency Rate
SM44 SM44067 CustomICUExchRate1 X_NUMERIC 15 23 8 Custom Invoice Currency Exchange Rate 1
SM44 SM44068 CustomICUExchRate2 X_NUMERIC 15 23 8 Custom Invoice Currency Exchange Rate 2
SM44 SM44069 CustomICUExchRateAlg STRING 3 3 0 Custom Invoice Currency Exchange Rate Algorithm
SM44 SM44070 GLUpdFlag SWITCH 1 1 0 GL Update Flag
SM44 SM44071 GLTransTxt VSTRING 25 25 0 GL Transaction Text
SM44 SM44072 OperationTypeTime VSTRING 10 10 0 Operation Type Time
SM44 SM44073 FinancialOperationCodeTime VSTRING 10 10 0 Financial Operation Code Time
SM44 SM44074 LineGroup VSTRING 6 6 0 Line Group
SM44 SM44075 JobID INTEGER 9 0 0 Job ID
SM44 SM44076 DelivNoteNo VSTRING 20 20 0 Delivery Note Number
SM44 SM44077 DeliveryBlocked INTEGER 1 0 0 Delivery blocked
SM44 SM44078 LineGUID VSTRING 36 36 0 Line GUID
SM44 SM44079 ApprovedCreditLimit SWITCH 1 1 0 Approved Credit Limit
SM44 SM44080 ConfirmedArrivalDate DATE 8 0 0 Confirmed Arrival Date Confirmed Arrival Date - 'Delivery Confirmation' functionality
4 SM44 SM44081 InvPlanLineNo STRING 6 6 0 InvPlanLineNo
SM44 SM44082 PlanedQuantity1 X_NUMERIC 12 20 8 Planed Quantity 1
SM44 SM44083 ActualQuantity1 X_NUMERIC 12 20 8 Actual Quantity 1
SM44 SM44084 PlanedQuantity2 X_NUMERIC 12 20 8 Planed Quantity 2
SM44 SM44085 ActualQuantity2 X_NUMERIC 12 20 8 Actual Quantity 2
SM44 SM44086 PlanedQuantity3 X_NUMERIC 12 20 8 Planed Quantity 3
SM44 SM44087 ActualQuantity3 X_NUMERIC 12 20 8 Actual Quantity 3
SM44 SM44088 TaxationReasonCode STRING 3 3 0 Taxation Reason Code