A reference of how field values in Spectrum subcontracts match up with fields in Trimble Pay as part of the import process.
| Spectrum Field Name | Trimble Pay Field Name |
|---|---|
| Total_Billed | amount_approved_off_system |
| not present | approved_application_count Note: Trimble Pay uses the number of posted invoices in Spectrum. |
| Subcontractor_Number | subcontract_number |
| Retention_Percent | default_retainage_percentage_of_completed_work |
| Retention_Percent | default_retainage_percentage_of_completed_stored |
| Contract_Type | description |
| Original_Amount (Subcontracts screen in Accounts Payable) | original_subcontract_value |
| Unit_Price_Flag (Subcontracts screen in Accounts Payable) | is_unit_based Note: All subcontracts are created as Lump Sum in Trimble Pay regardless of the setting in Spectrum. |
| AP Subcontract Status Change Event in Spectrum | Result in Trimble Pay |
|---|---|
Any state  Inactive
| Nothing occurs. |
| Any state Complete | |
| Not Set Active | Subcontract is automatically imported into Trimble Pay. |
| Inactive Active | Subcontract is automatically imported if it doesn't already exist in Trimble Pay. |
| Complete Active |