Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
2 | Sell-to Customer No. | Code20 |
|
NotBlank: Yes |
3 | No. | Code20 | ||
4 | Bill-to Customer No. | Code20 |
|
NotBlank: Yes |
5 | Bill-to Name | Text50 | ||
6 | Bill-to Name 2 | Text50 | ||
7 | Bill-to Address | Text50 | ||
8 | Bill-to Address 2 | Text50 | ||
9 | Bill-to City | Text30 |
|
|
10 | Bill-to Contact | Text50 | ||
11 | Your Reference | Text35 | ||
12 | Ship-to Code | Code10 |
|
|
13 | Ship-to Name | Text50 | ||
14 | Ship-to Name 2 | Text50 | ||
15 | Ship-to Address | Text50 | ||
16 | Ship-to Address 2 | Text50 | ||
17 | Ship-to City | Text30 |
|
|
18 | Ship-to Contact | Text50 | ||
19 | Order Date | Date | ||
20 | Posting Date | Date | ||
21 | Shipment Date | Date | ||
22 | Posting Description | Text50 | ||
23 | Payment Terms Code | Code10 |
|
|
24 | Due Date | Date | ||
25 | Payment Discount % | Decimal (0:5) | MaxValue: 100 | |
26 | Pmt. Discount Date | Date | ||
27 | Shipment Method Code | Code10 |
|
|
28 | Location Code | Code10 |
|
|
29 | Shortcut Dimension 1 Code | Code20 | CaptionClass: '1,2,1'
|
|
30 | Shortcut Dimension 2 Code | Code20 | CaptionClass: '1,2,2'
|
|
31 | Customer Posting Group | Code20 |
|
Editable: No |
32 | Currency Code | Code10 |
|
Editable: No |
33 | Currency Factor | Decimal (0:15) | ||
34 | Customer Price Group | Code10 |
|
|
35 | Prices Including VAT | Boolean | ||
37 | Invoice Disc. Code | Code20 | ||
40 | Customer Disc. Group | Code20 |
|
|
41 | Language Code | Code10 |
|
|
43 | Salesperson Code | Code20 |
|
|
46 | Comment | Boolean |
|
Editable: No FlowField |
47 | No. Printed | Integer | Editable: No | |
51 | On Hold | Code3 | ||
52 | Applies-to Doc. Type | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
53 | Applies-to Doc. No. | Code20 | ||
55 | Bal. Account No. | Code20 |
|
|
70 | VAT Registration No. | Text20 | ||
73 | Reason Code | Code10 |
|
|
74 | Gen. Bus. Posting Group | Code20 |
|
|
75 | EU 3-Party Trade | Boolean | ||
76 | Transaction Type | Code10 |
|
|
77 | Transport Method | Code10 |
|
|
78 | VAT Country/Region Code | Code10 |
|
|
79 | Sell-to Customer Name | Text50 | ||
80 | Sell-to Customer Name 2 | Text50 | ||
81 | Sell-to Address | Text50 | ||
82 | Sell-to Address 2 | Text50 | ||
83 | Sell-to City | Text30 |
|
|
84 | Sell-to Contact | Text50 | ||
85 | Bill-to Post Code | Code20 |
|
|
86 | Bill-to County | Text30 | ||
87 | Bill-to Country/Region Code | Code10 |
|
|
88 | Sell-to Post Code | Code20 |
|
|
89 | Sell-to County | Text30 | ||
90 | Sell-to Country/Region Code | Code10 |
|
|
91 | Ship-to Post Code | Code20 |
|
|
92 | Ship-to County | Text30 | ||
93 | Ship-to Country/Region Code | Code10 |
|
|
94 | Bal. Account Type | Option | [G/L Account,Bank Account] | |
97 | Exit Point | Code10 |
|
|
98 | Correction | Boolean | ||
99 | Document Date | Date | ||
100 | External Document No. | Code35 | ||
101 | Area | Code10 |
|
|
102 | Transaction Specification | Code10 |
|
|
104 | Payment Method Code | Code10 |
|
|
105 | Shipping Agent Code | Code10 |
|
|
106 | Package Tracking No. | Text30 | ||
109 | No. Series | Code20 |
|
Editable: No |
112 | User ID | Code50 |
|
|
113 | Source Code | Code10 |
|
|
114 | Tax Area Code | Code20 |
|
|
115 | Tax Liable | Boolean | ||
116 | VAT Bus. Posting Group | Code20 |
|
|
119 | VAT Base Discount % | Decimal (0:5) | MaxValue: 100 | |
480 | Dimension Set ID | Integer |
|
Editable: No |
5050 | Campaign No. | Code20 |
|
|
5052 | Sell-to Contact No. | Code20 |
|
|
5053 | Bill-to Contact No. | Code20 |
|
|
5055 | Opportunity No. | Code20 |
|
|
5700 | Responsibility Center | Code10 |
|
|
5790 | Requested Delivery Date | Date | Editable: No | |
5791 | Promised Delivery Date | Date | Editable: No | |
5792 | Shipping Time | DateFormula | Editable: No | |
5793 | Warehouse Handling Time | DateFormula | Editable: No | |
5797 | Late Order Shipping | Boolean | Editable: No | |
6601 | Return Order No. | Code20 | ||
6602 | Return Order No. Series | Code20 |
|
|
7001 | Allow Line Disc. | Boolean |
Keys
# | Fields | ||
---|---|---|---|
0 | No. | Clustered: Yes | |
1 | Return Order No. | ||
2 | Sell-to Customer No.,External Document No. | ||
3 | Bill-to Customer No. | ||
4 | Posting Date |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area | Area | Code |
|
1..n |
Bal. Account No. | Bank Account | No. |
|
1..n |
Campaign No. | Campaign | No. |
|
1..n |
Bill-to Contact No. | Contact | No. |
|
1..n |
Ship-to Country/Region Code | Country/Region | Code |
|
1..n |
Currency Code | Currency | Code |
|
1..n |
Bill-to Customer No. | Customer | No. |
|
1..n |
Customer Disc. Group | Customer Discount Group | Code |
|
1..n |
Customer Posting Group | Customer Posting Group | Code |
|
1..n |
Customer Price Group | Customer Price Group | Code |
|
1..n |
Dimension Set ID | Dimension Set Entry |
|
1..n | |
Shortcut Dimension 2 Code | Dimension Value | Code |
|
1..n |
Exit Point | Entry/Exit Point | Code |
|
1..n |
Bal. Account No. | G/L Account | No. |
|
1..n |
Gen. Bus. Posting Group | Gen. Business Posting Group | Code |
|
1..n |
Language Code | Language | Code |
|
1..n |
Location Code | Location |
|
1..n | |
Return Order No. Series | No. Series | Code |
|
1..n |
Opportunity No. | Opportunity | No. |
|
1..n |
Payment Method Code | Payment Method | Code |
|
1..n |
Payment Terms Code | Payment Terms | Code |
|
1..n |
Reason Code | Reason Code | Code |
|
1..n |
Responsibility Center | Responsibility Center | Code |
|
1..n |
Salesperson Code | Salesperson/Purchaser | Code |
|
1..n |
Ship-to Code | Ship-to Address | Code |
|
1..n |
Shipment Method Code | Shipment Method | Code |
|
1..n |
Shipping Agent Code | Shipping Agent | Code |
|
1..n |
Source Code | Source Code | Code |
|
1..n |
Tax Area Code | Tax Area | Code |
|
1..n |
Transaction Specification | Transaction Specification | Code |
|
1..n |
Transaction Type | Transaction Type | Code |
|
1..n |
Transport Method | Transport Method | Code |
|
1..n |
User ID | User | User Name |
|
1..n |
VAT Bus. Posting Group | VAT Business Posting Group | Code |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Item Charge Assignment (Sales) | Applies-to Doc. No. |
|
1..n |
Posted Invt. Pick Header | Source No. |
|
1..n |
Posted Invt. Put-away Header | Source No. |
|
1..n |
Registered Invt. Movement Hdr. | Source No. |
|
1..n |
Return Receipt Line | Document No. |
|
1..n |
Sales Header | Last Return Receipt No. |
|
1..n |
Sales Header Archive | Last Return Receipt No. |
|
1..n |