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 SM69 SM69001 ContractType STRING 3 3 0 Contract Type
SM69 SM69002 Description STRING 25 25 0 Description
SM69 SM69003 TypeOfLabour STRING 10 10 0 Category of Time Activity
SM69 SM69004 TypeOfCost STRING 10 10 0 Category of Cost Activity
SM69 SM69005 TypeMaterial STRING 10 10 0 Category of Material Activity
SM69 SM69006 AccCustomer STRING 10 10 0 Internal Customer Code
SM69 SM69007 Remark1 VSTRING 30 30 0 Remark Line 1
SM69 SM69008 Remark2 VSTRING 30 30 0 Remark Line 2
SM69 SM69009 CallBackHours X_NUMERIC 12 20 8 Call Back Time
SM69 SM69010 RespStartMon X_NUMERIC 5 13 8 Working Hours Monday Start Time 1
SM69 SM69011 RespStopMon X_NUMERIC 5 13 8 Working Hours Monday End Time 1
SM69 SM69012 RespStartTue X_NUMERIC 5 13 8 Working Hours Tuesday Start Time 1
SM69 SM69013 RespStopTue X_NUMERIC 5 13 8 Working Hours Tuesday End Time 1
SM69 SM69014 RespStartWed X_NUMERIC 5 13 8 Working Hours Wednesday Start Time 1
SM69 SM69015 RespStopWed X_NUMERIC 5 13 8 Working Hours Wednesday End Time 1
SM69 SM69016 RespStartThu X_NUMERIC 5 13 8 Working Hours Thursday Start Time 1
SM69 SM69017 RespStopThu X_NUMERIC 5 13 8 Working Hours Thursday End Time 1
SM69 SM69018 RespStartFri X_NUMERIC 5 13 8 Working Hours Friday Start Time 1
SM69 SM69019 RespStopFri X_NUMERIC 5 13 8 Working Hours Friday End Time 1
SM69 SM69020 RespStartSat X_NUMERIC 5 13 8 Working Hours Saturday Start Time 1
SM69 SM69021 RespStopSat X_NUMERIC 5 13 8 Working Hours Saturday End Time 1
SM69 SM69022 RespStartSun X_NUMERIC 5 13 8 Working Hours Sunday Start Time 1
SM69 SM69023 RespStopSun X_NUMERIC 5 13 8 Working Hours Sunday End Time 1
SM69 SM69024 RespBackHours X_NUMERIC 12 20 8 Response Time
SM69 SM69025 RespStartMon2 X_NUMERIC 5 13 8 Working Hours Monday Start Time 2
SM69 SM69026 RespStopMon2 X_NUMERIC 5 13 8 Working Hours Monday End Time 2
SM69 SM69027 RespStartTue2 X_NUMERIC 5 13 8 Working Hours Tuesday Start Time 2
SM69 SM69028 RespStopTue2 X_NUMERIC 5 13 8 Working Hours Tuesday End Time 2
SM69 SM69029 RespStartWed2 X_NUMERIC 5 13 8 Working Hours Wednesday Start Time 2
SM69 SM69030 RespStopWed2 X_NUMERIC 5 13 8 Working Hours Wednesday End Time 2
SM69 SM69031 RespStartThu2 X_NUMERIC 5 13 8 Working Hours Thursday Start Time 2
SM69 SM69032 RespStopThu2 X_NUMERIC 5 13 8 Working Hours Thursday End Time 2
SM69 SM69033 RespStartFri2 X_NUMERIC 5 13 8 Working Hours Friday Start Time 2
SM69 SM69034 RespStopFri2 X_NUMERIC 5 13 8 Working Hours Friday End Time 2
SM69 SM69035 RespStartSat2 X_NUMERIC 5 13 8 Working Hours Saturday Start Time 2
SM69 SM69036 RespStopSat2 X_NUMERIC 5 13 8 Working Hours Saturday End Time 2
SM69 SM69037 RespStartSun2 X_NUMERIC 5 13 8 Working Hours Sunday Start Time 2
SM69 SM69038 RespStopSun2 X_NUMERIC 5 13 8 Working Hours Sunday End Time 2
SM69 SM69039 AccntString ACCSTR 120 120 0 Accounting String
SM69 SM69040 DefContrPeriodDCP INTEGER 4 0 0 Default Contract Period
SM69 SM69041 DCPUnitCode INTEGER 2 0 0 Default Contract Period Unit 1 - Years
2 - Month
3 - Weeks
4 - Days
SM69 SM69042 DefInvInterval INTEGER 4 0 0 Default Invoice Interval
SM69 SM69043 DIIUnitCode INTEGER 2 0 0 Default Invoice Interval Unit 1 - Years
2 - Month
3 - Weeks
4 - Days
SM69 SM69044 AccountSteering STRING 10 10 0 Account Steering
SM69 SM69045 TAXCodeDefault STRING 6 6 0 Default VAT Code
SM69 SM69046 FlagEnterPriceonLine SWITCH 1 1 0 Enter Price and Discount
SM69 SM69047 FlagAdvanceInvoice SWITCH 1 1 0 Invoice in Advance
SM69 SM69048 FlagSerialNoMandatory SWITCH 1 1 0 Mandatory Serial Number
SM69 SM69049 FlagCheckAvailable SWITCH 1 1 0 Check Material Availability
SM69 SM69050 ContractNature STRING 1 1 0 Used For 1 - Service
2 - Rental/Leasing
3 - Call-off order
4 - Blanket order
SM69 SM69051 LineEntryMask VSTRING 150 150 0 Line Entry Mask One string where each character represents a line field, it controls if the field should be adjustable/visible when enter/adjust contract lines.
SM69 SM69052 FlagSerialNoTransactionHistory SWITCH 1 1 0 Serial Number Transaction History
SM69 SM69053 SerialNoHistoryTransactionType STRING 3 3 0 Serial Number History Transaction Type
SM69 SM69054 ContractCounter STRING 1 1 0 Contract Counter
SM69 SM69055 PriceUnitCodeDefault INTEGER 2 0 0 Default Time Unit for Prices 1 - Years
2 - Month
3 - Weeks
4 - Days
SM69 SM69056 AccountingCode STRING 2 2 0 Accounting Code
SM69 SM69057 DeferralsCreationRule SWITCH 1 1 0 Deferrals Creation Rule
SM69 SM69058 DeferralsAllocRule SWITCH 1 1 0 Deferrals Allocation Rule
SM69 SM69059 IntHandlingDays INTEGER 4 0 0 Internal handling in days
SM69 SM69060 IntegrAccDimName STRING 3 3 0 Integrated AccDim Name
SM69 SM69061 IntegrAccDimDescr1 STRING 3 3 0 Integrated AccDim Description Line 1
SM69 SM69062 IntegrAccDimDescr2 STRING 3 3 0 Integrated AccDim Description Line 2
SM69 SM69063 Spare SWITCH 1 1 0 Spare
SM69 SM69064 PurchaseOrderCounter STRING 1 1 0 Purchase Order Counter
SM69 SM69065 PurchaseOrderType INTEGER 1 0 0 Purchase Order Type
SM69 SM69066 AdjustmentOfPurchaseOrder SWITCH 1 1 0 Adjustment of Purchase Order
SM69 SM69067 UpdateFromPurchaseOrder SWITCH 1 1 0 Update from Purchase Order
SM69 SM69068 UpdateToPurchaseOrder SWITCH 1 1 0 Update to Purchase Order
SM69 SM69069 UseLTM SWITCH 1 1 0 Use LTM
SM69 SM69070 ReservationType INTEGER 2 0 0 Reservation Type
SM69 SM69071 ReservationDuration INTEGER 2 0 0 Reservation Time Out (Duration)
SM69 SM69072 ReservationTimeUnit INTEGER 2 0 0 Reservation Time Out (Time unit)
SM69 SM69073 TypeOfPricing INTEGER 2 0 0 Type of Pricing
SM69 SM69074 GenerateSalesStatistics SWITCH 1 1 0 Generate Sales Statistics
SM69 SM69075 AcceptedDeliveryInterval INTEGER 2 0 0 Accepted Delivery Interval
SM69 SM69076 Warehouse VSTRING 6 6 0 Warehouse Code
SM69 SM69077 ApplyMainCustomer SWITCH 1 1 0 Apply Main Customer
SM69 SM69078 OperationType VSTRING 10 10 0 Operation Type
SM69 SM69079 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
SM69 SM69080 Spare SWITCH 1 1 0 Spare
SM69 SM69081 DefaultContractterm INTEGER 1 0 0 Default Contract term
SM69 SM69082 CopyToHistory SWITCH 1 1 0 Copy To History
SM69 SM69083 DiscountValidityCalculation INTEGER 2 0 0 Discount validity calculation
SM69 SM69084 OverviewConfiguration VSTRING 50 50 0 Overview Configuration
SM69 SM69085 CreateExecutionOrder SWITCH 1 1 0 Create Execution Order
SM69 SM69086 ExecutionOrderType STRING 6 6 0 Execution Order Type
SM69 SM69087 LineEntryMask2 VSTRING 150 150 0 Mask for Lease Asset Lines
SM69 SM69088 LineEntryMask3 VSTRING 150 150 0 Mask for Lease Accessory Lines
SM69 SM69089 LineEntryMask4 VSTRING 150 150 0 Mask for Service Asset Lines
SM69 SM69090 PriceTypeAccessory INTEGER 1 0 0 Price Type Accessory
SM69 SM69091 DocumentSpecification INTEGER 1 0 0 Document Specification
SM69 SM69092 DefaultJobObjectType STRING 1 1 0 Default Job Object Type
SM69 SM69093 DefaultJobObjectCode STRING 35 35 0 Default Job Object Code
SM69 SM69094 DefaultJobNumber STRING 6 6 0 Default Job Number
SM69 SM69095 ContractLineCreated STRING 3 3 0 Contract Line Created
SM69 SM69096 AssetDelivered STRING 3 3 0 Asset Delivered
SM69 SM69097 AssetReturned STRING 3 3 0 Asset Returned
SM69 SM69098 AssetSold STRING 3 3 0 Asset Sold
SM69 SM69099 AssetScrapped STRING 3 3 0 Asset Scrapped
SM69 SM69100 ContractLineInvoiced STRING 3 3 0 Contract Line Invoiced
SM69 SM69101 ContractLineCredited STRING 3 3 0 Contract Line Credited
SM69 SM69102 ContractLineClosed STRING 3 3 0 Contract Line Closed
SM69 SM69103 ExtendedCommission SWITCH 1 1 0 Extended Commission
SM69 SM69104 PriceTypeAsset INTEGER 1 0 0 Price Type Asset
SM69 SM69105 InvoiceSpecification INTEGER 1 0 0 Invoice Specification
SM69 SM69106 LeaseStatistics SWITCH 1 1 0 Lease Statistics
SM69 SM69107 HideLeaseAssetLines SWITCH 1 1 0 Hide Lease Asset Lines
SM69 SM69108 HideMaintenanceAssetLines SWITCH 1 1 0 Hide Maintenance Asset Lines
SM69 SM69109 HideLeaseAccessoryLines SWITCH 1 1 0 Hide Lease Accessory Lines
SM69 SM69110 HideMaintenanceAccessoryLines SWITCH 1 1 0 Hide Maintenance Accessory Lines
SM69 SM69111 CreditMode INTEGER 2 0 0 Credit Mode
SM69 SM69112 MinInvoiceTimeValue X_NUMERIC 12 20 8 Min Invoice Time Value
SM69 SM69113 DecimalInvoiceTimeValue INTEGER 2 0 0 Decimals in Invoice Time Value
SM69 SM69114 LineInvoiceIntervalUnit INTEGER 2 0 0 Line invoice interval unit
SM69 SM69115 PriceCalculationProfile VSTRING 10 10 0 Price Calculation Profile
SM69 SM69116 BestPriceCode VSTRING 3 3 0 Best Price Code
SM69 SM69117 ConsolidationMode INTEGER 2 0 0 Consolidation Mode
SM69 SM69118 BestPriceType INTEGER 1 0 0 Best Price Type
SM69 SM69119 Spare X_NUMERIC 12 20 8 Spare
SM69 SM69120 Spare INTEGER 4 0 0 Spare
SM69 SM69121 Spare INTEGER 1 0 0 Spare
SM69 SM69122 LinkWithPOTill INTEGER 1 0 0 Link with PO till
SM69 SM69123 DeliveryDateMilestone INTEGER 1 0 0 Delivery Date Milestone
SM69 SM69124 DeliveryTimeValue X_NUMERIC 12 20 8 Delivery Time Value
SM69 SM69125 DeliveryTimeUnit INTEGER 2 0 0 Delivery Time Unit
SM69 SM69126 UpdatePOStatistics SWITCH 1 1 0 Update PO Statistics
SM69 SM69127 InvoicingModel INTEGER 2 0 0 Invoicing Model
SM69 SM69128 ClosingRule INTEGER 2 0 0 Closing Rule
SM69 SM69129 RevenueRecognitionModel STRING 3 3 0 Revenue Recognition Model
SM69 SM69130 DefaultReturnWH VSTRING 6 6 0 Default Return WH
SM69 SM69131 OperationType_AssetMaintenanceLine VSTRING 10 10 0 Operation Type (Asset Maintenance Line)
SM69 SM69132 FinancialOperationCode_AssetMaintenanceLine VSTRING 10 10 0 Financial Operation Code (Asset Maintenance Line)
SM69 SM69133 OperationType_AccessoryLeaseLine VSTRING 10 10 0 Operation Type (Accessory Lease Line)
SM69 SM69134 FinancialOperationCode_AccessoryLeaseLine VSTRING 10 10 0 Financial Operation Code (Accessory Lease Line)
SM69 SM69135 OperationType_AccessoryMaintenanceLine VSTRING 10 10 0 Operation Type (Accessory Maintenance Line)
SM69 SM69136 FinancialOperationCode_AccessoryMaintenanceLine VSTRING 10 10 0 Financial Operation Code (Accessory Maintenance Line)
SM69 SM69137 ServiceProvisionDateForTax INTEGER 2 0 0 Service Provision date for Tax
SM69 SM69138 TaxationReasonCode STRING 3 3 0 Taxation Reason Code
SM69 SM69139 ApplyATPForSalesContracts SWITCH 1 1 0 Apply ATP For Sales Contracts