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 PC01 PC01001 PurchOrderNo STRING 10 10 0 Purchase Order Number
PC01 PC01002 OrderType INTEGER 1 0 0 Order Type 0 - Purchase Order Proposal / Request for Quotation
1 - Normal Order
2 - Back Order
3 - Direct Delivery to Customer
4 - Replenishment Order
PC01 PC01003 OrdSupplCode VSTRING 10 10 0 Order Supplier Code
PC01 PC01004 CustCodeDel VSTRING 10 10 0 Customer Code Delivery
PC01 PC01005 Remark1 VSTRING 25 25 0 Remark Line 1
PC01 PC01006 Remark2 VSTRING 25 25 0 Remark Line 2
PC01 PC01007 FLPurchOrder INTEGER 1 0 0 Purchase Order Print Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
PC01 PC01008 FLRemConf INTEGER 1 0 0 Reminder of Confirmation Print Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
PC01 PC01009 FLRemShipm INTEGER 1 0 0 Reminder of Shipment Print Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
PC01 PC01010 FLDispNotEnt SWITCH 1 1 0 Delivery Note Entered
PC01 PC01011 FLInvEntered SWITCH 1 1 0 Invoice Entered
PC01 PC01012 TermsOfPaym INTEGER 2 0 0 Payment Terms
PC01 PC01013 TermsOfDel INTEGER 2 0 0 Delivery Terms
PC01 PC01014 WayOfDel INTEGER 2 0 0 Delivery Method
PC01 PC01015 OrderDate DATE 8 0 0 Order Date
PC01 PC01016 DelDate DATE 8 0 0 Delivery Date
PC01 PC01017 OurReference VSTRING 35 35 0 Our Reference
PC01 PC01018 YourReferenc VSTRING 35 35 0 Your Reference
PC01 PC01019 OrderDiscoun X_NUMERIC 6 14 8 Order Discount
PC01 PC01020 OrderValue MONEY 20 28 8 Order Value (Local Currency)
PC01 PC01021 LanguageCode VSTRING 3 3 0 Language
PC01 PC01022 CurrCode INTEGER 2 0 0 Currency Code
PC01 PC01023 WareHouse VSTRING 6 6 0 Warehouse
PC01 PC01024 ExternalControl SWITCH 1 1 0 External Control
PC01 PC01025 SPARE VSTRING 1 1 0 (obsolete)
PC01 PC01026 FLGRNXML VSTRING 1 1 0 Goods Received Note Sent (XML) 0 - Document not ready for sending
1 - Send document
2 - Document sent
PC01 PC01027 ProposedPOType VSTRING 1 1 0 Proposed Purchase Order Type The default order type that shall be suggested when converting a purchase order proposal to an order. See PC01002 for description of the different order types.
PC01 PC01028 FLGRN VSTRING 1 1 0 Goods Received Note Printed 0 - Document not ready for printing
1 - Print document
2 - Document sent
PC01 PC01029 UserOption3 VSTRING 1 1 0 (obsolete)
PC01 PC01030 CurrContract SWITCH 1 1 0 Currency Contract
PC01 PC01031 FixedExcRate X_NUMERIC 20 28 8 Fixed Exchange Rate
PC01 PC01032 ContractNo VSTRING 15 15 0 Currency Contract Number
PC01 PC01033 DefaultAcc ACCSTR 120 120 0 Accounting String
PC01 PC01034 LetterOfCred SWITCH 1 1 0 Letter of Credit
PC01 PC01035 LetterOfCrOp DATE 8 0 0 Letter of Credit Open Date
PC01 PC01036 LetterOfCrDu DATE 8 0 0 Letter of Credit Due Date
PC01 PC01037 LettOfCreRef VSTRING 20 20 0 Letter of Credit Reference
PC01 PC01038 PartiaDelCde SWITCH 1 1 0 Partial Delivery Option
PC01 PC01039 EDITransmCou INTEGER 2 0 0 EDI Transmit Count
PC01 PC01040 EDIRecveCoun INTEGER 2 0 0 EDI Received Count
PC01 PC01041 EDIFlag1 SWITCH 1 1 0 EDI Flag 1 Currently not used for any specific functionality
PC01 PC01042 EDIFlag2 SWITCH 1 1 0 EDI Flag 2
PC01 PC01043 EDIFlag3 SWITCH 1 1 0 EDI Flag 3
PC01 PC01044 EDIFlag4 SWITCH 1 1 0 EDI Flag 4
PC01 PC01045 ShippAddrNo VSTRING 2 2 0 Shipping Address Number
PC01 PC01046 Purchaser VSTRING 6 6 0 Purchaser Code
PC01 PC01047 FixedExchgRate2 X_NUMERIC 10 18 8 Fixed Exchange Rate 2
PC01 PC01048 FixedExchgAlgtm STRING 3 3 0 Fixed Exchange Algorithm
PC01 PC01049 EDIContractSwitch SWITCH 1 1 0 EDI Contract
PC01 PC01050 OrAdminCode STRING 3 3 0 Order Administrator
PC01 PC01051 ProjManagActivityID VSTRING 30 30 0 Project Activity Reference
PC01 PC01052 SupplierOrderNo STRING 20 20 0 Supplier Order Number
PC01 PC01053 FLPurchOrderXML INTEGER 1 0 0 Purchase Order Sent Status (XML) 0 - Document not ready for sending
1 - Send document
2 - Document sent
PC01 PC01054 FLRenConfXML INTEGER 1 0 0 Reminder of Confirmation Send (XML) 0 - Document not ready for sending
1 - Send document
2 - Document sent
PC01 PC01055 FLRemShipmXML INTEGER 1 0 0 Reminder of Shipment Sent (XML) 0 - Document not ready for sending
1 - Send document
2 - Document sent
PC01 PC01056 ProjectNumber STRING 12 12 0 Project Number
PC01 PC01057 SiteCode STRING 25 25 0 Site Code
PC01 PC01058 CustomerPoNumber VSTRING 30 30 0 Customer Purchase Order Number
PC01 PC01059 Spare STRING 20 20 0 (obsolete)
PC01 PC01060 ExtRemark1 STRING 30 30 0 Extended Remark Line 1
PC01 PC01061 ExtRemark2 STRING 30 30 0 Extended Remark Line 2
PC01 PC01062 RequestNo STRING 10 10 0 Customer Request Number
PC01 PC01063 ImportOrder INTEGER 2 0 0 Import Order 0 - Not an Import Order
1 - Import Order
PC01 PC01064 ImportDocument INTEGER 2 0 0 Import Document Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
PC01 PC01065 TransportDocument INTEGER 2 0 0 Transport Document Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
PC01 PC01066 InvoiceNoLast VSTRING 25 25 0 Invoice Number
PC01 PC01067 ContractNumber STRING 10 10 0 Contract Number
PC01 PC01068 LinkedToProject STRING 1 1 0 Project Linked Option 0 - Not Linked to Project
1 - Linked to Standard Cost Activity
2 - Linked to Purchase Order Activity (type 6)
PC01 PC01069 FLAGReceivingClosed SWITCH 1 1 0 Closed for Receiving
PC01 PC01070 InstallationCustomer VSTRING 10 10 0 Installation Customer
PC01 PC01071 InstallationSite VSTRING 4 4 0 Installation Site
PC01 PC01072 ServiceMasterOrder STRING 10 10 0 Service Master Order
PC01 PC01073 UserID VSTRING 8 8 0 User ID for entry
PC01 PC01074 TaxLiability STRING 6 6 0 Tax Liability
PC01 PC01075 OperationType VSTRING 10 10 0 Operation Type
PC01 PC01076 FinOperationCode VSTRING 10 10 0 Financial Operation Code
PC01 PC01077 FiscTxtCode VSTRING 10 10 0 Fiscal Text Code
PC01 PC01078 FiscalNoteNo VSTRING 25 25 0 Number of printed Fiscal Note
PC01 PC01079 FiscalNoteDate DATE 8 0 0 Date of printed Fiscal Note
PC01 PC01080 Instalment SWITCH 1 1 0 Instalment
PC01 PC01081 NetWeight X_NUMERIC 10 18 8 Net Weight
PC01 PC01082 GrossWeight X_NUMERIC 10 18 8 Gross Weight
PC01 PC01083 NumberOfBoxes X_NUMERIC 10 18 8 Number of Boxes
PC01 PC01084 KindOfBox VSTRING 15 15 0 Kind of Box
PC01 PC01085 BoxNumbering VSTRING 15 15 0 Box numbering
PC01 PC01086 NumberOfPallets VSTRING 15 15 0 Number of pallets
PC01 PC01087 TransportCompanyCode VSTRING 10 10 0 Transport Company Code
PC01 PC01088 FreightAmount MONEY 20 28 8 Freight Amount
PC01 PC01089 PackingAmount MONEY 20 28 8 Packing Amount
PC01 PC01090 InsuranceAmount MONEY 20 28 8 Insurance Amount
PC01 PC01091 InvoicingFee MONEY 20 28 8 Invoicing Fee
PC01 PC01092 OwnFreightAmount MONEY 20 28 8 Own Freight Amount
PC01 PC01093 VehicleState VSTRING 10 10 0 Vehicle State/Province
PC01 PC01094 VehicleLicensePlate VSTRING 15 15 0 Vehicle License Plate
PC01 PC01095 FreightTaxCode STRING 6 6 0 Freight Tax Code
PC01 PC01096 PackingTaxCode STRING 6 6 0 Packing Tax Code
PC01 PC01097 InsuranceTaxCode STRING 6 6 0 Insurance Tax Code
PC01 PC01098 InvoicingTaxCode STRING 6 6 0 Invoicing Tax Code
PC01 PC01099 OwnFreightTaxCode STRING 6 6 0 Own Freight Tax Code
PC01 PC01100 ReasonCode INTEGER 3 0 0 Reason Code
PC01 PC01101 EmailAddress VSTRING 200 200 0 Email address
PC01 PC01102 OrgReqDeliveryDate DATE 8 0 0 Org. Req. Delivery Date
PC01 PC01103 CodeANTT VSTRING 10 10 0 Code ANTT
PC01 PC01104 RedStornoOrd SWITCH 1 1 0 Red Storno Order
PC01 PC01105 TaxPoint STRING 1 1 0 Tax Point
PC01 PC01106 PublicProcuremCode1 VSTRING 20 20 0 Public Procurement Code1
PC01 PC01107 PublicProcuremCode2 VSTRING 20 20 0 Public Procurement Code2
PC01 PC01108 InvSupplCode STRING 10 10 0 Invoice Supplier Code
PC01 PC01109 PaymentFlag STRING 1 1 0 Payment Flag