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 | Customer No. (Customer 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"
|
Editable: No FlowField |
| 14 | Remaining Amount (Remaining Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
| 15 | Original Amt. (LCY) (Original Amt. (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 16 | Remaining Amt. (LCY) (Remaining Amt. (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 17 | Amount (LCY) (Amount (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 18 | Sales (LCY) (Sales (LCY)) | Decimal | AutoFormatType: 1 | |
| 19 | Profit (LCY) (Profit (LCY)) | Decimal | AutoFormatType: 1 | |
| 20 | Inv. Discount (LCY) (Inv. Discount (LCY)) | Decimal | AutoFormatType: 1 | |
| 21 | Sell-to Customer No. (Sell-to Customer No.) | Code20 |
|
|
| 22 | Customer Posting Group (Customer Posting Group) | Code20 |
|
|
| 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 | Salesperson Code (Salesperson Code) | Code20 |
|
|
| 27 | User ID (User ID) | Code50 |
|
|
| 28 | Source Code (Source Code) | Code10 |
|
|
| 33 | On Hold (On Hold) | Code3 | ||
| 34 | Applies-to Doc. Type (Applies-to Doc. Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
| 35 | Applies-to Doc. No. (Applies-to Doc. No.) | Code20 | ||
| 36 | Open (Open) | Boolean | ||
| 37 | Due Date (Due Date) | Date | ||
| 38 | Pmt. Discount Date (Pmt. Discount Date) | Date | ||
| 39 | Original Pmt. Disc. Possible (Original Pmt. Disc. Possible) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 40 | Pmt. Disc. Given (LCY) (Pmt. Disc. Given (LCY)) | Decimal | AutoFormatType: 1 | |
| 43 | Positive (Positive) | Boolean | ||
| 44 | Closed by Entry No. (Closed by Entry No.) | Integer |
|
|
| 45 | Closed at Date (Closed at Date) | Date | ||
| 46 | Closed by Amount (Closed by Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 47 | Applies-to ID (Applies-to ID) | Code50 | ||
| 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 | ||
| 54 | Closed by Amount (LCY) (Closed by Amount (LCY)) | Decimal | AutoFormatType: 1 | |
| 58 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
BlankZero: Yes Editable: No FlowField |
| 59 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
BlankZero: Yes Editable: No FlowField |
| 60 | Debit Amount (LCY) (Debit Amount (LCY)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 61 | Credit Amount (LCY) (Credit Amount (LCY)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
| 62 | Document Date (Document Date) | Date | ||
| 63 | External Document No. (External Document No.) | Code35 | ||
| 64 | Calculate Interest (Calculate Interest) | Boolean | ||
| 65 | Closing Interest Calculated (Closing Interest Calculated) | Boolean | ||
| 66 | No. Series (No. Series) | Code20 |
|
|
| 67 | Closed by Currency Code (Closed by Currency Code) | Code10 |
|
|
| 68 | Closed by Currency Amount (Closed by Currency Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Closed by Currency Code" AccessByPermission: TableData 4=R |
|
| 73 | Adjusted Currency Factor (Adjusted Currency Factor) | Decimal (0:15) | ||
| 74 | Original Currency Factor (Original Currency Factor) | Decimal (0:15) | ||
| 75 | Original Amount (Original Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
| 76 | Date Filter (Date Filter) | Date | FlowFilter | |
| 77 | Remaining Pmt. Disc. Possible (Remaining Pmt. Disc. Possible) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 78 | Pmt. Disc. Tolerance Date (Pmt. Disc. Tolerance Date) | Date | ||
| 79 | Max. Payment Tolerance (Max. Payment Tolerance) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 80 | Last Issued Reminder Level (Last Issued Reminder Level) | Integer | ||
| 81 | Accepted Payment Tolerance (Accepted Payment Tolerance) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 82 | Accepted Pmt. Disc. Tolerance (Accepted Pmt. Disc. Tolerance) | Boolean | ||
| 83 | Pmt. Tolerance (LCY) (Pmt. Tolerance (LCY)) | Decimal | AutoFormatType: 1 | |
| 84 | Amount to Apply (Amount to Apply) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 85 | IC Partner Code (IC Partner Code) | Code20 |
|
|
| 86 | Applying Entry (Applying Entry) | Boolean | ||
| 87 | Reversed (Reversed) | Boolean | BlankZero: Yes | |
| 88 | Reversed by Entry No. (Reversed by Entry No.) | Integer |
|
BlankZero: Yes |
| 89 | Reversed Entry No. (Reversed Entry No.) | Integer |
|
BlankZero: Yes |
| 90 | Prepayment (Prepayment) | Boolean | ||
| 172 | Payment Method Code (Payment Method Code) | Code10 |
|
|
| 173 | Applies-to Ext. Doc. No. (Applies-to Ext. Doc. No.) | Code35 | ||
| 288 | Recipient Bank Account (Recipient Bank Account) | Code20 |
|
|
| 289 | Message to Recipient (Message to Recipient) | Text140 | ||
| 290 | Exported to Payment File (Exported to Payment File) | Boolean | Editable: No | |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 1200 | Direct Debit Mandate ID (Direct Debit Mandate ID) | Code35 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Entry No. (Entry No.) | Clustered: Yes | |
| 1 | Customer No.,Posting Date,Currency Code (Customer No.,Posting Date,Currency Code) | SumIndexFields: Sales (LCY),Profit (LCY),Inv. Discount (LCY) | |
| 2 | Customer No.,Currency Code,Posting Date (Customer No.,Currency Code,Posting Date) | ||
| 3 | Document No. (Document No.) | ||
| 4 | External Document No. (External Document No.) | ||
| 5 | Customer No.,Open,Positive,Due Date,Currency Code (Customer No.,Open,Positive,Due Date,Currency Code) | ||
| 6 | Open,Due Date (Open,Due Date) | ||
| 7 | Document Type,Customer No.,Posting Date,Currency Code (Document Type,Customer No.,Posting Date,Currency Code) | SumIndexFields: Sales (LCY),Profit (LCY),Inv. Discount (LCY) | MaintainSQLIndex: No MaintainSIFTIndex: No |
| 8 | Salesperson Code,Posting Date (Salesperson Code,Posting Date) | ||
| 9 | Closed by Entry No. (Closed by Entry No.) | ||
| 10 | Transaction No. (Transaction No.) | ||
| 11 | Customer No.,Open,Positive,Calculate Interest,Due Date (Customer No.,Open,Positive,Calculate Interest,Due Date) | ||
| 12 | Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code (Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code) | SumIndexFields: Sales (LCY),Profit (LCY),Inv. Discount (LCY) | |
| 13 | Customer No.,Open,Global Dimension 1 Code,Global Dimension 2 Code,Positive,Due Date,Currency Code (Customer No.,Open,Global Dimension 1 Code,Global Dimension 2 Code,Positive,Due Date,Currency Code) | ||
| 14 | Open,Global Dimension 1 Code,Global Dimension 2 Code,Due Date (Open,Global Dimension 1 Code,Global Dimension 2 Code,Due Date) | ||
| 15 | Document Type,Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code (Document Type,Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code) | ||
| 16 | Customer No.,Applies-to ID,Open,Positive,Due Date (Customer No.,Applies-to ID,Open,Positive,Due Date) | ||
| 17 | Document Type,Posting Date (Document Type,Posting Date) | SumIndexFields: Sales (LCY) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bal. Account No. (Bal. Account No.) | Bank Account | No. (No.) |
|
1..n |
| Closed by Currency Code (Closed by Currency Code) | Currency | Code (Code) |
|
1..n |
| Reversed Entry No. (Reversed Entry No.) | Cust. Ledger Entry | Entry No. (Entry No.) |
|
1..n |
| Bal. Account No. (Bal. Account No.) | Customer | No. (No.) |
|
1..n |
| Recipient Bank Account (Recipient Bank Account) | Customer Bank Account | Code (Code) |
|
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 |
| 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 |
| IC Partner Code (IC Partner Code) | IC Partner | Code (Code) |
|
1..n |
| No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
| Payment Method Code (Payment Method Code) | Payment Method | Code (Code) |
|
1..n |
| Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
| Direct Debit Mandate ID (Direct Debit Mandate ID) | SEPA Direct Debit Mandate | ID (ID) |
|
1..n |
| Salesperson Code (Salesperson Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
| Source Code (Source Code) | Source Code | Code (Code) |
|
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 |
| CV Ledger Entry Buffer | Closed by Entry No. (Closed by Entry No.) |
|
1..n |
| Cash Flow Forecast Entry | Source No. (Source No.) |
|
1..n |
| Credit Transfer Entry | Applies-to Entry No. (Applies-to Entry No.) |
|
1..n |
| Cust. Ledger Entry | Reversed Entry No. (Reversed Entry No.) |
|
1..n |
| Detailed Cust. Ledg. Entry | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |
| Direct Debit Collection Entry | Applies-to Entry No. (Applies-to Entry No.) |
|
1..n |
| Finance Charge Memo Line | Entry No. (Entry No.) |
|
1..n |
| Issued Fin. Charge Memo Line | Entry No. (Entry No.) |
|
1..n |
| Issued Reminder Line | Entry No. (Entry No.) |
|
1..n |
| Line Fee Note on Report Hist. | Cust. Ledger Entry No (Cust. Ledger Entry No) |
|
1..n |
| Payment Application Proposal | Applies-to Entry No. (Applies-to Entry No.) |
|
1..n |
| Reminder Line | Entry No. (Entry No.) |
|
1..n |
| Reminder/Fin. Charge Entry | Customer Entry No. (Customer Entry No.) |
|
1..n |
| Reversal Entry | Entry No. (Entry No.) |
|
1..n |
| Sales Cr. Memo Entity Buffer | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |
| Sales Cr.Memo Header | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |
| Sales Invoice Entity Aggregate | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |
| Sales Invoice Header | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |
| Sales Order Entity Buffer | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |
| Sales Quote Entity Buffer | Cust. Ledger Entry No. (Cust. Ledger Entry No.) |
|
1..n |