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 | ||
2 | Name (Name) | Text50 | ||
3 | Search Name (Search Name) | Code50 | ||
4 | Name 2 (Name 2) | Text50 | ||
5 | Address (Address) | Text50 | ||
6 | Address 2 (Address 2) | Text50 | ||
7 | City (City) | Text30 |
|
|
8 | Contact (Contact) | Text50 | ||
9 | Phone No. (Phone No.) | Text30 [Phone No.] | ||
10 | Telex No. (Telex No.) | Text20 | ||
13 | Bank Account No. (Bank Account No.) | Text30 | ||
14 | Transit No. (Transit No.) | Text20 | ||
15 | Territory Code (Territory Code) | Code10 |
|
|
16 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
17 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
18 | Chain Name (Chain Name) | Code10 | ||
20 | Min. Balance (Min. Balance) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
21 | Bank Acc. Posting Group (Bank Acc. Posting Group) | Code10 |
|
|
22 | Currency Code (Currency Code) | Code10 |
|
|
24 | Language Code (Language Code) | Code10 |
|
|
26 | Statistics Group (Statistics Group) | Integer | ||
29 | Our Contact Code (Our Contact Code) | Code10 |
|
|
35 | Country/Region Code (Country/Region Code) | Code10 |
|
|
37 | Amount (Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
38 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
39 | Blocked (Blocked) | Boolean | ||
41 | Last Statement No. (Last Statement No.) | Code20 | ||
42 | Last Payment Statement No. (Last Payment Statement No.) | Code20 | ||
54 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
55 | Date Filter (Date Filter) | Date | FlowFilter | |
56 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 | CaptionClass: '1,3,1'
|
FlowFilter |
57 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
FlowFilter |
58 | Balance (Balance) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
59 | Balance (LCY) (Balance (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
60 | Net Change (Net Change) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
61 | Net Change (LCY) (Net Change (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
62 | Total on Checks (Total on Checks) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
84 | Fax No. (Fax No.) | Text30 | ||
85 | Telex Answer Back (Telex Answer Back) | Text20 | ||
89 | Picture (Picture) | BLOB [Bitmap] | ||
91 | Post Code (Post Code) | Code20 |
|
|
92 | County (County) | Text30 | ||
93 | Last Check No. (Last Check No.) | Code20 | AccessByPermission: TableData 272=R | |
94 | Balance Last Statement (Balance Last Statement) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
95 | Balance at Date (Balance at Date) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
Editable: No FlowField |
96 | Balance at Date (LCY) (Balance at Date (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
97 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
BlankZero: Yes Editable: No FlowField |
98 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code"
|
BlankZero: Yes Editable: No FlowField |
99 | Debit Amount (LCY) (Debit Amount (LCY)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
100 | Credit Amount (LCY) (Credit Amount (LCY)) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
101 | Bank Branch No. (Bank Branch No.) | Text20 | ||
102 | E-Mail (E-Mail) | Text80 [E-Mail] | ||
103 | Home Page (Home Page) | Text80 [URL] | ||
107 | No. Series (No. Series) | Code10 |
|
Editable: No |
108 | Check Report ID (Check Report ID) | Integer |
|
|
109 | Check Report Name (Check Report Name) | Text250 |
|
Editable: No FlowField |
110 | IBAN (IBAN) | Code50 | ||
111 | SWIFT Code (SWIFT Code) | Code20 | ||
113 | Bank Statement Import Format (Bank Statement Import Format) | Code20 |
|
|
115 | Credit Transfer Msg. Nos. (Credit Transfer Msg. Nos.) | Code10 |
|
|
116 | Direct Debit Msg. Nos. (Direct Debit Msg. Nos.) | Code10 |
|
|
117 | SEPA Direct Debit Exp. Format (SEPA Direct Debit Exp. Format) | Code20 |
|
|
121 | Bank Stmt. Service Record ID (Bank Stmt. Service Record ID) | RecordID | ||
123 | Transaction Import Timespan (Transaction Import Timespan) | Integer | ||
124 | Automatic Stmt. Import Enabled (Automatic Stmt. Import Enabled) | Boolean | ||
140 | Image (Image) | Media [Person] | ||
170 | Creditor No. (Creditor No.) | Code35 | ||
1210 | Payment Export Format (Payment Export Format) | Code20 |
|
|
1211 | Bank Clearing Code (Bank Clearing Code) | Text50 | ||
1212 | Bank Clearing Standard (Bank Clearing Standard) | Text50 |
|
|
1213 | Bank Name - Data Conversion (Bank Name - Data Conversion) | Text50 |
|
|
1250 | Match Tolerance Type (Match Tolerance Type) | Option | [Percentage,Amount] | |
1251 | Match Tolerance Value (Match Tolerance Value) | Decimal (0:5) | ||
1260 | Positive Pay Export Code (Positive Pay Export Code) | Code20 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Search Name (Search Name) | ||
2 | Bank Acc. Posting Group (Bank Acc. Posting Group) | ||
3 | Currency Code (Currency Code) | ||
4 | Country/Region Code (Country/Region Code) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Check Report ID (Check Report ID) | AllObjWithCaption | Object ID (Object ID) |
|
1..n |
Bank Acc. Posting Group (Bank Acc. Posting Group) | Bank Account Posting Group | Code (Code) |
|
1..n |
Bank Clearing Standard (Bank Clearing Standard) | Bank Clearing Standard | Code (Code) |
|
1..n |
Positive Pay Export Code (Positive Pay Export Code) | Bank Export/Import Setup | Code (Code) |
|
1..n |
Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Global Dimension 2 Filter (Global Dimension 2 Filter) | Dimension Value | Code (Code) |
|
1..n |
Language Code (Language Code) | Language | Code (Code) |
|
1..n |
Direct Debit Msg. Nos. (Direct Debit Msg. Nos.) | No. Series | Code (Code) |
|
1..n |
Our Contact Code (Our Contact Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
Territory Code (Territory Code) | Territory | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Applied Payment Entry | Account No. (Account No.) |
|
1..n |
Bank Acc. Reconciliation | Bank Account No. (Bank Account No.) |
|
1..n |
Bank Acc. Reconciliation Line | Account No. (Account No.) |
|
1..n |
Bank Account Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Bank Account Statement | Bank Account No. (Bank Account No.) |
|
1..n |
Bank Account Statement Line | Bank Account No. (Bank Account No.) |
|
1..n |
CV Ledger Entry Buffer | Bal. Account No. (Bal. Account No.) |
|
1..n |
Check Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Comment Line | No. (No.) |
|
1..n |
Contact Business Relation | No. (No.) |
|
1..n |
Credit Transfer Register | From Bank Account No. (From Bank Account No.) |
|
1..n |
Cust. Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Default Dimension | No. (No.) |
|
1..n |
Direct Debit Collection | To Bank Account No. (To Bank Account No.) |
|
1..n |
FA Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
G/L Entry | Source No. (Source No.) |
|
1..n |
Gen. Journal Batch | Bal. Account No. (Bal. Account No.) |
|
1..n |
Gen. Journal Line | Source No. (Source No.) |
|
1..n |
Gen. Journal Template | Bal. Account No. (Bal. Account No.) |
|
1..n |
Maintenance Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Office Contact Associations | No. (No.) |
|
1..n |
Online Bank Acc. Link | No. (No.) |
|
1..1 |
Payment Application Proposal | Account No. (Account No.) |
|
1..n |
Payment Export Data | Sender Bank Account Code (Sender Bank Account Code) |
|
1..n |
Payment Matching Details | Bank Account No. (Bank Account No.) |
|
1..n |
Payment Method | Bal. Account No. (Bal. Account No.) |
|
1..n |
Payment Registration Setup | Bal. Account No. (Bal. Account No.) |
|
1..n |
Positive Pay Entry | Bank Account No. (Bank Account No.) |
|
1..n |
Positive Pay Entry Detail | Bank Account No. (Bank Account No.) |
|
1..n |
Posted Payment Recon. Hdr | Bank Account No. (Bank Account No.) |
|
1..n |
Posted Payment Recon. Line | Account No. (Account No.) |
|
1..n |
Purch. Cr. Memo Hdr. | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purch. Inv. Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purch. Rcpt. Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purchase Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Purchase Header Archive | Bal. Account No. (Bal. Account No.) |
|
1..n |
Return Receipt Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Return Shipment Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Reversal Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Cr.Memo Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Header Archive | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Invoice Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Shipment Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Cr.Memo Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Invoice Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Service Shipment Header | Bal. Account No. (Bal. Account No.) |
|
1..n |
Standard General Journal Line | Source No. (Source No.) |
|
1..n |
Text-to-Account Mapping | Bal. Source No. (Bal. Source No.) |
|
1..n |
Vendor Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |