Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Job No. (Job No.) | Code20 |
|
NotBlank: Yes Editable: No |
| 2 | Job Task No. (Job Task No.) | Code20 | NotBlank: Yes | |
| 3 | Description (Description) | Text50 | ||
| 4 | Job Task Type (Job Task Type) | Option | [Posting,Heading,Total,Begin-Total,End-Total] | |
| 6 | WIP-Total (WIP-Total) | Option | [ ,Total,Excluded] | |
| 7 | Job Posting Group (Job Posting Group) | Code10 |
|
|
| 9 | WIP Method (WIP Method) | Code20 |
|
|
| 10 | Schedule (Total Cost) (Schedule (Total Cost)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 11 | Schedule (Total Price) (Schedule (Total Price)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 12 | Usage (Total Cost) (Usage (Total Cost)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 13 | Usage (Total Price) (Usage (Total Price)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 14 | Contract (Total Cost) (Contract (Total Cost)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 15 | Contract (Total Price) (Contract (Total Price)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 16 | Contract (Invoiced Price) (Contract (Invoiced Price)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 17 | Contract (Invoiced Cost) (Contract (Invoiced Cost)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 19 | Posting Date Filter (Posting Date Filter) | Date | FlowFilter | |
| 20 | Planning Date Filter (Planning Date Filter) | Date | FlowFilter | |
| 21 | Totaling (Totaling) | Text250 |
|
|
| 22 | New Page (New Page) | Boolean | ||
| 23 | No. of Blank Lines (No. of Blank Lines) | Integer | BlankZero: Yes | |
| 24 | Indentation (Indentation) | Integer | ||
| 34 | Recognized Sales Amount (Recognized Sales Amount) | Decimal | BlankZero: Yes Editable: No |
|
| 37 | Recognized Costs Amount (Recognized Costs Amount) | Decimal | BlankZero: Yes Editable: No |
|
| 56 | Recognized Sales G/L Amount (Recognized Sales G/L Amount) | Decimal | BlankZero: Yes Editable: No |
|
| 57 | Recognized Costs G/L Amount (Recognized Costs G/L Amount) | Decimal | BlankZero: Yes Editable: No |
|
| 60 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
| 61 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 62 | Outstanding Orders (Outstanding Orders) | Decimal | AccessByPermission: TableData 120=R
|
FlowField |
| 63 | Amt. Rcd. Not Invoiced (Amt. Rcd. Not Invoiced) | Decimal | AccessByPermission: TableData 120=R
|
FlowField |
| 64 | Remaining (Total Cost) (Remaining (Total Cost)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 65 | Remaining (Total Price) (Remaining (Total Price)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 66 | Start Date (Start Date) | Date |
|
Editable: No FlowField |
| 67 | End Date (End Date) | Date |
|
Editable: No FlowField |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Job No.,Job Task No. (Job No.,Job Task No.) | SumIndexFields: Recognized Sales Amount,Recognized Costs Amount,Recognized Sales G/L Amount,Recognized Costs G/L Amount | Clustered: Yes |
| 1 | Job Task No. (Job Task No.) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Job No. (Job No.) | Job | No. (No.) |
|
1..n |
| Job Posting Group (Job Posting Group) | Job Posting Group | Code (Code) |
|
1..n |
| WIP Method (WIP Method) | Job WIP Method | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Gen. Journal Line | Job Task No. (Job Task No.) |
|
1..n |
| Item Ledger Entry | Job Task No. (Job Task No.) |
|
1..n |
| Job G/L Account Price | Job Task No. (Job Task No.) |
|
1..n |
| Job Item Price | Job Task No. (Job Task No.) |
|
1..n |
| Job Journal Line | Job Task No. (Job Task No.) |
|
1..n |
| Job Ledger Entry | Job Task No. (Job Task No.) |
|
1..n |
| Job Planning Line | Job Task No. (Job Task No.) |
|
1..n |
| Job Planning Line Invoice | Job Task No. (Job Task No.) |
|
1..n |
| Job Resource Price | Job Task No. (Job Task No.) |
|
1..n |
| Job Task Dimension | Job Task No. (Job Task No.) |
|
1..n |
| Job Usage Link | Job Task No. (Job Task No.) |
|
1..n |
| Job WIP Warning | Job Task No. (Job Task No.) |
|
1..n |
| Prepayment Inv. Line Buffer | Job Task No. (Job Task No.) |
|
1..n |
| Purch. Cr. Memo Line | Job Task No. (Job Task No.) |
|
1..n |
| Purch. Inv. Line | Job Task No. (Job Task No.) |
|
1..n |
| Purch. Rcpt. Line | Job Task No. (Job Task No.) |
|
1..n |
| Purchase Line | Job Task No. (Job Task No.) |
|
1..n |
| Return Shipment Line | Job Task No. (Job Task No.) |
|
1..n |
| Sales Cr.Memo Line | Job Task No. (Job Task No.) |
|
1..n |
| Sales Invoice Line | Job Task No. (Job Task No.) |
|
1..n |
| Sales Line | Job Task No. (Job Task No.) |
|
1..n |
| Sales Shipment Line | Job Task No. (Job Task No.) |
|
1..n |
| Service Ledger Entry | Job Task No. (Job Task No.) |
|
1..n |
| Service Line | Job Task No. (Job Task No.) |
|
1..n |
| Time Sheet Detail | Job Task No. (Job Task No.) |
|
1..n |
| Time Sheet Detail Archive | Job Task No. (Job Task No.) |
|
1..n |
| Time Sheet Line | Job Task No. (Job Task No.) |
|
1..n |
| Time Sheet Line Archive | Job Task No. (Job Task No.) |
|
1..n |
| Value Entry | Job Task No. (Job Task No.) |
|
1..n |