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 | ||
3 | G/L Account No. (G/L Account No.) | Code20 |
|
|
4 | Posting Date (Posting Date) | Date [ClosingDates:Yes] | ||
5 | Document Type (Document Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
6 | Document No. (Document No.) | Code20 | ||
7 | Description (Description) | Text50 | ||
10 | Bal. Account No. (Bal. Account No.) | Code20 |
|
|
17 | Amount (Amount) | Decimal | AutoFormatType: 1 | |
23 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
24 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
27 | User ID (User ID) | Code50 |
|
|
28 | Source Code (Source Code) | Code10 |
|
|
29 | System-Created Entry (System-Created Entry) | Boolean | ||
30 | Prior-Year Entry (Prior-Year Entry) | Boolean | ||
41 | Job No. (Job No.) | Code20 |
|
|
42 | Quantity (Quantity) | Decimal (0:5) | ||
43 | VAT Amount (VAT Amount) | Decimal | AutoFormatType: 1 | |
45 | Business Unit Code (Business Unit Code) | Code20 |
|
|
46 | Journal Batch Name (Journal Batch Name) | Code10 | ||
47 | Reason Code (Reason Code) | Code10 |
|
|
48 | Gen. Posting Type (Gen. Posting Type) | Option | [ ,Purchase,Sale,Settlement] | |
49 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
50 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
51 | Bal. Account Type (Bal. Account Type) | Option | [G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner] | |
52 | Transaction No. (Transaction No.) | Integer | ||
53 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
54 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
55 | Document Date (Document Date) | Date [ClosingDates:Yes] | ||
56 | External Document No. (External Document No.) | Code35 | ||
57 | Source Type (Source Type) | Option | [ ,Customer,Vendor,Bank Account,Fixed Asset] | |
58 | Source No. (Source No.) | Code20 |
|
|
59 | No. Series (No. Series) | Code10 |
|
|
60 | Tax Area Code (Tax Area Code) | Code20 |
|
|
61 | Tax Liable (Tax Liable) | Boolean | ||
62 | Tax Group Code (Tax Group Code) | Code10 |
|
|
63 | Use Tax (Use Tax) | Boolean | ||
64 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code10 |
|
|
65 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code10 |
|
|
68 | Additional-Currency Amount (Additional-Currency Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 4=R |
|
69 | Add.-Currency Debit Amount (Add.-Currency Debit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
70 | Add.-Currency Credit Amount (Add.-Currency Credit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
71 | Close Income Statement Dim. ID (Close Income Statement Dim. ID) | Integer | ||
72 | IC Partner Code (IC Partner Code) | Code20 |
|
|
73 | Reversed (Reversed) | Boolean | ||
74 | Reversed by Entry No. (Reversed by Entry No.) | Integer |
|
BlankZero: Yes |
75 | Reversed Entry No. (Reversed Entry No.) | Integer |
|
BlankZero: Yes |
76 | G/L Account Name (G/L Account Name) | Text50 |
|
Editable: No FlowField |
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
5400 | Prod. Order No. (Prod. Order No.) | Code20 | ||
5600 | FA Entry Type (FA Entry Type) | Option | [ ,Fixed Asset,Maintenance] AccessByPermission: TableData 5600=R |
|
5601 | FA Entry No. (FA Entry No.) | Integer |
|
BlankZero: Yes |
Keys
# | Fields | ||
---|---|---|---|
0 | Entry No. (Entry No.) | Clustered: Yes | |
1 | G/L Account No.,Posting Date (G/L Account No.,Posting Date) | SumIndexFields: Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount | |
2 | G/L Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date (G/L Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date) | SumIndexFields: Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount | |
3 | G/L Account No.,Business Unit Code,Posting Date (G/L Account No.,Business Unit Code,Posting Date) | SumIndexFields: Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount | |
4 | G/L Account No.,Business Unit Code,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date (G/L Account No.,Business Unit Code,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date) | SumIndexFields: Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount | |
5 | Document No.,Posting Date (Document No.,Posting Date) | ||
6 | Transaction No. (Transaction No.) | ||
7 | IC Partner Code (IC Partner Code) | ||
8 | G/L Account No.,Job No.,Posting Date (G/L Account No.,Job No.,Posting Date) | SumIndexFields: Amount | |
9 | Posting Date,G/L Account No.,Dimension Set ID (Posting Date,G/L Account No.,Dimension Set ID) | SumIndexFields: Amount |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Source No. (Source No.) | Bank Account | No. (No.) |
|
1..n |
Business Unit Code (Business Unit Code) | Business Unit | Code (Code) |
|
1..n |
Source No. (Source No.) | Customer | No. (No.) |
|
1..n |
Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
FA Entry No. (FA Entry No.) | FA Ledger Entry | Entry No. (Entry No.) |
|
1..n |
Source No. (Source No.) | Fixed Asset | No. (No.) |
|
1..n |
Bal. Account No. (Bal. Account No.) | G/L Account | No. (No.) |
|
1..n |
Reversed Entry No. (Reversed Entry No.) | G/L Entry | Entry No. (Entry 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 |
IC Partner Code (IC Partner Code) | IC Partner | Code (Code) |
|
1..n |
Job No. (Job No.) | Job | No. (No.) |
|
1..n |
FA Entry No. (FA Entry No.) | Maintenance Ledger Entry | Entry No. (Entry No.) |
|
1..n |
No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
Reason Code (Reason Code) | Reason Code | 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 Code (Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Source No. (Source No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Applied Payment Entry | Applies-to Entry No. (Applies-to Entry No.) |
|
1..n |
Cost Entry | G/L Entry No. (G/L Entry No.) |
|
1..n |
Cost Journal Line | G/L Entry No. (G/L Entry No.) |
|
1..n |
Cost Register | To G/L Entry No. (To G/L Entry No.) |
|
1..n |
FA Ledger Entry | G/L Entry No. (G/L Entry No.) |
|
1..n |
G/L - Item Ledger Relation | G/L Entry No. (G/L Entry No.) |
|
1..n |
G/L Entry | Reversed Entry No. (Reversed Entry No.) |
|
1..n |
G/L Entry - VAT Entry Link | G/L Entry No. (G/L Entry No.) |
|
1..n |
G/L Register | To Entry No. (To Entry No.) |
|
1..n |
Job Journal Line | Ledger Entry No. (Ledger Entry No.) |
|
1..n |
Job Ledger Entry | Ledger Entry No. (Ledger Entry No.) |
|
1..n |
Job Planning Line | Ledger Entry No. (Ledger Entry No.) |
|
1..n |
Job WIP G/L Entry | G/L Entry No. (G/L Entry No.) |
|
1..n |
Maintenance Ledger Entry | G/L Entry No. (G/L Entry No.) |
|
1..n |
Payment Application Proposal | Applies-to Entry No. (Applies-to Entry No.) |
|
1..n |
Reversal Entry | Entry No. (Entry No.) |
|
1..n |