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 |