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 PR02 PR02001 ProjectNo STRING 12 12 0 Project Number
2 PR02 PR02002 SubProject STRING 6 6 0 Sub-Project
3 PR02 PR02003 ActivityLine STRING 6 6 0 Activity Line Number
4 PR02 PR02004 ActiStruLine STRING 6 6 0 Activity Sub-line Number
PR02 PR02005 ActivType05 STRING 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
PR02 PR02006 ActivityCode STRING 6 6 0 Activity Code
PR02 PR02007 ResourceCode STRING 10 10 0 Resource Code
PR02 PR02008 Description VSTRING 35 35 0 Description
PR02 PR02009 ExtraDescr1 VSTRING 35 35 0 Extra Description Line 1
PR02 PR02010 ExtraDescr2 VSTRING 35 35 0 Extra Description Line 2
PR02 PR02011 ExtraDescr3 VSTRING 35 35 0 Extra Description Line 3
PR02 PR02012 Manager STRING 10 10 0 Resource Code Manager
PR02 PR02013 AccounString ACCSTR 120 120 0 Accounting String
PR02 PR02014 AccounCode VSTRING 2 2 0 Accounting Code
PR02 PR02015 EstStartDate DATE 8 0 0 Estimated Start Date
PR02 PR02016 ActStartDate DATE 8 0 0 Actual Start Date
PR02 PR02017 EstimEndDate DATE 8 0 0 Estimated End Date
PR02 PR02018 ActuEndDate DATE 8 0 0 Actual End Date
PR02 PR02019 IncFixedPric VSTRING 1 1 0 Is Included in Fixed Price
PR02 PR02020 ForecastHour X_NUMERIC 12 20 8 Estimated Quantity/Hours
PR02 PR02021 ForcDeHrsQty X_NUMERIC 12 20 8 Estimated Quantity/Hours to Charge
PR02 PR02022 ActRepHrsQty X_NUMERIC 12 20 8 Actual Reported Quantity/Hours
PR02 PR02023 ActDebHrsQty X_NUMERIC 12 20 8 Actual Invoiced Quantity/Hours
PR02 PR02024 EstRemHrsQty X_NUMERIC 12 20 8 Estimated Remaining Quantity/Hours
PR02 PR02025 PlannedHours X_NUMERIC 12 20 8 Scheduled/Planned Hours The number of hours that has been allocated to resources using the time planning feature.
PR02 PR02026 ForecRevenue MONEY 20 28 8 Estimated Total Revenue (Project Currency)
PR02 PR02027 ForecDebReve MONEY 20 28 8 Estimated Total Revenue to Charge (Project Currency)
PR02 PR02028 ActualReven MONEY 20 28 8 Actual Total Revenue (Project Currency)
PR02 PR02029 Spare VSTRING 20 20 0 Update Rule (Linked Order) 0 - Upload estimates assigned to internal customers only
1 - Upload estimates assigned to external customers only
2 - Upload estimates assigned to any customers
PR02 PR02030 Spare VSTRING 20 20 0 Estimate Settings (Linked Order) 0 - Update estimated revenue and estimated cost
1 - Update estimated cost only
2 - Update estimated revenue only
PR02 PR02031 ForecastReve MONEY 20 28 8 Estimated Total Revenue (Local Currency)
PR02 PR02032 ForecastCost MONEY 20 28 8 Estimated Total Cost (Local Currency)
PR02 PR02033 ActualCost MONEY 20 28 8 Actual Total Cost (Local Currency)
PR02 PR02034 Spare VSTRING 20 20 0 (obsolete)
PR02 PR02035 FctDebRevenueLCU MONEY 20 28 8 Estimated Total Revenuer to Charge (Local Currency)
PR02 PR02036 PurchaseOrderMarkup VSTRING 20 20 0 Purchase Order Mark-up %
PR02 PR02037 ActualDebRev MONEY 20 28 8 Actual Invoiced Revenue (Local Currency)
PR02 PR02038 ActivityToPurchOrd VSTRING 20 20 0 Is Linked to Purchase Order
PR02 PR02039 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)
PR02 PR02040 VATCode VSTRING 6 6 0 VAT Code
PR02 PR02041 ReporCode VSTRING 8 8 0 Report Code
PR02 PR02042 LinkedModule VSTRING 1 1 0 Linked Module Only used for activity type 0 and 2:
0 - Purchase Order
1 - Sales Order
PR02 PR02043 LinkedOrdNo VSTRING 10 10 0 Linked Order Number Depends on PR02042 and PR02005 and PR02038:
PR02005 = '0' and PR02038 = '1' : Contains Purchase Order Number (PC01001)
PR02005 = '2' and PR02042 = '0' : Contains Purchase Order Number (PC01001)
PR02005 = '2' and PR02042 = '1' : Contains Sales Order Number (OR01001)
PR02005 = '5' : : Contains Sales Order Number (OR01001)
PR02005 = '6' : : Contains Purchase Order Number (PC01001)
PR02005 = '7' : : Contains Service Order Number (SM01001)
PR02005 = '8' : : Contains Contract Number (SM11001)
PR02005 = '9' : : Contains Work Order Number (MP64001)
PR02 PR02044 EstDelivDate DATE 8 0 0 Estimated Delivery Date
PR02 PR02045 AutUpdEstMtr VSTRING 1 1 0 Automatically Update Estimates with Order Value
PR02 PR02046 LinkCreatDat DATE 8 0 0 Linked Object Date Created
PR02 PR02047 LinkClosDate DATE 8 0 0 Linked Object Close Date
PR02 PR02048 LinkStatus VSTRING 2 2 0 Linked Object Status
PR02 PR02049 WIPTransAmo MONEY 20 28 8 WIP Transaction Amount (Local Currency)
PR02 PR02050 WIPStatus VSTRING 1 1 0 WIP Status 0 - WIP has not been updated for the activity line
1 - WIP has been updated for the activity line
PR02 PR02051 FlReqNotePrn VSTRING 1 1 0 Request Note Print Status
PR02 PR02052 ReverIndLine STRING 12 12 0 Reversed Index Key
PR02 PR02053 FlaPrintDoc1 VSTRING 1 1 0 Document 1 Print Status
PR02 PR02054 FlaPrintDoc2 VSTRING 1 1 0 Document 2 Print Status
PR02 PR02055 FlaPrintDoc3 VSTRING 1 1 0 Document 3 Print Status
PR02 PR02056 FlaPrintDoc4 VSTRING 1 1 0 Document 4 Print Status
PR02 PR02057 FixPriceUnit VSTRING 1 1 0 Fixed Price Entered
PR02 PR02058 ExchangeRate1 X_NUMERIC 10 18 8 Currency Exchange Rate 1
PR02 PR02059 ExchangeRate2 X_NUMERIC 10 18 8 Currency Exchange Rate 2
PR02 PR02060 ExchangeAlgorithm STRING 3 3 0 Currency Exchange Algorithm
PR02 PR02061 CurrencyCode INTEGER 2 0 0 Currency Code
PR02 PR02062 StockCode STRING 35 35 0 Stock Item Code
PR02 PR02063 Workorder STRING 10 10 0 Work Order
PR02 PR02064 PlanStartTime INTEGER 4 0 0 Estimated Start Time
PR02 PR02065 PlanEndTime INTEGER 4 0 0 Estimated End Time
PR02 PR02066 LineGUID VSTRING 36 36 0 External ID
PR02 PR02067 FixedRevenue STRING 1 1 0 Fixed Revenue
PR02 PR02068 IncludeInRevenueRcgn STRING 1 1 0 Included into Revenue Recognition
PR02 PR02069 ActivityRevenuePCU MONEY 20 28 8 Activity Revenue PCU
PR02 PR02070 ApprovedCreditLimit SWITCH 1 1 0 Approved Credit Limit
PR02 PR02071 OperationType VSTRING 10 10 0 Operation Type
PR02 PR02072 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
PR02 PR02073 NCMCode VSTRING 25 25 0 NCM Code
PR02 PR02074 ProductTaxType VSTRING 10 10 0 Product Tax Type
PR02 PR02075 TaxationReasonCode STRING 3 3 0 Taxation Reason Code