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 CMIP CMIP001 ContractNumber VSTRING 10 10 0 Contract Number
2 CMIP CMIP002 PlanLineNumber STRING 6 6 0 Plan Line Number
CMIP CMIP003 InvoiceType INTEGER 2 0 0 Invoice Type
CMIP CMIP004 EventType INTEGER 2 0 0 Event Type
CMIP CMIP005 EventDate DATE 8 0 0 Event Date
CMIP CMIP006 InvoiceAmountCCU MONEY 20 28 8 Invoice Amount CCU
CMIP CMIP007 AmntToDeductCCU MONEY 20 28 8 Amount to deduct CCU
CMIP CMIP008 TaxCode STRING 6 6 0 Tax Code
CMIP CMIP009 TaxLiability STRING 6 6 0 Tax Liability
CMIP CMIP010 PaymentTerm STRING 2 2 0 Payment Term
CMIP CMIP011 InvoiceFrom DATE 8 0 0 Invoice From
CMIP CMIP012 InvoiceTo DATE 8 0 0 Invoice To
CMIP CMIP013 Comment VSTRING 200 200 0 Comment
CMIP CMIP014 Status INTEGER 2 0 0 Status
CMIP CMIP015 InvoiceNumber VSTRING 15 15 0 Invoice Number
CMIP CMIP016 LineSortingNumber STRING 6 6 0 Line Sorting Number
CMIP CMIP017 OriginalInvoiceNumber VSTRING 15 15 0 Original Invoice Number
CMIP CMIP018 InvDate DATE 8 0 0 Invoice Date
CMIP CMIP019 XMLInvoiceFlag INTEGER 1 0 0 XML Invoice Flag
CMIP CMIP020 SpecificationFlag SWITCH 1 1 0 Specification flag
CMIP CMIP021 RestoreContractState SWITCH 1 1 0 Restore contract state
CMIP CMIP022 OriginalPlanLineNumber STRING 6 6 0 Original Plan Line Number
CMIP CMIP023 InvCounterID VSTRING 12 12 0 Invoice Counter ID
CMIP CMIP024 TaxationReasonCode STRING 3 3 0 Taxation Reason Code