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 | Type (Type) | Option | [Person,Machine] | |
| 3 | Name (Name) | Text50 | ||
| 4 | Search Name (Search Name) | Code50 | ||
| 5 | Name 2 (Name 2) | Text50 | ||
| 6 | Address (Address) | Text50 | ||
| 7 | Address 2 (Address 2) | Text50 | ||
| 8 | City (City) | Text30 |
|
|
| 9 | Social Security No. (Social Security No.) | Text30 | ||
| 10 | Job Title (Job Title) | Text30 | ||
| 11 | Education (Education) | Text30 | ||
| 12 | Contract Class (Contract Class) | Text30 | ||
| 13 | Employment Date (Employment Date) | Date | ||
| 14 | Resource Group No. (Resource Group No.) | Code20 |
|
|
| 16 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
| 17 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 18 | Base Unit of Measure (Base Unit of Measure) | Code10 |
|
|
| 19 | Direct Unit Cost (Direct Unit Cost) | Decimal | AutoFormatType: 2 | |
| 20 | Indirect Cost % (Indirect Cost %) | Decimal (2:2) | ||
| 21 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 | |
| 22 | Profit % (Profit %) | Decimal (0:5) | ||
| 23 | Price/Profit Calculation (Price/Profit Calculation) | Option | [Profit=Price-Cost,Price=Cost+Profit,No Relationship] | |
| 24 | Unit Price (Unit Price) | Decimal | AutoFormatType: 2 | |
| 25 | Vendor No. (Vendor No.) | Code20 |
|
|
| 26 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
| 27 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 38 | Blocked (Blocked) | Boolean | ||
| 39 | Date Filter (Date Filter) | Date | FlowFilter | |
| 40 | Unit of Measure Filter (Unit of Measure Filter) | Code10 |
|
FlowFilter |
| 41 | Capacity (Capacity) | Decimal (0:5) |
|
FlowField |
| 42 | Qty. on Order (Job) (Qty. on Order (Job)) | Decimal (0:5) |
|
Editable: No FlowField |
| 43 | Qty. Quoted (Job) (Qty. Quoted (Job)) | Decimal (0:5) |
|
Editable: No FlowField |
| 44 | Usage (Qty.) (Usage (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 45 | Usage (Cost) (Usage (Cost)) | Decimal | AutoFormatType: 2
|
Editable: No FlowField |
| 46 | Usage (Price) (Usage (Price)) | Decimal | AutoFormatType: 2
|
Editable: No FlowField |
| 47 | Sales (Qty.) (Sales (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 48 | Sales (Cost) (Sales (Cost)) | Decimal | AutoFormatType: 2
|
Editable: No FlowField |
| 49 | Sales (Price) (Sales (Price)) | Decimal | AutoFormatType: 2
|
Editable: No FlowField |
| 50 | Chargeable Filter (Chargeable Filter) | Boolean | FlowFilter | |
| 51 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
| 52 | Picture (Picture) | BLOB [Bitmap] | ||
| 53 | Post Code (Post Code) | Code20 |
|
|
| 54 | County (County) | Text30 | ||
| 55 | Automatic Ext. Texts (Automatic Ext. Texts) | Boolean | ||
| 56 | No. Series (No. Series) | Code20 |
|
Editable: No |
| 57 | Tax Group Code (Tax Group Code) | Code20 |
|
|
| 58 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code20 |
|
|
| 59 | Country/Region Code (Country/Region Code) | Code10 |
|
|
| 60 | IC Partner Purch. G/L Acc. No. (IC Partner Purch. G/L Acc. No.) | Code20 |
|
|
| 140 | Image (Image) | Media | ||
| 900 | Qty. on Assembly Order (Qty. on Assembly Order) | Decimal (0:5) |
|
Editable: No FlowField |
| 950 | Use Time Sheet (Use Time Sheet) | Boolean | ||
| 951 | Time Sheet Owner User ID (Time Sheet Owner User ID) | Code50 |
|
|
| 952 | Time Sheet Approver User ID (Time Sheet Approver User ID) | Code50 |
|
|
| 1700 | Default Deferral Template Code (Default Deferral Template Code) | Code10 |
|
|
| 5900 | Qty. on Service Order (Qty. on Service Order) | Decimal (0:5) |
|
Editable: No FlowField |
| 5901 | Service Zone Filter (Service Zone Filter) | Code10 |
|
|
| 5902 | In Customer Zone (In Customer Zone) | Boolean |
|
Editable: No FlowField |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | No. (No.) | Clustered: Yes | |
| 1 | Search Name (Search Name) | ||
| 2 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | ||
| 3 | Name (Name) | ||
| 4 | Type (Type) | ||
| 5 | Base Unit of Measure (Base Unit of Measure) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
| Default Deferral Template Code (Default Deferral Template Code) | Deferral Template | Deferral Code (Deferral Code) |
|
1..n |
| Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
| IC Partner Purch. G/L Acc. No. (IC Partner Purch. G/L Acc. No.) | IC G/L Account | No. (No.) |
|
1..n |
| No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
| Resource Group No. (Resource Group No.) | Resource Group | No. (No.) |
|
1..n |
| Service Zone Filter (Service Zone Filter) | Service Zone | Code (Code) |
|
1..n |
| Tax Group Code (Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
| Unit of Measure Filter (Unit of Measure Filter) | Unit of Measure | Code (Code) |
|
1..n |
| Time Sheet Approver User ID (Time Sheet Approver User ID) | User Setup | User ID (User ID) |
|
1..n |
| VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
| Vendor No. (Vendor No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Assembly Line | No. (No.) |
|
1..n |
| BOM Buffer | No. (No.) |
|
1..n |
| BOM Component | No. (No.) |
|
1..n |
| Capacity Ledger Entry | No. (No.) |
|
1..n |
| Comment Line | No. (No.) |
|
1..n |
| Default Dimension | No. (No.) |
|
1..n |
| Employee | Resource No. (Resource No.) |
|
1..n |
| Extended Text Header | No. (No.) |
|
1..n |
| Extended Text Line | No. (No.) |
|
1..n |
| Item Journal Line | No. (No.) |
|
1..n |
| Job | Resource Filter (Resource Filter) |
|
1..n |
| Job Journal Line | No. (No.) |
|
1..n |
| Job Ledger Entry | No. (No.) |
|
1..n |
| Job Planning Line | No. (No.) |
|
1..n |
| Job Planning Line - Calendar | Resource No. (Resource No.) |
|
1..n |
| Job Resource Price | Code (Code) |
|
1..n |
| Posted Assembly Line | No. (No.) |
|
1..n |
| Purchase Line Archive | No. (No.) |
|
1..n |
| Res. Capacity Entry | Resource No. (Resource No.) |
|
1..n |
| Res. Journal Line | Resource No. (Resource No.) |
|
1..n |
| Res. Ledger Entry | Resource No. (Resource No.) |
|
1..n |
| Resource Cost | Code (Code) |
|
1..n |
| Resource Location | Resource No. (Resource No.) |
|
1..n |
| Resource Price | Code (Code) |
|
1..n |
| Resource Price Change | Code (Code) |
|
1..n |
| Resource Service Zone | Resource No. (Resource No.) |
|
1..n |
| Resource Skill | No. (No.) |
|
1..n |
| Resource Unit of Measure | Resource No. (Resource No.) |
|
1..n |
| Return Receipt Line | No. (No.) |
|
1..n |
| Sales & Receivables Setup | Write-in Product No. (Write-in Product No.) |
|
1..n |
| Sales Cr.Memo Line | No. (No.) |
|
1..n |
| Sales Invoice Line | No. (No.) |
|
1..n |
| Sales Line Archive | No. (No.) |
|
1..n |
| Sales Shipment Buffer | No. (No.) |
|
1..n |
| Sales Shipment Line | No. (No.) |
|
1..n |
| Serv. Price Adjustment Detail | No. (No.) |
|
1..n |
| Service Cr.Memo Header | Resource Filter (Resource Filter) |
|
1..n |
| Service Cr.Memo Line | No. (No.) |
|
1..n |
| Service Header | Resource Filter (Resource Filter) |
|
1..n |
| Service Invoice Header | Resource Filter (Resource Filter) |
|
1..n |
| Service Invoice Line | No. (No.) |
|
1..n |
| Service Item | Preferred Resource (Preferred Resource) |
|
1..n |
| Service Item Line | Resource Filter (Resource Filter) |
|
1..n |
| Service Ledger Entry | No. (No.) |
|
1..n |
| Service Line | No. (No.) |
|
1..n |
| Service Line Price Adjmt. | No. (No.) |
|
1..n |
| Service Order Allocation | Resource No. (Resource No.) |
|
1..n |
| Service Shipment Buffer | No. (No.) |
|
1..n |
| Service Shipment Header | Resource Filter (Resource Filter) |
|
1..n |
| Service Shipment Item Line | Resource Filter (Resource Filter) |
|
1..n |
| Service Shipment Line | No. (No.) |
|
1..n |
| Standard Cost Worksheet | No. (No.) |
|
1..n |
| Standard Purchase Line | No. (No.) |
|
1..n |
| Standard Sales Line | No. (No.) |
|
1..n |
| Standard Service Line | No. (No.) |
|
1..n |
| Time Sheet Detail | Resource No. (Resource No.) |
|
1..n |
| Time Sheet Detail Archive | Resource No. (Resource No.) |
|
1..n |
| Time Sheet Header | Resource No. (Resource No.) |
|
1..n |
| Time Sheet Header Archive | Resource No. (Resource No.) |
|
1..n |
| Value Entry | No. (No.) |
|
1..n |
| Warranty Ledger Entry | No. (No.) |
|
1..n |