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