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 PR29 PR29001 ProjectNo VSTRING 12 12 0 Project Number
2 PR29 PR29002 SubProject VSTRING 6 6 0 Sub-Project
3 PR29 PR29003 InvoiceDate DATE 8 0 0 Invoice Date
4 PR29 PR29004 InvoiceNo VSTRING 15 15 0 Invoice Number
PR29 PR29005 InvTypeStat VSTRING 1 1 0 Invoice Type 0 - Initial invoice
1 - Ongoing invoice
2 - Fixed price invoice (ongoing)
3 - Fixed price invoice (invoice plan)
4 - Final invoice (retention)
5 - Repeat invoice
6 - Fixed price invoice (final invoice)
PR29 PR29006 InvoicedAmou MONEY 20 28 8 Invoice Amount (Project Currency) Total invoice amount including tax, cost and deductions. The amount is in the currency of the project.
PR29 PR29007 InvoicedVAT MONEY 20 28 8 Invoice VAT Amount (Project Currency) VAT amount included in the invoice total
PR29 PR29008 VATcode VSTRING 2 2 0 VAT Code
PR29 PR29009 ReTxtAnnot1 VSTRING 35 35 0 Text Annotation Line 1
PR29 PR29010 DeductAmount MONEY 20 28 8 Deducted Advance Amount (Project Currency) The amount that was deducted from the invoice amount according to previous invoiced advance amount
PR29 PR29011 DeductAmntRetention MONEY 20 28 8 Deducted Retention Amount (Project Currency) The amount that was deducted from the invoice amount to be retained for the final invoice. The amount is in the currency of the project.
PR29 PR29012 LinNoInvPlan VSTRING 4 4 0 Line Number Invoice Plan
PR29 PR29013 AmNoInclFxPr MONEY 20 28 8 Amount Not Included in Fixed Price Amount part of the invoice that is not included in the fixed price
PR29 PR29014 OCUExchangeRate1 MONEY 20 28 8 OCU Exchange Rate 1
PR29 PR29015 Manager VSTRING 10 10 0 Resource Code Manager
PR29 PR29016 FinalInvoice VSTRING 1 1 0 Advance Invoice is Deductible
PR29 PR29017 PriceModel VSTRING 1 1 0 Price Model 0 - Ongoing
1 - Fixed Price
2 - Repeat Invoice
PR29 PR29018 TrRepeAmou MONEY 20 28 8 Invoice Amount before Deductions (Project Currency)
PR29 PR29019 FxPriceTime MONEY 20 28 8 Fixed Price Time Activities (Project Currency) For fixed price invoice, the amount related to time activities according to the split defined in the invoice plan.
PR29 PR29020 FxPriceCost MONEY 20 28 8 Fixed Price Cost Activities (Project Currency) For fixed price invoice, the amount related to cost activities according to the split defined in the invoice plan.
PR29 PR29021 FxPriceMater MONEY 20 28 8 Fixed Price Material (Project Currency) For fixed price invoice, the amount related to material according to the split defined in the invoice plan.
PR29 PR29022 TextAnnot2 VSTRING 35 35 0 Text Annotation Line 2
PR29 PR29023 Spare MONEY 20 28 8 Open Balance Advances (Project Currency) For advance invoice, the open amount that has not yet been deduct on other invoice. The amount is in the currency of the project.
PR29 PR29024 Spare MONEY 20 28 8 Open Balance Advances (Local Currency) For advance invoice, the open amount that has not yet been deduct on other invoice. The amount is in the currency of the local currency for the company.
PR29 PR29025 DeduCeiPrice MONEY 20 28 8 Deducted Ceiling Overrun Amount (Project Currency) The amount that was deducted from the invoice amount as a result of exceeding the ceiling price for the project
PR29 PR29026 SortOrder VSTRING 7 7 0 Sort Order String defining the sort order to be used on the invoice, its created based on the invoice sort order code.
PR29 PR29027 DetailLevel VSTRING 1 1 0 Detail Level Value from 1-7 indicating which level in the sort order that should be used as last summary level.
PR29 PR29028 RetensionAmount MONEY 20 28 8 Deducted Retention Amount (Local Currency) The amount that was deducted from the invoice amount to be retained for the final invoice. The amount is in the local currency of the company.
PR29 PR29029 InvoiceAmount MONEY 20 28 8 Invoice Amount (Invoice Currency) Total invoice amount including tax, cost and deductions. The amount is in the currency of the invoice.
PR29 PR29030 InvoiceCurrencyCode INTEGER 2 0 0 Currency Code Invoice
PR29 PR29031 OCUExchangeRate2 X_NUMERIC 10 18 8 OCU Exchange Rate 2
PR29 PR29032 OCUExchangeAlgorithm STRING 3 3 0 OCU Exchange Algorithm
PR29 PR29033 CurrencyCodeProject INTEGER 2 0 0 Currency Code Project
PR29 PR29034 InvoiceNoOriginalCreditNoteNo STRING 15 15 0 Original Invoice Number/Credit Note
PR29 PR29035 InvoiceNoCustomer STRING 10 10 0 Customer Code Invoice
PR29 PR29036 TimeTaxCode STRING 6 6 0 Time Tax Code
PR29 PR29037 CostTaxCode STRING 6 6 0 Cost Tax Code
PR29 PR29038 MaterialTaxCode STRING 6 6 0 Material Tax Code
PR29 PR29039 TaxLiability STRING 6 6 0 Tax Liability
PR29 PR29040 InvoicePrefix STRING 4 4 0 Invoice Prefix
PR29 PR29041 PaymentTerm STRING 2 2 0 Payment Term
PR29 PR29042 InvoiceDueDate DATE 8 0 0 Invoice Due Date
PR29 PR29043 InvoiceCopyNumber INTEGER 4 0 0 Invoice Copy Number
PR29 PR29044 FlagDocXMLInvoice INTEGER 1 0 0 Flag Doc XML Invoice
PR29 PR29045 InvoiceTime X_DATETIME 17 0 0 Invoice Time
PR29 PR29046 LanCode STRING 3 3 0 Language Code
PR29 PR29047 DocCode STRING 1 1 0 Document Code
PR29 PR29048 RevenueIsBookedAsBilling SWITCH 1 1 0 Revenue Is Booked As Billing
PR29 PR29049 TaxPoint STRING 1 1 0 Tax Point Tax registration moment
PR29 PR29050 InvoiceIssuerCode VSTRING 6 6 0 Invoice Issuer Code
PR29 PR29051 InvoiceCategory STRING 1 1 0 Invoice Category
PR29 PR29052 Tax Amount included into selling price MONEY 20 28 8 Tax Amount included into selling price
PR29 PR29053 TaxationReasonCode STRING 3 3 0 Taxation Reason Code
PR29 PR29054 ICUExchangeRate1 X_NUMERIC 10 18 8 ICU Exchange Rate 1
PR29 PR29055 ICUExchangeRate2 X_NUMERIC 10 18 8 ICU Exchange Rate 2
PR29 PR29056 ICUExchangeAlgorithm STRING 3 3 0 ICU Exchange Algorithm