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 SM45 SM45001 ServiceOrder STRING 10 10 0 Service Order
2 SM45 SM45002 ItemNo STRING 4 4 0 Service Order Line Number
SM45 SM45003 LineType STRING 1 1 0 Line Type 0 - Normal material line
5 - Linked picture
9 - Text line
SM45 SM45004 StockCode STRING 35 35 0 Stock Item Code
SM45 SM45005 DescrLine1 VSTRING 25 25 0 Description Line 1
SM45 SM45006 DescrLine2 VSTRING 25 25 0 Description Line 2
SM45 SM45007 SPARE MONEY 20 28 8 SPARE
SM45 SM45008 SellingPriMultip X_NUMERIC 10 18 8 Selling Price Multiplier
SM45 SM45009 QtyUnitInDelivery X_NUMERIC 10 18 8 Items per Package (Purchase)
SM45 SM45010 UnitCostPriceLCU MONEY 20 28 8 Unit Cost Price (Local Currency)
SM45 SM45011 CostPriMultiplie X_NUMERIC 10 18 8 Cost Price Multiplier
SM45 SM45012 QtyUnitOutDelivery X_NUMERIC 10 18 8 Items per Package (Sales)
SM45 SM45013 CustomerDisc X_NUMERIC 7 15 8 Customer Discount %
SM45 SM45014 VolumeDiscount X_NUMERIC 7 15 8 Volume Discount %
SM45 SM45015 UnitCode INTEGER 4 0 0 Unit Code
SM45 SM45016 QtyPlanedUse X_NUMERIC 12 20 8 Quantity Planned (Order Unit)
SM45 SM45017 QtyUsedShipp X_NUMERIC 12 20 8 Quantity Delivered (Order Unit)
SM45 SM45018 DeliveryDate DATE 8 0 0 Delivery Date Actual
SM45 SM45019 VATCode1 STRING 6 6 0 VAT Code 1
SM45 SM45020 AccCode STRING 2 2 0 Accounting Code
SM45 SM45021 Spare STRING 6 6 0 Discount Frozen
SM45 SM45022 Spare STRING 6 6 0 (obsolete)
SM45 SM45023 Spare STRING 6 6 0 (obsolete)
SM45 SM45024 Spare STRING 6 6 0 (obsolete)
SM45 SM45025 UnitPriceOCU MONEY 20 28 8 Unit Price (Order Currency)
SM45 SM45026 StatistPriceLCU MONEY 20 28 8 Statistical Price (Local Currency)
SM45 SM45027 StatistDiscount X_NUMERIC 7 15 8 Statistical Discount %
SM45 SM45028 StatCostPriceLCU MONEY 20 28 8 Statistical Cost Price (Local Currency)
SM45 SM45029 WIPTransactionLCU MONEY 20 28 8 WIP Transaction
SM45 SM45030 CurrExchRate X_NUMERIC 20 28 8 Currency Exchange Rate
SM45 SM45031 PlanDateCommit DATE 8 0 0 Delivery Date Committed
SM45 SM45032 InclFixPrice SWITCH 1 1 0 Included in Fixed Price
SM45 SM45033 Spare DATE 8 0 0 (obsolete)
SM45 SM45034 QtyAllocatedUsed X_NUMERIC 12 20 8 Quantity Allocated (Order Unit)
SM45 SM45035 StockStatus INTEGER 1 0 0 Stock Item Status
SM45 SM45036 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.
5 SM45 SM45037 WarehouseNo STRING 6 6 0 Warehouse
SM45 SM45038 PurchOrdNo STRING 10 10 0 Purchase Order Number
SM45 SM45039 PurchOrdLine STRING 12 12 0 Purchase Order Line Number
SM45 SM45040 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
SM45 SM45041 CustCodeInv STRING 10 10 0 Customer Code Invoice
SM45 SM45042 InvoiceDate DATE 8 0 0 Invoice Date
6 SM45 SM45043 InvoiceNo STRING 15 15 0 Invoice Number
SM45 SM45044 StructureFlag SWITCH 1 1 0 Has Sub-items in structure
SM45 SM45045 Spare STRING 6 6 0 (obsolete)
SM45 SM45046 Spare STRING 10 10 0 (obsolete)
SM45 SM45047 ExtServStatist STRING 15 15 0 External Statistical Number
SM45 SM45048 ProductCode VSTRING 35 35 0 Product code
SM45 SM45049 Module VSTRING 35 35 0 Module
SM45 SM45050 Position VSTRING 7 7 0 Position
SM45 SM45051 MaterialCode VSTRING 35 35 0 Material Code
SM45 SM45052 FaultCode VSTRING 7 7 0 Error Code
SM45 SM45053 QtyIssuedShipped X_NUMERIC 12 20 8 Quantity Lent to Engineer (Order Unit)
SM45 SM45054 OrderCurrency STRING 2 2 0 Currency Code Order
SM45 SM45055 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.
SM45 SM45056 PricelistNo STRING 2 2 0 Price List
SM45 SM45057 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
SM45 SM45058 AccString ACCSTR 120 120 0 Accounting String
SM45 SM45059 FieldEngineer STRING 10 10 0 Resource Code Engineer
SM45 SM45060 InvoiceCurrency STRING 2 2 0 Currency Code Invoice
3 SM45 SM45061 StructLineNo STRING 6 6 0 Service Order Sub-line Number
SM45 SM45062 VATCode2 STRING 6 6 0 VAT Code 2
SM45 SM45063 NetWeightOR X_NUMERIC 10 18 8 Net Weight
SM45 SM45064 GrossWghtOR X_NUMERIC 10 18 8 Gross Weight
SM45 SM45065 VolumeOR X_NUMERIC 10 18 8 Volume
SM45 SM45066 WIPWHID STRING 6 6 0 Warehouse WIP
SM45 SM45067 WIPBinNo STRING 6 6 0 Bin WIP
SM45 SM45068 QtyPlanIssSC X_NUMERIC 12 20 8 Quantity Planned Issue (Stock Unit)
SM45 SM45069 QtyAlloIssSC X_NUMERIC 12 20 8 Quantity Allocated Issue (Stock Unit)
SM45 SM45070 QtyIssueSC X_NUMERIC 12 20 8 Quantity Issued (Stock Unit)
SM45 SM45071 PlanIssuDate DATE 8 0 0 Date Planned Issue to Engineer
SM45 SM45072 IssueDate DATE 8 0 0 Date Issued to Engineer
SM45 SM45073 StatusIssue STRING 6 6 0 Issue Status
SM45 SM45074 QtyPlanReturn X_NUMERIC 12 20 8 Quantity Planned Returns (Stock Unit)
SM45 SM45075 QtyAllocReturn X_NUMERIC 12 20 8 Quantity Allocated Returns (Stock Unit)
SM45 SM45076 QtyReturnRec X_NUMERIC 12 20 8 Quantity Bad Returned (Stock Unit)
SM45 SM45077 PlanRetuDate DATE 8 0 0 Date Planned Return
SM45 SM45078 ReturnDate DATE 8 0 0 Date Returned Bad Items
SM45 SM45079 StatusReturn STRING 6 6 0 Return Status
SM45 SM45080 Spare X_NUMERIC 10 18 8 Spare
SM45 SM45081 QtyPlanUsage X_NUMERIC 12 20 8 Quantity Planned (Stock Unit)
SM45 SM45082 QtyAllocUsage X_NUMERIC 12 20 8 Quantity Allocated (Stock Unit)
SM45 SM45083 QtyUsedShip X_NUMERIC 12 20 8 Quantity Delivered (Stock Unit)
SM45 SM45084 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.
SM45 SM45085 MaterialPicking STRING 10 10 0 Materials Picking Note Number
SM45 SM45086 Spare INTEGER 1 0 0 BOM Blocked for Processing
SM45 SM45087 Spare STRING 10 10 0 (obsolete)
SM45 SM45088 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.
SM45 SM45089 ReturnNoteNo VSTRING 20 20 0 Return Note Number
SM45 SM45090 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.
SM45 SM45091 QtyDeallocUsage X_NUMERIC 12 20 8 Quantity Bad Returned (Order Unit)
SM45 SM45092 IncludedInCurrencyClause INTEGER 1 0 0 Included in Currency Clause
SM45 SM45093 Spare STRING 2 2 0 (obsolete)
SM45 SM45094 DeliveryFlag INTEGER 1 0 0 Delivery Flag
SM45 SM45095 SPARE MONEY 20 28 8 SPARE
SM45 SM45096 QtityReturn X_NUMERIC 12 20 8 Quantity Returned from Engineer (Stock Unit)
SM45 SM45097 DateReturn DATE 8 0 0 Date Returned Good Items
SM45 SM45098 DefectWHCode VSTRING 6 6 0 Warehouse Bad Items
SM45 SM45099 InvQtyORUnit X_NUMERIC 12 20 8 Quantity Invoices (Order Unit)
SM45 SM45100 Spare X_NUMERIC 12 20 8 Spare
SM45 SM45101 StatusSwitch0 SWITCH 1 1 0 Line Status 1
SM45 SM45102 StatusSwitch1 SWITCH 1 1 0 Line Status 2
SM45 SM45103 StatusSwitch2 SWITCH 1 1 0 Line Status 3
SM45 SM45104 StatusSwitch3 SWITCH 1 1 0 Line Status 4
SM45 SM45105 StatusSwitch4 SWITCH 1 1 0 Line Status 5
SM45 SM45106 StatusSwitch5 SWITCH 1 1 0 Marked for Invoice
4 SM45 SM45107 SubStrLinNo STRING 6 6 0 Service Order Child-line Number
SM45 SM45108 HasSubItem SWITCH 1 1 0 Is Parent
SM45 SM45109 Predecessors STRING 150 150 0 Predecessors MS Project Reserved for use when integrating with MS project
SM45 SM45110 JobNo STRING 6 6 0 Job Number
SM45 SM45111 CheckListID STRING 10 10 0 Check List ID
SM45 SM45112 FlagCreatedByJob SWITCH 1 1 0 Was Created from Job
SM45 SM45113 DropShipmentLine INTEGER 1 0 0 Drop Shipment Line
SM45 SM45114 NodeID_BOM_SM STRING 38 38 0 BoM Node ID Service Order
SM45 SM45115 NodeID_BOM_SC STRING 38 38 0 BoM Node ID Stock
SM45 SM45116 DiscountGroupNo INTEGER 10 0 0 Discount Group
SM45 SM45117 DiscountSchemaCode INTEGER 9 0 0 Discount Schema Code
SM45 SM45118 DatePricingOn DATE 8 0 0 Discount Date
SM45 SM45119 CustomICURate SWITCH 1 1 0 Use Custom Invoice Currency Rate
SM45 SM45120 CustomICUExchRate1 X_NUMERIC 15 23 8 Custom Invoice Currency Exchange Rate 1
SM45 SM45121 CustomICUExchRate2 X_NUMERIC 15 23 8 Custom Invoice Currency Exchange Rate 2
SM45 SM45122 CustomICUExchRateAlg STRING 3 3 0 Custom Invoice Currency Exchange Rate Algorithm
SM45 SM45123 OperationTypeMaterial VSTRING 10 10 0 Operation Type Material
SM45 SM45124 FinancialOperationCodeMaterial VSTRING 10 10 0 Financial Operation Code Material
SM45 SM45125 LineGroup VSTRING 6 6 0 Line Group
SM45 SM45126 Depreciation SWITCH 1 1 0 Depreciation
SM45 SM45127 Asset VSTRING 35 35 0 Asset
SM45 SM45128 ExecutionLineType INTEGER 1 0 0 ExecutionLineType
SM45 SM45129 SoldQty X_NUMERIC 12 20 8 Sold Qty
SM45 SM45130 SoldQtySC X_NUMERIC 12 20 8 Sold Qty SC
SM45 SM45131 SalesDate DATE 8 0 0 Sales Date
SM45 SM45132 DisposalCode VSTRING 6 6 0 Disposal Code
SM45 SM45133 ReasonCode STRING 3 3 0 Reason Code
SM45 SM45134 DispatchNote VSTRING 20 20 0 Dispatch Note
SM45 SM45135 QtyInvoicedOR X_NUMERIC 12 20 8 Quantity that has been Invoiced (Order Unit) for exec lines
SM45 SM45136 Spare X_NUMERIC 12 20 8 Spare
SM45 SM45137 JobID INTEGER 9 0 0 Job ID
SM45 SM45138 DeliveryBlocked INTEGER 1 0 0 Delivery blocked
SM45 SM45139 ItemType INTEGER 1 0 0 ItemType
SM45 SM45140 LineGUID VSTRING 36 36 0 Line GUID
SM45 SM45141 ApprovedCreditLimit SWITCH 1 1 0 Approved Credit Limit
SM45 SM45142 NomenclatureNumber VSTRING 25 25 0 Nomenclature Number
SM45 SM45143 ProductTaxType VSTRING 10 10 0 Product Tax Type
SM45 SM45144 LineFreightAmountOCU MONEY 20 28 8 Line Freight Amount OCU
SM45 SM45145 LineFreightAmountICU MONEY 20 28 8 Line Freight Amount ICU
SM45 SM45146 EntryInvoiceNo VSTRING 15 15 0 Entry Invoice No
7 SM45 SM45147 InvPlanLineNo STRING 6 6 0 InvPlanLineNo
SM45 SM45148 ReturnWH VSTRING 6 6 0 Return WH
SM45 SM45149 TaxationReasonCode STRING 3 3 0 Taxation Reason Code