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
HR01 Resource Master Table Company HR010100
HR02 Resource Templates Company HR020100
HR03 Resource Transactions Company HR030100
HR04 Time Planning Company HR040100
HR05 Payroll Transactions Company HR050100
HR06 Work Schedule (not used) Company HR060100
HR10 HR Courses Company HR100100
HR11 Course Multilingual Description Company HR110100
HR15 Course Plan Company HR150100
HR16 Course Details Company HR160100
HR17 Course Skills Company HR170100
HR18 Acquired Skills Company HR180100
HR19 Course Status Mapping Company HR190100
HR46 Course Details History Company HR460100
HRF1 Exposed Engineer Company HRF10100
HRX1 Time Planning 1 HRX10000
HRX2 Time Planning 2 HRX20000
HRX3 Time Planning 3 HRX30000
sca_trg_Audit_HR01 Audit trigger for HR01 table Company sca_trg_Audit_HR010100

Fields
PK Table Name Description Type Length Precision Note
1 HR03 HR03001 ResourceCode VSTRING 10 10 0 Resource Code
2 HR03 HR03002 TransactDate DATE 8 0 0 Transaction Date
3 HR03 HR03003 TransactType VSTRING 1 1 0 Transaction Source 0 - Project Management
1 - Service Order
4 HR03 HR03004 TransObject VSTRING 12 12 0 Transaction Object
5 HR03 HR03005 TransSubObj VSTRING 6 6 0 Transaction Sub-Project
6 HR03 HR03006 ActivityType VSTRING 1 1 0 Activity Type For project transactions:
0 - Cost activity
1 - Time activity
For service transactions:
0 - Time activity
7 HR03 HR03007 ActivityCode VSTRING 6 6 0 Activity Code
8 HR03 HR03008 TransLineNo VSTRING 3 3 0 Transaction Line Number
HR03 HR03009 HrsQuantity X_NUMERIC 12 20 8 Quantity/Hours
HR03 HR03010 HrsQtyToInvoice X_NUMERIC 12 20 8 Quantity/Hours to Invoice
HR03 HR03011 Price MONEY 20 28 8 Unit Price
HR03 HR03012 Cost MONEY 20 28 8 Unit Cost
HR03 HR03013 InvAmount MONEY 20 28 8 Unit Price to Invoice
HR03 HR03014 AccCode VSTRING 2 2 0 Accounting Code
HR03 HR03015 AccString ACCSTR 120 120 0 Accounting String
HR03 HR03016 ProjObjType VSTRING 6 6 0 Project Type
HR03 HR03017 WeekNo VSTRING 6 6 0 Week Number
HR03 HR03018 DateType VSTRING 1 1 0 Date Type Time reported as per:
0 - Date
1 - Week
2 - Month
HR03 HR03019 ActivityLine VSTRING 12 12 0 Activity Line
HR03 HR03020 PrjTransLine VSTRING 6 6 0 Project Transaction Line Number
HR03 HR03021 InvHrsQty X_NUMERIC 12 20 8 Quantity/Hours Invoiced
HR03 HR03022 Invoiced VSTRING 1 1 0 Transaction Has Been Invoiced
HR03 HR03023 Remark VSTRING 35 35 0 Text
HR03 HR03024 CostCategory VSTRING 1 1 0 Cost Category