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

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
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

PK Table Name Description Type Length Precision Note
1 PR03 PR03001 ProjectNo VSTRING 12 12 0 Project Number
2 PR03 PR03002 SubProject VSTRING 6 6 0 Sub-Project
3 PR03 PR03003 ActivityLine VSTRING 6 6 0 Activity Line Number
4 PR03 PR03004 ActStrucLine VSTRING 6 6 0 Activity Sub-line Number
5 PR03 PR03005 TransactDate DATE 8 0 0 Transaction Date
6 PR03 PR03006 ResourceCode VSTRING 10 10 0 Resource Code
7 PR03 PR03007 TransactLine VSTRING 6 6 0 Transaction Line Number
PR03 PR03008 HoursQty X_NUMERIC 12 20 8 Quantity/Hours Reported
PR03 PR03009 HoursQtyInv X_NUMERIC 12 20 8 Quantity/Hours to Invoice
PR03 PR03010 Price MONEY 20 28 8 Unit Price (Project Currency)
PR03 PR03011 PriceToInvoi MONEY 20 28 8 Unit Price to Invoice (Project Currency)
PR03 PR03012 CostLCU MONEY 20 28 8 Unit Cost (Local Currency)
PR03 PR03013 Description VSTRING 35 35 0 Text
PR03 PR03014 ChargeCode VSTRING 1 1 0 Charge Activity 0 - Activity shall not be charged to customer but cost allocated to the project
1 - Activity will included when invoicing the project
PR03 PR03015 ActualInvoicedCostLCU MONEY 20 28 8 Actual Invoiced Cost LCU
PR03 PR03016 ActInvAmount MONEY 20 28 8 Actual Invoiced Amount (Project Currency)
PR03 PR03017 InvoiceFlag VSTRING 1 1 0 Has Been Invoiced
PR03 PR03018 ActInvPrice MONEY 20 28 8 Actual Invoiced Amount (Local Currency)
PR03 PR03019 WIPTransLCU MONEY 20 28 8 WIP Transaction Amount (Local Currency)
PR03 PR03020 AccounString ACCSTR 120 120 0 Accounting String
PR03 PR03021 ActuaInvHour X_NUMERIC 12 20 8 Actual Invoiced Quantity/Hours
PR03 PR03022 Spare VSTRING 20 20 0 Spare
PR03 PR03023 Spare VSTRING 20 20 0 (obsolete)
PR03 PR03024 ActivityType VSTRING 1 1 0 Activity Type 0 - Cost Activity
1 - Time Activity
2 - Material Activity (Sales Order or Purchase Order)
3 - Milestone
4 - Text Annotation
5 - Linked Sales Order
6 - Linked Purchase Order
7 - Linked Service Order
8 - Linked Contract
9 - Linked Work Order
PR03 PR03025 VATCode VSTRING 6 6 0 VAT Code
PR03 PR03026 Markup X_NUMERIC 6 14 8 Mark-up %
PR03 PR03027 SupplCode VSTRING 10 10 0 Supplier Code
PR03 PR03028 InvLinLayout VSTRING 1 1 0 Invoice Line Layout 1 - Invoice lines include quantity, unit price and total amount.
2 - Invoice lines include only the totals.
(The actual layout is defined in the ddf files for invoices and invoice proposal)
PR03 PR03029 LinkActiLine VSTRING 6 6 0 Linked Activity Line Number
PR03 PR03030 LinActStrLin VSTRING 6 6 0 Linked Activity Sub-line Number
PR03 PR03031 VoucherNo VSTRING 9 9 0 General Ledger Transaction Number This information is updated for transaction updated from general ledger and manual general ledger transactions entered with project activity relation.
PR03 PR03032 CurrencyCode VSTRING 2 2 0 Currency Code
PR03 PR03033 WIPBEDate DATE 8 0 0 WIP Book-Entry Date
PR03 PR03034 EnterByUser VSTRING 10 10 0 Created By
PR03 PR03035 ConfirByUser VSTRING 10 10 0 Confirmed By
PR03 PR03036 DateType012 VSTRING 1 1 0 Date Type Time reported as per:
0 - Date
1 - Week
2 - Month
PR03 PR03037 WIPTransacNo VSTRING 9 9 0 WIP Transaction Number
PR03 PR03038 WIPAmtMarkup MONEY 20 28 8 WIP Amount Mark-up (Local Currency)
PR03 PR03039 WIPStatus VSTRING 1 1 0 WIP Status 0 - No cost/wip has been booked for the transaction line
1 - Transaction cost has been booked directly to P&L as cost (wip/cost method 1)
2 - Transaction cost has been booked to WIP account
3 - Booked wip amount has been booked as cost (reversed)
PR03 PR03040 PercentCompl X_NUMERIC 6 14 8 Estimated % to Completion Indicates how much is left to complete the activity. This estimate is entered by the user when reporting time.
PR03 PR03041 IntDebUpdate VSTRING 1 1 0 Internal Debiting Updated
PR03 PR03042 WIPReturnDate DATE 8 0 0 WIP Return Date
PR03 PR03043 WIPTreturnTranNo STRING 9 9 0 WIP Return Transaction Number
PR03 PR03044 ReservedForCredit STRING 8 8 0 Reserved For Credit
PR03 PR03045 CreatedForDistributeRevenue STRING 1 1 0 Created For Distribute Revenue
PR03 PR03046 SpareFlag2 STRING 1 1 0 (obsolete)
PR03 PR03047 InvoiceNoCustomer STRING 10 10 0 Customer Code Invoice
PR03 PR03048 GLTransactionLineID STRING 9 9 0 General Ledger Transaction Line Reference
PR03 PR03049 GLTransactionYear STRING 4 4 0 General Ledger Financial Year
PR03 PR03050 IncludeInRevenueRcgn STRING 1 1 0 Included into Revenue Recognition
PR03 PR03051 CloseDate DATE 8 0 0 Close Date
PR03 PR03052 OperationType VSTRING 10 10 0 Operation Type
PR03 PR03053 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
PR03 PR03054 NCMCode VSTRING 25 25 0 NCM Code
PR03 PR03055 ProductTaxType VSTRING 10 10 0 Product Tax Type
PR03 PR03056 TaxationReasonCode STRING 3 3 0 Taxation Reason Code