Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Document Type (Document Type) | Option | [Quote,Order,Invoice,Credit Memo] | |
| 2 | Customer No. (Customer No.) | Code20 |
|
|
| 3 | No. (No.) | Code20 | ||
| 4 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
NotBlank: Yes |
| 5 | Bill-to Name (Bill-to Name) | Text50 | ||
| 6 | Bill-to Name 2 (Bill-to Name 2) | Text50 | ||
| 7 | Bill-to Address (Bill-to Address) | Text50 | ||
| 8 | Bill-to Address 2 (Bill-to Address 2) | Text50 | ||
| 9 | Bill-to City (Bill-to City) | Text30 |
|
|
| 10 | Bill-to Contact (Bill-to Contact) | Text50 | ||
| 11 | Your Reference (Your Reference) | Text35 | ||
| 12 | Ship-to Code (Ship-to Code) | Code10 |
|
|
| 13 | Ship-to Name (Ship-to Name) | Text50 | ||
| 14 | Ship-to Name 2 (Ship-to Name 2) | Text50 | ||
| 15 | Ship-to Address (Ship-to Address) | Text50 | ||
| 16 | Ship-to Address 2 (Ship-to Address 2) | Text50 | ||
| 17 | Ship-to City (Ship-to City) | Text30 |
|
|
| 18 | Ship-to Contact (Ship-to Contact) | Text50 | ||
| 19 | Order Date (Order Date) | Date | NotBlank: Yes | |
| 20 | Posting Date (Posting Date) | Date | ||
| 22 | Posting Description (Posting Description) | Text50 | ||
| 23 | Payment Terms Code (Payment Terms Code) | Code10 |
|
|
| 24 | Due Date (Due Date) | Date | ||
| 25 | Payment Discount % (Payment Discount %) | Decimal (0:5) | MaxValue: 100 | |
| 26 | Pmt. Discount Date (Pmt. Discount Date) | Date | ||
| 27 | Shipment Method Code (Shipment Method Code) | Code10 |
|
|
| 28 | Location Code (Location Code) | Code10 |
|
|
| 29 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 30 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 31 | Customer Posting Group (Customer Posting Group) | Code20 |
|
Editable: No |
| 32 | Currency Code (Currency Code) | Code10 |
|
|
| 33 | Currency Factor (Currency Factor) | Decimal (0:15) | Editable: No | |
| 34 | Customer Price Group (Customer Price Group) | Code10 |
|
|
| 35 | Prices Including VAT (Prices Including VAT) | Boolean | ||
| 37 | Invoice Disc. Code (Invoice Disc. Code) | Code20 | ||
| 40 | Customer Disc. Group (Customer Disc. Group) | Code20 |
|
|
| 41 | Language Code (Language Code) | Code10 |
|
|
| 43 | Salesperson Code (Salesperson Code) | Code20 |
|
|
| 46 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 47 | No. Printed (No. Printed) | Integer | Editable: No | |
| 52 | Applies-to Doc. Type (Applies-to Doc. Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
| 53 | Applies-to Doc. No. (Applies-to Doc. No.) | Code20 | ||
| 55 | Bal. Account No. (Bal. Account No.) | Code20 |
|
|
| 62 | Shipping No. (Shipping No.) | Code20 | ||
| 63 | Posting No. (Posting No.) | Code20 | ||
| 64 | Last Shipping No. (Last Shipping No.) | Code20 |
|
Editable: No |
| 65 | Last Posting No. (Last Posting No.) | Code20 |
|
Editable: No |
| 70 | VAT Registration No. (VAT Registration No.) | Text20 | ||
| 73 | Reason Code (Reason Code) | Code10 |
|
|
| 74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
| 75 | EU 3-Party Trade (EU 3-Party Trade) | Boolean | ||
| 76 | Transaction Type (Transaction Type) | Code10 |
|
|
| 77 | Transport Method (Transport Method) | Code10 |
|
|
| 78 | VAT Country/Region Code (VAT Country/Region Code) | Code10 |
|
|
| 79 | Name (Name) | Text50 | ||
| 80 | Name 2 (Name 2) | Text50 | ||
| 81 | Address (Address) | Text50 | ||
| 82 | Address 2 (Address 2) | Text50 | ||
| 83 | City (City) | Text30 |
|
|
| 84 | Contact Name (Contact Name) | Text50 | ||
| 85 | Bill-to Post Code (Bill-to Post Code) | Code20 |
|
|
| 86 | Bill-to County (Bill-to County) | Text30 | ||
| 87 | Bill-to Country/Region Code (Bill-to Country/Region Code) | Code10 |
|
|
| 88 | Post Code (Post Code) | Code20 |
|
|
| 89 | County (County) | Text30 | ||
| 90 | Country/Region Code (Country/Region Code) | Code10 |
|
|
| 91 | Ship-to Post Code (Ship-to Post Code) | Code20 |
|
|
| 92 | Ship-to County (Ship-to County) | Text30 | ||
| 93 | Ship-to Country/Region Code (Ship-to Country/Region Code) | Code10 |
|
|
| 94 | Bal. Account Type (Bal. Account Type) | Option | [G/L Account,Bank Account] | |
| 97 | Exit Point (Exit Point) | Code10 |
|
|
| 98 | Correction (Correction) | Boolean | ||
| 99 | Document Date (Document Date) | Date | ||
| 101 | Area (Area) | Code10 |
|
|
| 102 | Transaction Specification (Transaction Specification) | Code10 |
|
|
| 104 | Payment Method Code (Payment Method Code) | Code10 |
|
|
| 105 | Shipping Agent Code (Shipping Agent Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
| 107 | No. Series (No. Series) | Code20 |
|
Editable: No |
| 108 | Posting No. Series (Posting No. Series) | Code20 |
|
|
| 109 | Shipping No. Series (Shipping No. Series) | Code20 |
|
|
| 114 | Tax Area Code (Tax Area Code) | Code20 |
|
|
| 115 | Tax Liable (Tax Liable) | Boolean | ||
| 116 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code20 |
|
|
| 117 | Reserve (Reserve) | Option | [Never,Optional,Always] | |
| 118 | Applies-to ID (Applies-to ID) | Code50 | ||
| 119 | VAT Base Discount % (VAT Base Discount %) | Decimal (0:5) | MaxValue: 100 | |
| 120 | Status (Status) | Option | [Pending,In Process,Finished,On Hold] | |
| 121 | Invoice Discount Calculation (Invoice Discount Calculation) | Option | [None,%,Amount] | Editable: No |
| 122 | Invoice Discount Value (Invoice Discount Value) | Decimal | AutoFormatType: 1 | Editable: No |
| 130 | Release Status (Release Status) | Option | [Open,Released to Ship] | Editable: No |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 5052 | Contact No. (Contact No.) | Code20 |
|
|
| 5053 | Bill-to Contact No. (Bill-to Contact No.) | Code20 |
|
|
| 5700 | Responsibility Center (Responsibility Center) | Code10 |
|
|
| 5750 | Shipping Advice (Shipping Advice) | Option | [Partial,Complete] | |
| 5752 | Completely Shipped (Completely Shipped) | Boolean |
|
Editable: No FlowField |
| 5754 | Location Filter (Location Filter) | Code10 |
|
FlowFilter |
| 5792 | Shipping Time (Shipping Time) | DateFormula | AccessByPermission: TableData 5790=R | |
| 5794 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 |
|
|
| 5796 | Date Filter (Date Filter) | Date | FlowFilter | |
| 5902 | Description (Description) | Text50 | ||
| 5904 | Service Order Type (Service Order Type) | Code10 |
|
|
| 5905 | Link Service to Service Item (Link Service to Service Item) | Boolean | ||
| 5907 | Priority (Priority) | Option | [Low,Medium,High] | Editable: No |
| 5911 | Allocated Hours (Allocated Hours) | Decimal (0:5) |
|
Editable: No FlowField |
| 5915 | Phone No. (Phone No.) | Text30 [Phone No.] | ||
| 5916 | E-Mail (E-Mail) | Text80 [E-Mail] | ||
| 5917 | Phone No. 2 (Phone No. 2) | Text30 [Phone No.] | ||
| 5918 | Fax No. (Fax No.) | Text30 | ||
| 5921 | No. of Unallocated Items (No. of Unallocated Items) | Integer |
|
Editable: No FlowField |
| 5923 | Order Time (Order Time) | Time | NotBlank: Yes | |
| 5924 | Default Response Time (Hours) (Default Response Time (Hours)) | Decimal (0:5) | ||
| 5925 | Actual Response Time (Hours) (Actual Response Time (Hours)) | Decimal (0:5) | Editable: No | |
| 5926 | Service Time (Hours) (Service Time (Hours)) | Decimal (0:5) | Editable: No | |
| 5927 | Response Date (Response Date) | Date | Editable: No | |
| 5928 | Response Time (Response Time) | Time | Editable: No | |
| 5929 | Starting Date (Starting Date) | Date | ||
| 5930 | Starting Time (Starting Time) | Time | ||
| 5931 | Finishing Date (Finishing Date) | Date | ||
| 5932 | Finishing Time (Finishing Time) | Time | ||
| 5933 | Contract Serv. Hours Exist (Contract Serv. Hours Exist) | Boolean |
|
Editable: No FlowField |
| 5934 | Reallocation Needed (Reallocation Needed) | Boolean |
|
Editable: No FlowField |
| 5936 | Notify Customer (Notify Customer) | Option | [No,By Phone 1,By Phone 2,By Fax,By Email] | |
| 5937 | Max. Labor Unit Price (Max. Labor Unit Price) | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
| 5938 | Warning Status (Warning Status) | Option | [ ,First Warning,Second Warning,Third Warning] | |
| 5939 | No. of Allocations (No. of Allocations) | Integer |
|
Editable: No FlowField |
| 5940 | Contract No. (Contract No.) | Code20 |
|
|
| 5951 | Type Filter (Type Filter) | Option | [ ,Resource,Item,Service Cost,Service Contract] | FlowFilter |
| 5952 | Customer Filter (Customer Filter) | Code20 |
|
FlowFilter |
| 5953 | Resource Filter (Resource Filter) | Code20 |
|
FlowFilter |
| 5954 | Contract Filter (Contract Filter) | Code20 |
|
FlowFilter |
| 5955 | Ship-to Fax No. (Ship-to Fax No.) | Text30 | ||
| 5956 | Ship-to E-Mail (Ship-to E-Mail) | Text80 [E-Mail] | ||
| 5957 | Resource Group Filter (Resource Group Filter) | Code20 |
|
FlowFilter |
| 5958 | Ship-to Phone (Ship-to Phone) | Text30 [Phone No.] | ||
| 5959 | Ship-to Phone 2 (Ship-to Phone 2) | Text30 [Phone No.] | ||
| 5966 | Service Zone Filter (Service Zone Filter) | Code10 |
|
FlowFilter |
| 5968 | Service Zone Code (Service Zone Code) | Code10 |
|
Editable: No |
| 5981 | Expected Finishing Date (Expected Finishing Date) | Date | ||
| 7001 | Allow Line Disc. (Allow Line Disc.) | Boolean | ||
| 9000 | Assigned User ID (Assigned User ID) | Code50 |
|
|
| 9001 | Quote No. (Quote No.) | Code20 |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document Type,No. (Document Type,No.) | Clustered: Yes | |
| 1 | No.,Document Type (No.,Document Type) | ||
| 2 | Customer No.,Order Date (Customer No.,Order Date) | ||
| 3 | Contract No.,Status,Posting Date (Contract No.,Status,Posting Date) | ||
| 4 | Status,Response Date,Response Time,Priority (Status,Response Date,Response Time,Priority) | ||
| 5 | Status,Priority,Response Date,Response Time (Status,Priority,Response Date,Response Time) | ||
| 6 | Document Type,Customer No.,Order Date (Document Type,Customer No.,Order Date) | MaintainSQLIndex: No |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Area (Area) | Area | Code (Code) |
|
1..n |
| Bal. Account No. (Bal. Account No.) | Bank Account | No. (No.) |
|
1..n |
| Bill-to Contact No. (Bill-to Contact No.) | Contact | No. (No.) |
|
1..n |
| Ship-to Country/Region Code (Ship-to Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
| Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
| Customer Filter (Customer Filter) | Customer | No. (No.) |
|
1..n |
| Customer Disc. Group (Customer Disc. Group) | Customer Discount Group | Code (Code) |
|
1..n |
| Customer Posting Group (Customer Posting Group) | Customer Posting Group | Code (Code) |
|
1..n |
| Customer Price Group (Customer Price Group) | Customer Price Group | Code (Code) |
|
1..n |
| Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
| Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Exit Point (Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
| Bal. Account No. (Bal. Account No.) | G/L Account | No. (No.) |
|
1..n |
| Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
| Language Code (Language Code) | Language | Code (Code) |
|
1..n |
| Location Filter (Location Filter) | Location | Code (Code) |
|
1..n |
| Shipping No. Series (Shipping No. Series) | No. Series | Code (Code) |
|
1..n |
| Payment Method Code (Payment Method Code) | Payment Method | Code (Code) |
|
1..n |
| Payment Terms Code (Payment Terms Code) | Payment Terms | Code (Code) |
|
1..n |
| Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
| Resource Filter (Resource Filter) | Resource | No. (No.) |
|
1..n |
| Resource Group Filter (Resource Group Filter) | Resource Group | No. (No.) |
|
1..n |
| Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
| Salesperson Code (Salesperson Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
| Contract Filter (Contract Filter) | Service Contract Header | Contract No. (Contract No.) |
|
1..n |
| Last Posting No. (Last Posting No.) | Service Invoice Header | No. (No.) |
|
1..n |
| Service Order Type (Service Order Type) | Service Order Type | Code (Code) |
|
1..n |
| Last Shipping No. (Last Shipping No.) | Service Shipment Header | No. (No.) |
|
1..n |
| Service Zone Code (Service Zone Code) | Service Zone | Code (Code) |
|
1..n |
| Ship-to Code (Ship-to Code) | Ship-to Address | Code (Code) |
|
1..n |
| Shipment Method Code (Shipment Method Code) | Shipment Method | Code (Code) |
|
1..n |
| Shipping Agent Code (Shipping Agent Code) | Shipping Agent | Code (Code) |
|
1..n |
| Shipping Agent Service Code (Shipping Agent Service Code) | Shipping Agent Services | Code (Code) |
|
1..n |
| Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
| Transaction Specification (Transaction Specification) | Transaction Specification | Code (Code) |
|
1..n |
| Transaction Type (Transaction Type) | Transaction Type | Code (Code) |
|
1..n |
| Transport Method (Transport Method) | Transport Method | Code (Code) |
|
1..n |
| Assigned User ID (Assigned User ID) | User Setup | User ID (User ID) |
|
1..n |
| VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Cash Flow Forecast Entry | Source No. (Source No.) |
|
1..n |
| Service Comment Line | No. (No.) |
|
1..n |
| Service Item | Service Order Filter (Service Order Filter) |
|
1..n |
| Service Item Line | Service Order Filter (Service Order Filter) |
|
1..n |
| Service Item Log | Document No. (Document No.) |
|
1..n |
| Service Line | Document No. (Document No.) |
|
1..n |
| Time Sheet Detail | Service Order No. (Service Order No.) |
|
1..n |
| Time Sheet Detail Archive | Service Order No. (Service Order No.) |
|
1..n |
| Time Sheet Line | Service Order No. (Service Order No.) |
|
1..n |
| Time Sheet Line Archive | Service Order No. (Service Order No.) |
|
1..n |