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
ORT1 Sales Order Tax Transactions Company ORT10100
SM01 Service Order Master Table Company SM010100
SM02 Service Order Status History Company SM020100
SM03 Service Order Activity Lines Company SM030100
SM04 Service Order Invoice Customers Company SM040100
SM05 Service Order Cost Lines Company SM050100
SM06 Service Order Delivery Lines Company SM060100
SM07 Service Order Material Lines Company SM070100
SM08 Service Order Internal Invoice Summary Company SM080100
SM09 Service Order Text Storage Company SM090100
SM10 Service Order Type Parameter Company SM100100
SM23 Service Order Planning Calendar Company SM230100
SM24 Service Order Activities Company SM240100
SM25 Service Order Activity & Cost Prices Company SM250100
SM26 Service Order Parameters Company SM260100
SM27 Service Order Document Texts (not used) Company SM270100
SM28 Service Order Phrase Texts Company SM280100
SM29 Service Order Templates Company SM290100
SM2A Service Order Material Lead Time Details History Company SM2A0100
SM2D Service Order Activity Descriptions Company SM2D0100
SM30 WIP Transaction Control Table Company SM300100
SM32 Service Job Description Company SM320100
SM33 Company Year SM330112
SM37 Service Order Pager Company SM370100
SM38 Standard Accessories Company SM380100
SM39 Accounting Rules Company SM390100
SM3H Company SM3H0100
SM3L Service Order Material Lead Time Details Company SM3L0100
SM3T Service Job Description Texts Company SM3T0100
SM41 Service Order Head History Company SM410100
SM42 History Service Order Status History Company SM420100
SM43 Service Order Activity Lines History Company SM430100
SM44 Service Order Cost Lines History Company SM440100
SM45 Service Order Material Lines History Company SM450100
SM46 Service Management Texts History Company SM460100
SM47 Service Order Delivery Lines History Company SM470100
SM48 Service Order Invoice Customers History Company SM480100
SM50 Warranty Extension Company SM500100
SM51 Service Order Discount Lines Company SM510100
SM52 Service Order Discount Lines History Company SM520100
SM61 Service Order Error Key (not used) Company SM610100
SM62 Service Order Errors (not used) Company SM620100
SM63 Service Order Automatic Accounting Coding Schedule Company Year SM630112
SM64 Company Year SM640112
SM68 Service Order External Program List Company SM680100
SM72 Service Invoice Sort File Company SM720100
SM73 Picking Locations Company SM730100
SM74 Picking Locations Lines Company SM740100
SM80 Help Desk Header Company SM800100
SM81 Help Desk Solution Code Company SM810100
SM82 Help Desk Instructions Company SM820100
SM83 Service Order User Def Tables (not used) Company SM830100
SM84 Service Order User Def Fields (not used) Company SM840100
SM90 Service Order Image Implementation Company SM900100
SM91 WIP Labour History Company SM910100
SM92 WIP Cost History Company SM920100
SM93 WIP Material History Company SM930100
SM94 Export Document Parameters Company SM940100
SM95 Service Order Transport Document Parameters Company SM950100
SM96 Service Order Transport Documents Company SM960100
SM97 Master Suborder Link Table Company SM970100
SM98 Master Suborder Links History Company SM980100
SMAC Work file for accounting summary Company SMAC0100
SMB1 Service Order BOM Node Company SMB10100
SMB2 Service BOM Node Name Company SMB20100
SMB3 Service Order BOM Link Company SMB30100
SMB4 Service Order BOM Branch Company SMB40100
SMC1 Check List Company SMC10100
SMC2 Check List Lines Company SMC20100
SMD0 Drop Shipment Templates Company SMD00100
SMD2 Service Order Drop Shipment Lines Company SMD20100
SMD3 Service Order Drop Shipment Lines History Company SMD30100
SMDW Work File for Documents Company SMDW0100
SMEX Extended Order Header Company SMEX0100
SMF2 Filter Shop Company SMF20100
SMH1 Service Order BOM Nodes History Company SMH10100
SMH2 Service Order BOM Node Names History Company SMH20100
SMH3 Service Order BOM Links History Company SMH30100
SMH4 Service Order BOM Branches History Company SMH40100
SMHA Service Order Cost and Time History Transactions Company SMHA0100
SMHM Service Order Material History Transactions Company SMHM0100
SMHS Company SMHS0100
SMI2 Service Order Instalment Lines Company SMI20100
SMI4 Service Order Instalment Lines History Company SMI40100
SMMT Business Transaction Type Service Order Mapping Company SMMT0100
SMP1 Preventive Maintenance Plan Company SMP10100
SMP2 Exception Pricing Plan Company SMP20100
SMP3 Actual Usage Company SMP30100
SMP4 Preventive Maintenance Proposal Company SMP40100
SMP5 Exceptional Invoicing Proposal Company SMP50100
SMP6 Conflicting Jobs Company SMP60100
SMT3 Service Order Activity Line Texts Company SMT30100
SMT5 Service Order Cost Line Texts Company SMT50100
SMT7 Service Order Material Line Texts Company SMT70100
SMTA Service Order Cost and Time Transactions Company SMTA0100
SMTM Service Order Material Transactions Company SMTM0100
SMU3 Service Order Activity Line Texts History Company SMU30100
SMU4 Service Order Cost Line Texts History Company SMU40100
SMU5 Service Order Material Line Texts History Company SMU50100
SMUW Mass Update Work file SMUW0000
SMX2 Work File for Time Planning Company SMX20100
SMX3 Work File for Closing Service Invoices Company SMX30100
SMXX Work File for External Update Company SMXX0100
SYS3 Selection Form Template Company SYS30100

Fields
PK Table Name Description Type Length Precision Note
1 SM48 SM48001 ServOrder STRING 10 10 0 Service Order
2 SM48 SM48002 ICustCode STRING 10 10 0 Customer Code Invoice
SM48 SM48003 InvUpdStat INTEGER 1 0 0 Invoice Status 0 - Invoice is not ready for printing
1 - Print invoice
2 - Invoice sent
3 - On-account invoice is ready for printing
4 - On-account invoice sent (waiting to be closed)
SM48 SM48004 ICusPriceList STRING 2 2 0 Price List
SM48 SM48005 FixPriHrsOCU MONEY 20 28 8 Fixed Price Work (Order Currency)
SM48 SM48006 FixPriCostOCU MONEY 20 28 8 Fixed Price Cost (Order Currency)
SM48 SM48007 FixPriMatOCU MONEY 20 28 8 Fixed Price Material (Order Currency)
SM48 SM48008 FixPriHrsICU MONEY 20 28 8 Fixed Price Work (Invoice Currency)
SM48 SM48009 FixPriCostICU MONEY 20 28 8 Fixed Price Cost (Invoice Currency)
SM48 SM48010 FixPriMatICU MONEY 20 28 8 Fixed Price Material (Invoice Currency)
SM48 SM48011 FixPriHrsLCU MONEY 20 28 8 Fixed Price Work (Local Currency)
SM48 SM48012 FixPriCostLCU MONEY 20 28 8 Fixed Price Cost (Local Currency)
SM48 SM48013 FixPriMatLCU MONEY 20 28 8 Fixed Price Material (Local Currency)
SM48 SM48014 InvSpecHrs INTEGER 1 0 0 Invoice Specification Work 0 - The sum of work, cost and material is printed as a single total amount
1 - All activity lines are printed as a single total amount.
2 - Each activity transaction is printed on the invoice
SM48 SM48015 InvSpecCost INTEGER 1 0 0 Invoice Specification Cost 1 - All cost lines are printed as a single total amount.
2 - Each cost transaction is printed on the invoice
SM48 SM48016 InvSpecMat INTEGER 1 0 0 Invoice Specification Material 1 - All material lines are printed as a single total amount.
2 - Each material transaction is printed on the invoice
SM48 SM48017 HandFeeOCU MONEY 20 28 8 Invoice Fee (Order Currency)
SM48 SM48018 HandFeeICU MONEY 20 28 8 Invoice Fee (Invoice Currency)
SM48 SM48019 HandFeeLCU MONEY 20 28 8 Invoice Fee (Local Currency)
SM48 SM48020 TermOfPay STRING 2 2 0 Payment Terms
SM48 SM48021 InvoiceMergeFlag STRING 1 1 0 Invoice Merge Option Invoice merge option:
0 - No consolidated invoice
1 - Consolidate invoice per week
2 - Consolidate invoice per month
SM48 SM48022 ExtCommis X_NUMERIC 7 15 8 External Commission %
SM48 SM48023 ExtCommCode VSTRING 10 10 0 External Commission Code
SM48 SM48024 SOAccCode STRING 2 2 0 Accounting Code Service Order
SM48 SM48025 AccString ACCSTR 120 120 0 Accounting String
SM48 SM48026 LanguageCode VSTRING 3 3 0 Language
SM48 SM48027 DocLayout STRING 1 1 0 Document Layout
SM48 SM48028 AdvInvoiceAmountOCU MONEY 20 28 8 On-account Amount (Order Currency)
SM48 SM48029 AdvInvoiceAmountICU MONEY 20 28 8 On-account Amount (Invoice Currency)
SM48 SM48030 AdvInvoiceAmountLCU MONEY 20 28 8 On-account Amount (Local Currency)
SM48 SM48031 CeilingAmountOCU MONEY 20 28 8 Ceiling Amount (Order Currency)
SM48 SM48032 CeilingAmountICU MONEY 20 28 8 Ceiling Amount (Invoice Currency)
SM48 SM48033 CeilingAmountLCU MONEY 20 28 8 Ceiling Amount (Local Currency)
SM48 SM48034 AdvInvPaidAmountOCU MONEY 20 28 8 On-account Invoice Amount (Order Currency)
SM48 SM48035 AdvInvPaidAmountICU MONEY 20 28 8 On-account Invoice Amount (Invoice Currency)
SM48 SM48036 AdvInvPaidAmountLCU MONEY 20 28 8 On-account Invoice Amount (Local Currency)
SM48 SM48037 AdvInvUsedAmountOCU MONEY 20 28 8 On-account Deducted Amount (Order Currency)
SM48 SM48038 AdvInvUsedAmountICU MONEY 20 28 8 On-account Deducted Amount (Invoice Currency)
SM48 SM48039 AdvInvUsedAmountLCU MONEY 20 28 8 On-account Deducted Amount (Local Currency)
SM48 SM48040 AdvInvoiceTaxCode STRING 6 6 0 On-account VAT Code
SM48 SM48041 DeductAdvInvoice SWITCH 1 1 0 Deduct On-account Invoice
SM48 SM48042 AdvInvoiceText1 STRING 25 25 0 Advance Invoice Text Line 1
SM48 SM48043 AdvInvoiceText2 STRING 25 25 0 Advance Invoice Text Line 2
SM48 SM48044 ExchngDate DATE 8 0 0 Currency Exchange Date
SM48 SM48045 CorrectionNumber STRING 1 1 0 Correction Number
SM48 SM48046 AdvInvTotalAmountOCU MONEY 20 28 8 On-account Total Amount (Order Currency)
SM48 SM48047 AdvInvTotalAmountICU MONEY 20 28 8 On-account Total Amount (Invoice Currency)
SM48 SM48048 AdvInvTotalAmountLCU MONEY 20 28 8 On-account Total Amount (Local Currency)
SM48 SM48049 InvCurrencyCode STRING 2 2 0 Currency Code Invoice
3 SM48 SM48050 LastInvoiceNumber STRING 15 15 0 Invoice Number
SM48 SM48051 LastInvoiceDate DATE 8 0 0 Invoice Date
SM48 SM48052 LastAdvInvoiceNumber STRING 15 15 0 Last Advance Invoice Number
SM48 SM48053 LastAdvInvoiceDate DATE 8 0 0 Last Advance Invoice Date
SM48 SM48054 CoveredAmountOCU MONEY 20 28 8 Covered Amount (Order Currency)
SM48 SM48055 CoveredAmountICU MONEY 20 28 8 Covered Amount (Invoice Currency)
SM48 SM48056 CoveredAmountLCU MONEY 20 28 8 Covered Amount (Local Currency)
SM48 SM48057 CoveredTotAmountOCU MONEY 20 28 8 Covered Total Amount (Order Currency)
SM48 SM48058 CoveredTotAmountICU MONEY 20 28 8 Covered Total Amount (Invoice Currency)
SM48 SM48059 CoveredTotAmountLCU MONEY 20 28 8 Covered Total Amount (Local Currency)
SM48 SM48060 MarkUp INTEGER 4 0 0 Mark-up %
SM48 SM48061 InvIssuer VSTRING 6 6 0 Invoice Issuer Code
SM48 SM48062 InvCategory SWITCH 1 1 0 Invoice Category
SM48 SM48063 InvType SWITCH 1 1 0 Invoice Type 0 - Invoice (day to day business)
1 - Debit note
2 - Credit note
SM48 SM48064 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
SM48 SM48065 FlagForwardCover SWITCH 1 1 0 Flag Forward Cover
SM48 SM48066 FwdCoverExchRate X_NUMERIC 15 23 8 Forward Cover Exchange Rate
SM48 SM48067 FwdCoverRef VSTRING 15 15 0 Forward Cover Reference
SM48 SM48068 DebitInvoiceFlag SWITCH 1 1 0 Debit Invoice Flag
SM48 SM48069 TaxCodeForInvFee STRING 6 6 0 Tax Code for Invoice Fee
SM48 SM48070 FixedPriceOCU X_NUMERIC 13 21 8 Fixed Price OCU
SM48 SM48071 FixedPriceICU X_NUMERIC 13 21 8 Fixed Price ICU
SM48 SM48072 FixedPriceLCU X_NUMERIC 13 21 8 Fixed Price LCU
SM48 SM48073 TaxCodeForFixPrice STRING 6 6 0 Tax Code for Fixed Price
SM48 SM48074 OperationTypeOrder VSTRING 10 10 0 Operation Type Order
SM48 SM48075 FinancialOperationCodeOrder VSTRING 10 10 0 Financial Operation Code Order
SM48 SM48076 OperationTypeTime VSTRING 10 10 0 Operation Type Time
SM48 SM48077 FinancialOperationCodeTime VSTRING 10 10 0 Financial Operation Code Time
SM48 SM48078 OperationTypeCost VSTRING 10 10 0 Operation Type Cost
SM48 SM48079 FinancialOperationCodeCost VSTRING 10 10 0 Financial Operation Code Cost
SM48 SM48080 OperationTypeMaterial VSTRING 10 10 0 Operation Type Material
SM48 SM48081 FinancialOperationCodeMaterial VSTRING 10 10 0 Financial Operation Code Material
SM48 SM48082 Instalment SWITCH 1 1 0 Instalment
SM48 SM48083 InterestPercent X_NUMERIC 12 20 8 Interest%
SM48 SM48084 NewInterestPercent X_NUMERIC 12 20 8 New Interest%
SM48 SM48085 ActivateNewInterestDate DATE 8 0 0 Activate New Interest Date
SM48 SM48086 FinancialCharge MONEY 20 28 8 Financial Charge
SM48 SM48087 InterestTaxCode STRING 6 6 0 Interest Tax Code
SM48 SM48088 FinancialTaxCode STRING 6 6 0 Financial Tax Code
SM48 SM48089 SpecificationPrintedFlag SWITCH 1 1 0 Specification Printed Flag
SM48 SM48090 FixedPriceTimeLineGroup VSTRING 6 6 0 Fixed Price Time Line Group
SM48 SM48091 FixedPriceCostLineGroup VSTRING 6 6 0 Fixed Price Cost Line Group
SM48 SM48092 FixedPriceMatLineGroup VSTRING 6 6 0 Fixed Price Mat Line Group
SM48 SM48093 ExternalCommissionAmount MONEY 20 28 8 External Commission Amount
SM48 SM48094 District STRING 2 2 0 District
SM48 SM48095 AdvertisingCode STRING 2 2 0 Advertising Code
SM48 SM48096 CityCode STRING 4 4 0 City Code
SM48 SM48097 SNICode STRING 5 5 0 SNI Code
SM48 SM48098 BankCode VSTRING 10 10 0 Bank Code
SM48 SM48099 PaymentAddressCode VSTRING 2 2 0 Payment Address Code
SM48 SM48100 ExtendedCommissionCode STRING 2 2 0 Extended Commission Code
SM48 SM48101 InvCounterID VSTRING 12 12 0 Invoice counter ID
SM48 SM48102 InvoiceCopyNumber INTEGER 4 0 0 Invoice Copy Number
SM48 SM48103 OnaccountInvoiceCopyNumber INTEGER 4 0 0 On-account Invoice Copy Number
SM48 SM48104 OriginalOrderNo VSTRING 10 10 0 Original Order No
SM48 SM48105 OriginalInvoiceNo VSTRING 15 15 0 Original Invoice No
SM48 SM48106 FlagDocXMLInvoice INTEGER 1 0 0 Flag Doc XML Invoice
SM48 SM48107 LastInvoiceTime X_DATETIME 17 0 0 Last Invoice Time
SM48 SM48108 LastAdvInvoiceTime X_DATETIME 17 0 0 Last Advance Invoice Time
SM48 SM48109 FreightAmountICU MONEY 20 28 8 Freight Amount, ICU
SM48 SM48110 TaxCodeFreight STRING 6 6 0 Tax Code for Freight
SM48 SM48111 FreightPayer STRING 1 1 0 Freight Payer
SM48 SM48112 NetWeight X_NUMERIC 10 18 8 Net Weight
SM48 SM48113 GrossWeight X_NUMERIC 10 18 8 Gross Weight
SM48 SM48114 Volume X_NUMERIC 10 18 8 Volume
SM48 SM48115 NoOfUnits X_NUMERIC 10 18 8 No Of Units
SM48 SM48116 KindOfBox VSTRING 15 15 0 Kind Of Box
SM48 SM48117 BoxNumbering VSTRING 15 15 0 Box Numbering
SM48 SM48118 NumberOfPallets VSTRING 15 15 0 Number Of Pallets
SM48 SM48119 TransportCompanyCode VSTRING 10 10 0 Transport Company Code
SM48 SM48120 VehicleState VSTRING 10 10 0 Vehicle State
SM48 SM48121 VehicleLicensePlate VSTRING 15 15 0 Vehicle License Plate
SM48 SM48122 CodeANTT VSTRING 10 10 0 Code ANTT
SM48 SM48123 TaxesForFreight STRING 1 1 0 Taxes for Freight
SM48 SM48124 FiscalKeyReference VSTRING 50 50 0 Fiscal Key Reference
SM48 SM48125 SpesometroForms VSTRING 12 12 0 Spesometro Forms
SM48 SM48126 TaxPoint STRING 1 1 0 Tax Point
4 SM48 SM48127 InvPlanLineNo STRING 6 6 0 InvPlanLineNo
SM48 SM48128 TaxationReasonCodeFixedPrice STRING 3 3 0 Taxation Reason Code Fixed Price
SM48 SM48129 TaxationReasonCodeOnAccount STRING 3 3 0 Taxation Reason Code On-Account
SM48 SM48130 ICUExchangeRate1 X_NUMERIC 10 18 8 ICU Exchange Rate 1
SM48 SM48131 ICUExchangeRate2 X_NUMERIC 10 18 8 ICU Exchange Rate 2
SM48 SM48132 ICUExchangeAlgorithm STRING 3 3 0 ICU Exchange Algorithm
SM48 SM48133 CreditReason VSTRING 50 50 0 Credit Reason