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
COB1 Configuration BOM Node Company COB10100
COB2 Configuration BOM Node Name Company COB20100
COB3 Configuration BOM Link Company COB30100
COB4 Configuration BOM Branch Company COB40100
COB5 BOM Configuration Names Company COB50100
COB6 Configuration Orders Company COB60100
COB8 Configuration helper Company COB80100
COH6 Configuration Orders Company COH60100
COH7 BOM Configuration History Company COH70100
sca_trg_Audit_SY29 Audit trigger for SY29 table Company sca_trg_Audit_SY290100
ScaCalCollections Calendar Collections Company ScaCalCollections0100
ScaCalCollectionsDescr Calendar Collection Descriptions Company ScaCalCollectionsDescr0100
ScaCalDays Calendar Days Company ScaCalDays0100
ScaCalDayTypeGroup Calendar Day Type Group Links Company ScaCalDayTypeGroup0100
ScaCalDayTypes Calendar Day Types Company ScaCalDayTypes0100
ScaCalDayTypesDescr Calendar Day Type Descriptions Company ScaCalDayTypesDescr0100
ScaCalendars Calendars Company ScaCalendars0100
ScaCalendarsDescr Calendar Descriptions Company ScaCalendarsDescr0100
ScaCalInheritance Calendar Inheritance Company ScaCalInheritance0100
ScaCalRecurrences ScaCalRecurrences Company ScaCalRecurrences0100
ScaCalStatus Calendars Status Company ScaCalStatus0100
ScaCalTaskConflicts Calendar Conflicting Tasks Company ScaCalTaskConflicts0100
ScaCalTaskOccurrences Calendar Task Occurrences Company ScaCalTaskOccurrences0100
ScaCalTasks Calendar Tasks Company ScaCalTasks0100
ScaCalTime Calendar Time Company ScaCalTime0100
ScaCalTimeTypeGroup Calendar Time Type Group Links Company ScaCalTimeTypeGroup0100
ScaCalTimeTypes Calendar Time Types Company ScaCalTimeTypes0100
ScaCalTimeTypesDescr Calendar Time Type Descriptions Company ScaCalTimeTypesDescr0100
ScaReportStyle Report Style ScaReportStyle0000
ScaReportStyleProperty Report Style Property ScaReportStyleProperty0000
ScaReportStylePropertyValue Report Style Property Value ScaReportStylePropertyValue0000
SY12 Standard Form Text Company SY120100
SY14 Currency File Company SY140100
SY16 Feature Activation File SY160000
SY18 Tax Engine Parameters Company SY180100
SY24 General Code File Company SY240100
SY26 Currency Quotation File Company SY260100
SY28 Pre-printing form inventory Company SY280100
SY29 Vat Codes/Tax Rate Codes Company SY290100
SY2C Scala Year Independent Counter Storage Company SY2C0100
SY2D Skipped Counter Values(Year Independent) Company SY2D0100
SY2X VAT Periods SY2X0000
SY2Z VAT Macros SY2Z0000
SY31 Accounting Dimensions Defaults Company SY310100
SY33 VAT Code Matrix Company SY330100
SY34 VAT Codes Foreign Descriptions Company SY340100
SY40 Scala Parameters Storage Company SY400100
SY41 Scala Import/Export Data Storage Company SY410100
SY42 Multilingual Code File Company SY420100
SY43 Planning Calendar Company SY430100
SY44 Electronic Links Company SY440100
SY45 Tolerance Table Company SY450100
SY46 Tolerance Control Table Company SY460100
SY47 Business Destinations SY470000
SY48 Business Destination Descriptions SY480000
SY49 Business Destination Links Company SY490100
SY51 Company SY510100
SY52 Export control action Company SY520100
SY53 Export control rules Company SY530100
SY55 Cheque Transactions Company SY550100
SY68 Scala Counter Storage Company Year SY680112
SY69 Skipped Counter Values Company Year SY690112
SY70 Multiple IBAN codes Company SY700100
SY71 IBAN Layout SY710000
SY72 IBAN Bank Definition Company SY720100
SY73 Common ID Definition SY730000
SY74 ISO Country Names SY740000
SY75 Common Address Layout SY750000
SY76 Common Address Data Company SY760100
SY77 Common ID Ranges Company SY770100
SY78 Common ID Primary Key SY780000
SY79 Common ID Query Definition SY790000
SY7A Common ID Description SY7A0000
SY7B Common Address Descriptions SY7B0000
SY7C Common Address Line Descriptions SY7C0000
SY7D IBAN Country Codes SY7D0000
SY7E IBAN Bank Names Company SY7E0100
SY7F IBAN Layout Descriptions SY7F0000
SY7H Country-specific Common Address SY7H0000
SY7K Extra Data Codes SY7K0000
SY7L Extra Data Codes Descriptions SY7L0000
SY7Q Common ID Query Description SY7Q0000
SY7R Common Ranges Company SY7R0100
SY7S UDDB Default Values Company SY7S0100
SY7T Validation Rules Company SY7T0100
SY80 Customer Site Addresses Company SY800100
SY81 BTT Type Multilingual Company SY810100
SY82 Lead Time Element Company SY820100
SY83 Lead Time Element Multilingual Company SY830100
SY84 Delivery Variation Company SY840100
SY85 Delivery Variation Multilingual Company SY850100
SY86 Lead Time Rule Company SY860100
SY87 Lead Time Rule Duration Company SY870100
SY88 BTT Type Company SY880100
SY90 Company SY900100
SY91 Company SY910100
SY97 Work file central currency dictionary SY970000
SY98 Work file central currency dictionary SY980000
SYA1 Company SYA10100
SYA2 Company SYA20100
SYAC Accounting String Conversion Control Company SYAC0100
SYAF Audit Trail for Monetary Restatement Company Year SYAF0112
SYB1 Tax Rule Company SYB10100
SYB3 Financial Operation Codes Company SYB30100
SYB4 IOGS Report Types Company SYB40100
SYB5 IOGS Record Types SYB50000
SYB6 IOGS Field Types SYB60000
SYB7 IOGS Record Structure Company SYB70100
SYB9 NCM Code Company SYB90100
SYBC Fiscal Text Codes Company SYBC0100
SYBD Document Fiscal Text Company SYBD0100
SYBE Business Event and Action Company SYBE0100
SYBJ Origin / Destination Rates Company SYBJ0100
SYBK EDI Layout Headers Company SYBK0100
SYBL Access Restrictions Company SYBL0100
SYBM EDI Layout Lines Company SYBM0100
SYBN Output FileHeaders Company Year SYBN0112
SYBO Output File Lines Company Year SYBO0112
SYBQ EDI Field Descriptions Company SYBQ0100
SYBT EDI Collection Events Company SYBT0100
SYBU EDI Bank Information Company SYBU0100
SYBY TS Margins Company SYBY0100
SYBZ Serial Invoice Number Company SYBZ0100
SYCC Central Currency. Dictionary SYCC0000
SYCD Currency Dictionary Company SYCD0100
SYCE EMU Currency History SYCE0000
SYCF Central Currency File SYCF0000
SYCH Currency History Company SYCH0100
SYCI Central Currency File SYCI0000
SYD0 Document image header Company SYD00100
SYD1 Document image lines Company SYD10100
SYDL Signed document lines Company SYDL0100
SYDN Signed Document Company SYDN0100
SYDS Signed Document Serial Number Company SYDS0100
SYEI Excel Import Definition Company SYEI0100
SYES Dynamic email setup Company SYES0100
SYET Table storing Entry Types Company SYET0100
SYFF Log File Monetary Restatement Company Year SYFF0112
SYFH View Audit History Filter Header Company SYFH0100
SYFL View Audit History Filter Fields Company SYFL0100
SYFT View Audit History Filter Tables Company SYFT0100
SYH1 Company SYH10100
SYH2 Company SYH20100
SYH3 Company SYH30100
SYHH Company SYHH0100
SYHL Company SYHL0100
SYIC Company SYIC0100
SYIF Company SYIF0100
SYIJ Invoicing jobs interconnection table Company SYIJ0100
SYL1 Tax Types Company SYL10100
SYL2 Tax Liability Company SYL20100
SYL3 Tax Liabilities Company SYL30100
SYL4 Tax Codes Company SYL40100
SYL5 Tax Codes Lines Company SYL50100
SYL6 Tax Rate Intervals Company SYL60100
SYL7 Tax Exemptions Company SYL70100
SYL8 Document Issuer Company SYL80100
SYLK Attachment Storage Links Company SYLK0100
SYM1 Company SYM10100
SYM2 Company SYM20100
SYNT Report Naming Template Table Company SYNT0100
SYPC Company SYPC0100
SYPD Purchaser File Foreign Name Company SYPD0100
SYPF Print Queue Filters Company SYPF0100
SYPP Company SYPP0100
SYPQ Print Job Queue Table Company SYPQ0100
SYPU Purchaser File Company SYPU0100
SYR0 Business Rule Certificate Assignment Company SYR00100
SYR4 Transaction Control Parameters Company SYR40100
SYR5 Control Classes Company SYR50100
SYR6 Business Rule Certificate Company SYR60100
SYR7 Business Rules Company SYR70100
SYR8 Business Rule Certificate UDFs Company SYR80100
SYR9 Business Rules Descriptions Company SYR90100
SYRA Business Rule Certificate UDF Template Company SYRA0100
SYRB Business Rule Certificate UDF Structure Company SYRB0100
SYRC Business Rule Certificate UDF Captions Company SYRC0100
SYRF Common ID References Company SYRF0100
SYRS Synchronization Setup Company SYRS0100
SYRT Synchronization Status Company SYRT0100
SYS1 Bank Information Company SYS10100
SYS2 Filter Switch Company SYS20100
SYSR Report File Replacement Symbols Company SYSR0100
SYTB Tax Box Links Company SYTB0100
SYTX Company SYTX0100
SYVT Company SYVT0100
SYXX Log File for Wizard utility Company Year SYXX0112
SYZC Zip Code Dictionary SYZC0000

Fields
PK Table Name Description Type Length Precision Note
1 SY24 SY24001 CodeType VSTRING 2 2 0 Code Type Identifies the type of code:
Code - Description (Module(s) : Length)

A1 - Communication channel (SY : 2)
A2 - IBAN (SY : 2)
A3 - Common address (SY : 2)
A4 - Common address sub-type (SY : 2)
A5 - Address entries (SY : 2)
AA - Journal codes (GL : 6)
AB - Cash books (GL : 6)
AT - Tier (GL : 2)
AX - Cash office (GL : 8)
AY - Reason codes (GL : 2)
AZ - Compound Category (GL : 2)

A0 - Asset group (GL : 10)
AF - Category A (GL : 4)
AG - Category B (GL : 4)
AH - Location (GL : 15)
AI - Engineer (GL : 25)
AJ - Disposal code (GL : 4)
A6 - User defined field 1 (GL : 15)
A7 - User defined field 2 (GL : 10)
A8 - User defined field 3 (GL : 10)
A9 - User defined field 4 (GL : 5)
AC - Insurance company (GL : 25)
AD - Insurance category (GL : 20)
AE - Business transaction code (GL : 3)
AK - Hospitality simulation transactions (GL : 2)

BA - Post codes (SL : 10)
BB - Categories (SL : 4)
BC - Districts (SL : 2)
BD - Advertising areas (SL : 2)
BE - Area codes (SL : 4)
BF - Trade codes (SL : 5)
BG - Discount codes (SL : 2)
BH - Accrual codes (SL : 2)
BI - Commission codes (SL : 2)
BJ - Bank codes (SL : 10)
BK - Salesmen (SL/ST/PR : 3)
BL - Field engineers (SL : 4)
BM - Country codes (SL : 3)
BN - Statistical codes (SC : 13)
BO - Export codes (SL : 1)
BP - Payment codes (SL : 2)
BQ - Accounting code customer (SL : 2)
BT - Billing terms (SL/PL : 4)
BS - Document type (SL/PL : 3)
BV - Jurisdiction code (SY/SL/PL : 2)

CA - Post codes (PL : 10)
CB - Categories (PL : 4)
CC - Country codes (PL : 3)
CD - Bank codes (PL : 10)
CE - Sales tax codes (PL : 2)
CF - Central bank codes (PL : 2)
CG - Authorization codes (PL : 5)
CH - Organization codes (PL : 1)
CI - Accounting code supplier (PL : 2)
CJ - Supplier type (PL : 1)

DA - Purchaser (MP/PC/SC : 3)
DC - Document codes (SY : 1)

EA - Skill codes (HR/SM : 3)
EB - Engineer categories (HR/SM : 4)
EC - Price codes (HR/SM/PR : 2)
ED - Order status (SM : 2)
EE - Weighted priorities (OR/PR/SM : 1)
EF - Order priorities (OR/PR/SM : 1)
EG - Analysis codes (SM : 15)
EH - Issue status (SM : 6)
EI - Return status (SM : 6)
EJ - Work schedule codes (HR/SM/PR : 6)
E1 - Error code (SM : 8) (Code EK replaced with E1)
EL - Error type (SM : 2)
EM - Error category (SM : 4)
EN - Status (SM : 2)
EO - Note category (SM : 2)
EP - Key word (SM : 15)
EQ - Note code (SM : 2)
ER - Price calculation profile (SM : 10)
EX - Service order accounting codes order (SM : 2)
EY - Service order accounting codes activ (SM : 2)
EZ - Service contract accounting codes (SM : 2
E0 - Type of days (SM : 1)
E2 - Customer priority codes (SL : 1)

F0 - Accounting code PUR (AM : 2)
F1 - Accounting code TAX (AM : 2)
F2 - Accounting code PLA (AM : 2)
F3 - Accounting code SAL (AM : 2)
F4 - Accounting code SCR (AM : 2)
F5 - Accounting code REV (AM : 2)
F6 - Accounting code ETX (AM : 2)
F7 - Accounting code FUS (AM : 2)
F8 - Accounting code ICT (AM : 2)
F9 - Accounting code PLP (AM : 2)
FA - Accounting code ACT (AM : 2)
FB - Accounting code OLD (AM : 2)
FC - Accounting code TRA (AM : 2)
FD - Accounting code STO (AM : 2)
FE - Accounting code REA (AM : 2)
FF - Accounting code SFA (AM : 2)
(FF - FP - Reserved for Asset Transaction Accounting codes)
(F* - Reserved for Asset Management module)

IA - Query queues (SC : 1)
IB - Product groups (SC : 4)
IC - Article status (SC : 1)
ID - Discount codes (SC : 2)
IE - Accounting codes (SC : 2)
IF - Maintenance codes (SC : 1)
IG - Service levels (SC : 1)
IH - Service priority (SC : 1)
II - Product categories (SC : 10)
IJ - Budget types (SC : 2)
IK - Extended product group (SC : 20)
IL - Price list (SC/PR/OR/PC : 2)
IM - Batch status codes (SC : 1)
IN - Cost types (SC : 2)
IQ - User defined field 1 (SC : 10)
IR - User defined field 2 (SC : 10)
IS - User defined field 3 (SC : 8)
IT - User defined field 4 (SC : 6)
IU - User defined field 5 (SC : 4)
IV - User defined field 6 (SC : 4)
IW - User defined field 7 (SC : 2)
IX - User defined field 8 (SC : 2)
IY - User defined field 9 (SC : 2)
IZ - User defined field 10 (SC : 2)
I1 - Cycle counting reason (SC : 4)
I2 - Storage type (SC : 1)
I3 - Bin type (SC : 3)
I4 - Bin location rule type (SC : 4)

GA - Serial number Standard transaction types (SC : 1)
GB - Serial number Incident Codes (SC : 4)
GC - Serial number Priority Codes (SC : 4)
GD - Serial number Action Codes (SC : 4)
GE - Serial number Status Codes (SC : 4)
GH - QC Category (SC : 2)
GF - Serial number User transaction types (SC : 3)

HA - Cancellation code (OR : 4)

MR - Customer request type (MA : 2)

PA - Profession codes (PA : 4, HR/PR/SM : 6)
PB - Education codes (PA : )
PC - Categories (PA : )
PD - Departments (PA : 5, HR/PR/SM : 15)
PE - Community codes 1 (PA : 2)
PF - Community codes 2 (PA : 2)
PG - Community codes 3 (PA : 2)
PH - Work places (PA : 5)
PI - Person categories (PA : 1)
PJ - Labour agreement areas (PA : 5)
PK - Statistical codes 1 (PA : 1)
PL - Statistical codes 2 (PA : 1)
PM - Statistical codes 3 (PA : 1)
PN - Statistical codes 4 (PA : 1)
PO - Statistical codes 5 (PA : 1)
PP - Statistical codes 6 (PA : 1)
PQ - Vacation codes (PA : 4)
PV - History categories (PA : 2)

QA - Direct invoicing (DI : 2)

R0 - User Field 1 (PR : 20)
R1 - User Field 2 (PR : 10)
R2 - User Field 3 (PR : 10)
R3 - User Field 4 (PR : 8)
R4 - User Field 5 (PR : 8)
R5 - User Field 6 (PR : 4)
R6 - User Field 7 (PR : 4)
R7 - User Field 8 (PR : 2)
R8 - User Field 9 (PR : 2)
R9 - User Field 10 (PR : 1)
RA - User DB Defined 1 (PR : 1-35)
RB - User DB Defined 2 (PR : 1-35)
RC - User DB Defined 3 (PR : 1-35)
RD - User DB Defined 4 (PR : 1-35)
RE - User DB Defined 5 (PR : 1-35)
RF - User DB Defined 6 (PR : 1-35)
RG - User DB Defined 7 (PR : 1-35)
RH - User DB Defined 8 (PR : 1-35)
RI - User DB Defined 9 (PR : 1-35)
RJ - User DB Defined 10 (PR : 1-35)
RK - (reserved) (PR : )
RL - Project category (PR : 4)
RM - Project type (PR : 2)
RN - Project status (PR : 1) (not used)
RO - Project report codes (PR : 8)
RP - Project budget codes (PR : 2)
RQ - Project Text Group Description (PR : 1)
RR - Project User Def Desc (PR : 1)
RS - Accounting Codes Project (PR : 2)
RT - Accounting codes Activity (PR : 2)
RU - Activity cost category (PR : 1)
RV - Activity gategory (PR : 10)
RW - Project discount code (PR : 2)
RX - Activity discount code (PR : 2)
RY - Invoice sort code (PR : 2)
RZ - (reserved) (PR : )

S* - (reserved) (PR : )
SB - IBAN Bank types (SY : 2)
SE - IBAN Account entry (SY : 1)
SF - IBAN Section filling (SY : 1)
SG - IBAN Layout groups (SY : 1)
ST - IBAN Section type (SY : 1)
SV - IBAN Validation rule (SY : 3)

TD - District codes (PL : 10)

SA - Layout codes (GL : 11)

WT - Withholding tax codes (PL : 4)

X0 - Printer groups (SY : 2)

Y0 - Header batch field 1 (SC/PC/OR/MP : 1)
Y1 - Header batch field 2 (SC/PC/OR/MP : 1)
Y2 - Header batch field 3 (SC/PC/OR/MP : 1)
Y3 - Header batch field 4 (SC/PC/OR/MP : 1)
Y4 - Header batch field 5 (SC/PC/OR/MP : 1)
Y5 - Header batch field 6 (SC/PC/OR/MP : 1)
Y6 - Header batch field 7 (SC/PC/OR/MP : 1)
Y7 - Header batch field 8 (SC/PC/OR/MP : 1)
Y8 - Header batch field 9 (SC/PC/OR/MP : 1)
Y9 - Header batch field 10 (SC/PC/OR/MP : 1)
YA - Batch user field 1 (SC/PC/OR/MP : 20)
YB - Batch user field 2 (SC/PC/OR/MP : 10)
YC - Batch user field 3 (SC/PC/OR/MP : 10)
YD - Batch user field 4 (SC/PC/OR/MP : 8)
YE - Batch user field 5 (SC/PC/OR/MP : 8)
YF - Batch user field 6 (SC/PC/OR/MP : 4)
YG - Batch user field 7 (SC/PC/OR/MP : 4)
YH - Batch user field 8 (SC/PC/OR/MP : 2)
YI - Batch user field 9 (SC/PC/OR/MP : 2)
YJ - Batch user field 10 (SC/PC/OR/MP : 1)

Z2 - Operation Code (SY/SL/PL : 10)
Z3 - Cust/Supp Activity (SY/SL/PL : 10)
Z4 - Invoice Type (SY/SL/PL : 10)
Z5 - Brazilian Regions (SY/SL/PL : 10)
Z6 - City Codes (SY/SL/PL : 10)
Z7 - State Codes (SY/SL/PL : 10)
Z8 - (reserved)
Z9 - Taxable Situation (SY/SL/PL : 10)
ZA - Type of Legal Entities (SY/SL/PL : 10)
ZB - Service Codes (SY/SL/PL : 10)
ZC - Tax Accounting Codes (SY/SL/PL : 1)

V* - Reserved for VBA projects (all codes starting with V)
W* - Reserved for VBA projects (all codes starting with W except for WT)
2 SY24 SY24002 Key VSTRING 35 35 0 Key
SY24 SY24003 TextDescription VSTRING 60 60 0 Description
SY24 SY24004 CodeDepFld1 VSTRING 18 18 0 Code Dependent Field 1
SY24 SY24005 CodeDepFld2 VSTRING 6 6 0 Code Dependent Field 2
SY24 SY24006 CodeDepFld3 VSTRING 8 8 0 Code Dependent Field 5
SY24 SY24007 CodeDepFld4 VSTRING 10 10 0 Code Dependent Field 6
SY24 SY24008 CodeDepFld5 VSTRING 50 50 0 Code Dependent Field 5
SY24 SY24009 CodeDepFld6 VSTRING 50 50 0 Code Dependent Field 6
SY24 SY24010 CodeDepFld7 VSTRING 50 50 0 Code Dependent Field 7
SY24 SY24011 CodeDepFld8 VSTRING 50 50 0 Code Dependent Field 8
SY24 SY24012 CodeDepFld9 VSTRING 50 50 0 Code Dependent Field 9
SY24 SY24013 CodeDepFld10 VSTRING 50 50 0 Code Dependent Field 10
SY24 SY24014 CodeDepFld11 VSTRING 50 50 0 Code Dependent Field 11
SY24 SY24015 CodeDepFld12 VSTRING 50 50 0 Code Dependent Field 12
SY24 SY24016 CodeDepFld13 VSTRING 50 50 0 Code Dependent Field 13
SY24 SY24017 AccountingString ACCSTR 120 120 0 Accounting String