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 SM15 SM15001 Year_ STRING 2 2 0 Year
SM15 SM15002 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15003 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15004 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15005 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15006 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15007 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15008 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15009 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15010 Spare NUMBER 1 20 0 (obsolete)
SM15 SM15011 InvCopNo INTEGER 2 0 0 Number of Copies Invoice
SM15 SM15012 ContrCopNo INTEGER 2 0 0 Number of Copies Contract
SM15 SM15013 LabelsCopyNo INTEGER 2 0 0 Number of Copies Label
SM15 SM15014 ReminderCopyNo INTEGER 2 0 0 Number of Copies Reminder
SM15 SM15015 InvoiceFee MONEY 20 28 8 Invoice Fee (Local Currency)
SM15 SM15016 LimOnInvFee MONEY 20 28 8 Invoice Fee Limit (Local Currency)
SM15 SM15017 IncrOrdPosit INTEGER 2 0 0 Increment Order Line Number
SM15 SM15018 SourceOfCurrency INTEGER 1 0 0 Source of Currency 0 - Contract and invoice currency is taken from price list
1 - Contract and invoice currency is taken from customer
2 - Contract currency is taken from price list. Invoice currency is taken from customer
SM15 SM15019 DeferralRule INTEGER 1 0 0 Deferral Rule 0 - Deferrals are not created
1 - Deferrals are created manually
2 - Deferrals are created automatically
SM15 SM15020 CopNoDoc2 INTEGER 2 0 0 Number of Copies Document 1
SM15 SM15021 CopNoDoc3 INTEGER 2 0 0 Number of Copies Document 2
SM15 SM15022 CopNoCancel INTEGER 2 0 0 Number of Copies Cancellation Document
SM15 SM15023 CopNoQuotation INTEGER 2 0 0 Number of Copies Quotation
SM15 SM15024 Spare MONEY 20 28 8 (obsolete)
SM15 SM15025 DaysIntHandling INTEGER 2 0 0 Internal Handling in Days
SM15 SM15026 SelectedDimension INTEGER 2 0 0 Selected Dimension
SM15 SM15027 Spare MONEY 20 28 8 (obsolete)
SM15 SM15028 Spare MONEY 20 28 8 (obsolete)
SM15 SM15029 Spare X_NUMERIC 12 20 8 (obsolete)
SM15 SM15030 DefaultInvoiceSplit INTEGER 8 0 0 Default invoice split
SM15 SM15031 Spare X_NUMERIC 6 14 8 (obsolete)
SM15 SM15032 Spare INTEGER 3 0 0 (obsolete)
SM15 SM15033 Spare INTEGER 2 0 0 (obsolete)
SM15 SM15034 Spare INTEGER 2 0 0 (obsolete)
SM15 SM15035 Spare INTEGER 2 0 0 (obsolete)
SM15 SM15036 Spare INTEGER 1 0 0 (obsolete)
SM15 SM15037 Spare INTEGER 1 0 0 (obsolete)
SM15 SM15038 Spare INTEGER 1 0 0 (obsolete)
SM15 SM15039 Spare INTEGER 1 0 0 (obsolete)
SM15 SM15040 Spare INTEGER 1 0 0 (obsolete)
SM15 SM15041 AccountingPeriodForDeferrals INTEGER 1 0 0 Accounting Period for Deferrals
SM15 SM15042 DimensionIntegration SWITCH 1 1 0 Dimension Integration
SM15 SM15043 Sw2UpdSOStat SWITCH 1 1 0 Update Statistics
SM15 SM15044 TransactionStamping STRING 1 1 0 Transaction Stamping 0 - No currency stamp on transactions
1 - Transactions are stamped with currency value
2 - Transactions are stamped with currency date
SM15 SM15045 Sw4FlClCoCan SWITCH 1 1 0 Delete Closed Contracts
SM15 SM15046 Sw5IndClaSta SWITCH 1 1 0 Index Clause as Default
SM15 SM15047 SLInvoiceMerge SWITCH 1 1 0 SL Invoice Merge
SM15 SM15048 CreditLimitBlockPicking SWITCH 1 1 0 Credit Limit Block Picking
SM15 SM15049 Sw8IndAdjDoc SWITCH 1 1 0 Use Index on Other Documents
SM15 SM15050 Sw9TakeAccnt SWITCH 1 1 0 Source of Accounting Information 0 - Accounting dimensions are taken from contract type
1 - Accounting dimensions are taken from contract line
SM15 SM15051 InvoiceHistory SWITCH 1 1 0 Invoice History
SM15 SM15052 DiscountAccounting SWITCH 1 1 0 Discount Accounting
SM15 SM15053 SNOwnerControl SWITCH 1 1 0 Serial Number Owner Control
SM15 SM15054 AccrType SWITCH 1 1 0 Deferrals per Invoice Period
SM15 SM15055 GLIntegrated SWITCH 1 1 0 Integrated with General Ledger
SM15 SM15056 UseGLTransactionNo SWITCH 1 1 0 Use General Ledger Transaction Number
SM15 SM15057 UpdUtilAmntWithContractReservations SWITCH 1 1 0 Update utilized amount with contract reservations
SM15 SM15058 UpdUtilAmntWithCustomerReservations SWITCH 1 1 0 Update utilized amount with customer reservations
SM15 SM15059 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15060 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15061 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15062 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15063 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15064 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15065 Spare SWITCH 1 1 0 (obsolete)
SM15 SM15066 TimZonName01 STRING 3 3 0 Time Zone 1 Name
SM15 SM15067 TimZonName02 STRING 3 3 0 Time Zone 2 Name
SM15 SM15068 TimZonName03 STRING 3 3 0 Time Zone 3 Name
SM15 SM15069 TimZonName04 STRING 3 3 0 Time Zone 4 Name
SM15 SM15070 TimZonName05 STRING 3 3 0 Time Zone 5 Name
SM15 SM15071 TimZonName06 STRING 3 3 0 Time Zone 6 Name
SM15 SM15072 TimZonName07 STRING 3 3 0 Time Zone 7 Name
SM15 SM15073 TimZonName08 STRING 3 3 0 Time Zone 8 Name
SM15 SM15074 TimZonName09 STRING 3 3 0 Time Zone 9 Name
SM15 SM15075 TimZonName10 STRING 3 3 0 Time Zone 10 Name
SM15 SM15076 TimZonName11 STRING 3 3 0 Time Zone 11 Name
SM15 SM15077 TimZonName12 STRING 3 3 0 Time Zone 12 Name
SM15 SM15078 TimZonName13 STRING 3 3 0 Time Zone 13 Name
SM15 SM15079 TimZonName14 STRING 3 3 0 Time Zone 14 Name
SM15 SM15080 TimZonName15 STRING 3 3 0 Time Zone 15 Name
SM15 SM15081 TimZonName16 STRING 3 3 0 Time Zone 16 Name
SM15 SM15082 TimZonName17 STRING 3 3 0 Time Zone 17 Name
SM15 SM15083 TimZonName18 STRING 3 3 0 Time Zone 18 Name
SM15 SM15084 TimZonName19 STRING 3 3 0 Time Zone 19 Name
SM15 SM15085 TimZonName20 STRING 3 3 0 Time Zone 20 Name
SM15 SM15086 TimZonName21 STRING 3 3 0 Time Zone 21 Name
SM15 SM15087 TimZonName22 STRING 3 3 0 Time Zone 22 Name
SM15 SM15088 TimZonName23 STRING 3 3 0 Time Zone 23 Name
SM15 SM15089 TimZonName24 STRING 3 3 0 Time Zone 24 Name
SM15 SM15090 ZonOffsHrs01 X_NUMERIC 6 14 8 Time Zone 1 Hours Offset to GMT
SM15 SM15091 ZonOffsHrs02 X_NUMERIC 6 14 8 Time Zone 2 Hours Offset to GMT
SM15 SM15092 ZonOffsHrs03 X_NUMERIC 6 14 8 Time Zone 3 Hours Offset to GMT
SM15 SM15093 ZonOffsHrs04 X_NUMERIC 6 14 8 Time Zone 4 Hours Offset to GMT
SM15 SM15094 ZonOffsHrs05 X_NUMERIC 6 14 8 Time Zone 5 Hours Offset to GMT
SM15 SM15095 ZonOffsHrs06 X_NUMERIC 6 14 8 Time Zone 6 Hours Offset to GMT
SM15 SM15096 ZonOffsHrs07 X_NUMERIC 6 14 8 Time Zone 7 Hours Offset to GMT
SM15 SM15097 ZonOffsHrs08 X_NUMERIC 6 14 8 Time Zone 8 Hours Offset to GMT
SM15 SM15098 ZonOffsHrs09 X_NUMERIC 6 14 8 Time Zone 9 Hours Offset to GMT
SM15 SM15099 ZonOffsHrs10 X_NUMERIC 6 14 8 Time Zone 10 Hours Offset to GMT
SM15 SM15100 ZonOffsHrs11 X_NUMERIC 6 14 8 Time Zone 11 Hours Offset to GMT
SM15 SM15101 ZonOffsHrs12 X_NUMERIC 6 14 8 Time Zone 12 Hours Offset to GMT
SM15 SM15102 ZonOffsHrs13 X_NUMERIC 6 14 8 Time Zone 13 Hours Offset to GMT
SM15 SM15103 ZonOffsHrs14 X_NUMERIC 6 14 8 Time Zone 14 Hours Offset to GMT
SM15 SM15104 ZonOffsHrs15 X_NUMERIC 6 14 8 Time Zone 15 Hours Offset to GMT
SM15 SM15105 ZonOffsHrs16 X_NUMERIC 6 14 8 Time Zone 16 Hours Offset to GMT
SM15 SM15106 ZonOffsHrs17 X_NUMERIC 6 14 8 Time Zone 17 Hours Offset to GMT
SM15 SM15107 ZonOffsHrs18 X_NUMERIC 6 14 8 Time Zone 18 Hours Offset to GMT
SM15 SM15108 ZonOffsHrs19 X_NUMERIC 6 14 8 Time Zone 19 Hours Offset to GMT
SM15 SM15109 ZonOffsHrs20 X_NUMERIC 6 14 8 Time Zone 20 Hours Offset to GMT
SM15 SM15110 ZonOffsHrs21 X_NUMERIC 6 14 8 Time Zone 21 Hours Offset to GMT
SM15 SM15111 ZonOffsHrs22 X_NUMERIC 6 14 8 Time Zone 22 Hours Offset to GMT
SM15 SM15112 ZonOffsHrs23 X_NUMERIC 6 14 8 Time Zone 23 Hours Offset to GMT
SM15 SM15113 ZonOffsHrs24 X_NUMERIC 6 14 8 Time Zone 24 Hours Offset to GMT
SM15 SM15114 Spare STRING 20 20 0 (obsolete)
SM15 SM15115 Spare STRING 20 20 0 (obsolete)
SM15 SM15116 Spare STRING 10 10 0 (obsolete)
SM15 SM15117 Spare STRING 10 10 0 (obsolete)
SM15 SM15118 Spare STRING 10 10 0 (obsolete)
SM15 SM15119 Spare DATE 8 0 0 (obsolete)
SM15 SM15120 Spare DATE 8 0 0 (obsolete)
SM15 SM15121 Spare STRING 6 6 0 Journal Code Accruals
SM15 SM15122 Spare STRING 6 6 0 (obsolete)
SM15 SM15123 Spare STRING 3 3 0 (obsolete)
SM15 SM15124 Spare STRING 3 3 0 (obsolete)
SM15 SM15125 Spare STRING 3 3 0 (obsolete)
SM15 SM15126 Spare STRING 2 2 0 (obsolete)
SM15 SM15127 Spare STRING 2 2 0 (obsolete)
SM15 SM15128 Spare STRING 2 2 0 (obsolete)
SM15 SM15129 Spare STRING 2 2 0 (obsolete)
SM15 SM15130 Spare STRING 2 2 0 (obsolete)
SM15 SM15131 Spare STRING 2 2 0 (obsolete)
SM15 SM15132 Spare STRING 1 1 0 (obsolete)
SM15 SM15133 Spare STRING 1 1 0 (obsolete)
SM15 SM15134 DeferralsEntryDay INTEGER 2 0 0 Day on which Deferrals are Booked
SM15 SM15135 InvoiceIntervalLength INTEGER 2 0 0 Maximum Invoice Interval Length in years
SM15 SM15136 DefaultContractType STRING 3 3 0 Default Contract Type
SM15 SM15137 DefaultContractNature STRING 1 1 0 Default Contract Nature
SM15 SM15138 ServiceEntryType STRING 3 3 0 Service Entry Type
SM15 SM15139 ServiceContractType STRING 3 3 0 Service Contract Type
SM15 SM15140 SalesEntryType STRING 3 3 0 Sales Entry Type
SM15 SM15141 SalesContractType STRING 3 3 0 Sales Contract Type
SM15 SM15142 PurchaseEntryType STRING 3 3 0 Purchase Entry Type
SM15 SM15143 PurchaseContractType STRING 3 3 0 Purchase Contract Type
SM15 SM15144 LeaseEntryType STRING 3 3 0 Lease Entry Type
SM15 SM15145 LeaseContractType STRING 3 3 0 Lease Contract Type
SM15 SM15146 RentalEntryType STRING 3 3 0 Rental Entry Type
SM15 SM15147 RentalContractType STRING 3 3 0 Rental Contract Type
SM15 SM15148 CreateElectronicContract INTEGER 1 0 0 Create Electronic Contract
SM15 SM15149 CreditCheckService SWITCH 1 1 0 Credit Check Service
SM15 SM15150 CreditCheckLease SWITCH 1 1 0 Credit Check Lease
SM15 SM15151 CreditCheckSales SWITCH 1 1 0 Credit Check Sales
SM15 SM15152 CreditCheckLine SWITCH 1 1 0 Credit Check Line
SM15 SM15153 CreditCheckSkipAdditional SWITCH 1 1 0 Credit Check Skip Additional
SM15 SM15154 CreditCheckExit SWITCH 1 1 0 Credit Check Exit
SM15 SM15155 CreditLimitBlockQuotation SWITCH 1 1 0 Credit Limit Block Quotation
SM15 SM15156 CreditLimitBlockEntry SWITCH 1 1 0 Credit Limit Block Entry
SM15 SM15157 CreditLimitBlockReservation SWITCH 1 1 0 Credit Limit Block Reservation
SM15 SM15158 CreditLimitBlockAllocation SWITCH 1 1 0 Credit Limit Block Allocation
SM15 SM15159 CreditLimitBlockDelivery SWITCH 1 1 0 Credit Limit Block Delivery
SM15 SM15160 CreditLimitBlockServiceOrder SWITCH 1 1 0 Credit Limit Block Service Order
SM15 SM15161 TaxPoint STRING 1 1 0 Tax Point