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 PR35 PR35001 ProjectNo STRING 12 12 0 Project Number
2 PR35 PR35002 SubProject STRING 6 6 0 Sub-Project
PR35 PR35003 CustCodeInv STRING 10 10 0 Customer Code Invoice
PR35 PR35004 CustCodeDeli STRING 10 10 0 Customer Code Delivery
PR35 PR35005 Description STRING 35 35 0 Description
PR35 PR35006 ExtraDescr1 VSTRING 35 35 0 Extra Description Line 1
PR35 PR35007 ExtraDescr2 VSTRING 35 35 0 Extra Description Line 2
PR35 PR35008 ExtraDescr3 VSTRING 35 35 0 Extra Description Line 3
PR35 PR35009 AccounString ACCSTR 120 120 0 Accounting String
PR35 PR35010 Manager STRING 10 10 0 Resource Code Manager
PR35 PR35011 PlanStartDat DATE 8 0 0 Planned Start Date
PR35 PR35012 ActStartDate DATE 8 0 0 Actual Start Date
PR35 PR35013 PlanEndDate DATE 8 0 0 Planned End Date
PR35 PR35014 ActEndDate DATE 8 0 0 Actual End Date
PR35 PR35015 AccounCode VSTRING 2 2 0 Accounting Code Project
PR35 PR35016 InclFixPrice VSTRING 1 1 0 Included in Fixed Price
PR35 PR35017 ReportCode VSTRING 8 8 0 Report Code
PR35 PR35018 UserGroup VSTRING 8 8 0 User Group
PR35 PR35019 LanguageCode VSTRING 3 3 0 Language
PR35 PR35020 DocumCode VSTRING 1 1 0 Document Layout
PR35 PR35021 UserDefined1 VSTRING 20 20 0 User Defined Field 1
PR35 PR35022 UserDefined2 VSTRING 10 10 0 User Defined Field 2
PR35 PR35023 UserDefined3 VSTRING 10 10 0 User Defined Field 3
PR35 PR35024 UserDefined4 VSTRING 8 8 0 User Defined Field 4
PR35 PR35025 UserDefined5 VSTRING 8 8 0 User Defined Field 5
PR35 PR35026 UserDefined6 VSTRING 4 4 0 User Defined Field 6
PR35 PR35027 UserDefined7 VSTRING 4 4 0 User Defined Field 7
PR35 PR35028 UserDefined8 VSTRING 2 2 0 User Defined Field 8
PR35 PR35029 UserDefined9 VSTRING 2 2 0 User Defined Field 9
PR35 PR35030 UserDefine10 VSTRING 1 1 0 User Defined Field 10
PR35 PR35031 CustAccCode VSTRING 2 2 0 Accounting Code Customer
PR35 PR35032 SeparInvoic VSTRING 1 1 0 Separate Invoice 0 - Sub-project will be invoiced together with the project
1 - Sub-project is invoiced separately, independent of the project.
PR35 PR35033 InvoiceProposalFlag VSTRING 1 1 0 Invoice Proposal Print Status
PR35 PR35034 InvoiceDate VSTRING 8 8 0 Invoice Date
PR35 PR35035 InvoiceNumber VSTRING 15 15 0 Invoice Number
PR35 PR35036 CommitedCost VSTRING 20 20 0 Committed Cost (Local Currency)
PR35 PR35037 WIPRecCost MONEY 20 28 8 WIP Recognised Cost (Local Currency)
PR35 PR35038 WIPRecRevTime MONEY 20 28 8 WIP Recognised Revenue Time (Local Currency)
PR35 PR35039 WIPRecRevCost MONEY 20 28 8 WIP Recognised Revenue Cost (Local Currency)
PR35 PR35040 WIPRecRevMate MONEY 20 28 8 WIP Recognised Revenue Material (Local Currency)
PR35 PR35041 LatRevenueDate DATE 8 0 0 Last Revenue Recognition Date
PR35 PR35042 LastRevenuePerc X_NUMERIC 6 14 8 Last Revenue Recognition Percentage
PR35 PR35043 AccString ACCSTR 120 120 0 Accounting String (Internal Customer)
PR35 PR35044 InvoiceIssuer VSTRING 6 6 0 InvoiceIssuer
PR35 PR35045 InvoiceCategory SWITCH 1 1 0 InvoiceCategory
PR35 PR35046 InvoiceType SWITCH 1 1 0 InvoiceType
PR35 PR35047 TaxLiability STRING 6 6 0 Tax Liability
PR35 PR35048 Operation Type (Sub-Project level) VSTRING 10 10 0 Operation Type (Sub-Project level)
PR35 PR35049 Financial Operation Code (Sub-Project level) VSTRING 10 10 0 Financial Operation Code (Sub-Project level)
PR35 PR35050 Operation Type (Time activities level) VSTRING 10 10 0 Operation Type (Time activities level)
PR35 PR35051 Financial Operation Code (Time activities level) VSTRING 10 10 0 Financial Operation Code (Time activities level)
PR35 PR35052 Operation Type (Cost activities level) VSTRING 10 10 0 Operation Type (Cost activities level)
PR35 PR35053 Financial Operation Code (Cost activities level) VSTRING 10 10 0 Financial Operation Code (Cost activities level)
PR35 PR35054 Operation Type (Material activities level) VSTRING 10 10 0 Operation Type (Material activities level)
PR35 PR35055 Financial Operation Code (Material activities level) VSTRING 10 10 0 Financial Operation Code (Material activities level)
PR35 PR35056 LineGUID VSTRING 36 36 0 External ID
PR35 PR35057 BookEntryDate DATE 8 0 0 Book-Entry Date
PR35 PR35058 FlagDocXMLInvoice INTEGER 1 0 0 Flag Doc XML Invoice
PR35 PR35059 InvoiceTime X_DATETIME 17 0 0 Invoice Time
PR35 PR35060 Operation Type (Linked activities level) VSTRING 10 10 0 Operation Type (Linked activities level)
PR35 PR35061 Financial Operation Code (Linked activities level) VSTRING 10 10 0 Financial Operation Code (Linked activities level)
PR35 PR35062 LatestInvoiceDate DATE 8 0 0 Latest Invoice Date