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 PCT1 PCT1001 OrderLineNo VSTRING 25 25 0 Order Line Number
3 PCT1 PCT1002 CustomerCode VSTRING 10 10 0 Customer Code
4 PCT1 PCT1003 TransType VSTRING 1 1 0 Transaction Type
7 PCT1 PCT1004 VATCode VSTRING 2 2 0 Tax Code/Tax Rate
8 PCT1 PCT1005 LineNo VSTRING 7 7 0 Line Number
9 PCT1 PCT1006 TransDate DATE 8 0 0 Transaction Date
PCT1 PCT1007 InvoiceDate DATE 8 0 0 Invoice Date
PCT1 PCT1008 BaseAmountLCU MONEY 20 28 8 Base Amount LCU
PCT1 PCT1009 TaxAmountLCU MONEY 20 28 8 Tax Amount LCU
PCT1 PCT1010 Remark VSTRING 4 4 0 Remark
PCT1 PCT1011 RefNo VSTRING 9 9 0 Invoice Reference Number
PCT1 PCT1012 CashMethod VSTRING 1 1 0 Cash Method
PCT1 PCT1013 Deductable VSTRING 6 6 0 Deductable
PCT1 PCT1014 ExpandedMacro VSTRING 1 1 0 Expanded Macro
PCT1 PCT1015 Reported VSTRING 1 1 0 Reported
PCT1 PCT1016 DeductibleAm MONEY 20 28 8 Deductible Amount
PCT1 PCT1017 BookedCostAmount MONEY 20 28 8 Booked Cost Amount
PCT1 PCT1018 VATDiffAmount MONEY 20 28 8 VAT Difference Amount
10 PCT1 PCT1019 TransactionNo VSTRING 9 9 0 Transaction Number
6 PCT1 PCT1020 TaxType STRING 6 6 0 Tax Type
PCT1 PCT1021 TaxLiability STRING 6 6 0 Tax Liability Code
5 PCT1 PCT1022 TaxCode STRING 6 6 0 Tax Code
PCT1 PCT1023 DocumentType STRING 3 3 0 Document Type
PCT1 PCT1024 TaxClassification STRING 2 2 0 Tax Classification
PCT1 PCT1025 TaxCertificate VSTRING 15 15 0 Tax Certificate
PCT1 PCT1026 TaxCertifFlag STRING 1 1 0 Tax Certificate Print Status
PCT1 PCT1027 PaymentNumber STRING 2 2 0 Payment Number
PCT1 PCT1028 PaymentSubNumber STRING 2 2 0 Payment Sub Number
PCT1 PCT1029 StockItem VSTRING 35 35 0 Stock Item Code
PCT1 PCT1030 OrigBatchNumber VSTRING 12 12 0 Original Batch Number
PCT1 PCT1031 TaxRate X_NUMERIC 12 20 8 Tax Rate
PCT1 PCT1032 TaxCalcMethod INTEGER 2 0 0 Tax Calculation Method
PCT1 PCT1033 RateType STRING 1 1 0 Rate Type
PCT1 PCT1034 TaxBaseType INTEGER 2 0 0 Tax Base Type
PCT1 PCT1035 TaxExemption STRING 2 2 0 Tax Exemption
PCT1 PCT1036 TaxExemptionRate X_NUMERIC 12 20 8 Tax Exemption Rate
1 PCT1 PCT1037 PurchOrderNo VSTRING 10 10 0 Purch Order Number
PCT1 PCT1038 FiscTextCode VSTRING 10 10 0 Fiscal Text Code
PCT1 PCT1039 TributarySitCode VSTRING 10 10 0 Tributary Situation Code
PCT1 PCT1040 CVFCode VSTRING 10 10 0 CVF Code
PCT1 PCT1041 STBaseAmountLCU MONEY 20 28 8 ST Base Amount LCU
PCT1 PCT1042 STTaxAmountLCU MONEY 20 28 8 Tributary Substitution Amount LCU
PCT1 PCT1043 TaxCategory VSTRING 10 10 0 Tax Category
PCT1 PCT1044 OriginalCompany VSTRING 2 2 0 Original Company
PCT1 PCT1045 MarginPercent X_NUMERIC 12 20 8 Margin Percent
PCT1 PCT1046 FixedPrice MONEY 20 28 8 Fixed Price LCU
PCT1 PCT1047 AcceptedDifference X_NUMERIC 12 20 8 Accepted Difference
PCT1 PCT1048 ResolutionName VSTRING 40 40 0 Resolution Name
PCT1 PCT1049 ResolutionDate DATE 8 0 0 Resolution Date
PCT1 PCT1050 InvoiceRefer VSTRING 25 25 0 InvoiceRefer
PCT1 PCT1051 OrigCurrCode VSTRING 2 2 0 Original Currency Code This field should contain the original currency code.
PCT1 PCT1052 BaseAmountOCU MONEY 20 28 8 Base Amount (Original Currency) This field should contain the tax base amount in original currency.
PCT1 PCT1053 TaxSlipNo VSTRING 15 15 0 Tax Slip No This field should contain the purchase tax slip number.
PCT1 PCT1054 TaxSlipLine VSTRING 6 6 0 Tax Slip Line This field should contain the purchase tax slip line.
PCT1 PCT1055 AccountingInfo ACCSTR 120 120 0 Accounting Info
PCT1 PCT1056 LineReference VSTRING 7 7 0 Line Reference
PCT1 PCT1057 FinYear VSTRING 4 4 0 Financial Year
PCT1 PCT1058 RefGL06 VSTRING 9 9 0 Ref GL06
PCT1 PCT1059 DirectfromGL VSTRING 1 1 0 Direct from GL
PCT1 PCT1060 IssuerCode STRING 6 6 0 Issuer Code Issuer Code
PCT1 PCT1061 OrderLineNum STRING 10 10 0 Order Line Number Order Line Number
PCT1 PCT1062 AASCode VSTRING 25 25 0 AAS code
PCT1 PCT1063 ThirdPartySupplier VSTRING 10 10 0 ThirdPartySupplier ThirdPartySupplier
PCT1 PCT1064 ProRataAmount MONEY 20 28 8 ProRataAmount Italian functionality to story VAT deductible
PCT1 PCT1065 ReferSLInvoice VSTRING 25 25 0 Reference to SL Invoice
PCT1 PCT1066 CertificateDate DATE 8 0 0 Certificate Date
PCT1 PCT1067 NonDeductAm MONEY 20 28 8 Non Deductible Amount
PCT1 PCT1068 OrderSubLineNo VSTRING 6 6 0 OrderSubLineNo OrderSubLineNo
PCT1 PCT1069 ActualTaxBase MONEY 20 28 8 Actual Tax Base
PCT1 PCT1070 ActualTaxRate X_NUMERIC 12 20 8 Actual Tax Rate
PCT1 PCT1071 DestinationRate X_NUMERIC 8 16 8 Destination Rate
PCT1 PCT1072 CostType STRING 2 2 0 Cost Type
PCT1 PCT1073 HMRCPeriodKey VSTRING 4 4 0 HMRC Period Key Key of HMRC period to which this transaction line is included.
PCT1 PCT1074 TaxRegCountry STRING 3 3 0 Tax Registration Country
PCT1 PCT1075 Specification STRING 3 3 0 Specification
PCT1 PCT1076 Notification STRING 3 3 0 Notification