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
PR01 Project Master Table Company PR010100
PR02 Project Activities Company PR020100
PR03 Project Activity Transactions Company PR030100
PR10 Activity Master Table Company PR100100
PR11 Activity Price Lists Company PR110100
PR13 Project Module Parameters Company PR130100
PR14 Project Invoice Text File Company PR140100
PR15 Project Delivery Addresses Company PR150100
PR17 Project Text Lines Company PR170100
PR18 Project Account Rule On-charges Company PR180100
PR19 Project Sub-project/Resource/Activity Price/Markup Company PR190100
PR23 Project Planning Calendar Company Year PR230112
PR24 Project User Database File Company PR240100
PR25 User Database Definitions Company PR250100
PR26 User Database Field Definitions Company PR260100
PR27 Project Invoice Proposal Transactions Company PR270100
PR28 Project Invoice Proposal Head Company PR280100
PR29 Project Invoice History Company PR290100
PR30 Project User Code File Definition Company PR300100
PR31 Project Invoice Plan Company PR310100
PR32 Project Accounting Journal Company Year PR320112
PR33 Project Automatic Account Coding Schedule Company Year PR330112
PR34 Project Budgets and Forecasts Company PR340100
PR35 Project Sub-projects Company PR350100
PR36 Main Projects Company PR360100
PR37 Project Templates Company PR370100
PR38 Project Invoice History Details Company PR380100
PR39 Company Year PR390112
PR41 Transaction Journal Company PR410100
PR42 Transaction Journal Text Lines Company PR420100
PR43 Resource Time Cards Company PR430100
PR44 Project Delivered Material Company PR440100
PR45 Invoice Statistics Head Company PR450100
PR46 Invoice Statistics Lines Company PR460100
PR47 Invoice Statistics Material Company PR470100
PR48 Import/Export definitions Company PR480100
PR49 WIP History Company PR490100
PR50 Sales Order Template Company PR500100
PR51 Project Activity Descriptions Company PR510100
PR52 Invoice Specification Company PR520100
PR53 Company PR530100
PRGL Company PRGL0100
PRI0 Project Instalments Company PRI00100
PRI2 Project Instalment Lines Company PRI20100
PRI4 Project Instalment Lines History Company PRI40100
PRX1 Wrk. PR0162 PRX10000
PRX2 Time Planning w PRX20000
PRX3 Cl.Pj.Inv. wrk. PRX30000
PRX4 Ed.Inv.Prop.wrk PRX40000
PRX5 Ed.Inv.Prop.wr1 PRX50000
PRX6 PRX60000
PRX7 Ed.Inv.Hist.wr1 PRX70000
PRX8 View Activites PRX80000
PRX9 Pj.Int.Debit w. PRX90000
PRXX Tr.Entries wrk. PRXX0000
PRXY Tr.Entries txt. PRXY0000
PRXZ Reports wrk. PRXZ0000

Fields
PK Table Name Description Type Length Precision Note
1 PR13 PR13001 IndexID VSTRING 1 1 0 Index Key
PR13 PR13002 PrjNoCounTpA VSTRING 1 1 0 (obsolete)
PR13 PR13003 PrjNoCounTpB VSTRING 1 1 0 (obsolete)
PR13 PR13004 PrjNoCounTpC VSTRING 1 1 0 (obsolete)
PR13 PR13005 PrjNoCounTpD VSTRING 1 1 0 (obsolete)
PR13 PR13006 PrjNoCounTpE VSTRING 1 1 0 (obsolete)
PR13 PR13007 PrjNoCounTpF VSTRING 1 1 0 (obsolete)
PR13 PR13008 PrjNoCounTpG VSTRING 1 1 0 (obsolete)
PR13 PR13009 NoOfLngeUsed VSTRING 1 1 0 (obsolete)
PR13 PR13010 InvoiNoCount VSTRING 1 1 0 (obsolete)
PR13 PR13011 CredNotNoCou VSTRING 1 1 0 (obsolete)
PR13 PR13012 IntInvNoCoun VSTRING 1 1 0 (obsolete)
PR13 PR13013 NoOfInvCopy VSTRING 2 2 0 Number of Invoice Copies
PR13 PR13014 InvFeeLCU VSTRING 20 20 0 Invoicing Fee (Local Currency)
PR13 PR13015 PrjNoCounTpH VSTRING 1 1 0 (obsolete)
PR13 PR13016 PrjNoCounTpI VSTRING 1 1 0 (obsolete)
PR13 PR13017 PrjNoCounTpJ VSTRING 1 1 0 (obsolete)
PR13 PR13018 PrjNoCounTpK VSTRING 1 1 0 (obsolete)
PR13 PR13019 PrjNoCounTpL VSTRING 1 1 0 (obsolete)
PR13 PR13020 PrjNoCounTpM VSTRING 1 1 0 (obsolete)
PR13 PR13021 PrjNoCounTpN VSTRING 1 1 0 (obsolete)
PR13 PR13022 PrjNoCounTpO VSTRING 1 1 0 (obsolete)
PR13 PR13023 PrjNoCounTpP VSTRING 1 1 0 (obsolete)
PR13 PR13024 AveragMarkup VSTRING 6 6 0 Average On-cost %
PR13 PR13025 FlagDocXMLInvoice INTEGER 1 0 0 Flag Doc XML Invoice
PR13 PR13026 LineIncrDef VSTRING 4 4 0 Activity Line Number Increment
PR13 PR13027 StruLineIncr VSTRING 4 4 0 Activity Sub-line Number Increment
PR13 PR13028 Tax Point (default) VSTRING 1 1 0 Tax Point (default)
PR13 PR13029 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13030 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13031 InvSortCode VSTRING 2 2 0 Invoice Sort Code Default
PR13 PR13032 Spare VSTRING 1 1 0 Print Non-Chargeable Activities 0 - Non-chargeable activities are not printed on Invoice proposal and invoice
1 - Non-chargeable activities are printed on invoice proposal only
2 - Non-chargeable activities are printed on both invoice proposal and invoice
PR13 PR13033 StatInvDate VSTRING 8 8 0 Statistics on Invoice Date
PR13 PR13034 InternMarkUp VSTRING 6 6 0 On-cost Internal Invoice %
PR13 PR13035 Tax Code for line-independent invoices VSTRING 6 6 0 Tax Code for line-independent invoices
PR13 PR13036 InvOnSubProjectLevl VSTRING 1 1 0 Invoice on Sub-Project Level
PR13 PR13037 NLtransaCoun VSTRING 1 1 0 (obsolete)
PR13 PR13038 ProjTransCou VSTRING 1 1 0 (obsolete)
PR13 PR13039 NoOfDeciCost VSTRING 1 1 0 Decimals in Quantity for Cost Activities
PR13 PR13040 NoOfDecTime VSTRING 1 1 0 Decimals in Hours for Time Activities
PR13 PR13041 Spare VSTRING 4 4 0 Invoice Plan Line Number Increment
PR13 PR13042 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13043 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13044 Journal Code for Revenue Recognition Journal VSTRING 6 6 0 Journal Code for Revenue Recognition Journal
PR13 PR13045 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13046 Journal Code for Project WIP Journal VSTRING 6 6 0 Journal Code for Project WIP Journal
PR13 PR13047 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13048 Spare VSTRING 6 6 0 (obsolete)
PR13 PR13049 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13050 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13051 DispNoteNo VSTRING 1 1 0 (obsolete)
PR13 PR13052 DispNoteCopy VSTRING 2 2 0 (obsolete)
PR13 PR13053 ConfirmCopy VSTRING 2 2 0 (obsolete)
PR13 PR13054 DiscountMeth VSTRING 1 1 0 (obsolete)
PR13 PR13055 InvoicingFee VSTRING 20 20 0 (obsolete)
PR13 PR13056 LimitInvFee VSTRING 20 20 0 (obsolete)
PR13 PR13057 AccCodeNoSto VSTRING 2 2 0 (obsolete)
PR13 PR13058 DefStatConf VSTRING 1 1 0 (obsolete)
PR13 PR13059 DefStatDispN VSTRING 1 1 0 (obsolete)
PR13 PR13060 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13061 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13062 AcsLevLinAdj VSTRING 1 1 0 (obsolete)
PR13 PR13063 AcsLevPrsAdj VSTRING 1 1 0 (obsolete)
PR13 PR13064 PrjNoCounTpQ VSTRING 1 1 0 (obsolete)
PR13 PR13065 PrjNoCounTpR VSTRING 1 1 0 (obsolete)
PR13 PR13066 PrjNoCounTpS VSTRING 1 1 0 (obsolete)
PR13 PR13067 PrjNoCounTpT VSTRING 1 1 0 (obsolete)
PR13 PR13068 PrjNoCounTpU VSTRING 1 1 0 (obsolete)
PR13 PR13069 PrjNoCounTpV VSTRING 1 1 0 (obsolete)
PR13 PR13070 PrjNoCounTpW VSTRING 1 1 0 (obsolete)
PR13 PR13071 PrjNoCounTpX VSTRING 1 1 0 (obsolete)
PR13 PR13072 PrjNoCounTpY VSTRING 1 1 0 (obsolete)
PR13 PR13073 PrjNoCounTpZ VSTRING 1 1 0 (obsolete)
PR13 PR13074 DefaultInvoiceSplit VSTRING 1 1 0 Default invoice split Used as default value for 'Separate per invoice' parameter in Print Invoice(Credit Note)
PR13 PR13075 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13076 MinInvAmount VSTRING 10 10 0 Minimum Invoice Amount (Local Currency)
PR13 PR13077 MarkupTimeB VSTRING 6 6 0 Price Increase Time % - Cost Category B
PR13 PR13078 MarkupTimeC VSTRING 6 6 0 Price Increase Time % - Cost Category C
PR13 PR13079 MarkupTimeD VSTRING 6 6 0 Price Increase Time % - Cost Category D
PR13 PR13080 MarkupTimeE VSTRING 6 6 0 Price Increase Time % - Cost Category E
PR13 PR13081 MarkupTimeF VSTRING 6 6 0 Price Increase Time % - Cost Category F
PR13 PR13082 PerfCrTestEn VSTRING 1 1 0 Credit Control Enabled
PR13 PR13083 GenPayrTrans VSTRING 1 1 0 Create Payroll Transactions
PR13 PR13084 AllocStrBase VSTRING 1 1 0 (obsolete)
PR13 PR13085 PrnDispNote VSTRING 1 1 0 (obsolete)
PR13 PR13086 DelivDateWN VSTRING 1 1 0 (obsolete)
PR13 PR13087 EnterDiscPr VSTRING 1 1 0 (obsolete)
PR13 PR13088 QtyPackUnit VSTRING 1 1 0 (obsolete)
PR13 PR13089 CreaPurcProp VSTRING 1 1 0 (obsolete)
PR13 PR13090 DelivPlann VSTRING 1 1 0 (obsolete)
PR13 PR13091 AutStrPrepar VSTRING 1 1 0 (obsolete)
PR13 PR13092 SortPickList VSTRING 1 1 0 (obsolete)
PR13 PR13093 DiscProdGrou VSTRING 1 1 0 (obsolete)
PR13 PR13094 IngrNominLed VSTRING 1 1 0 Integrated with General Ledger
PR13 PR13095 UseGLTransCounter VSTRING 1 1 0 Use General Ledger Transaction Counter
PR13 PR13096 StockAcMater VSTRING 1 1 0 (obsolete)
PR13 PR13097 CostAccHour VSTRING 1 1 0 Cost Accounting for Time Activities
PR13 PR13098 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13099 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13100 Spare VSTRING 1 1 0 (obsolete)
PR13 PR13101 TransactJour VSTRING 1 1 0 Use Transaction Journal
PR13 PR13102 UserDefin1 VSTRING 1 1 0 Use Code Table for User Defined Field 1
PR13 PR13103 UserDefin2 VSTRING 1 1 0 Use Code Table for User Defined Field 2
PR13 PR13104 UserDefin3 VSTRING 1 1 0 Use Code Table for User Defined Field 3
PR13 PR13105 UserDefin4 VSTRING 1 1 0 Use Code Table for User Defined Field 4
PR13 PR13106 UserDefin5 VSTRING 1 1 0 Use Code Table for User Defined Field 5
PR13 PR13107 UserDefin6 VSTRING 1 1 0 Use Code Table for User Defined Field 6
PR13 PR13108 UserDefin7 VSTRING 1 1 0 Use Code Table for User Defined Field 7
PR13 PR13109 UserDefin8 VSTRING 1 1 0 Use Code Table for User Defined Field 8
PR13 PR13110 UserDefin9 VSTRING 1 1 0 Use Code Table for User Defined Field 9
PR13 PR13111 UserDefin10 VSTRING 1 1 0 Use Code Table for User Defined Field 10
PR13 PR13112 CurrFromCust VSTRING 1 1 0 User Currency from Customer
PR13 PR13113 CalcPrcProj VSTRING 1 1 0 Calculate Price from Base Price List
PR13 PR13114 EntTimeHHMM VSTRING 1 1 0 Enter Time as HH:MM
PR13 PR13115 ShoTimeHHMM VSTRING 1 1 0 Show Time as HH:MM
PR13 PR13116 Register project dimension for Quotation VSTRING 1 1 0 Register project dimension for Quotation
PR13 PR13117 InvoiceSpecificationCounterRequired VSTRING 1 1 0 Invoice Specification Counter Required
PR13 PR13118 TextSwitches0 VSTRING 12 12 0 Free Text Block 0 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13119 TextSwitches1 VSTRING 12 12 0 Free Text Block 1 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13120 TextSwitches2 VSTRING 12 12 0 Free Text Block 2 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13121 TextSwitches3 VSTRING 12 12 0 Free Text Block 3 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13122 TextSwitches4 VSTRING 12 12 0 Free Text Block 4 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13123 TextSwitches5 VSTRING 12 12 0 Free Text Block 5 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13124 TextSwitches6 VSTRING 12 12 0 Free Text Block 6 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13125 TextSwitches7 VSTRING 12 12 0 Free Text Block 7 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13126 TextSwitches8 VSTRING 12 12 0 Free Text Block 8 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13127 TextSwitches9 VSTRING 12 12 0 Free Text Block 9 - Document Switches Each character in the string represent a document according to the following positions:
1 - Quotation
2 - Confirmation
3 - Work Order (Project)
4 - Project Specification
5 - Invoice Proposal
6 - Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
PR13 PR13128 CounAFixPre VSTRING 4 4 0 Prefix for Project Counter A
PR13 PR13129 CounBFixPre VSTRING 4 4 0 Prefix for Project Counter B
PR13 PR13130 CounCFixPre VSTRING 4 4 0 Prefix for Project Counter C
PR13 PR13131 CounDFixPre VSTRING 4 4 0 Prefix for Project Counter D
PR13 PR13132 CounEFixPre VSTRING 4 4 0 Prefix for Project Counter E
PR13 PR13133 CounFFixPre VSTRING 4 4 0 Prefix for Project Counter F
PR13 PR13134 CounGFixPre VSTRING 4 4 0 Prefix for Project Counter G
PR13 PR13135 CounHFixPre VSTRING 4 4 0 Prefix for Project Counter H
PR13 PR13136 CounIFixPre VSTRING 4 4 0 Prefix for Project Counter I
PR13 PR13137 CounJFixPre VSTRING 4 4 0 Prefix for Project Counter J
PR13 PR13138 CounKFixPre VSTRING 4 4 0 Prefix for Project Counter K
PR13 PR13139 CounLFixPre VSTRING 4 4 0 Prefix for Project Counter L
PR13 PR13140 CounMFixPre VSTRING 4 4 0 Prefix for Project Counter M
PR13 PR13141 CounNFixPre VSTRING 4 4 0 Prefix for Project Counter N
PR13 PR13142 CounOFixPre VSTRING 4 4 0 Prefix for Project Counter O
PR13 PR13143 CounPFixPre VSTRING 4 4 0 Prefix for Project Counter P
PR13 PR13144 CounQFixPre VSTRING 4 4 0 Prefix for Project Counter Q
PR13 PR13145 CounRFixPre VSTRING 4 4 0 Prefix for Project Counter R
PR13 PR13146 CounSFixPre VSTRING 4 4 0 Prefix for Project Counter S
PR13 PR13147 CounTFixPre VSTRING 4 4 0 Prefix for Project Counter T
PR13 PR13148 CounUFixPre VSTRING 4 4 0 Prefix for Project Counter U
PR13 PR13149 CounVFixPre VSTRING 4 4 0 Prefix for Project Counter V
PR13 PR13150 CounWFixPre VSTRING 4 4 0 Prefix for Project Counter W
PR13 PR13151 CounXFixPre VSTRING 4 4 0 Prefix for Project Counter X
PR13 PR13152 CounYFixPre VSTRING 4 4 0 Prefix for Project Counter Y
PR13 PR13153 CounZFixPre VSTRING 4 4 0 Prefix for Project Counter Z
PR13 PR13154 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13155 CountPreUsed VSTRING 4 4 0 Default Sales Order Counter
PR13 PR13156 DefPurchaseOrdCount VSTRING 4 4 0 Default Purchase Order Counter
PR13 PR13157 LinkedSalesOrderCounter VSTRING 4 4 0 Default Linked Sales Order Counter
PR13 PR13158 LinkedPurchaseOrderCounter VSTRING 4 4 0 Default Linked Purchase Order Counter
PR13 PR13159 LinkedServiceOrderCounter VSTRING 6 6 0 Default Linked Service Order Type
PR13 PR13160 LinkedServiceContractCounter VSTRING 4 4 0 Default Linked Service Contract Type
PR13 PR13161 LinkedWOCounter VSTRING 4 4 0 Default Linked Work Order Counter
PR13 PR13162 Taxation Reason code for line-independent invoices VSTRING 4 4 0 Taxation Reason code for line-independent invoices PR_PARAM_DEFAULT_TAXATION_REASON_CODE
PR13 PR13163 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13164 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13165 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13166 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13167 Spare VSTRING 4 4 0 (obsolete)
PR13 PR13168 CustomerPriorityWeightedforProject INTEGER 3 0 0 Weight Customer Priority for Project
PR13 PR13169 ProjectPriorityWeighted INTEGER 3 0 0 Weight Project Priority
PR13 PR13170 ProjectPriorityDefault INTEGER 1 0 0 Default Project Priority
PR13 PR13171 FlagAllowSiteCodeEmpty SWITCH 1 1 0 Site Code Is Mandatory
PR13 PR13172 ResourcePlanningLevel STRING 1 1 0 Resource Planning Level
PR13 PR13173 CreditCheckLine SWITCH 1 1 0 Credit Check Line
PR13 PR13174 CreditCheckSkipAdditional SWITCH 1 1 0 Credit Check Skip Additional
PR13 PR13175 CreditCheckExit SWITCH 1 1 0 Credit Check Exit
PR13 PR13176 CreditLimitBlockQuotation SWITCH 1 1 0 Credit Limit Block Quotation
PR13 PR13177 CreditLimitBlockEntry SWITCH 1 1 0 Credit Limit Block Entry
PR13 PR13178 CreditLimitBlockTransaction SWITCH 1 1 0 Credit Limit Block Transaction
PR13 PR13179 CreditLimitBlockLinkedObject SWITCH 1 1 0 Credit Limit Block Linked Object