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 PR33 PR33001 CustAccCode STRING 2 2 0 Accounting Code Customer
2 PR33 PR33002 ProjAccCode STRING 2 2 0 Accounting Code Project
3 PR33 PR33003 ActAccCode STRING 2 2 0 Accounting Code Activity
4 PR33 PR33004 ActivityType STRING 1 1 0 Activity Type 0 - Cost Activity
1 - Time Activity
2 - Material Activity (Sales Order or Purchase Order)
5 - Linked Sales Order
6 - Linked Purchase Order
7 - Linked Service Order
8 - Linked Contract
9 - Linked Work Order
5 PR33 PR33005 ResourceCode STRING 1 1 0 Resource Type 0 -. Internal human resource
1 - Resource group
2 - External resource
3 - Internal machine resource
PR33 PR33006 Account1 VSTRING 12 12 0 Account Sales Income VAT Exempt
PR33 PR33007 Account2 VSTRING 12 12 0 Account Sales Income VAT 1
PR33 PR33008 Account3 VSTRING 12 12 0 Account Sales Income VAT 2
PR33 PR33009 Account4 VSTRING 12 12 0 Account Sales Income VAT 3-99
PR33 PR33010 Account5 VSTRING 12 12 0 Account Sales Income Export
PR33 PR33011 Account6 VSTRING 12 12 0 Account Sales Income Export EC
PR33 PR33012 Account7 VSTRING 12 12 0 Account Sales Income Internal
PR33 PR33013 Account8 VSTRING 12 12 0 Account WIP - Account
PR33 PR33014 Account9 VSTRING 12 12 0 Account Cost Contra Account
PR33 PR33015 Account10 VSTRING 12 12 0 Account Mark-up Contra Account
PR33 PR33016 Account11 VSTRING 12 12 0 Account Cost of Sales
PR33 PR33017 Account12 VSTRING 12 12 0 Account WIP - Contra Account
PR33 PR33018 Account13 VSTRING 12 12 0 Account WIP Mark-up Contra Account
PR33 PR33019 Account14 VSTRING 12 12 0 Account Income Overrun VAT Exempt/Internal Debiting On automatic accounting schedule on activity level it's used for: Internal Debiting
PR33 PR33020 Account15 VSTRING 12 12 0 Account Income Overrun VAT 1/Internal Debiting Contra On automatic accounting schedule on activity level it's used for: Internal Debiting Contra Account
PR33 PR33021 Account16 VSTRING 12 12 0 Account Income Overrun VAT 2/Internal Debiting Mark-up On automatic accounting schedule on activity level it's used for: Internal Debiting Mark-up
PR33 PR33022 Account17 VSTRING 12 12 0 Account Income Overrun VAT 3-99 On automatic accounting schedule on activity level it's used for: Cost quantity variance over run cost
PR33 PR33023 Account18 VSTRING 12 12 0 Account Income Overrun Export On automatic accounting schedule on activity level it's used for: Cost quantity variance under run cost
PR33 PR33024 Account19 VSTRING 12 12 0 Account Income Overrun Export EC On automatic accounting schedule on activity level it's used for: Cost price variance over run cost
PR33 PR33025 Account20 VSTRING 12 12 0 Account Income Overrun Internal On automatic accounting schedule on activity level it's used for: Cost price variance under run cost
PR33 PR33026 Account21 VSTRING 12 12 0 Account Customer Advances On automatic accounting schedule on activity level it's used for: Cost quantity and price variance over run cost
PR33 PR33027 Account22 VSTRING 12 12 0 Account Customer Retentions On automatic accounting schedule on activity level it's used for: Cost quantity and price variance under run cost
PR33 PR33028 Account23 VSTRING 12 12 0 Account Internal Debiting
PR33 PR33029 Account24 VSTRING 12 12 0 Account Internal Debiting Contra
PR33 PR33030 Account25 VSTRING 12 12 0 Account Internal Debiting Mark-up
PR33 PR33031 Account26 VSTRING 12 12 0 Account Billings VAT Exempt
PR33 PR33032 Account27 VSTRING 12 12 0 Account Billings VAT 1
PR33 PR33033 Account28 VSTRING 12 12 0 Account Billings VAT 2
PR33 PR33034 Account29 VSTRING 12 12 0 Account Billings VAT 3-99
PR33 PR33035 Account30 VSTRING 12 12 0 Account Billings Export
PR33 PR33036 Account31 VSTRING 12 12 0 Account Billings Export EC
PR33 PR33037 Account32 VSTRING 12 12 0 Account Billings Internal
PR33 PR33038 Account33 VSTRING 12 12 0 (obsolete)
PR33 PR33039 Account34 VSTRING 12 12 0 (obsolete)
PR33 PR33040 Account35 VSTRING 12 12 0 (obsolete)
PR33 PR33041 Account36 VSTRING 12 12 0 (obsolete)
PR33 PR33042 Account37 VSTRING 12 12 0 (obsolete)
PR33 PR33043 Account38 VSTRING 12 12 0 (obsolete)
PR33 PR33044 Account39 VSTRING 12 12 0 (obsolete)
PR33 PR33045 Account40 VSTRING 12 12 0 (obsolete)
6 PR33 PR33046 ScheduleType VSTRING 2 2 0 Schedule Type