ERP iScala Database Structure (2.3 SR2)

Modules
Name Description
00 System objects
AM Asset Management
CM Contract Management
DI Direct Invoicing
GL General Ledger
HR Resourse Management
MA Market Database
MP Material Production Control
OR Sales Order
PA Payroll
PC Purchase Order
PL Purchase Ledger
PN Promissory Notes
PR Project Management
SC Stock Control
SL Sales Ledger
SM Service Order Management
SO Other objects
ST Statistics
SY System Utilities/Office Autom.
UD User-defined

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 Spare Company COH70100
SCB5 BOM Template names Company SCB50100
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 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 matrix File Company SY330100
SY34 TAX codes descriptions Company SY340100
SY40 Scala Parameters Storage Company SY400100
SY41 Scala Import/Export Data Storage Company SY410100
SY42 Multilingual Code File Company SY420100
SY43 Sales Ledger Planning Calender 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 Export control audit 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 Address File I/O 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 User defined milestone Company SY900100
SY91 User defined milestone multilingual Company SY910100
SY97 Central Currency Register Work File - Correspondence Table SY970000
SY98 Central Currency Register Work File - Work Dictionary SY980000
SYA1 Calculation Algorithm Head Company SYA10100
SYA2 Calculation Algorithm Lines Company SYA20100
SYAF Audit Trail File for Monetary restatment utility 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 Codes Company SYB90100
SYBC Fiscal Text Company SYBC0100
SYBD DocumentFiscalText Company SYBD0100
SYBJ Rule Rate Company SYBJ0100
SYBK EDILayoutHeaders Company SYBK0100
SYBL Ownership Company SYBL0100
SYBM EDILayoutLines Company SYBM0100
SYBN OutputFileHeaders Company Year SYBN0112
SYBO OutputFileLines Company Year SYBO0112
SYBQ EDISysFields Company SYBQ0100
SYBT EDIEvents Company SYBT0100
SYBU EDI Bank Information Company SYBU0100
SYBY Margin Company SYBY0100
SYBZ Serial Invoice Number Company SYBZ0100
SYCC Central Curr. Dictionary SYCC0000
SYCD Currency Dictionary Company SYCD0100
SYCE EMU Currency History SYCE0000
SYCF Central Currency History SYCF0000
SYCH Currency History Company SYCH0100
SYCI Central Currency Source SYCI0000
SYD0 Document image header Company SYD00100
SYD1 Document image lines Company SYD10100
SYES Dyamic email setup Company SYES0100
SYET Entry Types Company SYET0100
SYFF Log File for Monetary restatement utility Company Year SYFF0112
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
SYM1 Code Map Company SYM10100
SYM2 Mapping Company SYM20100
SYPD Purchaser File (Language dependant) Company SYPD0100
SYPQ Print Job Queue Table Company SYPQ0100
SYPU Purchaser File Company SYPU0100
SYRF CommonID References Company SYRF0100
SYRS Synchronization Setup Company SYRS0100
SYRT Synchronization Status Company SYRT0100
SYS1 Bank Information Company SYS10100
SYS2 Filter Switch Company SYS20100
SYVT Generic Patch Company SYVT0100
SYXX Log File for Wizard utility Company Year SYXX0112
SYZC TaxWare Zip Codes table SYZC0000

Fields
Table Name Description Type Length Precision Note
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)
"
SY24 SY24002 Key VSTRING 35 35 0
SY24 SY24003 TextDescription VSTRING 50 50 0 Description
SY24 SY24004 CodeDepFld1 VSTRING 18 18 0 Code Dependent Field 1
SY24 SY24005 CodeDepFld2 VSTRING 6 6 0
SY24 SY24006 CodeDepFld5 VSTRING 8 8 0 Code Dependent Field 5
SY24 SY24007 CodeDepFld6 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