ManPageW Bank
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Bank
Description : Maintain Bank
Help : The Bank Window is used to define the banks and accounts associated with an organization or business partner
Tab: Bank
Description : 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
Table Name : C_Bank
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| 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
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | 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
CHAR(1) YesNo |
| Address | Location or Address | The Location / Address field defines the location of an entity. | C_Location_ID
NUMBER(10) Location |
| Own 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
CHAR(1) YesNo |
| 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
NVARCHAR2(20) String |
| 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
NVARCHAR2(20) String |
Tab: Account
Description : 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.
Table Name : C_BankAccount
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| Account No | Account Number | The Account Number indicates the Number assigned to this bank account. | AccountNo
NVARCHAR2(20) String |
| 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
NVARCHAR2(40) String |
| 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
NVARCHAR2(40) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | 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
CHAR(1) YesNo |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault
CHAR(1) YesNo |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
| 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
CHAR(1) List |
| Credit limit | Amount of Credit allowed | The Credit Limit field indicates the credit limit for this account. | CreditLimit
NUMBER Number |
| Current balance | Current Balance | The Current Balance field indicates the current balance in this account. | CurrentBalance
NUMBER Number |
Tab: Bank Account Document
Description : 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.
Table Name : C_BankAccountDoc
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | C_BankAccount_ID
NUMBER(10) TableDir |
| 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
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | 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
CHAR(1) YesNo |
| Payment Rule | How you pay the invoice | The Payment Rule indicates the method of invoice payment. | PaymentRule
CHAR(1) List |
| Current Next | The next number to be used | The Current Next indicates the next number to use for this document | CurrentNext
NUMBER(10) Integer |
| Check Print Format | Print Format for printing Checks | You need to define a Print Format to print the document. | Check_PrintFormat_ID
NUMBER(10) Table |
Tab: Payment Processor
Description : Processor for online payments
Help : The Electronic Payments Tab is used to define the parameters for the processing of electronic payments. If no currency is defined, all currencies are accepted. If a minumum amount is defined (or not zero), the payment processor is only used if the payment amount is equal or higher than the minumum amount.
The class needs to implement org.compiere.model.PaymentProcessor
Table Name : C_PaymentProcessor
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | C_BankAccount_ID
NUMBER(10) TableDir |
| 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
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | 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
CHAR(1) YesNo |
| Host Address | Host Address URL or DNS | The Host Address identifies the URL or DNS of the target host | HostAddress
NVARCHAR2(60) String |
| Host port | Host Communication Port | The Host Port identifies the port to communicate with the host. | HostPort
NUMBER(10) Integer |
| Partner ID | Partner ID or Account for the Payment Processor | Partner ID (Verisign) or Account ID (Optimal) | PartnerID
NVARCHAR2(60) String |
| Vendor ID | Vendor ID for the Payment Processor | VendorID
NVARCHAR2(60) String | |
| User ID | User ID or account number | The User ID identifies a user and allows access to records or processes. | UserID
NVARCHAR2(60) String |
| 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
NVARCHAR2(60) String |
| 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
NVARCHAR2(60) String |
| Proxy port | Port of your proxy server | The Proxy Port identifies the port of your proxy server. | ProxyPort
NUMBER(10) Integer |
| Proxy logon | Logon of your proxy server | The Proxy Logon identifies the Logon ID for your proxy server. | ProxyLogon
NVARCHAR2(60) String |
| Proxy password | Password of your proxy server | The Proxy Password identifies the password for your proxy server. | ProxyPassword
NVARCHAR2(60) String |
| Accept MasterCard | Accept Master Card | Indicates if Master Cards are accepted | AcceptMC
CHAR(1) YesNo |
| Accept Visa | Accept Visa Cards | Indicates if Visa Cards are accepted | AcceptVisa
CHAR(1) YesNo |
| Accept AMEX | Accept American Express Card | Indicates if American Express Cards are accepted | AcceptAMEX
CHAR(1) YesNo |
| Accept Diners | Accept Diner's Club | Indicates if Diner's Club Cards are accepted | AcceptDiners
CHAR(1) YesNo |
| Accept Corporate | Accept Corporate Purchase Cards | Indicates if Corporate Purchase Cards are accepted | AcceptCorporate
CHAR(1) YesNo |
| Accept Discover | Accept Discover Card | Indicates if Discover Cards are accepted | AcceptDiscover
CHAR(1) YesNo |
| Accept Direct Deposit | Accept Direct Deposit (payee initiated) | Indicates if Direct Deposits (wire transfers, etc.) are accepted. Direct Deposits are initiated by the payee. | AcceptDirectDeposit
CHAR(1) YesNo |
| Accept Direct Debit | Accept Direct Debits (vendor initiated) | Accept Direct Debit transactions. Direct Debits are initiated by the vendor who has permission to deduct amounts from the payee's account. | AcceptDirectDebit
CHAR(1) YesNo |
| Accept Electronic Check | Accept ECheck (Electronic Checks) | Indicates if EChecks are accepted | AcceptCheck
CHAR(1) YesNo |
| Accept ATM | Accept Bank ATM Card | Indicates if Bank ATM Cards are accepted | AcceptATM
CHAR(1) YesNo |
| Minimum Amt | Minumum Amout in Document Currency | MinimumAmt
NUMBER Amount | |
| Only Currency | Restrict accepting only this currency | The Only Currency field indicates that this bank account accepts only the currency identified here. | C_Currency_ID
NUMBER(10) TableDir |
| Require CreditCard Verification Code | Require 3/4 digit Credit Verification Code | The Require CC Verification checkbox indicates if this bank accounts requires a verification number for credit card transactions. | RequireVV
CHAR(1) YesNo |
| Sequence | Document Sequence | The Sequence defines the numbering sequence to be used for documents. | AD_Sequence_ID
NUMBER(10) Table |
| Payment Processor Class | Payment Processor Java Class | Payment Processor class identifies the Java class used to process payments extending the org.compiere.model.PaymentProcessor class. Example implementations are Optimal Payments: org.compiere.model.PP_Optimal or Verisign: org.compiere.model.PP_PayFlowPro |
PayProcessorClass
NVARCHAR2(60) String |
| Commission % | Commission stated as a percentage | The Commission indicates (as a percentage) the commission to be paid. | Commission
NUMBER Number |
| Cost per transaction | Fixed cost per transaction | The Cost per Transaction indicates the fixed cost per to be charged per transaction. | CostPerTrx
NUMBER CostsPrices |
Tab: Statement Loader
Description : 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
Table Name : C_BankStatementLoader
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | C_BankAccount_ID
NUMBER(10) TableDir |
| 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
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Active | 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
CHAR(1) YesNo |
| Financial Institution ID | The ID of the Financial Institution / Bank | Depending on the loader, it might require a ID of the financial institution | FinancialInstitutionID
NVARCHAR2(20) String |
| Branch ID | Bank Branch ID | Dependent on the loader, you may have to provide a bank branch ID | BranchID
NVARCHAR2(20) String |
| Account No | Account Number | The Account Number indicates the Number assigned to this bank account. | AccountNo
NVARCHAR2(20) String |
| PIN | Personal Identification Number | PIN
NVARCHAR2(20) String | |
| User ID | User ID or account number | The User ID identifies a user and allows access to records or processes. | UserID
NVARCHAR2(60) String |
| 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
NVARCHAR2(60) String |
| Host Address | Host Address URL or DNS | The Host Address identifies the URL or DNS of the target host | HostAddress
NVARCHAR2(60) String |
| Host port | Host Communication Port | The Host Port identifies the port to communicate with the host. | HostPort
NUMBER(10) Integer |
| 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
NVARCHAR2(60) String |
| Proxy port | Port of your proxy server | The Proxy Port identifies the port of your proxy server. | ProxyPort
NUMBER(10) Integer |
| Proxy logon | Logon of your proxy server | The Proxy Logon identifies the Logon ID for your proxy server. | ProxyLogon
NVARCHAR2(60) String |
| Proxy password | Password of your proxy server | The Proxy Password identifies the password for your proxy server. | ProxyPassword
NVARCHAR2(60) String |
| File Name | Name of the local file or URL | Name of a file in the local directory space - or URL (file://.., http://.., ftp://..) | FileName
NVARCHAR2(120) String |
| 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
NVARCHAR2(60) String |
| Date Format | Date format used in the imput format | The date format is usually detected, but sometimes need to be defined. | DateFormat
NVARCHAR2(20) String |
| Date last run | Date the process was last run. | The Date Last Run indicates the last time that a process was run. | DateLastRun
DATE DateTime |
Tab: Accounting
Description : Maintain Accounting Data
Help : The Accounting Tab is used to define the accounts used for transactions with this Bank.
Table Name : C_BankAccount_Acct
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| 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
NUMBER(10) TableDir |
| 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
NUMBER(10) TableDir |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | C_BankAccount_ID
NUMBER(10) TableDir |
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID
NUMBER(10) TableDir |
| Active | 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
CHAR(1) YesNo |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| Unallocated Cash | Unallocated Cash Clearing Account | Receipts not allocated to Invoices | B_UnallocatedCash_Acct
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| Payment Selection | AP Payment Selection Clearing Account | B_PaymentSelect_Acct
NUMBER(10) Account | |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
| 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
NUMBER(10) Account |
