Bank (Venster ID-158)

Uit iDempiere nl
Naar navigatie springen Naar zoeken springen



Venster: Bank

Beschrijving: Beheer Banken

Help: Het Bank Scherm wordt gebruikt om banken en rekeningen verbonden aan een organisatie of relatie te beheren.



TAB: Bank

Beschrijving: Maintain Bank


Help The Bank Tab defines a bank that is used by an organization or business partner. Each Bank is given an identifying Name, Address, Routing No and Swift Code


Bestand:Bank - Bank - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Address Adres Location or Address The Location / Address field defines the location of an entity. C_Location_ID
numeric(10)
Location (Address)
Own Bank Eigen Bank Bank for this Organization The Own Bank field indicates if this bank is for this Organization as opposed to a Bank for a Business Partner. IsOwnBank
character(1) NOT NULL
Yes-No
Routing No Routing No Bank Routing Number The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. RoutingNo
character varying(20) NOT NULL
String
Swift code Swift code Swift Code or BIC The Swift Code (Society of Worldwide Interbank Financial Telecommunications) or BIC (Bank Identifier Code) is an identifier of a Bank. The first 4 characters are the bank code, followed by the 2 character country code, the two character location code and optional 3 character branch code. For details see http://www.swift.com/biconline/index.cfm SwiftCode
character varying(20)
String




TAB: Account

Beschrijving: Maintain Bank Account


Help The Account Tab is used to define one or more accounts for a Bank. Each account has a unique Account No and Currency. The bank account organization is used for accounting.


Bestand:Bank - Account - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Bank Bank Bank The Bank is a unique identifier of a Bank for this Organization or for a Business Partner with whom this Organization transacts. C_Bank_ID
numeric(10) NOT NULL
Table Direct
Account No Account No Account Number The Account Number indicates the Number assigned to this bank account. AccountNo
character varying(20) NOT NULL
String
BBAN BBAN Basic Bank Account Number The Basic (or Domestic) Bank Account Number is used in Bank transfers (see also IBAN). For details see ISO 13616 and http://www.ecbs.org/ BBAN
character varying(40)
String
IBAN IBAN International Bank Account Number If your bank provides an International Bank Account Number, enter it here

Details ISO 13616 and http://www.ecbs.org. The account number has the maximum length of 22 characters (without spaces). The IBAN is often printed with a apace after 4 characters. Do not enter the spaces in Adempiere.

IBAN
character varying(40)
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Default Standaard Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault
character(1) NOT NULL
Yes-No
Currency Munteenheid The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID
numeric(10) NOT NULL
Table Direct
Bank Account Type Bank Account Type Bank Account Type The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as. BankAccountType
character(1) NOT NULL
List
Credit limit Credit limiet Amount of Credit allowed The Credit Limit field indicates the credit limit for this account. CreditLimit
numeric NOT NULL
Number
Payment Export Class Payment Export Class null null PaymentExportClass
character varying(60)
String
Current balance Current balance Current Balance The Current Balance field indicates the current balance in this account. CurrentBalance
numeric NOT NULL
Number




TAB: Bank Account Document

Beschrijving: Maintain Bank Account Documents


Help In this tab, you define the documents used for this bank account. You define your check and other payment document (sequence) number as well as format.


Bestand:Bank - Bank Account Document - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Bank Account Document Bank Account Document Checks, Transfers, etc. Bank documents, you generate or track C_BankAccountDoc_ID
numeric(10) NOT NULL
ID
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Bank Account Bank Rekening (Bank Account) Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID
numeric(10) NOT NULL
Table Direct
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Payment Rule Payment Rule How you pay the invoice The Payment Rule indicates the method of invoice payment. PaymentRule
character(1) NOT NULL
List
Current Next Current Next The next number to be used The Current Next indicates the next number to use for this document CurrentNext
numeric(10) NOT NULL
Integer
Check Print Format Check Print Format Print Format for printing Checks You need to define a Print Format to print the document. Check_PrintFormat_ID
numeric(10)
Table




TAB: Bank Account Processor

Beschrijving: Maintain Bank Account Payment Processors


Help null


Bestand:Bank - Bank Account Processor - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Bank Account Bank Rekening (Bank Account) Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID
numeric(10) NOT NULL
Table Direct
Payment Processor Payment Processor Payment processor for electronic payments The Payment Processor indicates the processor to be used for electronic payments C_PaymentProcessor_ID
numeric(10) NOT NULL
Table Direct
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No




TAB: Statement Loader

Beschrijving: Definition of Bank Statement Loader (SWIFT, OFX)


Help The loader definition privides the parameters to load bank statements from EFT formats like SWIFT (MT940) or OFX. The required parameters depend on the actual statement loader class


Bestand:Bank - Statement Loader - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Bank Statement Loader Bank Statement Loader Definition of Bank Statement Loader (SWIFT, OFX) The loader definition provides the parameters to load bank statements from EFT formats like SWIFT (MT940) or OFX C_BankStatementLoader_ID
numeric(10) NOT NULL
ID
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Bank Account Bank Rekening (Bank Account) Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID
numeric(10) NOT NULL
Table Direct
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Financial Institution ID Financial Institution ID The ID of the Financial Institution / Bank Depending on the loader, it might require a ID of the financial institution FinancialInstitutionID
character varying(20)
String
Branch ID Branch ID Bank Branch ID Dependent on the loader, you may have to provide a bank branch ID BranchID
character varying(20)
String
Account No Account No Account Number The Account Number indicates the Number assigned to this bank account. AccountNo
character varying(20)
String
PIN PIN Personal Identification Number null PIN
character varying(20)
String
User ID User ID User ID or account number The User ID identifies a user and allows access to records or processes. UserID
character varying(60)
String
Password Password Password of any length (case sensitive) The Password for this User. Passwords are required to identify authorized users. For Adempiere Users, you can change the password via the Process "Reset Password". Password
character varying(60)
String
Host Address Host Address Host Address URL or DNS The Host Address identifies the URL or DNS of the target host HostAddress
character varying(60)
String
Host port Host port Host Communication Port The Host Port identifies the port to communicate with the host. HostPort
numeric(10)
Integer
Proxy address Proxy address Address of your proxy server The Proxy Address must be defined if you must pass through a firewall to access your payment processor. ProxyAddress
character varying(60)
String
Proxy port Proxy port Port of your proxy server The Proxy Port identifies the port of your proxy server. ProxyPort
numeric(10)
Integer
Proxy logon Proxy logon Logon of your proxy server The Proxy Logon identifies the Logon ID for your proxy server. ProxyLogon
character varying(60)
String
Proxy password Proxy password Password of your proxy server The Proxy Password identifies the password for your proxy server. ProxyPassword
character varying(60)
String
File Name File Naam Name of the local file or URL Name of a file in the local directory space - or URL (file://.., http://.., ftp://..) FileName
character varying(120)
String
Statement Loader Class Statement Loader Class Class name of the bank statement loader The name of the actual bank statement loader implementing the interface org.compiere.impexp.BankStatementLoaderInterface StmtLoaderClass
character varying(60)
String
Date Format Date Format Date format used in the input format The date format is usually detected, but sometimes need to be defined. DateFormat
character varying(20)
String
Date last run Date last run Date the process was last run. The Date Last Run indicates the last time that a process was run. DateLastRun
timestamp without time zone
Date+Time




TAB: Accounting

Beschrijving: Maintain Accounting Data


Help The Accounting Tab is used to define the accounts used for transactions with this Bank.


Bestand:Bank - Accounting - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Bank Account Bank Rekening (Bank Account) Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID
numeric(10) NOT NULL
Table Direct
Accounting Schema Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID
numeric(10) NOT NULL
Table Direct
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Bank Asset Bank Asset Bank Asset Account The Bank Asset Account identifies the account to be used for booking changes to the balance in this bank account B_Asset_Acct
numeric(10) NOT NULL
Account
Bank In Transit Bank In Transit Bank In Transit Account The Bank in Transit Account identifies the account to be used for funds which are in transit. B_InTransit_Acct
numeric(10) NOT NULL
Account
Unallocated Cash Unallocated Cash Unallocated Cash Clearing Account Receipts not allocated to Invoices B_UnallocatedCash_Acct
numeric(10) NOT NULL
Account
Bank Unidentified Receipts Bank Unidentified Receipts Bank Unidentified Receipts Account The Bank Unidentified Receipts Account identifies the account to be used when recording receipts that can not be reconciled at the present time. B_Unidentified_Acct
numeric(10)
Account
Payment Selection Payment Selection AP Payment Selection Clearing Account null B_PaymentSelect_Acct
numeric(10) NOT NULL
Account
Bank Expense Bank Expense Bank Expense Account The Bank Expense Account identifies the account to be used for recording charges or fees incurred from this Bank. B_Expense_Acct
numeric(10)
Account
Bank Interest Expense Bank Interest Expense Bank Interest Expense Account The Bank Interest Expense Account identifies the account to be used for recording interest expenses. B_InterestExp_Acct
numeric(10) NOT NULL
Account
Bank Interest Revenue Bank Interest Revenue Bank Interest Revenue Account The Bank Interest Revenue Account identifies the account to be used for recording interest revenue from this Bank. B_InterestRev_Acct
numeric(10) NOT NULL
Account
Bank Revaluation Gain Bank Revaluation Gain Bank Revaluation Gain Account The Bank Revaluation Gain Account identifies the account to be used for recording gains that are recognized when converting currencies. B_RevaluationGain_Acct
numeric(10)
Account
Bank Revaluation Loss Bank Revaluation Loss Bank Revaluation Loss Account The Bank Revaluation Loss Account identifies the account to be used for recording losses that are recognized when converting currencies. B_RevaluationLoss_Acct
numeric(10)
Account
Bank Settlement Gain Bank Settlement Gain Bank Settlement Gain Account The Bank Settlement Gain account identifies the account to be used when recording a currency gain when the settlement and receipt currency are not the same. B_SettlementGain_Acct
numeric(10)
Account
Bank Settlement Loss Bank Settlement Loss Bank Settlement Loss Account The Bank Settlement loss account identifies the account to be used when recording a currency loss when the settlement and receipt currency are not the same. B_SettlementLoss_Acct
numeric(10)
Account


Contributions / Posts