MoneyWorks Manual
Edit
Jobs
Internal Name Job.
| Field | Type | Size | Notes |
|---|---|---|---|
| Billed | N | The amount billed to date for the job. | |
| Category1 | T | 15 | Any value. This can be used for analysis purposes. |
| Category2 | T | 15 | Any value. This can be used for analysis purposes. |
| Category3 | T | 15 | Any value. This can be used for analysis purposes. |
| Category4 | T | 15 | Any value. This can be used for analysis purposes. |
| Client | T | 11 | The code of the client for whom the job is being done. Must be a debtor. |
| Code | T | 9 | The job code. |
| Colour | N | The colour, represented internally as a numeric index in the range 0-7 but rendered as a textual colour name | |
| Comment | T | 1020 | Comments on the job |
| Contact | T | 63 | The contact for the job |
| Custom1 | T | 255 | For your own use |
| Custom2 | T | 255 | For your own use |
| Custom3 | T | 15 | For your own use |
| Custom4 | T | 15 | For your own use |
| Custom5 | T | 15 | For your own use |
| Custom6 | T | 15 | For your own use |
| Custom7 | T | 15 | For your own use |
| Custom8 | T | 15 | For your own use |
| Description | T | 255 | The job name. |
| EndDate | D | The expected end date | |
| LastModifiedTime | S | The date that this job record was last changed. Transactions related to the job do not change the modification date of the job record | |
| Manager | T | 3 | The manager for the job |
| Markup | N | The percent markup applied to items used on the job. | |
| OrderNum | T | 31 | The client's order number for the job |
| PercentComplete | N | Percent that the job is complete | |
| Phone | T | 19 | The contact's phone number |
| Project | T | 9 | Job code of project to which this belongs |
| Quote | N | The amount quoted for the job. | |
| StartDate | D | The start date of the job | |
| Status | A | 2 | The status of the job. "QU" for quoted, "OP" for active, "CO" for complete |
| TaggedText | T | 255 | Scriptable tag storage |
| TargetDate | D | Target date for job | |
| UserNum | N | User defined | |
| UserText | T | 255 | User defined |