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 PC03 PC03001 PurchaOrdNo STRING 10 10 0 Purchase Order Number
2 PC03 PC03002 LineNumber STRING 6 6 0 Purchase Order Line Number
3 PC03 PC03003 StructLineNo STRING 6 6 0 Purchase Order Sub-line Number
PC03 PC03004 LineType INTEGER 1 0 0 Line Type 0 - Stock Item Line
1 - Non Stock Item Line (dot item)
PC03 PC03005 StockCode VSTRING 35 35 0 Stock Item Code
PC03 PC03006 DescriptLine1 VSTRING 25 25 0 Description Line 1
PC03 PC03007 DescriptLine2 VSTRING 25 25 0 Description Line 2
PC03 PC03008 UnitPrice MONEY 20 28 8 Unit Price (Order Currency)
PC03 PC03009 UnitCode INTEGER 4 0 0 Unit Code
PC03 PC03010 PCQtyOrdered X_NUMERIC 12 20 8 Quantity Ordered
PC03 PC03011 PCQtyReceive X_NUMERIC 12 20 8 Quantity Received
PC03 PC03012 PCQtyInvoice X_NUMERIC 12 20 8 Quantity Invoiced
PC03 PC03013 AccountCode1 STRING 2 2 0 Accounting Code 1
PC03 PC03014 FLAGBackOrd SWITCH 1 1 0 Back Order
PC03 PC03015 Discount X_NUMERIC 6 14 8 Discount
PC03 PC03016 DelDateCommi DATE 8 0 0 Delivery Date Committed
PC03 PC03017 DelDateActua DATE 8 0 0 Actual Delivery Date
PC03 PC03018 QtyUnitInDel X_NUMERIC 10 18 8 Items per Package (Purchase)
PC03 PC03019 CostPrcMult X_NUMERIC 10 18 8 Cost Price Multiplier
PC03 PC03020 NomenclatureNo VSTRING 25 25 0 Nomenclature Number
PC03 PC03021 TransactSour INTEGER 1 0 0 Related Type of Order - Not linked to other order type
1 - Sales Order
2 - Service Order
3 - Work Order
PC03 PC03022 ItemType VSTRING 1 1 0 Item Type
PC03 PC03023 StockStatus INTEGER 1 0 0 Stock Item Status
PC03 PC03024 BatchCreatDt DATE 8 0 0 Date Batch Created
PC03 PC03025 DelExchRate X_NUMERIC 20 28 8 Delivery Date Exchange Rate
PC03 PC03026 Spare VSTRING 1 1 0 (obsolete)
PC03 PC03027 FLAGNewOrLin STRING 1 1 0 New Order Line
PC03 PC03028 UserOption2 VSTRING 1 1 0 UserOption2
PC03 PC03029 FlagLineConfirmed VSTRING 1 1 0 Line Confirmed
PC03 PC03030 DelDateReque DATE 8 0 0 Delivery Date Requested
PC03 PC03031 DelDatBackOr DATE 8 0 0 Delivery Date Back Order
PC03 PC03032 NetWeight X_NUMERIC 10 18 8 Net Weight
PC03 PC03033 GrossWeight X_NUMERIC 10 18 8 Gross Weight
PC03 PC03034 Volume X_NUMERIC 10 18 8 Volume
PC03 PC03035 WarehouseID VSTRING 6 6 0 Warehouse
PC03 PC03036 AccounString ACCSTR 120 120 0 Accounting String
PC03 PC03037 ProjectRefer VSTRING 12 12 0 Project Reference
PC03 PC03038 QtyRecDispNt X_NUMERIC 12 20 8 Total Received Quantity
PC03 PC03039 OrReference VSTRING 10 10 0 Order Reference
PC03 PC03040 PurchaserDepartment VSTRING 9 9 0 Purchaser/Department
PC03 PC03041 DelivBatchNo VSTRING 12 12 0 Delivery Batch Number
PC03 PC03042 UnConvForPur X_NUMERIC 10 18 8 Unit Conversion Factor Purchase to Stock
PC03 PC03043 DeliverQtySC X_NUMERIC 12 20 8 Quantity Received (Stock Unit)
PC03 PC03044 OrdQtySCunit X_NUMERIC 12 20 8 Quantity Ordered (Stock Unit)
PC03 PC03045 OrdLineRefer STRING 14 14 0 Order Line Reference
PC03 PC03046 RemainQtySC X_NUMERIC 12 20 8 Remaining Quantity (Stock Unit)
PC03 PC03047 RemainQtyPC X_NUMERIC 12 20 8 Remaining Quantity
PC03 PC03048 SubType STRING 1 1 0 Sub Type
PC03 PC03049 QCQuantity X_NUMERIC 12 20 8 Quantity on Quality Control
PC03 PC03050 StatusQC STRING 1 1 0 Status Quality Control
PC03 PC03051 Contract VSTRING 27 27 0 Contract
PC03 PC03052 Spare1 STRING 3 3 0 (obsolete)
PC03 PC03053 Spare2 STRING 3 3 0 (obsolete)
PC03 PC03054 DelExchRate2 X_NUMERIC 10 18 8 Delivery Date Exchange Rate 2
PC03 PC03055 DelExchRateAlg STRING 3 3 0 Delivery Date Exchange Rate Algorithm
PC03 PC03056 CurrencyCode INTEGER 2 0 0 Currency Code Order
PC03 PC03057 OverDeliveryControl STRING 1 1 0 Over Delivery Control
PC03 PC03058 OverDeliveryPerc X_NUMERIC 6 14 8 Over Delivery Perc
PC03 PC03059 OverDeliveryQTY X_NUMERIC 12 20 8 Over Delivery Quantity
PC03 PC03060 EDIContractSwitch SWITCH 1 1 0 EDI-Contract
PC03 PC03061 OrigPriceCurCode INTEGER 2 0 0 Currency Code Original Price
PC03 PC03062 OrigUnitPrice MONEY 20 28 8 Original Unit Price
PC03 PC03063 SupplierOrderNumber STRING 20 20 0 Supplier Order Number
PC03 PC03064 SupplierOrderLineRef STRING 20 20 0 Supplier Order Line Reference
PC03 PC03065 LineNumberOrg STRING 12 12 0 Line Number Original Line
PC03 PC03066 PCQtyOrderedOrg X_NUMERIC 12 20 8 Original Quantity Ordered
PC03 PC03067 InvoiceNumber VSTRING 25 25 0 Invoice Number
PC03 PC03068 POReceipt VSTRING 1 1 0 Drop Shipment Receipt Rule 0 - Receive into Inventory
1 - Receive into Inventory and hard allocate to sales/service order
2 - Receive into Inventory and issue to sales/service order
3 - Issue to sales/service order without inventory update
PC03 PC03069 POAdjustment VSTRING 1 1 0 Drop Shipment Adjustment Allowed
PC03 PC03070 MarginRule VSTRING 1 1 0 Delivery Margin Rule
PC03 PC03071 MarginPercent X_NUMERIC 6 14 8 Delivery Margin Percent
PC03 PC03072 DSLine VSTRING 1 1 0 Drop Shipment Line
PC03 PC03073 Owner VSTRING 20 20 0 Owner
PC03 PC03074 QtyPCUnitLastInvoice X_NUMERIC 12 20 8 Quantity Last Invoiced
PC03 PC03075 QtySCUnitLastInvoice X_NUMERIC 12 20 8 Quantity Last Invoiced (Stock Unit)
PC03 PC03076 Spare X_NUMERIC 20 28 8 (obsolete)
PC03 PC03077 Spare X_NUMERIC 20 28 8 (obsolete)
PC03 PC03078 NodeIDBOMPC STRING 38 38 0 BoM Node ID Purchase Order
PC03 PC03079 NodeIDBOMSC STRING 38 38 0 BoM Node ID Stock
PC03 PC03080 BlockForProcess STRING 1 1 0 BoM Blocked for Processing
PC03 PC03081 InstallationCustomer VSTRING 10 10 0 Installation Customer
PC03 PC03082 InstallationSite VSTRING 4 4 0 Installation Site
PC03 PC03083 ServiceMasterOrder STRING 10 10 0 Service Master Order
PC03 PC03084 OriginalConfDD DATE 8 0 0 Original Confirmed Delivery Date
PC03 PC03085 CreationSource INTEGER 1 0 0 Creation Source
PC03 PC03086 TaxCode STRING 6 6 0 Tax Code
PC03 PC03087 ReminderDateFPO DATE 8 0 0 Reminder Date FPO
PC03 PC03088 LinkedToContract INTEGER 1 0 0 Linked to contract
PC03 PC03089 AccountCode2 STRING 2 2 0 Accounting Code 2
PC03 PC03090 ContractNumber VSTRING 10 10 0 Contract Number
PC03 PC03091 ContractLineNumber STRING 6 6 0 Contract Line Number
PC03 PC03092 DeliveryScheduleLineNumber STRING 6 6 0 Delivery Schedule Line Number
PC03 PC03093 OrgReqDeliveryDate DATE 8 0 0 Org. Req. Delivery Date
PC03 PC03094 CommodityCode VSTRING 35 35 0 Commodity code
PC03 PC03095 ProductTaxType VSTRING 10 10 0 Product Tax Type
PC03 PC03096 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
PC03 PC03097 ExUserDef1 VSTRING 150 150 0 Extended User-Defined Field 1
PC03 PC03098 ExUserDef2 VSTRING 150 150 0 Extended User-Defined Field 2
PC03 PC03099 ExUserDef3 VSTRING 150 150 0 Extended User-Defined Field 3
PC03 PC03100 ExUserDef4 VSTRING 150 150 0 Extended User-Defined Field 4
PC03 PC03101 ExUserDef5 VSTRING 150 150 0 Extended User-Defined Field 5
PC03 PC03102 ExUserDef6 VSTRING 150 150 0 Extended User-Defined Field 6
PC03 PC03103 ExUserDef7 VSTRING 150 150 0 Extended User-Defined Field 7
PC03 PC03104 ExUserDef8 VSTRING 150 150 0 Extended User-Defined Field 8
PC03 PC03105 ExUserDef9 VSTRING 150 150 0 Extended User-Defined Field 9
PC03 PC03106 ExUserDef10 VSTRING 150 150 0 Extended User-Defined Field 10
PC03 PC03107 ExUserDef11 VSTRING 150 150 0 Extended User-Defined Field 11
PC03 PC03108 ExUserDef12 VSTRING 150 150 0 Extended User-Defined Field 12
PC03 PC03109 ExUserDef13 VSTRING 150 150 0 Extended User-Defined Field 13
PC03 PC03110 ExUserDef14 VSTRING 150 150 0 Extended User-Defined Field 14
PC03 PC03111 ExUserDef15 VSTRING 150 150 0 Extended User-Defined Field 15
PC03 PC03112 ExUserDef16 VSTRING 150 150 0 Extended User-Defined Field 16
PC03 PC03113 ExUserDef17 VSTRING 150 150 0 Extended User-Defined Field 17
PC03 PC03114 ExUserDef18 VSTRING 150 150 0 Extended User-Defined Field 18
PC03 PC03115 ExUserDef19 VSTRING 150 150 0 Extended User-Defined Field 19
PC03 PC03116 ExUserDef20 VSTRING 150 150 0 Extended User-Defined Field 20
PC03 PC03117 Requisition VSTRING 10 10 0 Requisition
PC03 PC03118 RqsnLine STRING 4 4 0 Requisition Line
PC03 PC03119 DeliveryBlock INTEGER 1 0 0 Delivery Block
PC03 PC03120 ATPPeriodShiftDays INTEGER 1 0 0 ATP period shift days
PC03 PC03121 ActualATPPeriodShiftDays INTEGER 1 0 0 Actual ATP period shift days