Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | No. (No.) | Code20 | ||
| 2 | Search Description (Search Description) | Code50 | ||
| 3 | Description (Description) | Text50 | ||
| 4 | Description 2 (Description 2) | Text50 | ||
| 5 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
|
| 12 | Creation Date (Creation Date) | Date | Editable: No | |
| 13 | Starting Date (Starting Date) | Date | ||
| 14 | Ending Date (Ending Date) | Date | ||
| 19 | Status (Status) | Option | [Planning,Quote,Open,Completed] InitValue: Open |
|
| 20 | Person Responsible (Person Responsible) | Code20 |
|
|
| 21 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
| 22 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 23 | Job Posting Group (Job Posting Group) | Code10 |
|
|
| 24 | Blocked (Blocked) | Option | [ ,Posting,All] | |
| 29 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
| 30 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 31 | Customer Disc. Group (Customer Disc. Group) | Code20 |
|
|
| 32 | Customer Price Group (Customer Price Group) | Code10 |
|
|
| 41 | Language Code (Language Code) | Code10 |
|
|
| 49 | Scheduled Res. Qty. (Scheduled Res. Qty.) | Decimal (0:5) |
|
Editable: No FlowField |
| 50 | Resource Filter (Resource Filter) | Code20 |
|
FlowFilter |
| 51 | Posting Date Filter (Posting Date Filter) | Date | FlowFilter | |
| 55 | Resource Gr. Filter (Resource Gr. Filter) | Code20 |
|
FlowFilter |
| 56 | Scheduled Res. Gr. Qty. (Scheduled Res. Gr. Qty.) | Decimal (0:5) |
|
Editable: No FlowField |
| 57 | Picture (Picture) | BLOB [Bitmap] | ||
| 58 | Bill-to Name (Bill-to Name) | Text50 | ||
| 59 | Bill-to Address (Bill-to Address) | Text50 | ||
| 60 | Bill-to Address 2 (Bill-to Address 2) | Text50 | ||
| 61 | Bill-to City (Bill-to City) | Text30 |
|
|
| 63 | Bill-to County (Bill-to County) | Text30 | ||
| 64 | Bill-to Post Code (Bill-to Post Code) | Code20 |
|
|
| 66 | No. Series (No. Series) | Code10 |
|
Editable: No |
| 67 | Bill-to Country/Region Code (Bill-to Country/Region Code) | Code10 |
|
Editable: Yes |
| 68 | Bill-to Name 2 (Bill-to Name 2) | Text50 | ||
| 117 | Reserve (Reserve) | Option | [Never,Optional,Always] AccessByPermission: TableData 27=R |
|
| 140 | Image (Image) | Media | ||
| 1000 | WIP Method (WIP Method) | Code20 |
|
|
| 1001 | Currency Code (Currency Code) | Code10 |
|
|
| 1002 | Bill-to Contact No. (Bill-to Contact No.) | Code20 | AccessByPermission: TableData 5050=R | |
| 1003 | Bill-to Contact (Bill-to Contact) | Text50 | ||
| 1004 | Planning Date Filter (Planning Date Filter) | Date | FlowFilter | |
| 1005 | Total WIP Cost Amount (Total WIP Cost Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1006 | Total WIP Cost G/L Amount (Total WIP Cost G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1007 | WIP Entries Exist (WIP Entries Exist) | Boolean |
|
FlowField |
| 1008 | WIP Posting Date (WIP Posting Date) | Date | Editable: No | |
| 1009 | WIP G/L Posting Date (WIP G/L Posting Date) | Date |
|
Editable: No FlowField |
| 1011 | Invoice Currency Code (Invoice Currency Code) | Code10 |
|
|
| 1012 | Exch. Calculation (Cost) (Exch. Calculation (Cost)) | Option | [Fixed FCY,Fixed LCY] | |
| 1013 | Exch. Calculation (Price) (Exch. Calculation (Price)) | Option | [Fixed FCY,Fixed LCY] | |
| 1014 | Allow Schedule/Contract Lines (Allow Schedule/Contract Lines) | Boolean | ||
| 1015 | Complete (Complete) | Boolean | ||
| 1017 | Recog. Sales Amount (Recog. Sales Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1018 | Recog. Sales G/L Amount (Recog. Sales G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1019 | Recog. Costs Amount (Recog. Costs Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1020 | Recog. Costs G/L Amount (Recog. Costs G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1021 | Total WIP Sales Amount (Total WIP Sales Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1022 | Total WIP Sales G/L Amount (Total WIP Sales G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1023 | WIP Completion Calculated (WIP Completion Calculated) | Boolean |
|
FlowField |
| 1024 | Next Invoice Date (Next Invoice Date) | Date |
|
FlowField |
| 1025 | Apply Usage Link (Apply Usage Link) | Boolean | ||
| 1026 | WIP Warnings (WIP Warnings) | Boolean |
|
Editable: No FlowField |
| 1027 | WIP Posting Method (WIP Posting Method) | Option | [Per Job,Per Job Ledger Entry] | |
| 1028 | Applied Costs G/L Amount (Applied Costs G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1029 | Applied Sales G/L Amount (Applied Sales G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1030 | Calc. Recog. Sales Amount (Calc. Recog. Sales Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1031 | Calc. Recog. Costs Amount (Calc. Recog. Costs Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1032 | Calc. Recog. Sales G/L Amount (Calc. Recog. Sales G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1033 | Calc. Recog. Costs G/L Amount (Calc. Recog. Costs G/L Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 1034 | WIP Completion Posted (WIP Completion Posted) | Boolean |
|
FlowField |
| 1035 | Over Budget (Over Budget) | Boolean | ||
| 1036 | Project Manager (Project Manager) | Code50 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | No. (No.) | Clustered: Yes | |
| 1 | Search Description (Search Description) | ||
| 2 | Bill-to Customer No. (Bill-to Customer No.) | ||
| 3 | Description (Description) | ||
| 4 | Status (Status) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bill-to Country/Region Code (Bill-to Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
| Invoice Currency Code (Invoice Currency Code) | Currency | Code (Code) |
|
1..n |
| Bill-to Customer No. (Bill-to Customer No.) | Customer | No. (No.) |
|
1..n |
| Customer Disc. Group (Customer Disc. Group) | Customer Discount Group | Code (Code) |
|
1..n |
| Customer Price Group (Customer Price Group) | Customer Price Group | Code (Code) |
|
1..n |
| Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
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 |
| Language Code (Language Code) | Language | Code (Code) |
|
1..n |
| No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
| Resource Filter (Resource Filter) | Resource | No. (No.) |
|
1..n |
| Resource Gr. Filter (Resource Gr. Filter) | Resource Group | No. (No.) |
|
1..n |
| Project Manager (Project Manager) | User Setup | User ID (User ID) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Cash Flow Forecast Entry | Source No. (Source No.) |
|
1..n |
| Comment Line | No. (No.) |
|
1..n |
| Default Dimension | No. (No.) |
|
1..n |
| Deferral Post. Buffer | Job No. (Job No.) |
|
1..n |
| G/L Entry | Job No. (Job No.) |
|
1..n |
| Gen. Journal Line | Job No. (Job No.) |
|
1..n |
| Invoice Post. Buffer | Job No. (Job No.) |
|
1..n |
| Item Ledger Entry | Job No. (Job No.) |
|
1..n |
| Job G/L Account Price | Job No. (Job No.) |
|
1..n |
| Job Item Price | Job No. (Job No.) |
|
1..n |
| Job Journal Line | Job No. (Job No.) |
|
1..n |
| Job Ledger Entry | Job No. (Job No.) |
|
1..n |
| Job Planning Line | Job No. (Job No.) |
|
1..n |
| Job Planning Line Invoice | Job No. (Job No.) |
|
1..n |
| Job Posting Buffer | Job No. (Job No.) |
|
1..n |
| Job Resource Price | Job No. (Job No.) |
|
1..n |
| Job Task | Job No. (Job No.) |
|
1..n |
| Job Usage Link | Job No. (Job No.) |
|
1..n |
| Job WIP Buffer | Job No. (Job No.) |
|
1..n |
| Job WIP Entry | Job No. (Job No.) |
|
1..n |
| Job WIP G/L Entry | Job No. (Job No.) |
|
1..n |
| Job WIP Total | Job No. (Job No.) |
|
1..n |
| Job WIP Warning | Job No. (Job No.) |
|
1..n |
| My Job | Job No. (Job No.) |
|
1..n |
| Prepayment Inv. Line Buffer | Job No. (Job No.) |
|
1..n |
| Purch. Cr. Memo Line | Job No. (Job No.) |
|
1..n |
| Purch. Inv. Line | Job No. (Job No.) |
|
1..n |
| Purch. Rcpt. Line | Job No. (Job No.) |
|
1..n |
| Purchase Line | Job No. (Job No.) |
|
1..n |
| Purchase Line Archive | Job No. (Job No.) |
|
1..n |
| Res. Journal Line | Job No. (Job No.) |
|
1..n |
| Res. Ledger Entry | Job No. (Job No.) |
|
1..n |
| Return Receipt Line | Job No. (Job No.) |
|
1..n |
| Return Shipment Line | Job No. (Job No.) |
|
1..n |
| Sales Cr.Memo Line | Job No. (Job No.) |
|
1..n |
| Sales Invoice Line | Job No. (Job No.) |
|
1..n |
| Sales Line | Job No. (Job No.) |
|
1..n |
| Sales Line Archive | Job No. (Job No.) |
|
1..n |
| Sales Shipment Line | Job No. (Job No.) |
|
1..n |
| Service Ledger Entry | Job No. (Job No.) |
|
1..n |
| Service Line | Job No. (Job No.) |
|
1..n |
| Standard General Journal Line | Job No. (Job No.) |
|
1..n |
| Time Sheet Detail | Job No. (Job No.) |
|
1..n |
| Time Sheet Detail Archive | Job No. (Job No.) |
|
1..n |
| Time Sheet Line | Job No. (Job No.) |
|
1..n |
| Time Sheet Line Archive | Job No. (Job No.) |
|
1..n |
| Value Entry | Job No. (Job No.) |
|
1..n |