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 | Bank Account No. (Bank Account No.) | Code20 |
|
|
| 4 | Posting Date (Posting Date) | Date | ||
| 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 | ||
| 11 | Currency Code (Currency Code) | Code10 |
|
|
| 13 | Amount (Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 14 | Remaining Amount (Remaining Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 17 | Amount (LCY) (Amount (LCY)) | Decimal | AutoFormatType: 1 | |
| 22 | Bank Acc. Posting Group (Bank Acc. Posting Group) | Code10 |
|
|
| 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'
|
|
| 25 | Our Contact Code (Our Contact Code) | Code10 |
|
|
| 27 | User ID (User ID) | Code50 |
|
|
| 28 | Source Code (Source Code) | Code10 |
|
|
| 36 | Open (Open) | Boolean | ||
| 43 | Positive (Positive) | Boolean | ||
| 44 | Closed by Entry No. (Closed by Entry No.) | Integer |
|
|
| 45 | Closed at Date (Closed at Date) | Date | ||
| 49 | Journal Batch Name (Journal Batch Name) | Code10 | ||
| 50 | Reason Code (Reason Code) | Code10 |
|
|
| 51 | Bal. Account Type (Bal. Account Type) | Option | [G/L Account,Customer,Vendor,Bank Account,Fixed Asset] | |
| 52 | Bal. Account No. (Bal. Account No.) | Code20 |
|
|
| 53 | Transaction No. (Transaction No.) | Integer | ||
| 55 | Statement Status (Statement Status) | Option | [Open,Bank Acc. Entry Applied,Check Entry Applied,Closed] | |
| 56 | Statement No. (Statement No.) | Code20 |
|
|
| 57 | Statement Line No. (Statement Line No.) | Integer |
|
|
| 58 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
| 59 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
| 60 | Debit Amount (LCY) (Debit Amount (LCY)) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
| 61 | Credit Amount (LCY) (Credit Amount (LCY)) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
| 62 | Document Date (Document Date) | Date [ClosingDates:Yes] | ||
| 63 | External Document No. (External Document No.) | Code35 | ||
| 64 | Reversed (Reversed) | Boolean | ||
| 65 | Reversed by Entry No. (Reversed by Entry No.) | Integer |
|
BlankZero: Yes |
| 66 | Reversed Entry No. (Reversed Entry No.) | Integer |
|
BlankZero: Yes |
| 70 | Check Ledger Entries (Check Ledger Entries) | Integer |
|
FlowField |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Entry No. (Entry No.) | Clustered: Yes | |
| 1 | Bank Account No.,Posting Date (Bank Account No.,Posting Date) | SumIndexFields: Amount,Amount (LCY),Debit Amount,Credit Amount,Debit Amount (LCY),Credit Amount (LCY) | |
| 2 | Bank Account No.,Open (Bank Account No.,Open) | ||
| 3 | Document Type,Bank Account No.,Posting Date (Document Type,Bank Account No.,Posting Date) | SumIndexFields: Amount | MaintainSQLIndex: No |
| 4 | Document No.,Posting Date (Document No.,Posting Date) | ||
| 5 | Transaction No. (Transaction No.) | ||
| 6 | Bank Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date (Bank Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date) | SumIndexFields: Amount,Amount (LCY),Debit Amount,Credit Amount,Debit Amount (LCY),Credit Amount (LCY) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Statement Line No. (Statement Line No.) | Bank Acc. Reconciliation Line | Statement Line No. (Statement Line No.) |
|
1..n |
| Bal. Account No. (Bal. Account No.) | Bank Account | No. (No.) |
|
1..n |
| Reversed Entry No. (Reversed Entry No.) | Bank Account Ledger Entry | Entry No. (Entry No.) |
|
1..n |
| Bank Acc. Posting Group (Bank Acc. Posting Group) | Bank Account Posting Group | Code (Code) |
|
1..n |
| Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
| Bal. Account No. (Bal. Account 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 |
| Bal. Account No. (Bal. Account No.) | Fixed Asset | No. (No.) |
|
1..n |
| Bal. Account No. (Bal. Account No.) | G/L Account | No. (No.) |
|
1..n |
| Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
| Our Contact Code (Our Contact Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
| Source Code (Source Code) | Source Code | Code (Code) |
|
1..n |
| User ID (User ID) | User | User Name (User Name) |
|
1..n |
| Bal. Account No. (Bal. Account 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 |
| Bank Account Ledger Entry | Reversed Entry No. (Reversed Entry No.) |
|
1..n |
| Check Ledger Entry | Bank Account Ledger Entry No. (Bank Account Ledger 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 |