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 PR37 PR37001 ProjTypeID VSTRING 2 2 0 Project Type
2 PR37 PR37002 TemplateNo VSTRING 2 2 0 Template Number
3 PR37 PR37003 RecordType VSTRING 1 1 0 Record Type A - Project head information
B - Sub-project information
C - Activity line information
4 PR37 PR37004 SubProjectID VSTRING 6 6 0 Sub-Project
5 PR37 PR37005 ActivityLine VSTRING 6 6 0 Activity Line Number
PR37 PR37006 Description1 VSTRING 35 35 0 Description Line 1
PR37 PR37007 Description2 VSTRING 35 35 0 Description Line 2
PR37 PR37008 ExtraText1 VSTRING 35 35 0 Extra Description Line 1
PR37 PR37009 ExtraText2 VSTRING 35 35 0 Extra Description Line 2
PR37 PR37010 ExtraText3 VSTRING 35 35 0 Extra Description Line 3
PR37 PR37011 ExtraText4 VSTRING 35 35 0 Extra Description Line 4
PR37 PR37012 UserDefined1 VSTRING 20 20 0 User Defined Field 1
PR37 PR37013 UserDefined2 VSTRING 10 10 0 User Defined Field 2
PR37 PR37014 UserDefined3 VSTRING 10 10 0 User Defined Field 3
PR37 PR37015 UserDefined4 VSTRING 8 8 0 User Defined Field 4
PR37 PR37016 UserDefined5 VSTRING 8 8 0 User Defined Field 5
PR37 PR37017 UserDefined6 VSTRING 4 4 0 User Defined Field 6
PR37 PR37018 UserDefined7 VSTRING 4 4 0 User Defined Field 7
PR37 PR37019 UserDefined8 VSTRING 2 2 0 User Defined Field 8
PR37 PR37020 UserDefined9 VSTRING 2 2 0 User Defined Field 9
PR37 PR37021 UserDefine10 VSTRING 1 1 0 User Defined Field 10
PR37 PR37022 ProjectCateg VSTRING 4 4 0 Project Category
PR37 PR37023 InvModelCost VSTRING 1 1 0 Included in Fixed Price
PR37 PR37024 InvModelTime VSTRING 1 1 0 Separate Invoice
PR37 PR37025 EstStrAddUni VSTRING 1 1 0 Estimated Start-up Time Unit 1 - Hours
2 - Days
3 - Weeks
4 - Month
5 - Years
PR37 PR37026 EstStrAddTim VSTRING 3 3 0 Estimated Start-up Time
PR37 PR37027 EstEndAddUni VSTRING 1 1 0 Estimated Length Unit 1 - Hours
2 - Days
3 - Weeks
4 - Month
5 - Years
PR37 PR37028 EstEndAddTim VSTRING 3 3 0 Estimated Length Time
PR37 PR37029 DefBudgAmt VSTRING 20 20 0 (obsolete)
PR37 PR37030 DefBudgCost VSTRING 20 20 0 Linked to Purchase Order
PR37 PR37031 TemplDescrip VSTRING 35 35 0 Template Description
PR37 PR37032 CountNoUsed VSTRING 1 1 0 Project Counter
PR37 PR37033 ProjAccCode VSTRING 2 2 0 Accounting Code Project
PR37 PR37034 ActivityCode VSTRING 6 6 0 Activity Code
PR37 PR37035 ActivQtyHour X_NUMERIC 12 20 8 Default Quantity/Hours
PR37 PR37036 Manager VSTRING 10 10 0 Resource Code Manager
PR37 PR37037 DefResource VSTRING 10 10 0 Resource Code Default
PR37 PR37038 ReportCode VSTRING 8 8 0 Report Code
PR37 PR37039 ActivityType VSTRING 1 1 0 Activity Type
PR37 PR37040 DocumCode VSTRING 1 1 0 Document Code (Sub-project)
PR37 PR37041 DebtToCust VSTRING 1 1 0 (obsolete)
PR37 PR37042 InvSortCode VSTRING 2 2 0 Invoice Sort Code
PR37 PR37043 VATCodFixPri VSTRING 2 2 0 VAT Code (Initial Invoice)
PR37 PR37044 DocCode44 VSTRING 1 1 0 Document Layout
PR37 PR37045 DefPurchaseOrdCount VSTRING 10 10 0 Default Purchase Order Count
PR37 PR37046 TpWIPCostAcTime VSTRING 1 1 0 Type of WIP/Cost Accounting (Time) Accounting method used for cost of time activities:
0 - No WIP/Cost accounting
1 - Direct Cost accounting (transactions entered are booked directly as cost)
2 - WIP accounting
3 - WIP accounting with reversal
4 - Percentage of completion (POC)
5 - WIP with reversal and variance transactions
PR37 PR37047 Spare VSTRING 6 6 0 Spare
PR37 PR37048 Spare VSTRING 6 6 0 Spare
PR37 PR37049 Spare VSTRING 6 6 0 Spare
PR37 PR37050 DefaultProjectStatus VSTRING 1 1 0 Default Project Status Only for records where PR37003 = 'A'
PR37 PR37051 DefOrCouOR VSTRING 1 1 0 Default Sales Order Counter
PR37 PR37052 TpWIPCostAc VSTRING 1 1 0 Type of WIP/Cost Accounting (Cost) Accounting method used for cost of cost activities:
0 - No WIP/Cost accounting
1 - Direct Cost accounting (transactions entered are booked directly as cost)
2 - WIP accounting
3 - WIP accounting with reversal
4 - Percentage of completion (POC)
5 - WIP with reversal and variance transactions
PR37 PR37053 TpWIPCostAcMtrl VSTRING 1 1 0 Type of WIP/Cost Accounting (Material) Accounting method used for cost of material activities:
0 - No WIP/Cost accounting
1 - Direct Cost accounting (transactions entered are booked directly as cost)
2 - WIP accounting
3 - WIP accounting with reversal
4 - Percentage of completion (POC)
5 - WIP with reversal and variance transactions
PR37 PR37054 AccCodeString ACCSTR 120 120 0 Accounting String
PR37 PR37055 DefLinkSalesOrderCounter STRING 1 1 0 Default Linked Sales Order Counter
PR37 PR37056 DefLinkPurchOrderCounter STRING 1 1 0 Default Linked Purchase Order Counter
PR37 PR37057 DefLinkServiceOrderCounter VSTRING 6 6 0 Default Linked Service Order Type
PR37 PR37058 DefLinkServiceContractCounter VSTRING 3 3 0 Default Linked Service Contract Type
PR37 PR37059 DefLinkWorkOrderCounter STRING 1 1 0 Default Linked Work Order Counter
PR37 PR37060 ApplyAccRules INTEGER 1 0 0 Apply Accounting Rules 0 - Accounting Dimensions values taken from the template will be kept unchanged during the creation of a project.
1 - Accounting Dimensions values taken from the template may be overwritten by the system.
PR37 PR37061 DefaultTaxPoint INTEGER 1 0 0 Default Tax Point
PR37 PR37062 InvoiceIssuer STRING 6 6 0 Invoice Issuer Code
PR37 PR37063 InvoiceCategory SWITCH 1 1 0 Invoice Category
PR37 PR37064 InvoiceType SWITCH 1 1 0 Invoice Type
PR37 PR37065 Operation Type (Time activities level default) VSTRING 10 10 0 Operation Type (Time activities level default)
PR37 PR37066 Financial Operation Code (Time activities level default) VSTRING 10 10 0 Financial Operation Code (Time activities level default)
PR37 PR37067 Operation Type (Cost activities level default) VSTRING 10 10 0 Operation Type (Cost activities level default)
PR37 PR37068 Financial Operation Code (Cost activities level default) VSTRING 10 10 0 Financial Operation Code (Cost activities level default)
PR37 PR37069 Operation Type (Material activities level default) VSTRING 10 10 0 Operation Type (Material activities level default)
PR37 PR37070 Financial Operation Code (Material activities level default) VSTRING 10 10 0 Financial Operation Code (Material activities level default)
PR37 PR37071 RecognitionModel STRING 3 3 0 Recognition model
PR37 PR37072 CostReallocation STRING 1 1 0 Cost Reallocation
PR37 PR37073 ClosingRule STRING 1 1 0 Closing Rule
PR37 PR37074 WarrantySubProject VSTRING 6 6 0 Warranty SubProject
PR37 PR37075 WarrantyActivityLine VSTRING 6 6 0 Warranty Activity Line
PR37 PR37076 Operation Type (Linked activities level default) VSTRING 10 10 0 Operation Type (Linked activities level default)
PR37 PR37077 Financial Operation Code (Linked activities level default) VSTRING 10 10 0 Financial Operation Code (Linked activities level default)