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
CM3L table Extended Contract Lines Company CM3L0100
CMBP Best Price Table Company CMBP0100
CMH1 Contract History Master File Company CMH10100
CMH3 Contract Line History File Company CMH30100
CMH4 Delivery Schedule History Company CMH40100
CMH5 Contract Line Act History Company CMH50100
CMHD Company CMHD0100
CMHI Invoicing Plan History Company CMHI0100
CMHL Extended Contract Lines LTM History Company CMHL0100
CMHT Contract Line Text History Company CMHT0100
CMI2 Contract Instalment Lines Company CMI20100
CMI4 Contract Instalment Lines History Company CMI40100
CMIP Invoicing Plan Company CMIP0100
CMMT Business Transaction Type Contract Mapping Company CMMT0100
CMVV Variable Values Company CMVV0100
SM11 Service Contract Master Company SM110100
SM13 Service Contract Lines Company SM130100
SM15 Service Contract Parameters Company SM150100
SM16 Service Contract Document Texts Company SM160100
SM17 Phrase File Company SM170100
SM18 Contract Price Table Company SM180100
SM1T Service Contract Line Texts Company SM1T0100
SM20 Service Contract Automatic Accounting Coding Schedule Company Year SM200112
SM31 WIP Transaction Journal Company Year SM310112
SM34 Price Calculation Profiles Company SM340100
SM35 Service Contract Index File Company SM350100
SM36 Index History File Company SM360100
SM69 Contract Codes Company SM690100
SM70 Contract Invoicing History Company SM700100
SM71 Service Contract Deferrals Booking History Company SM710100
SM75 Delivery Schedule Company SM750100
SM85 Contract Line Activities Company SM850100

Fields
PK Table Name Description Type Length Precision Note
SM31 SM31001 Reccounter NUMBER 9 20 0 Record Counter
1 SM31 SM31002 Transactno STRING 9 9 0 Transaction Number
2 SM31 SM31003 Linenumber STRING 7 7 0 Line Number
SM31 SM31004 Trandate DATE 8 0 0 Transaction Date
SM31 SM31005 Flag SWITCH 1 1 0 Primary Line Currency
SM31 SM31006 Accstring ACCSTR 120 120 0 Accounting String
SM31 SM31007 Amountlcu MONEY 20 28 8 Amount (Local Currency)
SM31 SM31008 Currcode INTEGER 2 0 0 Currency Code Line
SM31 SM31009 Accstringocu ACCSTR 120 120 0 Accounting String Line Currency
SM31 SM31010 Amountocu MONEY 20 28 8 Amount (Line Currency)
SM31 SM31011 Trantext VSTRING 100 100 0 Transaction Line Text
SM31 SM31012 Code1 STRING 10 10 0 Customer
SM31 SM31013 Code2 VSTRING 25 25 0 Transaction Code 2
SM31 SM31014 Code3 STRING 6 6 0 Transaction Code 3
SM31 SM31015 Code4 STRING 2 2 0 Transaction Code 4
SM31 SM31016 Code5 VSTRING 35 35 0 Contract Number
SM31 SM31017 Code6 STRING 8 8 0 Transaction Code 6
SM31 SM31018 Tag1 STRING 1 1 0 Transaction Tag 1
SM31 SM31019 Tag2 STRING 1 1 0 Transaction Tag 2
SM31 SM31020 Tag3 STRING 1 1 0 Transaction Tag 3
SM31 SM31021 Tranlinetype STRING 1 1 0 Line Type
SM31 SM31022 Tranlinesign STRING 1 1 0 Transaction Sign
SM31 SM31023 Noofdecimals NUMBER 1 20 0 Number of Decimals
SM31 SM31024 Linkcode STRING 8 8 0 Link Code
SM31 SM31025 Quantity X_NUMERIC 20 28 8 Quantity
SM31 SM31026 Unitcode INTEGER 4 0 0 Unit Code
SM31 SM31027 Amountccu MONEY 20 28 8 Amount (Alternative Currency)
SM31 SM31028 contraacc STRING 13 13 0 Contra Account
SM31 SM31029 Journalno NUMBER 6 20 0 Journal Number
SM31 SM31030 Plreference STRING 9 9 0 PL Reference
SM31 SM31031 Subprjcode STRING 6 6 0 Sub-Project Number
SM31 SM31032 Activitycode STRING 6 6 0 Activity Code
SM31 SM31033 Usridentby STRING 8 8 0 Entered By
SM31 SM31034 Dateofentry DATE 8 0 0 Date Entered
SM31 SM31035 Usridupdby STRING 8 8 0 Updated By
SM31 SM31036 Dateofupd DATE 8 0 0 Date Updated
SM31 SM31037 Trantxtocu VSTRING 100 100 0 Transaction Text Line Currency
SM31 SM31038 SourceCompany STRING 2 2 0 Source Company
SM31 SM31039 SourceModule STRING 2 2 0 Source Module
SM31 SM31040 Usridprnby STRING 8 8 0 Printed By
SM31 SM31041 DatePrinted DATE 8 0 0 Date Printed
SM31 SM31042 PrnStatus SWITCH 1 1 0 PrintedStatus
SM31 SM31043 AASCode VSTRING 25 25 0 AAS code