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 |