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 SM07 SM07001 ServiceOrder STRING 10 10 0 Service Order
2 SM07 SM07002 ItemNo STRING 4 4 0 Service Order Line Number
SM07 SM07003 LineType STRING 1 1 0 Line Type 0 - Normal material line
5 - Linked picture
9 - Text line
SM07 SM07004 StockCode STRING 35 35 0 Stock Item Code
SM07 SM07005 DescrLine1 VSTRING 25 25 0 Description Line 1
SM07 SM07006 DescrLine2 VSTRING 25 25 0 Description Line 2
SM07 SM07007 SPARE MONEY 20 28 8 SPARE
SM07 SM07008 SellingPriMultip X_NUMERIC 10 18 8 Selling Price Multiplier
SM07 SM07009 QtyUnitInDelivery X_NUMERIC 10 18 8 Items per Package (Purchase)
SM07 SM07010 UnitCostPriceLCU MONEY 20 28 8 Unit Cost Price (Local Currency)
SM07 SM07011 CostPriMultiplie X_NUMERIC 10 18 8 Cost Price Multiplier
SM07 SM07012 QtyUnitOutDelivery X_NUMERIC 10 18 8 Items per Package (Sales)
SM07 SM07013 CustomerDisc X_NUMERIC 7 15 8 Customer Discount %
SM07 SM07014 VolumeDiscount X_NUMERIC 7 15 8 Volume Discount %
SM07 SM07015 UnitCode INTEGER 4 0 0 Unit Code
SM07 SM07016 QtyPlanOR X_NUMERIC 12 20 8 Quantity Planned (Order Unit)
SM07 SM07017 QtyDeliveryOR X_NUMERIC 12 20 8 Quantity Delivered (Order Unit)
SM07 SM07018 DeliveryDate DATE 8 0 0 Delivery Date Actual
SM07 SM07019 VATCode1 STRING 6 6 0 VAT Code 1
SM07 SM07020 AccCode STRING 2 2 0 Accounting Code
SM07 SM07021 Spare STRING 6 6 0 Discount Frozen
SM07 SM07022 Spare STRING 6 6 0 (obsolete)
SM07 SM07023 Spare STRING 6 6 0 (obsolete)
SM07 SM07024 Spare STRING 6 6 0 (obsolete)
SM07 SM07025 UnitPriceOCU MONEY 20 28 8 Unit Price (Order Currency)
SM07 SM07026 StatistPriceLCU MONEY 20 28 8 Statistical Price (Local Currency)
SM07 SM07027 StatistDiscount X_NUMERIC 7 15 8 Statistical Discount %
SM07 SM07028 StatCostPriceLCU MONEY 20 28 8 Statistical Cost Price (Local Currency)
SM07 SM07029 WIPTransactionLCU MONEY 20 28 8 WIP Transaction
SM07 SM07030 CurrExchRate X_NUMERIC 20 28 8 Currency Exchange Rate
SM07 SM07031 PlanDate DATE 8 0 0 Delivery Date Committed
SM07 SM07032 InclFixPrice SWITCH 1 1 0 Included in Fixed Price
SM07 SM07033 Spare DATE 8 0 0 (obsolete)
SM07 SM07034 QtyAllocatedOR X_NUMERIC 12 20 8 Quantity Allocated (Order Unit)
SM07 SM07035 StockStatus INTEGER 1 0 0 Stock Item Status
SM07 SM07036 ShipmentRule STRING 1 1 0 Delivery Rule 0 - No test of the stock balance.
1 - Test on positive stock balance .
2 - Closed stock item, blocked orders.
3 - Direct delivery from supplier to customer.
4 - No over delivery.
5 - Back-delivery to purchase control.
SM07 SM07037 WarehouseNo STRING 6 6 0 Warehouse
SM07 SM07038 PurchOrdNo STRING 10 10 0 Purchase Order Number
SM07 SM07039 PurchOrdLine STRING 12 12 0 Purchase Order Line Number
SM07 SM07040 PurchOrdShipp SWITCH 1 1 0 Purchase Order Status 0 - Purchase order line created
1 - Purchase order printed
2 - Purchase order line confirmed
3 - Delivery entered for purchase order line
SM07 SM07041 CustCodeInv STRING 10 10 0 Customer Code Invoice
SM07 SM07042 InvoiceDate DATE 8 0 0 Invoice Date
SM07 SM07043 InvoiceNo STRING 15 15 0 Invoice Number
SM07 SM07044 StructureFlag SWITCH 1 1 0 Has Sub-items in structure
SM07 SM07045 Spare STRING 6 6 0 (obsolete)
SM07 SM07046 Spare STRING 10 10 0 (obsolete)
SM07 SM07047 ExtServStatist STRING 15 15 0 External Statistical Number
SM07 SM07048 ProductCode VSTRING 35 35 0 Product code
SM07 SM07049 Module VSTRING 35 35 0 Module
SM07 SM07050 Position VSTRING 7 7 0 Position
SM07 SM07051 MaterialCode VSTRING 35 35 0 Material Code
SM07 SM07052 FaultCode VSTRING 7 7 0 Error Code
SM07 SM07053 QtyLentOR X_NUMERIC 12 20 8 Quantity Lent to Engineer (Order Unit)
SM07 SM07054 OrderCurrency STRING 2 2 0 Currency Code Order
SM07 SM07055 FLAGInvUpdate 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.
SM07 SM07056 PricelistNo STRING 2 2 0 Price List
SM07 SM07057 ChangeCustFlag 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
SM07 SM07058 AccString ACCSTR 120 120 0 Accounting String
SM07 SM07059 FieldEngineer STRING 10 10 0 Resource Code Engineer
SM07 SM07060 InvoiceCurrency STRING 2 2 0 Currency Code Invoice
3 SM07 SM07061 StructLineNo STRING 6 6 0 Service Order Sub-line Number
SM07 SM07062 VATCode2 STRING 6 6 0 VAT Code 2
SM07 SM07063 NetWeightOR X_NUMERIC 10 18 8 Net Weight
SM07 SM07064 GrossWghtOR X_NUMERIC 10 18 8 Gross Weight
SM07 SM07065 VolumeOR X_NUMERIC 10 18 8 Volume
SM07 SM07066 WIPWHID STRING 6 6 0 Warehouse WIP
SM07 SM07067 WIPBinNo STRING 6 6 0 Bin WIP
SM07 SM07068 QtyPlanIssSC X_NUMERIC 12 20 8 Quantity Planned Issue (Stock Unit)
SM07 SM07069 QtyAlloIssSC X_NUMERIC 12 20 8 Quantity Allocated Issue (Stock Unit)
SM07 SM07070 QtyLentSC X_NUMERIC 12 20 8 Quantity Issued (Stock Unit)
SM07 SM07071 PlanIssuDate DATE 8 0 0 Date Planned Issue to Engineer
SM07 SM07072 LentDate DATE 8 0 0 Date Issued to Engineer
SM07 SM07073 StatusIssue STRING 6 6 0 Issue Status
SM07 SM07074 QtyGoodReturnSC X_NUMERIC 12 20 8 Quantity Planned Returns (Stock Unit)
SM07 SM07075 QtyAllocReturn X_NUMERIC 12 20 8 Quantity Allocated Returns (Stock Unit)
SM07 SM07076 QtyBadReturnSC X_NUMERIC 12 20 8 Quantity Bad Returned (Stock Unit)
SM07 SM07077 PlanRetuDate DATE 8 0 0 Date Planned Return
SM07 SM07078 BadReturnDate DATE 8 0 0 Date Returned Bad Items
SM07 SM07079 StatusReturn STRING 6 6 0 Return Status
SM07 SM07080 Spare X_NUMERIC 10 18 8 Spare
SM07 SM07081 QtyPlanSC X_NUMERIC 12 20 8 Quantity Planned (Stock Unit)
SM07 SM07082 QtyAllocatedSC X_NUMERIC 12 20 8 Quantity Allocated (Stock Unit)
SM07 SM07083 QtyDeliverySC X_NUMERIC 12 20 8 Quantity Delivered (Stock Unit)
SM07 SM07084 DocFlagMatPick INTEGER 1 0 0 Material Picking List Print Status 0/1 - Material picking list will be sent for the order line
2 - Material picking list has been sent for the order line.
SM07 SM07085 MaterialPicking STRING 10 10 0 Materials Picking Note Number
SM07 SM07086 Spare INTEGER 1 0 0 BOM Blocked for Processing
SM07 SM07087 Spare STRING 10 10 0 (obsolete)
SM07 SM07088 DocflRetNote INTEGER 1 0 0 Return Note Print Status 0/1 - Return note will be sent for the order line
2 - Return note has been sent for the order line.
SM07 SM07089 ReturnNoteNo VSTRING 20 20 0 Return Note Number
SM07 SM07090 FlagExchRule INTEGER 1 0 0 Exchange Rule 0 - No test is performed for exchange items.
1 - Test for exchange items is performed when releasing the service orders.
2 - Exchange item must be in stock before releasing the service orders.
SM07 SM07091 QtyBadReturnOR X_NUMERIC 12 20 8 Quantity Bad Returned (Order Unit)
SM07 SM07092 IncludedInCurrencyClause INTEGER 1 0 0 Included in Currency Clause
SM07 SM07093 Spare STRING 2 2 0 (obsolete)
SM07 SM07094 DeliveryFlag INTEGER 1 0 0 Delivery Flag
SM07 SM07095 SPARE MONEY 20 28 8 SPARE
SM07 SM07096 QtyGoodReturnOR X_NUMERIC 12 20 8 Quantity Returned from Engineer (Stock Unit)
SM07 SM07097 GoodReturnDate DATE 8 0 0 Date Returned Good Items
SM07 SM07098 DefectWHCode VSTRING 6 6 0 Warehouse Bad Items
SM07 SM07099 QtyInvoiceOR X_NUMERIC 12 20 8 Quantity Invoices (Order Unit)
SM07 SM07100 Spare X_NUMERIC 12 20 8 Spare
SM07 SM07101 StatusSwitch0 SWITCH 1 1 0 Line Status 1
SM07 SM07102 StatusSwitch1 SWITCH 1 1 0 Line Status 2
SM07 SM07103 StatusSwitch2 SWITCH 1 1 0 Line Status 3
SM07 SM07104 StatusSwitch3 SWITCH 1 1 0 Line Status 4
SM07 SM07105 StatusSwitch4 SWITCH 1 1 0 Line Status 5
SM07 SM07106 StatusSwitch5 SWITCH 1 1 0 Marked for Invoice
4 SM07 SM07107 SubStrLinNo STRING 6 6 0 Service Order Child-line Number
SM07 SM07108 ParentRChild SWITCH 1 1 0 Is Parent
SM07 SM07109 Predecessors STRING 150 150 0 Predecessors MS Project Reserved for use when integrating with MS project
SM07 SM07110 JobNo STRING 6 6 0 Job Number
SM07 SM07111 CheckLineID STRING 10 10 0 Check List ID
SM07 SM07112 FlagCreatedbyJobOrder SWITCH 1 1 0 Was Created from Job
SM07 SM07113 DropShipmentLine INTEGER 1 0 0 Drop Shipment Line
SM07 SM07114 NodeID_BOM_SM STRING 38 38 0 BoM Node ID Service Order
SM07 SM07115 NodeID_BOM_SC STRING 38 38 0 BoM Node ID Stock
SM07 SM07116 DiscountGroupNo INTEGER 10 0 0 Discount Group
SM07 SM07117 DiscountSchemaCode INTEGER 9 0 0 Discount Schema Code
SM07 SM07118 DatePricingOn DATE 8 0 0 Discount Date
SM07 SM07119 CustomICURate SWITCH 1 1 0 Use Custom Invoice Currency Rate
SM07 SM07120 CustomICUExchRate1 X_NUMERIC 15 23 8 Custom Invoice Currency Exchange Rate 1
SM07 SM07121 CustomICUExchRate2 X_NUMERIC 15 23 8 Custom Invoice Currency Exchange Rate 2
SM07 SM07122 CustomICUExchRateAlg STRING 3 3 0 Custom Invoice Currency Exchange Rate Algorithm
SM07 SM07123 OperationTypeMaterial VSTRING 10 10 0 Operation Type Material
SM07 SM07124 FinancialOperationCodeMaterial VSTRING 10 10 0 Financial Operation Code Material
SM07 SM07125 LineGroup VSTRING 6 6 0 Line Group
SM07 SM07126 Depreciation SWITCH 1 1 0 Depreciation
SM07 SM07127 Asset VSTRING 35 35 0 Asset
SM07 SM07128 ExecutionLineType INTEGER 1 0 0 ExecutionLineType
SM07 SM07129 SoldQty X_NUMERIC 12 20 8 Sold Qty
SM07 SM07130 SoldQtySC X_NUMERIC 12 20 8 Sold Qty SC
SM07 SM07131 SalesDate DATE 8 0 0 Sales Date
SM07 SM07132 DisposalCode VSTRING 6 6 0 Disposal Code
SM07 SM07133 ReasonCode STRING 3 3 0 Reason Code
SM07 SM07134 DispatchNote VSTRING 20 20 0 Dispatch Note
SM07 SM07135 QtyInvoicedOR X_NUMERIC 12 20 8 Quantity that has been Invoiced (Order Unit) for exec lines
SM07 SM07136 Spare X_NUMERIC 12 20 8 Spare
SM07 SM07137 JobID INTEGER 9 0 0 Job ID
SM07 SM07138 DeliveryBlocked INTEGER 1 0 0 Delivery blocked
SM07 SM07139 ItemType INTEGER 1 0 0 ItemType
SM07 SM07140 LineGUID VSTRING 36 36 0 Line GUID
SM07 SM07141 ApprovedCreditLimit SWITCH 1 1 0 Approved Credit Limit
SM07 SM07142 NomenclatureNumber VSTRING 25 25 0 Nomenclature Number
SM07 SM07143 ProductTaxType VSTRING 10 10 0 Product Tax Type
SM07 SM07144 LineFreightAmountOCU MONEY 20 28 8 Line Freight Amount OCU
SM07 SM07145 LineFreightAmountICU MONEY 20 28 8 Line FreightAmount ICU
SM07 SM07146 EntryInvoiceNo VSTRING 15 15 0 Entry Invoice No
SM07 SM07147 InvPlanLineNo STRING 6 6 0 InvPlanLineNo
SM07 SM07148 ReturnWH VSTRING 6 6 0 Return WH
SM07 SM07149 TaxationReasonCode STRING 3 3 0 Taxation Reason Code