查看“Template:导入银行对帐单 (窗口 ID-277 V1.0.0)”的源代码

[[en:Import Bank Statement (Window ID-277)]]
[[ar:Import Bank Statement (نافذة ID-277)]]
[[bg:Импортване на банково извлечение (прозорец ID-277)]]
[[da:Import Bank Statement (Vindue ID-277)]]
[[de:Import eines Bankauszugs (Fenster ID-277)]]
[[el:Εισαγωγή Παραστατικού Τράπεζας (παράθυρο ID-277)]]
[[es:Importar Estado de Cuenta (Ventana ID-277)]]
[[fr:Importation des relevés bancaires (Fenêtre ID-277)]]
[[hu:Bankkivonatok importálása (Aablak ID-277)]]
[[id:Import Bank Statement (jendela ID-277)]]
[[it:Importazione Estratto Conto Bancario (finestra ID-277)]]
[[ja:銀行取引明細書のインポート (ウィンドウ ID-277)]]
[[ms:Import Penyata Bank (tetingkap ID-277)]]
[[nl:Import Bank Statement (Venster ID-277)]]
[[pl:Import wyciągów bankowych (Okno ID-277)]]
[[pt:Importar Extracto Bancário (Janela ID-277)]]
[[ro:Import Extras bancar (fereastră ID-277)]]
[[ru:Импорт выписки (окно ID-277)]]
[[sr:Увоз извода из банке (прозор ID-277)]]
[[sv:Importera bankkontoutdrag (Fönster ID-277)]]
[[th:นำเข้าเอกสารสรุปรายการเดินบัญชี (หน้าต่าง ID-277)]]
[[tr:Import Bank Statement (pencere ID-277)]]
[[zh:导入银行对帐单 (窗口 ID-277)]]
 


== 窗口: 导入银行对帐单 ==

'''描述:''' 导入银行对帐单

'''幫助:''' null

 

    
    
=== TAB: 银行对帐单 ===

'''描述:''' 导入银行对帐单 


'''幫助''' null


[[image:导入银行对帐单 - 银行对帐单 - 窗口 (iDempiere 1.0.0).png]]




     


{| border="1" cellpadding="5" cellspacing="0" 
|- 
|-valign="top" 
!style="background:#efefef;" |'''''名稱''''' 
!style="background:#efefef;" |'''''名稱''''' 
!style="background:#efefef;" |'''''描述''''' 
!style="background:#efefef;" |'''''幫助''''' 
!style="background:#efefef;" |'''''產品規格''''' 
|-valign="top" 
|- 


|-valign="top" 
|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<br>character(1)<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Import Bank Statement
|导入银行对帐单
|银行对帐单的导入 
|null
|I_BankStatement_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-

|-valign="top" 
|Imported
|已导入
|Has this import been processed 
|The Imported check box indicates if this import has been processed.
|I_IsImported<br>character(1) NOT NULL<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|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<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Bank statement line
|银行对帐单明细
|Line on a statement from this Bank 
|The Bank Statement Line identifies a unique transaction (Payment, Withdrawal, Charge) for the defined time period at this Bank.
|C_BankStatementLine_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Import Error Message
|导入错误信息
|Messages generated from import process 
|The Import Error Message displays any error messages generated during the import process.
|I_ErrorMsg<br>character varying(2000)<br>String
|-valign="top" 
|-

|-valign="top" 
|Client
|客户
|安装此软件的客户 
|客户是一个公司或者合法的实体。你不能在客户之间共享数据。
|AD_Client_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|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<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|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<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|Description
|描述
|该记录的可选描述 
|描述最多为 255 个字符。
|Description<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Routing No
|路由号
|银行工作路明细排定数字 
|The Bank Routing Number (ABA Number) identifies a legal Bank.  It is used in routing checks and electronic transactions.
|RoutingNo<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|Bank Account No
|银行帐户号
|银行帐户号 
|null
|BankAccountNo<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|Bank Account
|银行帐户
|在银行的帐户 
|The Bank Account identifies an account at this Bank.
|C_BankAccount_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Statement date
|对帐单日期
|Date of processing a statement 
|The Statement Date field defines the date of the statement being processed.
|StatementDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|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<br>numeric(10)<br>Integer
|-valign="top" 
|-

|-valign="top" 
|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<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Line Description
|行描述
|明细的描述 
|null
|LineDescription<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Statement Line Date
|Statement Line Date
|Date of the Statement Line 
|null
|StatementLineDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Account Date
|记账日期
|记账日期 
|The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document
|DateAcct<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Effective date
|有效的日期
|付款已到期日 
|The Effective Date indicates the date that money is available from the bank.
|ValutaDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Reversal
|撤销(红冲)
|撤销(红冲)交易 
|The Reversal check box indicates if this is a reversal of a prior transaction.
|IsReversal<br>character(1)<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|ISO Currency Code
|ISO货币编码
|币种的 ISO 4217 编码 
|For details - http:  www.unece.org trade rec rec09en.htm
|ISO_Code<br>character(3)<br>String
|-valign="top" 
|-

|-valign="top" 
|Currency
|货币
|币种为该笔记录 
|Indicates the Currency to be used when processing or reporting on this record
|C_Currency_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Transaction Amount
|交易金额
|一交易的金额 
|The Transaction Amount indicates the amount for a single transaction.
|TrxAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Statement amount
|对帐单金额
|对帐单金额 
|The Statement Amount indicates the amount of a single statement line.
|StmtAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Charge Name
|费用名
|费用名 
|null
|ChargeName<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|Charge
|费用
|附加的文件收费 
|The Charge indicates a type of Charge (Handling, Shipping, Restocking)
|C_Charge_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Interest Amount
|关心点金额
|关心点金额 
|The Interest Amount indicates any interest charged or received on a Bank Statement.
|InterestAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Charge amount
|费用金额
|费用金额 
|The Charge Amount indicates the amount for an additional charge.
|ChargeAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Memo
|备忘录
|备忘录文本 
|null
|Memo<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Business Partner Key
|业务伙伴关键字
|业务伙伴的关键字 
|null
|BPartnerValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Business Partner 
|业务伙伴 
|标识业务伙伴 
|A Business Partner is anyone with whom you transact.  This can include Vendor, Customer, Employee or Salesperson
|C_BPartner_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Invoice Document No
|发票文件号
|Document Number of the Invoice 
|null
|InvoiceDocumentNo<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|Invoice
|发票
|开发票标识符 
|The Invoice ID uniquely identifies an Invoice Document.
|C_Invoice_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Payment Document No
|Payment Document No
|Document number of the Payment 
|null
|PaymentDocumentNo<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|Payment
|付款
|付款标识符 
|The Payment is a unique identifier of this payment.
|C_Payment_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Transaction Type
|交易类型
|Type of credit card transaction 
|The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company.
|TrxType<br>character varying(20)<br>List
|-valign="top" 
|-

|-valign="top" 
|Match Bank Statement
|Match Bank Statement
|Match Bank Statement Info to Business Partners, Invoices and Payments 
|null
|MatchStatement<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Import Bank Statement
|Import Bank Statement
|Import Bank Statement 
|The Parameters are default values for null import record values, they do not overwrite any data.
|Processing<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Create Payment
|产生付款单
|Create Payment from Bank Statement Info 
|null
|CreatePayment<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Processed
|已处理
|The document has been processed 
|The Processed checkbox indicates that a document has been processed.
|Processed<br>character(1)<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|EFT Statement Reference
|EFT Statement Reference
|Electronic Funds Transfer Statement Reference 
|Information from EFT media
|EftStatementReference<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Statement Date
|EFT Statement Date
|Electronic Funds Transfer Statement Date 
|Information from EFT media
|EftStatementDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|EFT Trx ID
|EFT Trx ID
|Electronic Funds Transfer Transaction ID 
|Information from EFT media
|EftTrxID<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Trx Type
|EFT Trx Type
|Electronic Funds Transfer Transaction Type 
|Information from EFT media
|EftTrxType<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Check No
|EFT Check No
|Electronic Funds Transfer Check No 
|Information from EFT media
|EftCheckNo<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Reference
|EFT Reference
|Electronic Funds Transfer Reference 
|Information from EFT media
|EftReference<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Memo
|EFT Memo
|Electronic Funds Transfer Memo 
|Information from EFT media
|EftMemo<br>character varying(2000)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Payee
|EFT Payee
|Electronic Funds Transfer Payee information 
|Information from EFT media
|EftPayee<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Payee Account
|EFT Payee Account
|Electronic Funds Transfer Payyee Account Information 
|Information from EFT media
|EftPayeeAccount<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Statement Line Date
|EFT Statement Line Date
|Electronic Funds Transfer Statement Line Date 
|Information from EFT media
|EftStatementLineDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|EFT Effective Date
|EFT Effective Date
|Electronic Funds Transfer Valuta (effective) Date 
|Information from EFT media
|EftValutaDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|EFT Currency
|EFT Currency
|Electronic Funds Transfer Currency 
|Information from EFT media
|EftCurrency<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|EFT Amount
|EFT Amount
|Electronic Funds Transfer Amount 
|null
|EftAmt<br>numeric<br>Amount
|-valign="top" 
|-
|}