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
PC01 Purchase Order Head Company PC010100
PC03 Purchase Order Lines Company PC030100
PC04 Delivery Addresses Company PC040100
PC05 Purchase Order Parameters Company PC050100
PC06 Purchase Order Document Text Company PC060100
PC07 Purchase Phrase File Company PC070100
PC08 Suppliers for Quotes Company PC080100
PC10 Purchase Proposals Company PC100100
PC11 Import Document Parameter File Company PC110100
PC12 Purchase Coding Slips Company PC120100
PC14 Order Line Del. Company PC140100
PC15 P.Ord.Line.Deliv Company PC150100
PC16 P.ord.Line.Alloc Company PC160100
PC17 Purchase Order Text Lines Company PC170100
PC19 Purchase Order Delivery Lines Company PC190100
PC20 Invoice Costs Company PC200100
PC21 Invoice Terms Company PC210100
PC22 Invoice Header Company PC220100
PC23 Invoice Line Company PC230100
PC24 Invoice Taxes Company PC240100
PC25 Supplier Statistics Data Company PC250100
PC26 Spare Company PC260100
PC27 Spare Company PC270100
PC28 Spare Company PC280100
PC29 Spare Company PC290100
PC2T PO Invoice Text Lines Company PC2T0100
PC30 Consolidated GRN File Company PC300100
PC3L Extended order lines (Purchase Order) Company PC3L0100
PC41 Purchase Order Head History Company PC410100
PC42 Purchase Order Lines History Company PC420100
PC43 Purchase Order Delivery Lines History Company PC430100
PC44 Purchase Order TextLines History Company PC440100
PC45 Delivery Address History Company PC450100
PC46 Extended order lines (PC History) Company PC460100
PCB1 BOM Node Company PCB10100
PCB2 BOM Node Name Company PCB20100
PCB3 BOM Link Company PCB30100
PCB4 BOM Branch Company PCB40100
PCH1 BOM Node Company PCH10100
PCH2 BOM Node Name Company PCH20100
PCH3 BOM Link Company PCH30100
PCH4 BOM Branch Company PCH40100
PCHC Authorization levels Company PCHC0100
PCI2 Instalments Company PCI20100
PCI4 Instalments History Company PCI40100
PCMT Business Transaction Type Purchase Order Mapping Company PCMT0100
PCR1 Requisition Header Company PCR10100
PCR2 Requisition Line Company PCR20100
PCR3 Requisition Template Header Company PCR30100
PCR4 Requisition Template Line Company PCR40100
PCR5 Requisition History Lines Company PCR50100
PCR6 Requisition Type Setup Company PCR60100
PCR7 Requisition Type/Stock Item Status Setup Company PCR70100
PCR8 Requisition Header History Company PCR80100
PCT1 PC VAT Transactions Company PCT10100
PCXC Work file for CGRN adjustment PCXC0000
PCXX P.Ord.Inv.Entry Company PCXX0100
PCXY Purchase Inv.w. Company PCXY0100
PLIN Invoice Based Intrastat PL Company PLIN0100

Fields
Table Name Description Type Length Precision Note
PCH4 PCH4001 ParentNodeID STRING 38 38 0
PCH4 PCH4002 BranchNo INTEGER 9 0 0
PCH4 PCH4003 Flag_Optional INTEGER 1 0 0
PCH4 PCH4004 Flag_SwitchedOff INTEGER 1 0 0
PCH4 PCH4005 Qty_Child X_NUMERIC 20 28 8
PCH4 PCH4006 Flag_Independent_Child_Qty INTEGER 1 0 0
PCH4 PCH4007 Flag_Changable_Node INTEGER 1 0 0
PCH4 PCH4008 PriceList STRING 2 2 0
PCH4 PCH4009 Flag_Calculate_Price INTEGER 1 0 0
PCH4 PCH4010 Flag_Printable_in)Document INTEGER 1 0 0
PCH4 PCH4011 Spare INTEGER 1 0 0 "Structure Type 0 - Dependent; May only be delivered as a whole and in the quantity delivered. Partial delivery is not allowed.
1 - Independent; May only be delivered as a whole and in the quantity delivered. Partial delivery is allowed. Cannot be used for BOM Configurations.
2 - Semi-dependent; May be delivered both as a whole and partially; that is; not only by the top node; but also by sub-nodes. Cannot be used for BOM Configurations."
PCH4 PCH4012 OR DS Transfer Option INTEGER 1 0 0 "Sales Order Drop Shipment Transfer Option 0 - All BOM components are transferred independently. No reference to the configuration is stored.
1 - BOM components are transferred independently. Source configuration data is stored in a text line.
2 - BOM is transferred as a structure."
PCH4 PCH4013 SM DS Transfer Option INTEGER 1 0 0 "Service Order Drop Shipment Transfer Option 0 - All BOM components are transferred independently. No reference to the configuration is stored.
1 - BOM components are transferred independently. Source configuration data is stored in a text line.
2 - BOM is transferred as a structure."
PCH4 PCH4014 Create lines for intermediate phantom items INTEGER 1 0 0
PCH4 PCH4015 Spare INTEGER 1 0 0
PCH4 PCH4016 RecalculateTopItemPrice INTEGER 1 0 0
PCH4 PCH4017 UnitCode INTEGER 4 0 0 Unit Code
PCH4 PCH4018 Spare 11 STRING 1 1 0
PCH4 PCH4019 Spare 12 STRING 1 1 0
PCH4 PCH4020 Spare 13 STRING 1 1 0
PCH4 PCH4021 Spare 14 STRING 1 1 0
PCH4 PCH4022 Spare 15 STRING 1 1 0
PCH4 PCH4023 Spare 16 STRING 2 2 0
PCH4 PCH4024 Spare 17 STRING 2 2 0
PCH4 PCH4025 Spare 18 STRING 2 2 0
PCH4 PCH4026 Spare 19 STRING 2 2 0
PCH4 PCH4027 Spare 20 STRING 2 2 0
PCH4 PCH4028 UnitConvFactor X_NUMERIC 18 26 8