银行对帐单 (窗口 ID-194)
窗口: 银行对帐单
描述: 银行对帐单处理
幫助: The Process Bank Statements window allows you to reconcile your Bank Statements. You can either enter the line items from the statement in the Statement Line tab or select the 'Create From' button to automatically generate the statement from all unreconciled payments to this bank account. Once you have completed reconciling, select the 'Process Statement' button to mark the payments as reconciled and update the appropriate GL accounts.
TAB: 银行对帐单
描述: 银行对帐单
幫助 The Bank Statement Tab defines the Bank Statement to be reconciled.
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 |
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 |
Statement date | 对帐单日期 | Date of processing a statement | The Statement Date field defines the date of the statement being processed. | StatementDate timestamp without time zone NOT NULL Date |
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 |
Manual | 手工 | 这是手工的程序 | The Manual check box indicates if the process will done manually. | IsManual character(1) NOT NULL Yes-No |
Beginning Balance | 期初余款 | Balance prior to any transactions | The Beginning Balance is the balance prior to making any adjustments for payments or disbursements. | BeginningBalance numeric Amount |
Create lines from | 产生明细 | Process which will generate a new document lines based on an existing document | The Create From process will create a new document based on information in an existing document selected by the user. | CreateFrom character(1) Button |
Statement difference | 对帐单差额 | Difference between statement ending balance and actual ending balance | The Statement Difference reflects the difference between the Statement Ending Balance and the Actual Ending Balance. | StatementDifference numeric Amount |
Match Bank Statement | Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | null | MatchStatement character(1) Button |
Ending balance | 终止余款 | 终止或结束余款 | The Ending Balance is the result of adjusting the Beginning Balance by any payments or disbursements. | EndingBalance numeric NOT NULL Amount |
EFT Statement Reference | EFT Statement Reference | Electronic Funds Transfer Statement Reference | Information from EFT media | EftStatementReference character varying(60) String |
EFT Statement Date | EFT Statement Date | Electronic Funds Transfer Statement Date | Information from EFT media | EftStatementDate timestamp without time zone Date |
Document Status | 文档状态 | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | DocStatus character(2) NOT NULL List |
Process Statement | 对帐单处理 | null | null | DocAction character(2) NOT NULL Button |
Approved | 已批准 | 指示该文档是否需要批准 | The Approved checkbox indicates if this document requires approval before it can be processed. | IsApproved character(1) NOT NULL Yes-No |
Posted | 已过帐 | 过帐状态 | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | Posted character(1) NOT NULL Button |
TAB: 对帐单明细
描述: 对帐单明细
幫助 The Statement Line Tab defines the individual line items on the Bank Statement. They can be entered manually or generated from payments entered.
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 Statement | 银行对帐单 | 银行对帐单 | The Bank Statement identifies a unique Bank Statement for a defined time period. The statement defines all transactions that occurred | C_BankStatement_ID numeric(10) NOT NULL Table Direct |
Line No | 明细号 | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line numeric(10) NOT NULL Integer |
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 |
Manual | 手工 | 这是手工的程序 | The Manual check box indicates if the process will done manually. | IsManual character(1) NOT NULL Yes-No |
Statement Line Date | Statement Line Date | Date of the Statement Line | null | StatementLineDate timestamp without time zone NOT NULL Date |
Account Date | 记账日期 | 记账日期 | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document | DateAcct timestamp without time zone NOT NULL Date |
Effective date | 有效的日期 | 付款已到期日 | The Effective Date indicates the date that money is available from the bank. | ValutaDate timestamp without time zone NOT NULL Date |
Statement amount | 对帐单金额 | 对帐单金额 | The Statement Amount indicates the amount of a single statement line. | StmtAmt numeric NOT NULL Amount |
Payment | 付款 | 付款标识符 | The Payment is a unique identifier of this payment. | C_Payment_ID numeric(10) Search |
Transaction Amount | 交易金额 | 一交易的金额 | The Transaction Amount indicates the amount for a single transaction. | TrxAmt numeric NOT NULL Amount |
Currency | 货币 | 币种为该笔记录 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) NOT NULL Table Direct |
Charge amount | 费用金额 | 费用金额 | The Charge Amount indicates the amount for an additional charge. | ChargeAmt numeric NOT NULL Amount |
Charge | 费用 | 附加的文件收费 | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Charge_ID numeric(10) Table Direct |
Interest Amount | 关心点金额 | 关心点金额 | The Interest Amount indicates any interest charged or received on a Bank Statement. | InterestAmt numeric NOT NULL Amount |
Reference No | 引用号 | Your customer or vendor number at the Business Partner's site 你在业务伙伴那里的客户号或供应商号。 | The reference number can be printed on orders and invoices to allow your business partner to faster identify your records. | ReferenceNo character varying(40) String |
Memo | 备忘录 | 备忘录文本 | null | Memo character varying(255) String |
Match Bank Statement | Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | null | MatchStatement character(1) Button |
Create Payment | 产生付款单 | Create Payment from Bank Statement Info | null | CreatePayment character(1) Button |
Business Partner | 业务伙伴 | 标识业务伙伴 | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID numeric(10) Search |
Invoice | 发票 | 开发票标识符 | The Invoice ID uniquely identifies an Invoice Document. | C_Invoice_ID numeric(10) Search |
EFT Trx ID | EFT Trx ID | Electronic Funds Transfer Transaction ID | Information from EFT media | EftTrxID character varying(40) String |
EFT Trx Type | EFT Trx Type | Electronic Funds Transfer Transaction Type | Information from EFT media | EftTrxType character varying(20) String |
EFT Check No | EFT Check No | Electronic Funds Transfer Check No | Information from EFT media | EftCheckNo character varying(20) String |
EFT Reference | EFT Reference | Electronic Funds Transfer Reference | Information from EFT media | EftReference character varying(60) String |
EFT Memo | EFT Memo | Electronic Funds Transfer Memo | Information from EFT media | EftMemo character varying(2000) String |
EFT Payee | EFT Payee | Electronic Funds Transfer Payee information | Information from EFT media | EftPayee character varying(255) String |
EFT Payee Account | EFT Payee Account | Electronic Funds Transfer Payyee Account Information | Information from EFT media | EftPayeeAccount character varying(40) String |
EFT Statement Line Date | EFT Statement Line Date | Electronic Funds Transfer Statement Line Date | Information from EFT media | EftStatementLineDate timestamp without time zone Date |
EFT Effective Date | EFT Effective Date | Electronic Funds Transfer Valuta (effective) Date | Information from EFT media | EftValutaDate timestamp without time zone Date |
EFT Currency | EFT Currency | Electronic Funds Transfer Currency | Information from EFT media | EftCurrency character varying(20) String |
EFT Amount | EFT Amount | Electronic Funds Transfer Amount | null | EftAmt numeric Amount |