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 SM23 SM23001 Year_ STRING 2 2 0 Year
SM23 SM23002 StrtTimeMon1 X_NUMERIC 5 13 8 Start Time Monday 1
SM23 SM23003 StrtTimeTue1 X_NUMERIC 5 13 8 Start Time Tuesday 1
SM23 SM23004 StrtTimeWen1 X_NUMERIC 5 13 8 Start Time Wednesday 1
SM23 SM23005 StrtTimeThu1 X_NUMERIC 5 13 8 Start Time Thursday 1
SM23 SM23006 StrtTimeFri1 X_NUMERIC 5 13 8 Start Time Friday 1
SM23 SM23007 StrtTimeSat1 X_NUMERIC 5 13 8 Start Time Saturday 1
SM23 SM23008 StrtTimeSun1 X_NUMERIC 5 13 8 Start Time Sunday 1
SM23 SM23009 EndTimeMon1 X_NUMERIC 5 13 8 End Time Monday 1
SM23 SM23010 EndTimeTue1 X_NUMERIC 5 13 8 End Time Tuesday 1
SM23 SM23011 EndTimeWen1 X_NUMERIC 5 13 8 End Time Wednesday 1
SM23 SM23012 EndTimeThu1 X_NUMERIC 5 13 8 End Time Thursday 1
SM23 SM23013 EndTimeFri1 X_NUMERIC 5 13 8 End Time Friday 1
SM23 SM23014 EndTimeSat1 X_NUMERIC 5 13 8 End Time Saturday 1
SM23 SM23015 EndTimeSun1 X_NUMERIC 5 13 8 End Time Sunday 1
SM23 SM23016 StrtTimeMon2 X_NUMERIC 5 13 8 Start Time Monday 2
SM23 SM23017 StrtTimeTue2 X_NUMERIC 5 13 8 Start Time Tuesday 2
SM23 SM23018 StrtTimeWen2 X_NUMERIC 5 13 8 Start Time Wednesday 2
SM23 SM23019 StrtTimeThu2 X_NUMERIC 5 13 8 Start Time Thursday 2
SM23 SM23020 StrtTimeFri2 X_NUMERIC 5 13 8 Start Time Friday 2
SM23 SM23021 StrtTimeSat2 X_NUMERIC 5 13 8 Start Time Saturday 2
SM23 SM23022 StrtTimeSun2 X_NUMERIC 5 13 8 Start Time Sunday 2
SM23 SM23023 EndTimeMon2 X_NUMERIC 5 13 8 End Time Monday 2
SM23 SM23024 EndTimeTue2 X_NUMERIC 5 13 8 End Time Tuesday 2
SM23 SM23025 EndTimeWen2 X_NUMERIC 5 13 8 End Time Wednesday 2
SM23 SM23026 EndTimeThu2 X_NUMERIC 5 13 8 End Time Thursday 2
SM23 SM23027 EndTimeFri2 X_NUMERIC 5 13 8 End Time Friday 2
SM23 SM23028 EndTimeSat2 X_NUMERIC 5 13 8 End Time Saturday 2
SM23 SM23029 EndTimeSun2 X_NUMERIC 5 13 8 End Time Sunday 2
SM23 SM23030 StrtTimeMon3 X_NUMERIC 5 13 8 Start Time Monday 3
SM23 SM23031 StrtTimeTue3 X_NUMERIC 5 13 8 Start Time Tuesday 3
SM23 SM23032 StrtTimeWen3 X_NUMERIC 5 13 8 Start Time Wednesday 3
SM23 SM23033 StrtTimeThu3 X_NUMERIC 5 13 8 Start Time Thursday 3
SM23 SM23034 StrtTimeFri3 X_NUMERIC 5 13 8 Start Time Friday 3
SM23 SM23035 StrtTimeSat3 X_NUMERIC 5 13 8 Start Time Saturday 3
SM23 SM23036 StrtTimeSun3 X_NUMERIC 5 13 8 Start Time Sunday 3
SM23 SM23037 EndTimeMon3 X_NUMERIC 5 13 8 End Time Monday 3
SM23 SM23038 EndTimeTue3 X_NUMERIC 5 13 8 End Time Tuesday 3
SM23 SM23039 EndTimeWen3 X_NUMERIC 5 13 8 End Time Wednesday 3
SM23 SM23040 EndTimeThu3 X_NUMERIC 5 13 8 End Time Thursday 3
SM23 SM23041 EndTimeFri3 X_NUMERIC 5 13 8 End Time Friday 3
SM23 SM23042 EndTimeSat3 X_NUMERIC 5 13 8 End Time Saturday 3
SM23 SM23043 EndTimeSun3 X_NUMERIC 5 13 8 End Time Sunday 3
SM23 SM23044 NonOpPer1FrD DATE 8 0 0 None Operational Period From Date 1
SM23 SM23045 NonOpPer1ToD DATE 8 0 0 None Operational Period To Date 1
SM23 SM23046 NonOpPer2FrD DATE 8 0 0 None Operational Period From Date 2
SM23 SM23047 NonOpPer2ToD DATE 8 0 0 None Operational Period To Date 2
SM23 SM23048 NonOpPer3FrD DATE 8 0 0 None Operational Period From Date 3
SM23 SM23049 NonOpPer3ToD DATE 8 0 0 None Operational Period To Date 3
SM23 SM23050 NonOpPer4FrD DATE 8 0 0 None Operational Period From Date 4
SM23 SM23051 NonOpPer4ToD DATE 8 0 0 None Operational Period To Date 4
SM23 SM23052 NonOpPer5FrD DATE 8 0 0 None Operational Period From Date 5
SM23 SM23053 NonOpPer5ToD DATE 8 0 0 None Operational Period To Date 5
SM23 SM23054 NonOpPer6FrD DATE 8 0 0 None Operational Period From Date 6
SM23 SM23055 NonOpPer6ToD DATE 8 0 0 None Operational Period To Date 6
SM23 SM23056 NonOpPer7FrD DATE 8 0 0 None Operational Period From Date 7
SM23 SM23057 NonOpPer7ToD DATE 8 0 0 None Operational Period To Date 7
SM23 SM23058 NonOpPer8FrD DATE 8 0 0 None Operational Period From Date 8
SM23 SM23059 NonOpPer8ToD DATE 8 0 0 None Operational Period To Date 8
SM23 SM23060 NonOpPer9FrD DATE 8 0 0 None Operational Period From Date 9
SM23 SM23061 NonOpPer9ToD DATE 8 0 0 None Operational Period To Date 9
SM23 SM23062 NonOpPer10FrD DATE 8 0 0 None Operational Period From Date 10
SM23 SM23063 NonOpPer10ToD DATE 8 0 0 None Operational Period To Date 10
SM23 SM23064 NonOpPer11FrD DATE 8 0 0 None Operational Period From Date 11
SM23 SM23065 NonOpPer11ToD DATE 8 0 0 None Operational Period To Date 11
SM23 SM23066 NonOpPer12FrD DATE 8 0 0 None Operational Period From Date 12
SM23 SM23067 NonOpPer12ToD DATE 8 0 0 None Operational Period To Date 12
SM23 SM23068 NonOpPer13FrD DATE 8 0 0 None Operational Period From Date 13
SM23 SM23069 NonOpPer13ToD DATE 8 0 0 None Operational Period To Date 13
SM23 SM23070 NonOpPer14FrD DATE 8 0 0 None Operational Period From Date 14
SM23 SM23071 NonOpPer14ToD DATE 8 0 0 None Operational Period To Date 14
SM23 SM23072 NonOpPer15FrD DATE 8 0 0 None Operational Period From Date 15
SM23 SM23073 NonOpPer15ToD DATE 8 0 0 None Operational Period To Date 15
SM23 SM23074 NonOpPer16FrD DATE 8 0 0 None Operational Period From Date 16
SM23 SM23075 NonOpPer16ToD DATE 8 0 0 None Operational Period To Date 16
SM23 SM23076 Spare DATE 8 0 0 (obsolete)
SM23 SM23077 Spare DATE 8 0 0 (obsolete)
SM23 SM23078 Spare DATE 8 0 0 (obsolete)
SM23 SM23079 Spare DATE 8 0 0 (obsolete)
SM23 SM23080 Spare DATE 8 0 0 (obsolete)
SM23 SM23081 Spare DATE 8 0 0 (obsolete)
SM23 SM23082 Spare DATE 8 0 0 (obsolete)
SM23 SM23083 Spare DATE 8 0 0 (obsolete)
SM23 SM23084 NonOpPer1FrT X_NUMERIC 5 13 8 None Operational Period From Time 1
SM23 SM23085 NonOpPer1ToT X_NUMERIC 5 13 8 None Operational Period To Time 1
SM23 SM23086 NonOpPer2FrT X_NUMERIC 5 13 8 None Operational Period From Time 2
SM23 SM23087 NonOpPer2ToT X_NUMERIC 5 13 8 None Operational Period To Time 2
SM23 SM23088 NonOpPer3FrT X_NUMERIC 5 13 8 None Operational Period From Time 3
SM23 SM23089 NonOpPer3ToT X_NUMERIC 5 13 8 None Operational Period To Time 3
SM23 SM23090 NonOpPer4FrT X_NUMERIC 5 13 8 None Operational Period From Time 4
SM23 SM23091 NonOpPer4ToT X_NUMERIC 5 13 8 None Operational Period To Time 4
SM23 SM23092 NonOpPer5FrT X_NUMERIC 5 13 8 None Operational Period From Time 5
SM23 SM23093 NonOpPer5ToT X_NUMERIC 5 13 8 None Operational Period To Time 5
SM23 SM23094 NonOpPer6FrT X_NUMERIC 5 13 8 None Operational Period From Time 6
SM23 SM23095 NonOpPer6ToT X_NUMERIC 5 13 8 None Operational Period To Time 6
SM23 SM23096 NonOpPer7FrT X_NUMERIC 5 13 8 None Operational Period From Time 7
SM23 SM23097 NonOpPer7ToT X_NUMERIC 5 13 8 None Operational Period To Time 7
SM23 SM23098 NonOpPer8FrT X_NUMERIC 5 13 8 None Operational Period From Time 8
SM23 SM23099 NonOpPer8ToT X_NUMERIC 5 13 8 None Operational Period To Time 8
SM23 SM23100 NonOpPer9FrT X_NUMERIC 5 13 8 None Operational Period From Time 9
SM23 SM23101 NonOpPer9ToT X_NUMERIC 5 13 8 None Operational Period To Time 9
SM23 SM23102 NonOpPer10FrT X_NUMERIC 5 13 8 None Operational Period From Time 10
SM23 SM23103 NonOpPer10ToT X_NUMERIC 5 13 8 None Operational Period To Time 10
SM23 SM23104 NonOpPer11FrT X_NUMERIC 5 13 8 None Operational Period From Time 11
SM23 SM23105 NonOpPer11ToT X_NUMERIC 5 13 8 None Operational Period To Time 11
SM23 SM23106 NonOpPer12FrT X_NUMERIC 5 13 8 None Operational Period From Time 12
SM23 SM23107 NonOpPer12ToT X_NUMERIC 5 13 8 None Operational Period To Time 12
SM23 SM23108 NonOpPer13FrT X_NUMERIC 5 13 8 None Operational Period From Time 13
SM23 SM23109 NonOpPer13ToT X_NUMERIC 5 13 8 None Operational Period To Time 13
SM23 SM23110 NonOpPer14FrT X_NUMERIC 5 13 8 None Operational Period From Time 14
SM23 SM23111 NonOpPer14ToT X_NUMERIC 5 13 8 None Operational Period To Time 14
SM23 SM23112 NonOpPer15FrT X_NUMERIC 5 13 8 None Operational Period From Time 15
SM23 SM23113 NonOpPer15ToT X_NUMERIC 5 13 8 None Operational Period To Time 15
SM23 SM23114 NonOpPer16FrT X_NUMERIC 5 13 8 None Operational Period From Time 16
SM23 SM23115 NonOpPer16ToT X_NUMERIC 5 13 8 None Operational Period To Time 16
SM23 SM23116 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23117 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23118 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23119 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23120 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23121 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23122 Spare X_NUMERIC 5 13 8 (obsolete)
SM23 SM23123 Spare X_NUMERIC 5 13 8 (obsolete)