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
PCHC Authorization levels Company PCHC0100
SC01 Stock Item File Company SC010100
SC03 Warehouse File Company SC030100
SC04 Stock Extra Information Company SC040100
SC05 Serial Numbers Company SC050100
SC06 Product Structures Company SC060100
SC07 Stock Transactions Company SC070100
SC08 Prices/Budget Company SC080100
SC09 Stock Unit Text Company SC090100
SC10 Stock Parameters 1 Company SC100100
SC11 Stock Planning Company SC110100
SC13 Distribution Fees Company SC130100
SC14 Price Calculations Company SC140100
SC15 Calculation Parameters 1 Company SC150100
SC16 Serial Number History Company SC160100
SC18 Supplier/Customer Prices Company SC180100
SC19 Customer Order Discounts Company SC190100
SC1B Stock Parameters 2 Company SC1B0100
SC1C Stock Parameters 3 Company SC1C0100
SC1D Calculation Parameters 2 Company SC1D0100
SC21 Structure Groups Company SC210100
SC22 Price Calculations Customers Company SC220100
SC23 Warehouse Addresses Company SC230100
SC24 Automatic Accounting Table SC Company SC240100
SC25 GL Transactions Company Year SC250112
SC26 Transaction Index File Company SC260100
SC27 EC Trade Statistics Company SC270100
SC28 EC Tax Rep. wrk SC280000
SC2A Work File for EC Tax Reports Definition SC2A0000
SC30 Serial Number Remarks Company SC300100
SC32 Unit Conversion Parameters Company SC320100
SC33 Batch Information Company SC330100
SC34 Batch Costs Company SC340100
SC36 Bin Information Company SC360100
SC37 Standard Stock Items Company SC370100
SC38 Standard Item Discounts Company SC380100
SC39 Price Lists Company SC390100
SC42 Stock Taking Lists Company SC420100
SC43 Batch Extra Description Company SC430100
SC45 Customer Discounts Company SC450100
SC46 Discount Templates Company SC460100
SC47 Discount Codes Company SC470100
SC48 Discount Descriptions Company SC480100
SC49 Discount Setup Company SC490100
SC4A Template Names Company SC4A0100
SC4B Discount Setup Descriptions Company SC4B0100
SC50 Discount Ranges Company SC500100
SC51 Template Values Company SC510100
SC52 Discount Accounting Company SC520100
SC53 Discount Schemas Company SC530100
SC54 Discount Scheme Descriptions Company SC540100
SC55 Schema Structure Company SC550100
SC56 Discount Setup Statistics Company SC560100
SC60 Shipment Company SC600100
SC61 PackingList Company SC610100
SC62 BoxHeader Company SC620100
SC63 BoxLine Company SC630100
SC64 BoxElement Company SC640100
SC65 Cycle Count Item Parameters Company SC650100
SC66 Cycle Counting Class Company SC660100
SC67 Cycle Counting Campaigns Company Year SC670112
SC68 Counting Parameters Company SC680100
SC69 Counting Proposal Header Company Year SC690112
SC70 Allocation History Company SC700100
SC71 Campaign Parameter Header Details Company Year SC710112
SC72 Counting Proposal Header History Company Year SC720112
SC73 Counting Proposal List Lines History Company Year SC730112
SC74 Cycle Counting Parameters Company SC740100
SC75 Counting Proposal List Lines Company Year SC750112
SC76 Iscala stock balance History Company SC760100
SC77 WMS stock balance History Company SC770100
SC78 Box Handling Picking Proposal file structure Company SC780100
SC79 Box Handling Reciept work file structure Company SC790100
SC7A SC Box Handling Reciept work file structure Company SC7A0100
SC7B Box Handling User-defined fields Company SC7B0100
SC7C Stock Transfer Order Header Company SC7C0100
SC7D Stock Transfer Order Lines Company SC7D0100
SC7E Stock Transfer Order Delivery Lines Company SC7E0100
SC7F STO - linked work orders and purchase orders Company SC7F0100
SC7G Stock transfer order serial number file Company SC7G0100
SC80 Picking list head Company SC800100
SC81 Picking list line Company SC810100
SC82 Picking list line details Company SC820100
SC83 Picking list serial numbers Company SC830100
SC85 Picking list head history Company SC850100
SC86 Picking list line history Company SC860100
SC87 Picking list line details history Company SC870100
SC88 Picking list serial numbers history Company SC880100
SC89 Picking; Warehouse settings Company SC890100
SC8A Picking list allocation log Company SC8A0100
SC8B Merged picking lists Company SC8B0100
SC8C Picking module - links to Picking request line Company SC8C0100
SC90 Consumed Reservations Company SC900100
SCA1 Rules for MPC WO allocations Company SCA10100
SCB1 SC BOM Node Company SCB10100
SCB2 SC BOM Name Company SCB20100
SCB3 SC BOM Link Company SCB30100
SCB4 SC BOM Branch Company SCB40100
SCB5 BOM Template names Company SCB50100
SCB6 Work file for ATP Rescheduling SCB60000
SCB7 Temporary Stock planning table;ATP SCB70000
SCB8 Work file for splitted lines; ATP SCB80000
SCB9 BOM Printing Options Company SCB90100
SCBA Generic Batch Allocations Company SCBA0100
SCBG Temporary ATP Period table SCBG0000
SCBP Bin Location Proposals Company SCBP0100
SCDB Default Bins Company SCDB0100
SCF1 Exposed Stock Item Company SCF10100
SCGL HI. GL Transactions Company SCGL0100
SCH0 Stock Withdrawal Parameters Company SCH00100
SCH3 Stock Matrix Company SCH30100
SCH4 Credit Account Matrix Company SCH40100
SCH5 Department Company SCH50100
SCI1 Reason Codes descriptions Company SCI10100
SCI2 Reason Code features Company SCI20100
SCII Inwarding Information Company SCII0100
SCK4 Supplier Priorities for QC Company SCK40100
SCL1 Batch Tax Transactions Company SCL10100
SCLC Logistic form Connections Company SCLC0100
SCLF Logistic forms Company SCLF0100
SCP1 Life Cycle Phase Definition Company SCP10100
SCP2 Life Cycle Phase Strings Company SCP20100
SCP3 Stock Item Life Cycle Phase Company SCP30100
SCT1 Extra Stock Item Information Company SCT10100
SCT2 Batch User Authorization Company SCT20100
SCT5 Customer/Supplier Control Company SCT50100
SCT6 Trace Batch Changes Company SCT60100
SCT7 Batch Price List Company SCT70100
SCT8 Batch Templates Company SCT80100
SCT9 Workorder Batch Trace Connections Company SCT90100
SCUC unit codes Company SCUC0100
SCUN unit names in different languages Company SCUN0100
SCW1 Central Warehouse Def SCW10000
SCW2 Transaction warehouse definition SCW20000
SCW3 Central Warehouse Pickinglist Head Company SCW30100
SCW4 Central Warehouse Order Process Status SCW40000
SCW5 Central Warehouse PL Invoice Transfer Table Company SCW50100
SCW6 Central Warehouse Tax Transaction Transfer Company SCW60100
SCW7 Central Warehouse PL Invoice Transaction Transfer Company SCW70100
SCW8 Central Warehouse Order Head Extension SCW80000
SCW9 Central Warehouse Order Line Extension SCW90000
SCWA Warehouse Area Company SCWA0100
SCWB Central Warehouse Pickinglist Line Company SCWB0100
SCWC Central warehouse customer values SCWC0000
SCWD Central warehouse order status and parameters SCWD0000
SCWE Central Warehouse Purchase Statistics Transfer Company SCWE0100
SCWF Intercompany Serial Number SCWF0000
SCWG Central Warehouse Delivery Error Log SCWG0000
SCWH Central Warehouse pickinglist allocations SCWH0000
SCWI Central warehouse merged pickinglists Company SCWI0100
SCWL Central warehouse serial number transfer Company SCWL0100
SCWM Central Warehouse Delivery Transactions SCWM0000
SCWQ Central warehouse pickinglist log Company SCWQ0100
SCWS Central Warehouse Central VAT codes SCWS0000
SCWT Central Warehouse Central VAT code references SCWT0000
SCWU Central Warehouse VAT Macro references SCWU0000
SCWW Central Warehouse Intercompany delivery transaction history SCWW0000
SCXP Extra Parameters Company SCXP0100
SCXX Work File for Batch Trace SCXX0000
SCXZ Work File for ABC-Analysis SCXZ0000
SCZ5 Tax Exemptions Company SCZ50100
SL61 Reminder Proposal Company SL610100
ST30 Stock Item - Packaging Codes Company ST300100
ST31 Temporary ST310000

Fields
Table Name Description Type Length Precision Note
SCW9 SCW9001 Order company STRING 2 2 0
SCW9 SCW9002 Order number STRING 10 10 0
SCW9 SCW9003 Order line STRING 6 6 0
SCW9 SCW9004 Structure line STRING 6 6 0
SCW9 SCW9005 Warehouse owner company STRING 2 2 0
SCW9 SCW9006 Warehouse ID STRING 6 6 0
SCW9 SCW9007 Stock code VSTRING 35 35 0
SCW9 SCW9008 Ordered quantity X_NUMERIC 12 20 8
SCW9 SCW9009 Delivered quantity X_NUMERIC 12 20 8
SCW9 SCW9010 Delivery date DATE 8 0 0
SCW9 SCW9011 Pickinglist number VSTRING 10 10 0
SCW9 SCW9012 Changes allowed SWITCH 1 1 0
SCW9 SCW9013 Priority VSTRING 30 30 0
SCW9 SCW9014 Unit price for credit check MONEY 20 28 8
SCW9 SCW9015 Amount ICP MONEY 20 28 8
SCW9 SCW9016 Allocated OR X_NUMERIC 12 20 8
SCW9 SCW9017 Allocated SC X_NUMERIC 12 20 8
SCW9 SCW9018 Not used VSTRING 10 10 0
SCW9 SCW9019 Not used VSTRING 10 10 0
SCW9 SCW9020 Not used VSTRING 8 8 0
SCW9 SCW9021 Not used VSTRING 8 8 0
SCW9 SCW9022 Not used VSTRING 6 6 0
SCW9 SCW9023 Not used VSTRING 6 6 0
SCW9 SCW9024 Pricelist ICP VSTRING 2 2 0
SCW9 SCW9025 Not used VSTRING 2 2 0
SCW9 SCW9026 Not used SWITCH 1 1 0
SCW9 SCW9027 Not used SWITCH 1 1 0
SCW9 SCW9028 Source of request STRING 1 1 0 Source of request
SCW9 SCW9029 Unit Code INTEGER 4 0 0 Unit Code