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
1 SM71 SM71001 ContractNum STRING 10 10 0 Service Contract Number
3 SM71 SM71002 InvoicePeriodStart DATE 8 0 0 Start Date of the Invoicing Period
4 SM71 SM71003 AccPeriodNum INTEGER 2 0 0 GL Accounting Period number
SM71 SM71004 FinanceYear STRING 4 4 0 Financial year of the transaction
SM71 SM71005 TransactionDate DATE 8 0 0 Transaction Date
SM71 SM71006 BEDate DATE 8 0 0 Book Entry Date
SM71 SM71007 AmountToInvoiceICU MONEY 20 28 8 Amount to Invoice (invoice currency)
SM71 SM71008 AmountToInvoiceLCU MONEY 20 28 8 Amount to Invoice (local currency)
SM71 SM71009 InvoicedAmountICU MONEY 20 28 8 Invoiced Amount (invoice currency)
SM71 SM71010 InvoicedAmountLCU MONEY 20 28 8 Invoiced Amount (local currency)
SM71 SM71011 DeferredAmountICU MONEY 20 28 8 Deferred Amount (invoice currency)
SM71 SM71012 DeferredAmountLCU MONEY 20 28 8 Deferred Amount (local currency)
SM71 SM71013 ReversedDeferralAmountICU MONEY 20 28 8 Reversed Deferral Amount (invoice currency)
SM71 SM71014 ReversedDeferralAmountLCU MONEY 20 28 8 Reversed Deferral Amount (local currency)
SM71 SM71015 ExchangeRate1 X_NUMERIC 10 18 8 Currency Exchange Rate 1
SM71 SM71016 ExchangeRate2 X_NUMERIC 10 18 8 Currency Exchange Rate 2
SM71 SM71017 ExchangeAlgorithm STRING 3 3 0 Currency Exchange Algorithm
SM71 SM71018 IncomeAccStr ACCSTR 120 120 0 Accounting string for sales/interest income
SM71 SM71019 DeferralsAccStr ACCSTR 120 120 0 Accounting string for deferred/accrued revenue
5 SM71 SM71020 HistoryLineCounter VSTRING 20 20 0 HistoryLineCounter
SM71 SM71021 InvoiceNumber VSTRING 20 20 0 Invoice number
2 SM71 SM71022 LineNumber VSTRING 20 20 0 LineNumber
SM71 SM71023 IncomeAASCode VSTRING 25 25 0 AAS code for sales/interest income acc string
SM71 SM71024 DeferralsAASCode VSTRING 25 25 0 AAS code for deferred/accrued revenue acc string
SM71 SM71025 DeferralsType INTEGER 1 0 0 Deferrals Type
SM71 SM71026 InvoicePlanLineNumber STRING 6 6 0 Invoice Plan Line Number