導入銀行對帳單 (窗口 ID-277)
出自iDempiere zh
於 2013年5月3日 (五) 19:37 由 Wikirobot（討論 | 貢獻） 所做的修訂 （以“ <!-- Note to editors: DON'T MODIFY THIS CODE --> Category: 參考手冊 {{导入银行对帐单 (窗口 ID-277 V1.0.0)}} <!-- END Note to editors: DON'T MODIFY...”为内容创建页面）
窗口: 導入銀行對帳單
描述: 導入銀行對帳單
幫助: null
TAB: 銀行對帳單
描述: 導入銀行對帳單
幫助 null
File:導入銀行對帳單 - 銀行對帳單 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| 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) Yes-No |
| Import Bank Statement | 導入銀行對帳單 | 銀行對帳單的導入 | null | I_BankStatement_ID numeric(10) NOT NULL ID |
| Imported | 已導入 | Has this import been processed | The Imported check box indicates if this import has been processed. | I_IsImported character(1) NOT NULL Yes-No |
| 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) Search |
| 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 numeric(10) Search |
| Import Error Message | 導入錯誤信息 | Messages generated from import process | The Import Error Message displays any error messages generated during the import process. | I_ErrorMsg character varying(2000) String |
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) 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) 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) String |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| 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) String |
| Bank Account No | 銀行帳戶號 | 銀行帳戶號 | null | BankAccountNo character varying(20) String |
| Bank Account | 銀行帳戶 | 在銀行的帳戶 | The Bank Account identifies an account at this Bank. | C_BankAccount_ID numeric(10) Table Direct |
| Statement date | 對帳單日期 | Date of processing a statement | The Statement Date field defines the date of the statement being processed. | StatementDate timestamp without time zone Date |
| 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) Integer |
| 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 |
| Line Description | 行描述 | 明細的描述 | null | LineDescription character varying(255) String |
| Statement Line Date | Statement Line Date | Date of the Statement Line | null | StatementLineDate timestamp without time zone 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 Date |
| Effective date | 有效的日期 | 付款已到期日 | The Effective Date indicates the date that money is available from the bank. | ValutaDate timestamp without time zone Date |
| Reversal | 撤銷(紅沖) | 撤銷(紅沖)交易 | The Reversal check box indicates if this is a reversal of a prior transaction. | IsReversal character(1) Yes-No |
| ISO Currency Code | ISO貨幣編碼 | 幣種的 ISO 4217 編碼 | For details - http: www.unece.org trade rec rec09en.htm | ISO_Code character(3) String |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Transaction Amount | 交易金額 | 一交易的金額 | The Transaction Amount indicates the amount for a single transaction. | TrxAmt numeric Amount |
| Statement amount | 對帳單金額 | 對帳單金額 | The Statement Amount indicates the amount of a single statement line. | StmtAmt numeric Amount |
| Charge Name | 費用名 | 費用名 | null | ChargeName character varying(60) String |
| 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 Amount |
| Charge amount | 費用金額 | 費用金額 | The Charge Amount indicates the amount for an additional charge. | ChargeAmt numeric Amount |
| Memo | 備忘錄 | 備忘錄文本 | null | Memo character varying(255) String |
| Business Partner Key | 業務夥伴關鍵字 | 業務夥伴的關鍵字 | null | BPartnerValue character varying(40) String |
| 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 Document No | 發票文件號 | Document Number of the Invoice | null | InvoiceDocumentNo character varying(30) String |
| Invoice | 發票 | 開發票標識符 | The Invoice ID uniquely identifies an Invoice Document. | C_Invoice_ID numeric(10) Search |
| Payment Document No | Payment Document No | Document number of the Payment | null | PaymentDocumentNo character varying(30) String |
| Payment | 付款 | 付款標識符 | The Payment is a unique identifier of this payment. | C_Payment_ID numeric(10) Search |
| Transaction Type | 交易類型 | Type of credit card transaction | The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company. | TrxType character varying(20) List |
| Match Bank Statement | Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | null | MatchStatement character(1) Button |
| 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 character(1) Button |
| Create Payment | 產生付款單 | Create Payment from Bank Statement Info | null | CreatePayment character(1) Button |
| Processed | 已處理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed character(1) Yes-No |
| 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 |
| 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 |
.png){kind=link}