MoneyWorks Manual
Edit
Job Sheet Items
Internal name JobSheet.
| Field | Type | Size | Notes |
|---|---|---|---|
| Account | T | 7 | The general ledger expense code for the resource |
| ActivityCode | T | 9 | A free-form activity code |
| Analysis | T | 9 | The analysis field |
| Batch | N | For jobsheets entered using a Timesheet, the sequencenumber of the first jobsheet created when the Timesheet is accepted. This forms a unique batch number to identify all jobsheets entered on that time-share. | |
| Colour | N | The colour, represented internally as a numeric index in the range 0-7 but rendered as a textual colour name | |
| Comments | T | 255 | General comments on the entry |
| CostCentre | T | 5 | The cost centre for which the resource was used |
| CostPrice | N | The cost price of the resource used. | |
| Date | D | The date the resource was used | |
| DateEntered | D | The date the job sheet item was entered. | |
| DestTransSeq | N | The sequence number of the invoice on which this item was billed out. | |
| EnteredBy | T | 3 | User who entered the job sheet record |
| Flags | N | Accessible via the Testflags function. 1 = Time, 2 = Material | |
| Job | T | 9 | The job code. |
| LastModifiedTime | S | The date that this job sheet item record was last changed. | |
| Memo | T | 255 | A description of the job sheet item. |
| Period | N | A number representing the period of the job sheet item. This is determined automatically by the Date field, and is stored in the same manner as the period field in the transaction file. | |
| Qty | N | The quantity of the resource used | |
| Resource | T | 19 | The code of the resource |
| SellPrice | N | The estimated sell value of the resource used, based on the job markup. | |
| SerialNumber | T | 31 | Serial/Batch number of the item |
| SourceTransSeq | N | The sequence number of the originating transaction | |
| Status | A | 2 | The status field. "PE" if the item is pending (unbilled), "PR" if it is processed, "BU" if it is a budget entry. |
| StockLocation | T | 15 | The location of the item |
| TaggedText | T | 255 | Scriptable tag storage |
| TimeProcessed | S | 15 | Timestamp for when the job sheet was processed |
| Type | A | 2 | The type of entry. "IN" for income, "EX" for expense. |
| Units | T | 3 | The units of resource used. |
| UserNum | N | Scriptable number | |
| UserText | T | 255 | Scriptable text |