银行 (窗口 ID-158)
窗口: 银行
描述: 维护银行
幫助: The Bank Window is used to define the banks and accounts associated with an organization or business partner
TAB: 银行
描述: 维护银行
幫助 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
File:银行 - 银行 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 | 名称 | 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 | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | 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 | 地址 | 位置或地址 | The Location Address field defines the location of an entity. | C_Location_ID numeric(10) Location (Address) |
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 character(1) NOT NULL Yes-No |
Routing No | 路由号 | 银行工作路明细排定数字 | 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 (Society of Worldwide Interbank Financial Telecommunications) | The SWIFT code is an identifier of a Bank | SwiftCode character varying(20) String |
TAB: 帐户
描述: 维护帐户
幫助 The Account Tab is used to define one or more accounts for a Bank. Each account has a unique Account No and Currency.
File:银行 - 帐户 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | 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 | 名称 | 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 | 银行 | 银行 | 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 | 帐户号 | 帐户数字 | The Account Number indicates the Number assigned to this 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 | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | 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 | 缺省值 | 缺省值 | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) NOT NULL Yes-No |
Currency | 货币 | 币种为该笔记录 | 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 | 银行帐户类型 | 银行帐户类型 | 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 | 信用额度 | 信用的金额允许 | 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 | 当前余款 | 当前余款 | The Current Balance field indicates the current balance in this account. | CurrentBalance numeric NOT NULL Number |
TAB: 银行帐户文件
描述: Maintain Bank Account Documents
幫助 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.
File:银行 - 银行帐户文件 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Bank Account Document | 银行帐户文件 | Checks, Transfers, etc. | Bank documents, you generate or track | C_BankAccountDoc_ID numeric(10) NOT NULL ID |
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 | 银行帐户 | 在银行的帐户 | The Bank Account identifies an account at this Bank. | C_BankAccount_ID numeric(10) NOT NULL Table Direct |
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 | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | 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 | 付款规则 | 你如何支付发票 | The Payment Rule indicates the method of invoice payment. | PaymentRule character(1) NOT NULL List |
Current Next | 现在的下一个 | 下一个用到的数字 | The Current Next indicates the next number to use for this document | CurrentNext numeric(10) NOT NULL Integer |
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
描述: Maintain Bank Account Payment Processors
幫助 null
File:银行 - Bank Account Processor - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 | 银行帐户 | 在银行的帐户 | The Bank Account identifies an account at this Bank. | C_BankAccount_ID numeric(10) NOT NULL Table Direct |
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 | 有效 | 本记录有效 | 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: 银行对账单加载器
描述: Definition of Bank Statement Loader (SWIFT, OFX)
幫助 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
File:银行 - 银行对账单加载器 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Bank Statement Loader | Bank Statement Loader | Definition of Bank Statement Loader (SWIFT, OFX) | The loader definition privides the parameters to load bank statements from EFT formats like SWIFT (MT940) or OFX | C_BankStatementLoader_ID numeric(10) NOT NULL ID |
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 | 银行帐户 | 在银行的帐户 | The Bank Account identifies an account at this Bank. | C_BankAccount_ID numeric(10) NOT NULL Table Direct |
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 | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | 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 | 帐户号 | 帐户数字 | The Account Number indicates the Number assigned to this account | AccountNo character varying(20) String |
PIN | PIN | Personal Identification Number | null | PIN character varying(20) String |
User ID | 用户ID | 用户ID | The User ID identifies a user and allows access to records or processes. | UserID character varying(60) String |
Password | 口令 | 任意长度的口令(区分大小写) | The Password indicates the Password for this User Id. Passwords are required to identify authorized users. | Password character varying(60) String |
Host Address | 主机地址 | 主人地址网址或 DNS | The Host Address identifies the URL or DNS of the target host | HostAddress character varying(60) String |
Host port | 主机端口 | 主办沟通港口 | The Host Port identifies the port to communicate with the host. | HostPort numeric(10) Integer |
Proxy address | 代理地址 | 代理服务器的地址 | 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 | 代理端口 | 你的代理服务器的港口 | The Proxy Port identifies the port of your proxy server. | ProxyPort numeric(10) Integer |
Proxy logon | 代理注册 | 你的代理服务器注册 | The Proxy Logon identifies the Logon ID for your proxy server. | ProxyLogon character varying(60) String |
Proxy password | 代理密码 | 你的代理服务器的密码 | The Proxy Password identifies the password for your proxy server. | ProxyPassword character varying(60) String |
File Name | File Name | 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 imput format | The date format is usually detected, but sometimes need to be defined. | DateFormat character varying(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 timestamp without time zone Date+Time |
TAB: 会计
描述: 维护会计数据
幫助 The Accounting Tab is used to define the accounts used for transactions with this Bank.
File:银行 - 会计 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 | 银行帐户 | 在银行的帐户 | The Bank Account identifies an account at this Bank. | C_BankAccount_ID numeric(10) NOT NULL Table Direct |
Accounting Schema | 会计模式 | 帐户的规则 | 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 | 有效 | 本记录有效 | 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 | 银行资产 | 银行资产帐户 | 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 | 转帐中银行 | 转帐中银行帐户 | 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 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 | 付款选择 | 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 | 银行利息费用 | 银行利息费用帐户 | 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 | 银行利息收入 | 银行利息收入帐户 | 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 |