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
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 Company PC150100
PC17 Purchase Order Text Lines Company PC170100
PC19 Purchase Order Delivery Lines Company PC190100
PC20 Received Invoices - Costs Company PC200100
PC21 Received Invoices - Terms Company PC210100
PC22 Received Invoices - Header Company PC220100
PC23 Received Invoices - Lines Company PC230100
PC24 Received Invoices - Taxes Company PC240100
PC25 Supplier Statistics Data Company PC250100
PC26 Transport Documents Company PC260100
PC27 Import Documents Company PC270100
PC28 Spare Company PC280100
PC29 Service Order Transport Document Parameters Company PC290100
PC2S Company PC2S0100
PC2T Received Invoices - Text Lines Company PC2T0100
PC30 Consolidated Goods Received Notes Company PC300100
PC3L Purchase Order Lines Lead Time Details 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 Text Lines History Company PC440100
PC45 Delivery Address History Company PC450100
PC46 Purchase Order Lines Lead Time Details History Company PC460100
PCB1 Purchase Order BOM Node Company PCB10100
PCB2 Purchase Order BOM Node Name Company PCB20100
PCB3 Purchase Order BOM Link Company PCB30100
PCB4 Purchase Order BOM Branch Company PCB40100
PCBD Budget Reservations Company PCBD0100
PCD1 Customs Declaration Header Company PCD10100
PCD2 Customs Declaration Lines Company PCD20100
PCD3 Customs Declaration Batch Lines Company PCD30100
PCD4 Customs Declaration Cost Allocation Lines Company PCD40100
PCD7 Customs Declaration Taxes Company PCD70100
PCD8 Company PCD80100
PCH1 Purchase Order BOM Node History Company PCH10100
PCH2 Purchase Order BOM Node Name History Company PCH20100
PCH3 Purchase Order BOM Link History Company PCH30100
PCH4 Purchase Order BOM Branch History 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
PCR9 Approval Matrix Company PCR90100
PCT1 PC VAT Transactions Company PCT10100
PCTF Company PCTF0100
PCTH Company PCTH0100
PCTL Order Template columns Company PCTL0100
PCWT Purchase Invoice WH Taxes Company PCWT0100
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
sca_trg_Audit_PC01 Audit trigger for PC01 table Company sca_trg_Audit_PC010100
sca_trg_Audit_PC03 Audit trigger for PC03 table Company sca_trg_Audit_PC030100
sca_trg_Audit_PC04 Audit trigger for PC04 table Company sca_trg_Audit_PC040100

Fields
PK Table Name Description Type Length Precision Note
1 PCR5 PCR5001 RequisitionHeaderNo VSTRING 10 10 0 Requisition Number
2 PCR5 PCR5002 RequisitionLineNo VSTRING 4 4 0 Requisition Line Number
PCR5 PCR5003 ReqType VSTRING 1 1 0 Requisition Type 0 - Undefined
1 - Normal purchase order
2 - Stock transfer
3 - Direct delivery
4 - Commissary item
5 - Stock issue
PCR5 PCR5004 DepartmentCode VSTRING 6 6 0 Department Code
PCR5 PCR5005 Warehouse VSTRING 6 6 0 Warehouse
PCR5 PCR5006 SupplierCode VSTRING 10 10 0 Supplier Code
PCR5 PCR5007 StockCode VSTRING 35 35 0 Stock Item Code
PCR5 PCR5008 StockDescription1 VSTRING 25 25 0 Stock Item Description
PCR5 PCR5009 QuantityOrdered X_NUMERIC 12 20 8 Quantity Ordered
PCR5 PCR5010 Price MONEY 20 28 8 Unit Price
PCR5 PCR5011 AuthorizationStatus VSTRING 1 1 0 Authorization Status 0 - Not authorized
1 - Authorized
2 - Rejected
PCR5 PCR5012 UserEnterAuthStatus VSTRING 8 8 0 Last Authorized By
PCR5 PCR5013 AccString ACCSTR 120 120 0 Accounting String
PCR5 PCR5014 UserPrintRqsnLine VSTRING 8 8 0 Printed By
PCR5 PCR5015 RequisitionDate DATE 8 0 0 Requisition Date
PCR5 PCR5016 UserRQSNEnter VSTRING 8 8 0 Created/Updated By
PCR5 PCR5017 LinkedRqsnLine VSTRING 4 4 0 Linked Requisition Line Number
PCR5 PCR5018 AccStrManualChange VSTRING 1 1 0 Accounting String Manually Changed
PCR5 PCR5019 ToWarehouse VSTRING 6 6 0 To Warehouse
PCR5 PCR5020 QtyIssued X_NUMERIC 12 20 8 Issued (Delivered) Quantity
PCR5 PCR5021 PurchaseOrderNo VSTRING 10 10 0 Purchase Order Number
PCR5 PCR5022 PurchaseOrderLineNo VSTRING 6 6 0 Purchase Order Line Number
PCR5 PCR5023 PurchaseOrderSubLineNo VSTRING 6 6 0 Purchase Order Sub-line Number
PCR5 PCR5024 IssueReceiptDate DATE 8 0 0 Issue/Receipt Date
PCR5 PCR5025 RequisitionLineStatus VSTRING 1 1 0 Requisition Line Status
PCR5 PCR5026 ConversionDeletionDate DATE 8 0 0 Conversion/Deletion Date
PCR5 PCR5027 NonregisteredItem SWITCH 1 1 0 Non-Stock Item
PCR5 PCR5028 UnitCode INTEGER 4 0 0 Unit Code
PCR5 PCR5029 CurrencyCode VSTRING 2 2 0 Currency Code
PCR5 PCR5030 RequiredDeliveryDate DATE 8 0 0 Required Delivery Date
PCR5 PCR5031 StockDescription2 VSTRING 25 25 0 Stock Description 2
PCR5 PCR5032 UnitConversionFactor X_NUMERIC 18 26 8 Unit Conversion Factor
PCR5 PCR5033 SuppManualChange STRING 1 1 0 Was Supplier manually changed?
PCR5 PCR5034 PriceManualChange STRING 1 1 0 Was Price manually changed?
PCR5 PCR5035 PickListID STRING 10 10 0 Picking List Id
PCR5 PCR5036 FromBin VSTRING 6 6 0 From Bin
PCR5 PCR5037 ToBin VSTRING 6 6 0 To Bin
PCR5 PCR5038 PickingStatus INTEGER 1 0 0 Picking Status 0 – Not Processed
1 - Request Created
2 – Printed
3 – Started
4 – Closed
PCR5 PCR5039 Spare X_NUMERIC 12 20 8 Spare
PCR5 PCR5040 OrReference STRING 10 10 0 OR Reference Link requisitions released from MRP or SRP to demand
PCR5 PCR5041 OrLineRef STRING 14 14 0 OR Line Ref Link requisitions released from MRP or SRP to demand
PCR5 PCR5042 ExUserDef1 VSTRING 150 150 0 Extended User-Defined Field 1
PCR5 PCR5043 ExUserDef2 VSTRING 150 150 0 Extended User-Defined Field 2
PCR5 PCR5044 ExUserDef3 VSTRING 150 150 0 Extended User-Defined Field 3
PCR5 PCR5045 ExUserDef4 VSTRING 150 150 0 Extended User-Defined Field 4
PCR5 PCR5046 ExUserDef5 VSTRING 150 150 0 Extended User-Defined Field 5
PCR5 PCR5047 ExUserDef6 VSTRING 150 150 0 Extended User-Defined Field 6
PCR5 PCR5048 ExUserDef7 VSTRING 150 150 0 Extended User-Defined Field 7
PCR5 PCR5049 ExUserDef8 VSTRING 150 150 0 Extended User-Defined Field 8
PCR5 PCR5050 ExUserDef9 VSTRING 150 150 0 Extended User-Defined Field 9
PCR5 PCR5051 ExUserDef10 VSTRING 150 150 0 Extended User-Defined Field 10
PCR5 PCR5052 ExUserDef11 VSTRING 150 150 0 Extended User-Defined Field 11
PCR5 PCR5053 ExUserDef12 VSTRING 150 150 0 Extended User-Defined Field 12
PCR5 PCR5054 ExUserDef13 VSTRING 150 150 0 Extended User-Defined Field 13
PCR5 PCR5055 ExUserDef14 VSTRING 150 150 0 Extended User-Defined Field 14
PCR5 PCR5056 ExUserDef15 VSTRING 150 150 0 Extended User-Defined Field 15
PCR5 PCR5057 ExUserDef16 VSTRING 150 150 0 Extended User-Defined Field 16
PCR5 PCR5058 ExUserDef17 VSTRING 150 150 0 Extended User-Defined Field 17
PCR5 PCR5059 ExUserDef18 VSTRING 150 150 0 Extended User-Defined Field 18
PCR5 PCR5060 ExUserDef19 VSTRING 150 150 0 Extended User-Defined Field 19
PCR5 PCR5061 ExUserDef20 VSTRING 150 150 0 Extended User-Defined Field 20
PCR5 PCR5062 ContractID VSTRING 10 10 0 Contract ID
PCR5 PCR5063 ContractLine STRING 6 6 0 Contract Line