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 | NotBlank: Yes | |
2 | Customer No. (Customer No.) | Code20 |
|
|
3 | Name (Name) | Text50 | ||
4 | Name 2 (Name 2) | Text50 | ||
5 | Address (Address) | Text50 | ||
6 | Address 2 (Address 2) | Text50 | ||
7 | Post Code (Post Code) | Code20 |
|
|
8 | City (City) | Text30 |
|
|
9 | County (County) | Text30 | ||
10 | Country/Region Code (Country/Region Code) | Code10 |
|
|
11 | Language Code (Language Code) | Code10 |
|
|
12 | Currency Code (Currency Code) | Code10 |
|
|
13 | Contact (Contact) | Text50 | ||
14 | Your Reference (Your Reference) | Text35 | ||
15 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
16 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
17 | Customer Posting Group (Customer Posting Group) | Code10 |
|
|
18 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
19 | VAT Registration No. (VAT Registration No.) | Text20 | ||
20 | Reason Code (Reason Code) | Code10 |
|
|
21 | Posting Date (Posting Date) | Date | ||
22 | Document Date (Document Date) | Date | ||
23 | Due Date (Due Date) | Date | ||
24 | Reminder Terms Code (Reminder Terms Code) | Code10 |
|
|
25 | Fin. Charge Terms Code (Fin. Charge Terms Code) | Code10 |
|
|
26 | Interest Posted (Interest Posted) | Boolean | ||
27 | Additional Fee Posted (Additional Fee Posted) | Boolean | ||
28 | Reminder Level (Reminder Level) | Integer |
|
|
29 | Posting Description (Posting Description) | Text50 | ||
30 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
31 | Remaining Amount (Remaining Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
32 | Interest Amount (Interest Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
33 | Additional Fee (Additional Fee) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
34 | VAT Amount (VAT Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
35 | No. Printed (No. Printed) | Integer | ||
36 | User ID (User ID) | Code50 |
|
|
37 | No. Series (No. Series) | Code10 |
|
Editable: No |
38 | Pre-Assigned No. Series (Pre-Assigned No. Series) | Code10 |
|
|
39 | Pre-Assigned No. (Pre-Assigned No.) | Code20 | ||
40 | Source Code (Source Code) | Code10 |
|
|
41 | Tax Area Code (Tax Area Code) | Code20 |
|
|
42 | Tax Liable (Tax Liable) | Boolean | ||
43 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code10 |
|
|
44 | Add. Fee per Line (Add. Fee per Line) | Decimal | AutoFormatExpr: "Currency Code"
|
FlowField |
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Customer No.,Posting Date (Customer No.,Posting Date) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Customer No. (Customer No.) | Customer | No. (No.) |
|
1..n |
Customer Posting Group (Customer Posting Group) | Customer Posting 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 |
Fin. Charge Terms Code (Fin. Charge Terms Code) | Finance Charge Terms | Code (Code) |
|
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 |
Pre-Assigned No. Series (Pre-Assigned No. Series) | No. Series | Code (Code) |
|
1..n |
Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
Reminder Level (Reminder Level) | Reminder Level | No. (No.) |
|
1..n |
Reminder Terms Code (Reminder Terms Code) | Reminder Terms | Code (Code) |
|
1..n |
Source Code (Source Code) | Source Code | Code (Code) |
|
1..n |
Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
User ID (User ID) | User | User Name (User Name) |
|
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 | ||
---|---|---|---|
Issued Reminder Line | Reminder No. (Reminder No.) |
|
1..n |
Reminder Comment Line | No. (No.) |
|
1..n |
Reminder/Fin. Charge Entry | No. (No.) |
|
1..n |