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 PCD3 PCD3001 BrokerSupplierCode VSTRING 10 10 0 Broker Supplier Code
2 PCD3 PCD3002 CustomsDeclarationNumber VSTRING 25 25 0 Customs Declaration Number
4 PCD3 PCD3003 SupplierCode VSTRING 10 10 0 Supplier Code
5 PCD3 PCD3004 InvoiceNumber VSTRING 25 25 0 Invoice Number
6 PCD3 PCD3005 OrderNo STRING 10 10 0 Order Number
7 PCD3 PCD3006 LineNo STRING 6 6 0 Line Number
8 PCD3 PCD3007 StructLineNo STRING 6 6 0 Structure Line Number
9 PCD3 PCD3008 AutSubStrLNo STRING 4 4 0 AutoSubStructLineNo
PCD3 PCD3009 BatchNumber VSTRING 12 12 0 Batch Number
PCD3 PCD3010 QtyInvoiced X_NUMERIC 12 20 8 Quantity Invoiced
PCD3 PCD3011 QtyDelivered X_NUMERIC 12 20 8 Quantity Delivered
PCD3 PCD3012 DelivDateAct DATE 8 0 0 Delivery Date Actual
PCD3 PCD3013 DelivNoteNo VSTRING 20 20 0 Delivery Note Number
PCD3 PCD3014 UnitCostPrice MONEY 20 28 8 Unit Cost Price
PCD3 PCD3015 BinNo VSTRING 6 6 0 Bin Number
PCD3 PCD3016 LockStatus09 INTEGER 1 0 0 LockStatus09
PCD3 PCD3017 SearchField VSTRING 20 20 0 Search Field
PCD3 PCD3018 DateReceived DATE 8 0 0 Date Received
PCD3 PCD3019 DateManufact DATE 8 0 0 Date Manufactured
PCD3 PCD3020 DateBestBefore DATE 8 0 0 Date Best Before
PCD3 PCD3021 DateShipBefore DATE 8 0 0 Date Ship Before
PCD3 PCD3022 SupplierBatchID VSTRING 20 20 0 Supplier Batch ID
PCD3 PCD3023 UserDefFld1 VSTRING 20 20 0 UserDefFld1
PCD3 PCD3024 UserDefFld2 VSTRING 10 10 0 UserDefFld2
PCD3 PCD3025 UserDefFld3 VSTRING 10 10 0 UserDefFld3
PCD3 PCD3026 UserDefFld4 VSTRING 8 8 0 UserDefFld4
PCD3 PCD3027 UserDefFld5 VSTRING 8 8 0 UserDefFld5
PCD3 PCD3028 UserDefFld6 VSTRING 4 4 0 UserDefFld6
PCD3 PCD3029 UserDefFld7 VSTRING 4 4 0 UserDefFld7
PCD3 PCD3030 UserDefFld8 VSTRING 2 2 0 UserDefFld8
PCD3 PCD3031 UserDefFld9 VSTRING 2 2 0 UserDefFld9
PCD3 PCD3032 UserDefFld10 VSTRING 1 1 0 UserDefFld10
PCD3 PCD3033 NetWeight X_NUMERIC 10 18 8 Net Weight
PCD3 PCD3034 GrossWeight X_NUMERIC 10 18 8 Gross Weight
PCD3 PCD3035 Volume X_NUMERIC 10 18 8 Volume
PCD3 PCD3036 DelDateRequested DATE 8 0 0 Delivery Date Requested
PCD3 PCD3037 DeliveryDateCommitted DATE 8 0 0 Delivery Date Committed
PCD3 PCD3038 DeliveryDateExchangeRate X_NUMERIC 20 28 8 Delivery Date Exchange Rate
PCD3 PCD3039 DeliveredQuantitySC X_NUMERIC 12 20 8 Delivered Quantity SC
PCD3 PCD3040 DeliveryDateBackOrder DATE 8 0 0 Delivery Date Back Order
PCD3 PCD3041 PurchSurcharge X_NUMERIC 6 14 8 PurchSurcharge
PCD3 PCD3042 Discount X_NUMERIC 6 14 8 Discount
PCD3 PCD3043 InvoicedQuantityPC X_NUMERIC 12 20 8 Invoiced Quantity PC
PCD3 PCD3044 QtyDelTimePC X_NUMERIC 12 20 8 QtyDelTimePC
PCD3 PCD3045 QtyDelTimeSC X_NUMERIC 12 20 8 QtyDelTimeSC
PCD3 PCD3046 QtyInvTimePC X_NUMERIC 12 20 8 QtyInvTimePC
PCD3 PCD3047 QtyInvTimeSC X_NUMERIC 12 20 8 QtyInvTimeSC
PCD3 PCD3048 BatchDelExis INTEGER 1 0 0 BatchDelExis
PCD3 PCD3049 DeliveryDateExchangeRate2 X_NUMERIC 10 18 8 Delivery Date Exchange Rate 2
PCD3 PCD3050 DeliveryDateExhchangeAlgorithm STRING 3 3 0 Delivery Date Exhchange Algorithm
PCD3 PCD3051 CurrencyCode INTEGER 2 0 0 Currency Code
PCD3 PCD3052 AutoDelNoteNo VSTRING 10 10 0 AutoDelNoteNo
PCD3 PCD3053 OriginalBatchID STRING 12 12 0 Original Batch ID
PCD3 PCD3054 QCCategory STRING 2 2 0 QC Category
PCD3 PCD3055 PotencyFactor X_NUMERIC 6 14 8 PotencyFactor
PCD3 PCD3056 DateOfExpiry DATE 8 0 0 Date of Expiry
PCD3 PCD3057 CustomsDespatchNoteNumber STRING 25 25 0 Customs Despatch Note Number
PCD3 PCD3058 DateImported DATE 8 0 0 Date Imported
PCD3 PCD3059 CountryOfOrigin STRING 3 3 0 Country of Origin
PCD3 PCD3060 CustomsOfficeCode STRING 10 10 0 Customs Office Code
PCD3 PCD3061 QtyRejected X_NUMERIC 12 20 8 Rejected quantity
PCD3 PCD3062 RejectionCode VSTRING 4 4 0 Rejection Code
PCD3 PCD3063 Temperature VSTRING 12 12 0 Temperature
PCD3 PCD3064 Humidity VSTRING 12 12 0 Humidity
PCD3 PCD3065 UserDef1 VSTRING 12 12 0 User def. 1
PCD3 PCD3066 UserDef2 VSTRING 12 12 0 User def. 2
PCD3 PCD3067 UserDef3 VSTRING 12 12 0 User def. 3
PCD3 PCD3068 UserDef4 VSTRING 12 12 0 User def. 4
PCD3 PCD3069 UserDef5 VSTRING 12 12 0 User def. 5
PCD3 PCD3070 DestinationCode STRING 4 4 0 Destination Code
3 PCD3 PCD3071 AdditionalInvoiceFlag INTEGER 1 0 0 Additional Invoice Flag