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
2 PC22 PC22001 InvNum STRING 25 25 0 Invoice Number
PC22 PC22002 InvDate DATE 8 0 0 Invoice Date
PC22 PC22003 EntryDate DATE 8 0 0 Date Entered
PC22 PC22004 InvMatchStatus INTEGER 2 0 0 Invoice Match Status 0 - Loaded with Error
1 - Loaded
2 - Matched with Error
3 - Matched with Warning
4 - Matched
1 PC22 PC22005 SuppCode STRING 10 10 0 Supplier Code
PC22 PC22006 SuppName VSTRING 35 35 0 Supplier Name
PC22 PC22007 InvCurr STRING 3 3 0 Invoice Currency
PC22 PC22008 InvAmnt MONEY 20 28 8 Invoice Amount
PC22 PC22009 DueDate DATE 8 0 0 Due Date
PC22 PC22010 PmntTermCode INTEGER 2 0 0 Payment Terms
PC22 PC22011 PmntTermDescr VSTRING 50 50 0 Payment Terms Description
PC22 PC22012 TransMethCode INTEGER 2 0 0 Delivery Terms
PC22 PC22013 TransMethDescr VSTRING 50 50 0 Delivery Terms Description
PC22 PC22014 DelMethCode INTEGER 2 0 0 Delivery Method
PC22 PC22015 DelMethDescr VSTRING 50 50 0 Description Delivery Method
PC22 PC22016 BankCodeCentral STRING 4 4 0 Central Bank Code
PC22 PC22017 PaymentReferenceComment VSTRING 40 40 0 Payment Reference
PC22 PC22018 WithholdingTaxCode VSTRING 8 8 0 Withholding Tax Code
PC22 PC22019 AmountWithholdingTax MONEY 20 28 8 Withholding Tax Amount
PC22 PC22020 WithholdingTaxPercent X_NUMERIC 5 13 8 Withholding Tax %
PC22 PC22021 DateBookEntry DATE 8 0 0 Book-Entry Date
PC22 PC22022 BankCodeSupplier STRING 2 2 0 Bank Code Supplier
PC22 PC22023 PaymentWay STRING 2 2 0 Payment Method
PC22 PC22024 FlagPaymentBlock STRING 1 1 0 Blocked for Payment
PC22 PC22025 AuthorizationCode STRING 5 5 0 Authorization Code
PC22 PC22026 TextComment VSTRING 15 15 0 Text
PC22 PC22027 PaymentPriority STRING 1 1 0 Payment Priority
PC22 PC22028 DateStatusAssigned DATE 8 0 0 Date Status Assigned
PC22 PC22029 Remark VSTRING 50 50 0 Remark
PC22 PC22030 UserID VSTRING 8 8 0 User
PC22 PC22031 TaxRegNo VSTRING 15 15 0 Tax Registration Number
PC22 PC22032 ECVATStatus INTEGER 1 0 0 EC VAT Status
PC22 PC22033 InvPLUpdateStatus INTEGER 1 0 0 Invoice Update Status 0 - Not updated
5 - Updated as Unauthorized
6 - Updated
PC22 PC22034 TaxLiability STRING 6 6 0 Tax Liability
PC22 PC22035 OperationType VSTRING 10 10 0 Operation Type
PC22 PC22036 FinOperationCode VSTRING 10 10 0 Fin Operation Code
PC22 PC22037 NetInvAmntOCU MONEY 20 28 8 Net Invoice Amount in OCU
PC22 PC22038 PaymentBlockReason INTEGER 3 0 0 Payment Block Reason
PC22 PC22039 ReferenceNumber VSTRING 25 25 0 Reference Number
PC22 PC22040 WHTaxBase MONEY 20 28 8 Withholding Tax Base
PC22 PC22041 AmountWithholdingTaxOCU MONEY 20 28 8 Withholding Tax Amount OCU
PC22 PC22042 WHTaxAmountXMLFlag STRING 4 4 0 WH Tax Amount XML Flag
PC22 PC22043 ExchangeRate X_NUMERIC 10 18 8 Exchange Rate
PC22 PC22044 DocumentType VSTRING 3 3 0 Document Type
PC22 PC22045 ExtUserdefined1 VSTRING 150 150 0 Ext. User defined 1
PC22 PC22046 ExtUserdefined2 VSTRING 150 150 0 Ext. User defined 2
PC22 PC22047 ExtUserdefined3 VSTRING 150 150 0 Ext. User defined 3
PC22 PC22048 ExtUserdefined4 VSTRING 150 150 0 Ext. User defined 4
PC22 PC22049 ExtUserdefined5 VSTRING 150 150 0 Ext. User defined 5
PC22 PC22050 ExtUserdefined6 VSTRING 150 150 0 Ext. User defined 6
PC22 PC22051 ExtUserdefined7 VSTRING 150 150 0 Ext. User defined 7
PC22 PC22052 ExtUserdefined8 VSTRING 150 150 0 Ext. User defined 8
PC22 PC22053 ExtUserdefined9 VSTRING 150 150 0 Ext. User defined 9
PC22 PC22054 ExtUserdefined10 VSTRING 150 150 0 Ext. User defined 10
PC22 PC22055 ExtUserdefined11 VSTRING 150 150 0 Ext. User defined 11
PC22 PC22056 ExtUserdefined12 VSTRING 150 150 0 Ext. User defined 12
PC22 PC22057 ExtUserdefined13 VSTRING 150 150 0 Ext. User defined 13
PC22 PC22058 ExtUserdefined14 VSTRING 150 150 0 Ext. User defined 14
PC22 PC22059 ExtUserdefined15 VSTRING 150 150 0 Ext. User defined 15
PC22 PC22060 ExtUserdefined16 VSTRING 150 150 0 Ext. User defined 16
PC22 PC22061 ExtUserdefined17 VSTRING 150 150 0 Ext. User defined 17
PC22 PC22062 ExtUserdefined18 VSTRING 150 150 0 Ext. User defined 18
PC22 PC22063 ExtUserdefined19 VSTRING 150 150 0 Ext. User defined 19
PC22 PC22064 ExtUserdefined20 VSTRING 150 150 0 Ext. User defined 20
PC22 PC22065 OrigInv VSTRING 35 35 0 Original invoice number
PC22 PC22066 CorrNum STRING 1 1 0 Corrective Number
PC22 PC22067 TaxDate DATE 8 0 0 TaxDate Date for VAT to make separate transaction (Belgium VAT rules)
PC22 PC22068 PO3Subtype STRING 2 2 0 PO3 Sub type
PC22 PC22069 TaxRegCountry STRING 3 3 0 Tax Registration Country