Import Matrix: Services
Technical Documentation
Available Fields
Active
Billing Item ID
Class ID
Department
Description
Hourly Cost
Hourly Rate 1
Hourly Rate 2
Hourly Rate 3
Hourly Rate 4
Hourly Rate 5
Rate Description 1
Rate Description 2
Rate Description 3
Rate Description 4
Rate Description 5
Sales Account Number
Service Code
Tax 1 Applies
Tax 2 Applies
Matrix
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
Hourly Rate 5 |
|
|
Numeric |
|
|
|
|
Billing Item ID |
|
|
|
Yes |
Billing Items |
Billing Item ID |
|
Class ID |
|
See Comments |
|
Yes |
GL Classes |
Class ID |
If Require Class GL Tracking Options is Yes then Class ID must be a valid Class |
Department |
|
See Comments |
|
Yes |
Departments |
Department ID |
If Require Department GL Tracking Options is Yes then Department must be a valid Class |
Description |
|
Yes |
|
|
|
|
|
Hourly Cost |
|
|
Numeric |
Yes |
GL Accounts |
Account Number |
|
Hourly Rate 1 |
|
|
Numeric |
|
|
|
|
Hourly Rate 2 |
|
|
Numeric |
|
|
|
|
Hourly Rate 3 |
|
|
Numeric |
|
|
|
|
Hourly Rate 4 |
|
|
Numeric |
|
|
|
|
Active |
|
|
Yes No |
|
|
|
|
Rate Description 1 |
|
|
|
|
|
|
|
Rate Description 2 |
|
|
|
|
|
|
|
Rate Description 3 |
|
|
|
|
|
|
|
Rate Description 4 |
|
|
|
|
|
|
|
Rate Description 5 |
|
|
|
|
|
|
|
Sales Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
Service Code |
Yes |
Yes |
|
|
|
|
|
Tax 1 Applies |
|
|
Yes No |
|
|
|
|
Tax 2 Applies |
|
|
Yes No |
|
|
|
|