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 CMH3 CMH3001 ServContrNo STRING 10 10 0 Service Contract Number
2 CMH3 CMH3002 LineNo STRING 6 6 0 Contract Line Number
CMH3 CMH3003 LineType STRING 1 1 0 Line Type
CMH3 CMH3004 StockCode STRING 35 35 0 Stock Item Code
CMH3 CMH3005 SerialNo STRING 20 20 0 SerialNo
CMH3 CMH3006 DescrLine1 VSTRING 25 25 0 Description Line 1
CMH3 CMH3007 DescrLine2 VSTRING 25 25 0 Description Line 2
CMH3 CMH3008 PricePerUnitOCU MONEY 20 28 8 Unit Price (Contract Currency)
CMH3 CMH3009 Spare STRING 1 1 0 Spare
CMH3 CMH3010 DiscountPercent X_NUMERIC 7 15 8 Discount %
CMH3 CMH3011 DateEntryLine DATE 8 0 0 Date_EntryLine
CMH3 CMH3012 ContractType STRING 3 3 0 Contract_Type
CMH3 CMH3013 PriceType INTEGER 1 0 0 PriceType
CMH3 CMH3014 AccCode STRING 2 2 0 Accounting Code
CMH3 CMH3015 JobCode STRING 6 6 0 JobCode
CMH3 CMH3016 Warehouse STRING 6 6 0 Warehouse
CMH3 CMH3017 Spare STRING 7 7 0 Spare
CMH3 CMH3018 Spare STRING 6 6 0 Spare
CMH3 CMH3019 SalesTaxCode STRING 6 6 0 VAT Code
CMH3 CMH3020 LineTax2 STRING 7 7 0 VAT Code 2
CMH3 CMH3021 NextInvDate DATE 8 0 0 Next Invoice Date
CMH3 CMH3022 InstallatSite STRING 4 4 0 Site Code
CMH3 CMH3023 DateLineStart DATE 8 0 0 Contract Line Start Date
CMH3 CMH3024 DateLineEnd DATE 8 0 0 Contract Line End Date
CMH3 CMH3025 OverRespTime X_NUMERIC 12 20 8 Response Time Override
CMH3 CMH3026 Status INTEGER 1 0 0 Line Status
CMH3 CMH3027 ChangeValueOCU MONEY 20 28 8 Change Value (Contract Currency)
CMH3 CMH3028 ReasChngText STRING 20 20 0 Change Reason
CMH3 CMH3029 ChangeDate DATE 8 0 0 Change Date
CMH3 CMH3030 AccString ACCSTR 120 120 0 Accounting String
CMH3 CMH3031 DiscEndDate DATE 8 0 0 Discount End Date
CMH3 CMH3032 CustCodeSite STRING 10 10 0 Customer Code Installation Address
CMH3 CMH3033 ContactCurrency STRING 2 2 0 Currency Code Contract
CMH3 CMH3034 PrevAccPrice MONEY 20 28 8 Previous Accrual Unit Price (Local Currency)
CMH3 CMH3035 DateAcCreated DATE 8 0 0 Date Accruals Created
CMH3 CMH3036 DateContrClosed DATE 8 0 0 Date Contract Closed
CMH3 CMH3037 AccumAccrAcount MONEY 20 28 8 Accumulated Accrual Amount (Local Currency)
CMH3 CMH3038 PrevAccrStartDate DATE 8 0 0 Previous Accrual Start Date
CMH3 CMH3039 PrevAccrEndDate DATE 8 0 0 Previous Accrual End Date
3 CMH3 CMH3040 SubLineNum STRING 6 6 0 Contract Sub-line Number
CMH3 CMH3041 PriceList STRING 2 2 0 Price List
CMH3 CMH3042 PriceUnitCode INTEGER 2 0 0 Price_UnitCode
CMH3 CMH3043 CalendarID STRING 10 10 0 CalendarID
CMH3 CMH3044 QtyPlanned X_NUMERIC 12 20 8 Qty_Planned
CMH3 CMH3045 QtyActual X_NUMERIC 12 20 8 Qty_Actual
CMH3 CMH3046 RentalUnitsActual X_NUMERIC 12 20 8 Quantity Actual Rental
CMH3 CMH3047 UnitCodeQty INTEGER 4 0 0 UnitCode_Qty
CMH3 CMH3048 CntrLineStartTime STRING 4 4 0 Contract Line Start Time
CMH3 CMH3049 CntrLineEndTime STRING 4 4 0 Contract Line End Time
CMH3 CMH3050 InvoiceQty X_NUMERIC 20 28 8 InvoiceQty
CMH3 CMH3051 RequestedDate DATE 8 0 0 RequestedDate
CMH3 CMH3052 ConfirmedDate DATE 8 0 0 ConfirmedDate
CMH3 CMH3053 LastUsedDate DATE 8 0 0 LastUsedDate
CMH3 CMH3054 AcceptedDate DATE 8 0 0 AcceptedDate
CMH3 CMH3055 Spare X_NUMERIC 12 20 8 Spare
CMH3 CMH3056 DefaultEngineer VSTRING 10 10 0 Default Engineer
CMH3 CMH3057 ExpiryDate DATE 8 0 0 Reservation Expiry Date
CMH3 CMH3058 ReqDelTimeRem VSTRING 20 20 0 Requested Delivery Time remark
CMH3 CMH3059 AccDelTimeRem VSTRING 20 20 0 Accepted Delivery Time remark
CMH3 CMH3060 ContractLinePricingDate DATE 8 0 0 Contract Line Pricing Date
CMH3 CMH3061 ContractPricingNumber STRING 10 10 0 Contract Pricing Number
4 CMH3 CMH3062 InvoiceNo STRING 15 15 0 InvoiceNo
CMH3 CMH3063 ExecutionLineNo STRING 4 4 0 Execution Line No
CMH3 CMH3064 LeaseObjectType STRING 1 1 0 Lease Object Type
CMH3 CMH3065 LeaseLineNature INTEGER 1 0 0 Lease Line Nature
CMH3 CMH3066 GroupCode VSTRING 6 6 0 Group Code
CMH3 CMH3067 ValueComponent VSTRING 10 10 0 Value Component
CMH3 CMH3068 IndexClause SWITCH 1 1 0 Index Clause
CMH3 CMH3069 Deposit MONEY 20 28 8 Deposit
CMH3 CMH3070 CapitalValue MONEY 20 28 8 Capital Value
CMH3 CMH3071 ResidualValue MONEY 20 28 8 Residual Value
CMH3 CMH3072 InterestRateCode VSTRING 6 6 0 Interest Rate Code
CMH3 CMH3073 InterestRatePercentage X_NUMERIC 7 15 8 Interest Rate Percentage
CMH3 CMH3074 InterestRateTime INTEGER 3 0 0 Interest Rate Time
CMH3 CMH3075 InterestRateTimeUnit INTEGER 1 0 0 Interest Rate Time Unit
CMH3 CMH3076 TotalNumPeriods X_NUMERIC 12 20 8 Total Number of Periods
CMH3 CMH3077 CurrentNumOfPeriods X_NUMERIC 12 20 8 Current number of Periods
CMH3 CMH3078 InvoicedNumOfPeriods X_NUMERIC 12 20 8 Invoiced number of Periods
CMH3 CMH3079 LeaseCharge MONEY 20 28 8 Lease Charge
CMH3 CMH3080 AccumulatedDepreciation MONEY 20 28 8 Accumulated Depreciation
CMH3 CMH3081 ExecutionStructureLineNumber STRING 6 6 0 Execution Structure Line Number
CMH3 CMH3082 ExecutionSubStructureLineNumber STRING 6 6 0 Execution Sub Structure Line Number
CMH3 CMH3083 CreateServiceOrdOnReturn SWITCH 1 1 0 Create Service Order on Return
CMH3 CMH3084 DaysInService INTEGER 3 0 0 Days in Service
CMH3 CMH3085 LeaseContractNo VSTRING 10 10 0 Linked Lease Contract No
CMH3 CMH3086 LeaseLineNo VSTRING 6 6 0 Linked Lease Contract Line No
CMH3 CMH3087 LeaseSublineNo VSTRING 6 6 0 Linked Lease Contract Subline No
CMH3 CMH3088 CapitalCharge MONEY 20 28 8 Capital Charge
CMH3 CMH3089 InterestCharge MONEY 20 28 8 Interest Charge
CMH3 CMH3090 InvoiceTimeValue X_NUMERIC 12 20 8 Invoice Time Value
CMH3 CMH3091 InvoiceTimeUnit INTEGER 2 0 0 Invoice Time Unit
CMH3 CMH3092 PriorQty X_NUMERIC 12 20 8 Prior Qty
CMH3 CMH3093 Change_Date DATE 8 0 0 Change Date
CMH3 CMH3094 UseBestPrice SWITCH 1 1 0 Use Best Price
CMH3 CMH3095 JobID INTEGER 9 0 0 Job ID
CMH3 CMH3096 ServiceOrderType STRING 6 6 0 Service Order Type
CMH3 CMH3097 MinOrderedQty X_NUMERIC 12 20 8 Min Ordered Qty
CMH3 CMH3098 DeliveryTime X_NUMERIC 12 20 8 Delivery Time
CMH3 CMH3099 DeliveryTimeUnit INTEGER 2 0 0 Delivery Time Unit
CMH3 CMH3100 Subtype INTEGER 1 0 0 Subtype
CMH3 CMH3101 ApprovedCreditLimit SWITCH 1 1 0 Approved Credit Limit
CMH3 CMH3102 VariableInterestRateCode1 STRING 3 3 0 Variable Interest Rate Code 1
CMH3 CMH3103 VariableInterestRatePercent1 X_NUMERIC 7 15 8 Variable Interest Rate Percent.1
CMH3 CMH3104 VariableInterestRateCode2 STRING 3 3 0 Variable Interest Rate Code 2
CMH3 CMH3105 VariableInterestRatePercent2 X_NUMERIC 7 15 8 Variable Interest Rate Percent.2
5 CMH3 CMH3106 InvoicePlanLineNumber STRING 6 6 0 Invoice Plan Line Number
CMH3 CMH3107 AgreedInterval X_NUMERIC 12 20 8 Agreed Interval
CMH3 CMH3108 AgreedIntervalUnit INTEGER 2 0 0 Agreed Interval Unit
CMH3 CMH3109 AgreedQty X_NUMERIC 12 20 8 Agreed Qty
CMH3 CMH3110 QtyType STRING 2 2 0 Qty Type
CMH3 CMH3111 OverPriceQty MONEY 20 28 8 Over Price/Qty
CMH3 CMH3112 CostCode STRING 8 8 0 Cost Code
CMH3 CMH3113 UsageBillingFrom DATE 8 0 0 Usage Billing From
CMH3 CMH3114 ReturnWH VSTRING 6 6 0 Return WH
CMH3 CMH3115 OperationType VSTRING 10 10 0 Operation Type
CMH3 CMH3116 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
CMH3 CMH3117 NCMCode VSTRING 25 25 0 NCM Code
CMH3 CMH3118 TaxationReasonCode STRING 3 3 0 Taxation Reason Code
CMH3 CMH3119 QuantityPerMultiple X_NUMERIC 12 20 8 Quantity Per Multiple