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 SM13 SM13001 ServContrNo STRING 10 10 0 Service Contract Number
2 SM13 SM13002 LineNo STRING 6 6 0 Contract Line Number
SM13 SM13003 LineType STRING 1 1 0 Line Type 0 - Normal contract line
9 - Text line
SM13 SM13004 StockCode STRING 35 35 0 Stock Item Code
SM13 SM13005 SerialNo STRING 20 20 0 Serial Number
SM13 SM13006 DescrLine1 VSTRING 25 25 0 Description Line 1
SM13 SM13007 DescrLine2 VSTRING 25 25 0 Description Line 2
SM13 SM13008 PricePerUnitOCU MONEY 20 28 8 Unit Price (Contract Currency)
SM13 SM13009 Spare STRING 1 1 0 (obsolete)
SM13 SM13010 Discount X_NUMERIC 7 15 8 Discount %
SM13 SM13011 DateEntryLine DATE 8 0 0 Date Entered
SM13 SM13012 ContractType STRING 3 3 0 Contract Type
SM13 SM13013 PriceType INTEGER 1 0 0 Price Type 0 - The prices entered on the contract lines are used, index can be used to restate the prices at invoice time.
1 - Current price from price list will be used at the time of invoice.
SM13 SM13014 AccCode STRING 2 2 0 Accounting Code
SM13 SM13015 JobCode STRING 6 6 0 Job Number
SM13 SM13016 WH STRING 6 6 0 Warehouse
SM13 SM13017 Spare STRING 7 7 0 (obsolete)
SM13 SM13018 Spare STRING 6 6 0 (obsolete)
SM13 SM13019 SalesTaxCode STRING 6 6 0 VAT Code
SM13 SM13020 LineTax2 STRING 7 7 0 VAT Code 2
SM13 SM13021 NextInvDate DATE 8 0 0 Next Invoice Date
SM13 SM13022 InstallatSite STRING 4 4 0 Site Code
SM13 SM13023 DateLineStart DATE 8 0 0 Contract Line Start Date
SM13 SM13024 DateLineEnd DATE 8 0 0 Contract Line End Date
SM13 SM13025 OverRespTime X_NUMERIC 12 20 8 Response Time Override
SM13 SM13026 Status INTEGER 1 0 0 Line Status 0 - Normal contract line
1 - Changed invoice amount
2 - Cancelled line, by date
3 - Switched of line
SM13 SM13027 DebitCreditValueOCU MONEY 20 28 8 Debit/Credit Value (Contract Currency)
SM13 SM13028 ReasChngText STRING 20 20 0 Change Reason
SM13 SM13029 StatusDate DATE 8 0 0 Status Date
SM13 SM13030 AccString ACCSTR 120 120 0 Accounting String
SM13 SM13031 DiscEndDate DATE 8 0 0 Discount End Date
SM13 SM13032 CustCodeSite STRING 10 10 0 Customer Code Installation Address
SM13 SM13033 ContactCurrency STRING 2 2 0 Currency Code Contract
SM13 SM13034 PrevAccPrice MONEY 20 28 8 Previous Accrual Unit Price (Local Currency)
SM13 SM13035 DateAcCreated DATE 8 0 0 Date Accruals Created
SM13 SM13036 DateContrClosed DATE 8 0 0 Date Contract Closed
SM13 SM13037 AccumAccrAcount MONEY 20 28 8 Accumulated Accrual Amount (Local Currency)
SM13 SM13038 PrevAccrStartDate DATE 8 0 0 Previous Accrual Start Date
SM13 SM13039 PrevAccrEndDate DATE 8 0 0 Previous Accrual End Date
3 SM13 SM13040 SubLineNum STRING 6 6 0 Contract Sub-line Number
SM13 SM13041 PriceList STRING 2 2 0 Price List
SM13 SM13042 PriceUnitCode INTEGER 2 0 0 Unit Code Price
SM13 SM13043 CalendarID STRING 10 10 0 Calendar ID
SM13 SM13044 QtyPlanned X_NUMERIC 12 20 8 Quantity Planned
SM13 SM13045 QtyActual X_NUMERIC 12 20 8 Quantity Actual
SM13 SM13046 RentalUnitsActual X_NUMERIC 12 20 8 Quantity Actual Rental
SM13 SM13047 UnitCodeQty INTEGER 4 0 0 Unit Code Quantity
SM13 SM13048 CntrLineStartTime STRING 4 4 0 Contract Line Start Time
SM13 SM13049 CntrLineEndTime STRING 4 4 0 Contract Line End Time
SM13 SM13050 InvoiceQty X_NUMERIC 20 28 8 Invoice Qty
SM13 SM13051 RequestedDate DATE 8 0 0 Requested Date
SM13 SM13052 ConfirmedDate DATE 8 0 0 Confirmed Date
SM13 SM13053 LastUsedDate DATE 8 0 0 Last Used Date
SM13 SM13054 AcceptedDate DATE 8 0 0 AcceptedDate
SM13 SM13055 Spare X_NUMERIC 12 20 8 Spare
SM13 SM13056 DefaultEngineer VSTRING 10 10 0 Default Engineer
SM13 SM13057 ExpiryDate DATE 8 0 0 Reservation Expiry Date
SM13 SM13058 ReqDelTimeRem VSTRING 20 20 0 Requested Delivery Time remark
SM13 SM13059 AccDelTimeRem VSTRING 20 20 0 Accepted Delivery Time remark
SM13 SM13060 ContractLinePricingDate DATE 8 0 0 Contract Line Pricing Date
SM13 SM13061 ContractPricingNumber STRING 10 10 0 Contract Pricing Number
SM13 SM13062 InvoiceNo STRING 15 15 0 InvoiceNo
SM13 SM13063 ExecutionLineNo STRING 4 4 0 Execution Line No
SM13 SM13064 LeaseObjectType STRING 1 1 0 Lease Object Type For lease contracts: Asset or Accessory
SM13 SM13065 LeaseLineNature INTEGER 1 0 0 Lease Line Nature For lease contracts: Lease or Maintenance line
SM13 SM13066 LineGroupCode VSTRING 6 6 0 Line Group Code
SM13 SM13067 ValueComponent VSTRING 10 10 0 Value Component
SM13 SM13068 IndexClause SWITCH 1 1 0 Index Clause
SM13 SM13069 Deposit MONEY 20 28 8 Deposit
SM13 SM13070 CapitalValue MONEY 20 28 8 Capital Value
SM13 SM13071 ResidualValue MONEY 20 28 8 Residual Value
SM13 SM13072 InterestRateCode VSTRING 6 6 0 Interest Rate Code
SM13 SM13073 InterestRatePercentage X_NUMERIC 7 15 8 Interest Rate Percentage
SM13 SM13074 InterestRateTime INTEGER 3 0 0 Interest Rate Time
SM13 SM13075 InterestRateTimeUnit INTEGER 1 0 0 Interest Rate Time Unit
SM13 SM13076 TotalNumPeriods X_NUMERIC 12 20 8 Total Number of Periods
SM13 SM13077 CurrentNumOfPeriods X_NUMERIC 12 20 8 Current number of Periods
SM13 SM13078 InvoicedNumOfPeriods X_NUMERIC 12 20 8 Invoiced number of Periods
SM13 SM13079 LeaseCharge MONEY 20 28 8 Lease Charge
SM13 SM13080 AccumulatedDepreciation MONEY 20 28 8 Accumulated Depreciation
SM13 SM13081 ExecutionStructureLineNumber STRING 6 6 0 Execution Structure Line Number
SM13 SM13082 ExecutionSubStructureLineNumber STRING 6 6 0 Execution Sub Structure Line Number
SM13 SM13083 CreateServiceOrdOnReturn SWITCH 1 1 0 Create Service Order on Return
SM13 SM13084 DaysInService INTEGER 3 0 0 Days in Service
SM13 SM13085 LeaseContractNo VSTRING 10 10 0 Linked Lease Contract No
SM13 SM13086 LeaseLineNo VSTRING 6 6 0 Linked Lease Contract Line No
SM13 SM13087 LeaseSublineNo VSTRING 6 6 0 Linked Lease Contract Subline No
SM13 SM13088 CapitalCharge MONEY 20 28 8 Capital Charge
SM13 SM13089 InterestCharge MONEY 20 28 8 Interest Charge
SM13 SM13090 InvoiceTimeValue X_NUMERIC 12 20 8 Invoice Time Value
SM13 SM13091 InvoiceTimeUnit INTEGER 2 0 0 Invoice Time Unit
SM13 SM13092 PriorQty X_NUMERIC 12 20 8 Prior Qty
SM13 SM13093 ChangeDate DATE 8 0 0 Change Date
SM13 SM13094 UseBestPrice SWITCH 1 1 0 Use Best Price
SM13 SM13095 JobID INTEGER 9 0 0 Job ID
SM13 SM13096 ServiceOrderType STRING 6 6 0 Service Order Type
SM13 SM13097 MinOrderedQty X_NUMERIC 12 20 8 Min Ordered Qty
SM13 SM13098 DeliveryTime X_NUMERIC 12 20 8 Delivery Time
SM13 SM13099 DeliveryTimeUnit INTEGER 2 0 0 Delivery Time Unit
SM13 SM13100 Subtype INTEGER 1 0 0 Subtype
SM13 SM13101 ApprovedCreditLimit SWITCH 1 1 0 Approved Credit Limit
SM13 SM13102 VariableInterestRateCode1 STRING 3 3 0 Variable Interest Rate Code 1
SM13 SM13103 VariableInterestRatePercent1 X_NUMERIC 7 15 8 Variable Interest Rate Percent.1
SM13 SM13104 VariableInterestRateCode2 STRING 3 3 0 Variable Interest Rate Code 2
SM13 SM13105 VariableInterestRatePercent2 X_NUMERIC 7 15 8 Variable Interest Rate Percent.2
SM13 SM13106 InvoicePlanLineNumber STRING 6 6 0 Invoice Plan Line Number
SM13 SM13107 AgreedInterval X_NUMERIC 12 20 8 Agreed Interval
SM13 SM13108 AgreedIntervalUnit INTEGER 2 0 0 Agreed Interval Unit
SM13 SM13109 AgreedQty X_NUMERIC 12 20 8 Agreed Qty
SM13 SM13110 QtyType STRING 2 2 0 Qty Type
SM13 SM13111 OverPriceQty MONEY 20 28 8 Over Price/Qty
SM13 SM13112 CostCode STRING 8 8 0 Cost Code
SM13 SM13113 UsageBillingFrom DATE 8 0 0 Usage Billing From
SM13 SM13114 ReturnWH VSTRING 6 6 0 Return WH
SM13 SM13115 OperationType VSTRING 10 10 0 Operation Type
SM13 SM13116 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
SM13 SM13117 NCMCode VSTRING 25 25 0 NCM Code
SM13 SM13118 TaxationReasonCode STRING 3 3 0 Taxation Reason Code
SM13 SM13119 QuantityPerMultiple X_NUMERIC 12 20 8 Quantity Per Multiple