Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Entry No. (Entry No.) | Integer | Editable: No | |
2 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
Editable: No |
3 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
Editable: No |
4 | Posting Date (Posting Date) | Date | Editable: No | |
5 | Document No. (Document No.) | Code20 | Editable: No | |
6 | Document Type (Document Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | Editable: No |
7 | Type (Type) | Option | [ ,Purchase,Sale,Settlement] | Editable: No |
8 | Base (Base) | Decimal | AutoFormatType: 1 | Editable: No |
9 | Amount (Amount) | Decimal | AutoFormatType: 1 | Editable: No |
10 | VAT Calculation Type (VAT Calculation Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
12 | Bill-to/Pay-to No. (Bill-to/Pay-to No.) | Code20 |
|
|
13 | EU 3-Party Trade (EU 3-Party Trade) | Boolean | ||
14 | User ID (User ID) | Code50 |
|
Editable: No |
15 | Source Code (Source Code) | Code10 |
|
Editable: No |
16 | Reason Code (Reason Code) | Code10 |
|
Editable: No |
17 | Closed by Entry No. (Closed by Entry No.) | Integer |
|
Editable: No |
18 | Closed (Closed) | Boolean | Editable: No | |
19 | Country/Region Code (Country/Region Code) | Code10 |
|
|
20 | Internal Ref. No. (Internal Ref. No.) | Text30 | Editable: No | |
21 | Transaction No. (Transaction No.) | Integer | Editable: No | |
22 | Unrealized Amount (Unrealized Amount) | Decimal | AutoFormatType: 1 | Editable: No |
23 | Unrealized Base (Unrealized Base) | Decimal | AutoFormatType: 1 | Editable: No |
24 | Remaining Unrealized Amount (Remaining Unrealized Amount) | Decimal | AutoFormatType: 1 | Editable: No |
25 | Remaining Unrealized Base (Remaining Unrealized Base) | Decimal | AutoFormatType: 1 | Editable: No |
26 | External Document No. (External Document No.) | Code35 | Editable: No | |
28 | No. Series (No. Series) | Code10 |
|
Editable: No |
29 | Tax Area Code (Tax Area Code) | Code20 |
|
Editable: No |
30 | Tax Liable (Tax Liable) | Boolean | Editable: No | |
31 | Tax Group Code (Tax Group Code) | Code10 |
|
Editable: No |
32 | Use Tax (Use Tax) | Boolean | Editable: No | |
33 | Tax Jurisdiction Code (Tax Jurisdiction Code) | Code10 |
|
Editable: No |
34 | Tax Group Used (Tax Group Used) | Code10 |
|
Editable: No |
35 | Tax Type (Tax Type) | Option | [Sales Tax,Excise Tax] | Editable: No |
36 | Tax on Tax (Tax on Tax) | Boolean | Editable: No | |
37 | Sales Tax Connection No. (Sales Tax Connection No.) | Integer | Editable: No | |
38 | Unrealized VAT Entry No. (Unrealized VAT Entry No.) | Integer |
|
Editable: No |
39 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code10 |
|
Editable: No |
40 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code10 |
|
Editable: No |
43 | Additional-Currency Amount (Additional-Currency Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 4=R |
Editable: No |
44 | Additional-Currency Base (Additional-Currency Base) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 4=R |
Editable: No |
45 | Add.-Currency Unrealized Amt. (Add.-Currency Unrealized Amt.) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
46 | Add.-Currency Unrealized Base (Add.-Currency Unrealized Base) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
48 | VAT Base Discount % (VAT Base Discount %) | Decimal (0:5) | MaxValue: 100 | Editable: No |
49 | Add.-Curr. Rem. Unreal. Amount (Add.-Curr. Rem. Unreal. Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
50 | Add.-Curr. Rem. Unreal. Base (Add.-Curr. Rem. Unreal. Base) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
51 | VAT Difference (VAT Difference) | Decimal | AutoFormatType: 1 | Editable: No |
52 | Add.-Curr. VAT Difference (Add.-Curr. VAT Difference) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 4=R |
Editable: No |
53 | Ship-to/Order Address Code (Ship-to/Order Address Code) | Code10 |
|
|
54 | Document Date (Document Date) | Date | Editable: No | |
55 | VAT Registration No. (VAT Registration No.) | Text20 | ||
56 | Reversed (Reversed) | Boolean | ||
57 | Reversed by Entry No. (Reversed by Entry No.) | Integer |
|
BlankZero: Yes |
58 | Reversed Entry No. (Reversed Entry No.) | Integer |
|
BlankZero: Yes |
59 | EU Service (EU Service) | Boolean | Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | Entry No. (Entry No.) | Clustered: Yes | |
1 | Type,Closed,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date (Type,Closed,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date) | SumIndexFields: Base,Amount,Additional-Currency Base,Additional-Currency Amount,Remaining Unrealized Amount,Remaining Unrealized Base,Add.-Curr. Rem. Unreal. Amount,Add.-Curr. Rem. Unreal. Base | |
2 | Type,Closed,Tax Jurisdiction Code,Use Tax,Posting Date (Type,Closed,Tax Jurisdiction Code,Use Tax,Posting Date) | SumIndexFields: Base,Amount,Unrealized Amount,Unrealized Base,Remaining Unrealized Amount | |
3 | Type,Country/Region Code,VAT Registration No.,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date (Type,Country/Region Code,VAT Registration No.,VAT Bus. Posting Group,VAT Prod. Posting Group,Posting Date) | SumIndexFields: Base,Additional-Currency Base | |
4 | Document No.,Posting Date (Document No.,Posting Date) | ||
5 | Transaction No. (Transaction No.) | ||
6 | Tax Jurisdiction Code,Tax Group Used,Tax Type,Use Tax,Posting Date (Tax Jurisdiction Code,Tax Group Used,Tax Type,Use Tax,Posting Date) | ||
7 | Type,Bill-to/Pay-to No.,Transaction No. (Type,Bill-to/Pay-to No.,Transaction No.) | MaintainSQLIndex: No | |
8 | Document Date (Document Date) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Bill-to/Pay-to No. (Bill-to/Pay-to No.) | Customer | No. (No.) |
|
1..n |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
Ship-to/Order Address Code (Ship-to/Order Address Code) | Order Address | Code (Code) |
|
1..n |
Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
Ship-to/Order Address Code (Ship-to/Order Address Code) | Ship-to Address | 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 |
Tax Group Used (Tax Group Used) | Tax Group | Code (Code) |
|
1..n |
Tax Jurisdiction Code (Tax Jurisdiction Code) | Tax Jurisdiction | 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 |
Reversed Entry No. (Reversed Entry No.) | VAT Entry | Entry No. (Entry No.) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Bill-to/Pay-to No. (Bill-to/Pay-to No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
G/L Entry - VAT Entry Link | VAT Entry No. (VAT Entry No.) |
|
1..n |
G/L Register | To VAT Entry No. (To VAT Entry No.) |
|
1..n |
Reversal Entry | Entry No. (Entry No.) |
|
1..n |
VAT Entry | Reversed Entry No. (Reversed Entry No.) |
|
1..n |