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 PC05 PC05001 YearKey STRING 2 2 0 Year
PC05 PC05002 OrNoCounterA NUMBER 1 20 0 (obsolete)
PC05 PC05003 OrNoCounterB NUMBER 1 20 0 (obsolete)
PC05 PC05004 OrNoCounterC NUMBER 1 20 0 (obsolete)
PC05 PC05005 NoOfPuOrCopy INTEGER 2 0 0 No of Purchase Order Copies
PC05 PC05006 NoOfRemCopy INTEGER 2 0 0 No of Reminder Copies
PC05 PC05007 AccCodNoStIt STRING 2 2 0 Accounting Code None Stock Items
PC05 PC05008 DefStConfRem INTEGER 1 0 0 Normal Status Reminder of Confirmation 0 - Order confirmation reminder is not selected, it can still be printed manually
1 - The order is selected for printing order confirmation reminder
PC05 PC05009 DefStShipRem INTEGER 1 0 0 Normal Status Reminder of Shipment 0 - Delivery reminder is not selected, it can still be printed manually
1 - The order is selected for printing delivery reminder
PC05 PC05010 DefOrType INTEGER 1 0 0 Normal Order Type 0 - Purchase order proposal / Request for quotation
1 - Normal order
2 - Back order
3 - Direct delivery to customer
PC05 PC05011 DayReminConf INTEGER 2 0 0 Days Until Printing Reminder of Confirmation
PC05 PC05012 DayReminShip INTEGER 2 0 0 Days Until Printing Reminder of Shipment
PC05 PC05013 OrLineIncrem INTEGER 3 0 0 Order Line Number Increment
PC05 PC05014 ForecastPeri INTEGER 2 0 0 Planning Weeks Purchases
PC05 PC05015 OffsetShipm INTEGER 2 0 0 Move Delivery Forward (weeks)
PC05 PC05016 DfltAssignmtPrior VSTRING 1 1 0 Default Assignment Priority 0 - No Default Assignment
1 - Highest Escalation Level and Priority within Requested Delivery Date
2 - Highest Weighted Order Priorities within Requested Delivery Date
3 - Earliest Required Delivery Date
PC05 PC05017 StratSelSupp INTEGER 1 0 0 Priority Supplier Selection 0 - The supplier from the stock item is selected
1 - The supplier with lowest purchase price is selected
2 - The supplier with shortest delivery time is selected
PC05 PC05018 BudgForComm INTEGER 1 0 0 Budget Alternative for Commitments
PC05 PC05019 IncrBatchLine INTEGER 3 0 0 Batch Line Number Increment
PC05 PC05020 IncrTextLine INTEGER 3 0 0 Text Line Number Increment
PC05 PC05021 OrdNoCountD NUMBER 1 20 0 (obsolete)
PC05 PC05022 OrdNoCountE NUMBER 1 20 0 (obsolete)
PC05 PC05023 OrdNoCountF NUMBER 1 20 0 (obsolete)
PC05 PC05024 OrdNoCountG NUMBER 1 20 0 (obsolete)
PC05 PC05025 OrdNoCountH NUMBER 1 20 0 (obsolete)
PC05 PC05026 OrdNoCountI NUMBER 1 20 0 (obsolete)
PC05 PC05027 OrdNoCountJ NUMBER 1 20 0 (obsolete)
PC05 PC05028 OrdNoCountK NUMBER 1 20 0 (obsolete)
PC05 PC05029 OrdNoCountL NUMBER 1 20 0 (obsolete)
PC05 PC05030 OrdNoCountM NUMBER 1 20 0 (obsolete)
PC05 PC05031 OrdNoCountN NUMBER 1 20 0 (obsolete)
PC05 PC05032 OrdNoCountO NUMBER 1 20 0 (obsolete)
PC05 PC05033 OrdNoCountP NUMBER 1 20 0 (obsolete)
PC05 PC05034 OrdNoCountQ NUMBER 1 20 0 (obsolete)
PC05 PC05035 OrdNoCountR NUMBER 1 20 0 (obsolete)
PC05 PC05036 OrdNoCountS NUMBER 1 20 0 (obsolete)
PC05 PC05037 OrdNoCountT NUMBER 1 20 0 (obsolete)
PC05 PC05038 OrdNoCountU NUMBER 1 20 0 (obsolete)
PC05 PC05039 OrdNoCountV NUMBER 1 20 0 (obsolete)
PC05 PC05040 OrdNoCountW NUMBER 1 20 0 (obsolete)
PC05 PC05041 OrdNoCountX NUMBER 1 20 0 (obsolete)
PC05 PC05042 OrdNoCountY NUMBER 1 20 0 (obsolete)
PC05 PC05043 OrdNoCountZ NUMBER 1 20 0 (obsolete)
PC05 PC05044 DelivDateDay SWITCH 1 1 0 Delivery Date as Week Number
PC05 PC05045 SavOrdAftInv SWITCH 1 1 0 Save Order After Invoice 0 - Save invoiced order neither in master nor in history tables.
1 - Save invoiced order in master tables only.
2 - Save invoiced order in history tables only.
3 - Save invoiced order both in master and history tables.
PC05 PC05046 DelAfDelivNt SWITCH 1 1 0 Delete Without Reversing Transactions Y - Delivered Purchase Orders can be deleted without reversed stock transactions.
N - Stock transactions will be reversed on delivered orders if deleted.
PC05 PC05047 ExtrTextDocu SWITCH 1 1 0 Print Extra Text from Stock Item on Documents
PC05 PC05048 CreatePICS SWITCH 1 1 0 Create Basis for Invoice Coding Slip
PC05 PC05049 UpdatePurchP SWITCH 1 1 0 Update Purchase Price
PC05 PC05050 DispTextLine SWITCH 1 1 0 Display Text Lines
PC05 PC05051 DocInSuppOrd SWITCH 1 1 0 Print Document in Supplier Order
PC05 PC05052 CommitAccoun INTEGER 1 0 0 Commitment Accounting
PC05 PC05053 FFB VSTRING 1 1 0 Allow Change of Backorder Date
PC05 PC05054 PurchaseContractByStartDate VSTRING 1 1 0 Purchase Contract by Start date
PC05 PC05055 CounterConsGRN VSTRING 1 1 0 (obsolete)
PC05 PC05056 DispTextLineDN SWITCH 1 1 0 Display Text Lines at DN Entry Display Text Lines at DN Entry
PC05 PC05057 FFB4 VSTRING 1 1 0 (obsolete)
PC05 PC05058 FFB5 VSTRING 1 1 0 (obsolete)
PC05 PC05059 FFB6 VSTRING 1 1 0 (obsolete)
PC05 PC05060 NewPC05Par01 VSTRING 10 10 0 (obsolete)
PC05 PC05061 NewPC05Par02 VSTRING 10 10 0 (obsolete)
PC05 PC05062 NewPC05Par03 VSTRING 10 10 0 (obsolete)
PC05 PC05063 NewPC05Par04 VSTRING 10 10 0 (obsolete)
PC05 PC05064 NewPC05Par05 VSTRING 10 10 0 (obsolete)
PC05 PC05065 NewPC05Par06 VSTRING 10 10 0 (obsolete)
PC05 PC05066 NewPC05Par07 VSTRING 10 10 0 (obsolete)
PC05 PC05067 NewPC05Par08 VSTRING 10 10 0 (obsolete)
PC05 PC05068 NewPC05Par09 VSTRING 10 10 0 (obsolete)
PC05 PC05069 NewPC05Par10 VSTRING 10 10 0 (obsolete)
PC05 PC05070 SupplPerfAnalysus STRING 1 1 0 Save Statistics for Suppler Performance Analysis
PC05 PC05071 DeleteStatisticLine SWITCH 1 1 0 Save Tracking of Purchase Order Changes
PC05 PC05072 WeightVolCalcPerUnit SWITCH 1 1 0 Weight and Volume Calculation per Unit
PC05 PC05073 PrintItemsNoinDispatchNote SWITCH 1 1 0 Print no of Items on Dispatch Notes
PC05 PC05074 StatusImportDocumentNormal INTEGER 2 0 0 Normal Status Import Document 0 - Import document is not selected, it can still be printed manually
1 - Import document is selected for printing
PC05 PC05075 DelDateFromOrderHead SWITCH 1 1 0 DeliveryDateFromOrderHead
PC05 PC05076 FlagBOMAutomaticEntry SWITCH 1 1 0 BoM Price View 0 - Price for top order line is displayed; prices for components are set to zero.
1 - Price for top order line is set to zero; prices for components are displayed.
2 - Prices for both top order line and components are displayed.
PC05 PC05077 Sw4DelSched STRING 1 1 0 Use Delivery Time Planning
PC05 PC05078 ConsumpNoteCounter NUMBER 13 20 0 (obsolete)
PC05 PC05079 StockAccFlg INTEGER 1 0 0 (obsolete)
PC05 PC05080 DefaultStructQueryStockItem NUMBER 1 20 0 Default Structure Query for Stock Item 0 - BOM configurations query will be shown by default for stock item.
1 - BOM templates query will be shown by default for stock item.
2 - Both BoM templates and BoM configurations will be shown by default for stock item.
PC05 PC05081 RqsnFulfilment INTEGER 3 0 0 Normal Requisition Fulfilment Time (days)
PC05 PC05082 RqsnValidPeriod INTEGER 3 0 0 Maximum Requisition Valid Period (month)
PC05 PC05083 RqsnGroupCriteria INTEGER 1 0 0 Requisition Grouping Criteria 0 - Supplier, requisition type, and requisition number
1 - Supplier, requisition type and department
2 - Supplier and requisition type
PC05 PC05084 RqsnPONoSerie STRING 1 1 0 (obsolete)
PC05 PC05085 RqsnLineDefaultsTo4 SWITCH 1 1 0 Requisition Default Line Type as 4
PC05 PC05086 UpdateDSPOTill INTEGER 1 0 0 Update DS purchase order till
PC05 PC05087 DefaultStructQryBOMConfigurator SWITCH 1 1 0 Default Structure Query in BOM Configurator
PC05 PC05088 DeliveryMilestone SWITCH 1 1 0 Milestone related to Delivery Date
PC05 PC05089 LTAPStartBeforeToday SWITCH 1 1 0 LT AP start before today
PC05 PC05090 RenewSuppPriceRqsn STRING 1 1 0 Renew supplier and price in requisition
PC05 PC05091 AutoConvertRqsn SWITCH 1 1 0 Automatic Requisition Conversion
PC05 PC05092 PickListOnAuth SWITCH 1 1 0 Picking Request upon Authorisation
PC05 PC05093 AllocPickRequest SWITCH 1 1 0 Create allocations during creation of picking request
PC05 PC05094 TaxCodeNonStockItem STRING 6 6 0 Tax Code Non Stock Item
PC05 PC05095 AutoPrintProdLabels INTEGER 1 0 0 Automatic printing of Product Labels
PC05 PC05096 AutoProdLabelsPrintChannel VSTRING 255 255 0 Automatic Product Labels Print Channel
PC05 PC05097 StratSelSuppRqsn INTEGER 1 0 0 Priority Supplier Selection in Requisitions
PC05 PC05098 CommodityCodeActivation INTEGER 1 0 0 Commodity code activation
PC05 PC05099 ProductTaxTypeNonStockItem VSTRING 10 10 0 Product Tax Type Non Stock Item
PC05 PC05100 SourceOfSuppInvBEDate STRING 1 1 0 Source of Supplier Invoice BE Date
PC05 PC05101 SourceOfEInvBEDate STRING 1 1 0 Source of Electronic Invoice BE Date
PC05 PC05102 RedStornoDef SWITCH 1 1 0 Red Storno Default
PC05 PC05103 ManualConvOfRqsn SWITCH 1 1 0 Manual Conversion of Requisitions
PC05 PC05104 AdjSuppAndPrice SWITCH 1 1 0 Adjust Supplier and Price
PC05 PC05105 Spare INTEGER 1 0 0 Spare
PC05 PC05106 Spare INTEGER 1 0 0 Spare
PC05 PC05107 PurchaseBudget INTEGER 1 0 0 Purchase Budget
PC05 PC05108 BudgetAccumulation INTEGER 1 0 0 Budget Accumulation
PC05 PC05109 BudgetControlDate INTEGER 1 0 0 Budget Control Date
PC05 PC05110 OptForAbsenceBudget INTEGER 1 0 0 Option For Absence of Budget
PC05 PC05111 AccountingSeg1 INTEGER 1 0 0 Accounting Segment 1
PC05 PC05112 AccountingSeg2 INTEGER 1 0 0 Accounting Segment 2
PC05 PC05113 AccountingSeg3 INTEGER 1 0 0 Accounting Segment 3
PC05 PC05114 DeliveryBlock INTEGER 1 0 0 Delivery Block
PC05 PC05115 ATPPeriodShiftDays INTEGER 1 0 0 ATP period shift days