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
HR15 HR15001 CourseCode STRING 35 35 0 Course Code
1 HR15 HR15002 CourseID STRING 38 38 0 Course Schedule Identifier
HR15 HR15003 StartDate DATE 8 0 0 Start Date
HR15 HR15004 Teacher STRING 10 10 0 Resource Code Teacher
HR15 HR15005 Status INTEGER 1 0 0 Status 0 - Planned
1 - Started
2 - Completed
3 - Closed
HR15 HR15006 OrderNo STRING 10 10 0 Service Order Number
HR15 HR15007 OrderCustomer STRING 10 10 0 Customer Code Order
HR15 HR15008 InvoiceCustomer STRING 10 10 0 Customer Code Invoice
HR15 HR15009 PriceList STRING 2 2 0 Price List
HR15 HR15010 SiteCode STRING 4 4 0 Site Code
HR15 HR15011 EndDate DATE 8 0 0 End Date