A reference of how field values in Spectrum jobs match up with fields in Trimble Pay as part of the import process.
| Spectrum Field Name | Trimble Pay Field Name |
|---|---|
| not present | time_zone Note: Default value is Eastern time (ET). |
| Job_Description | name |
| Job_Number | project_number |
| Job_Type | project_type |
| Customer_Code | owner_name |
| Status_Code Note: Refer to the table below. | is_archived |
| Address_1 | address_line1 |
| Address_2 | address_line2 |
| Jobs_City | city |
| not present | county Note: After importing the job, update this value in Trimble Pay in the project settings. |
| Job_State Important:
Populate the State field in the job before importing it. Don't attempt to import the job if this value is null. | state |
| Zip_Code | zip_code |
| Status Change Event in Spectrum | Result in Trimble Pay |
|---|---|
Not Set  Inactive | Inactive jobs do not appear in the Trimble Pay import screen. |
| Not Set Active | Job will be available for import on Trimble Pay "Start import" screen. |
| Inactive Active | |
| Inactive Complete | If project is already imported, marked as archived. |
| Active Inactive | If project is already imported and "treat inactive jobs as active" is set to true, the project will not be marked as archived. Otherwise, Trimble Pay will archive the project. |
| Active Complete | If project is already imported, marked as archived. |
| Complete Inactive | If project is already imported, and "treat inactive jobs as open" is set to true, project is un-archived. |
| Complete Active | If project is already imported, project is un-archived. |