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 SM70 SM70001 ServContrNo STRING 10 10 0 Service Contract Number
2 SM70 SM70002 MinInvoice STRING 8 8 0 Reversed Invoice Date
3 SM70 SM70003 InvoiceNo STRING 15 15 0 Invoice Number
4 SM70 SM70004 Type STRING 1 1 0 Invoice Type
SM70 SM70005 InvCustomer STRING 10 10 0 Invoice Customer
SM70 SM70006 InvoiceDate DATE 8 0 0 Invoice Date
SM70 SM70007 InvoiceNetAmountLCU MONEY 20 28 8 Invoice Net Amount LCU
SM70 SM70008 InvoiceNetAmountICU MONEY 20 28 8 Invoice Net Amount ICU
SM70 SM70009 CurrencyCode STRING 2 2 0 Currency Code Invoice
SM70 SM70010 NomLedgerAC STRING 6 6 0 (obsolete)
SM70 SM70011 ServOrderNo STRING 10 10 0 Service Order Number
SM70 SM70012 Customer STRING 10 10 0 Customer
SM70 SM70013 Site STRING 4 4 0 Site Code
SM70 SM70014 SStckCode VSTRING 35 35 0 Stock Item Code
SM70 SM70015 SerialNo VSTRING 20 20 0 Serial Number
SM70 SM70016 IdxTabelDate DATE 8 0 0 Date Index Table
SM70 SM70017 Cfactor X_NUMERIC 12 20 8 Index Conversion Factor
SM70 SM70018 StartPerDate DATE 8 0 0 Period Start Date
SM70 SM70019 StopPeriDate DATE 8 0 0 Period End Date
SM70 SM70020 AccntString ACCSTR 120 120 0 Accounting String
SM70 SM70021 VATAmountOCU MONEY 20 28 8 VAT Amount (Invoice Currency)
SM70 SM70022 VATAmountLCU MONEY 20 28 8 VAT Amount (Local Currency)
SM70 SM70023 BookEntryDate DATE 8 0 0 Book Entry Date
SM70 SM70024 InvFeeAmountLCU X_NUMERIC 13 21 8 Invoice Fee Amount LCU
SM70 SM70025 InvFeeAmountOCU X_NUMERIC 13 21 8 Invoice Fee Amount OCU
SM70 SM70026 TaxCodeForInvFee STRING 6 6 0 Tax Code for Invoice Fee
SM70 SM70027 OperationType VSTRING 10 10 0 Operation Type
SM70 SM70028 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
SM70 SM70029 PlanLineNumber STRING 6 6 0 Plan Line Number
SM70 SM70030 InvoiceType INTEGER 2 0 0 Invoice Type
SM70 SM70031 EventType INTEGER 2 0 0 Event Type
SM70 SM70032 EventDate DATE 8 0 0 Event Date
SM70 SM70033 InvoicedAmountCCU MONEY 20 28 8 Invoiced Amount CCU
SM70 SM70034 DeductedAmountCCU MONEY 20 28 8 Deducted Amount CCU
SM70 SM70035 TaxCode STRING 6 6 0 Tax Code
SM70 SM70036 TaxLiability STRING 6 6 0 Tax Liability
SM70 SM70037 PaymentTerm STRING 2 2 0 Payment term
SM70 SM70038 Comment VSTRING 200 200 0 Comment
SM70 SM70039 InvoicedAmountICU MONEY 20 28 8 Invoiced Amount ICU
SM70 SM70040 InvoicedAmountLCU MONEY 20 28 8 Invoiced Amount LCU
SM70 SM70041 DeductedAmountICU MONEY 20 28 8 Deducted Amount ICU
SM70 SM70042 DeductedAmountLCU MONEY 20 28 8 Deducted Amount LCU
SM70 SM70043 AccString ACCSTR 120 120 0 Accounting String
SM70 SM70044 AASCode STRING 25 25 0 AAS Code
SM70 SM70045 LineSortingNumber STRING 6 6 0 Line Sorting Number
5 SM70 SM70046 InvoicePlanLineNumber STRING 6 6 0 Invoice Plan Line Number