عرض مصدر قالب:Import Bank Statement (نافذة 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)]]
 


== نافذة: Import Bank Statement ==

'''وصف:''' Import Bank Statements

'''مساعدة:''' null

 

    
    
=== TAB: Bank Statement ===

'''وصف:''' Import Bank Statement 


'''مساعدة''' null


[[image:Import Bank Statement - Bank Statement - نافذة (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
|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<br>character(1)<br>Yes-No
|-valign="top" 
|-

|-valign="top" 
|Import Bank Statement
|Import Bank Statement
|Import of the Bank Statement 
|null
|I_BankStatement_ID<br>numeric(10) NOT NULL<br>ID
|-valign="top" 
|-

|-valign="top" 
|Imported
|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
|Bank Statement
|Bank Statement of account 
|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
|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
|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
|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
|Description
|Optional short description of the record 
|A description is limited to 255 characters.
|Description<br>character varying(255)<br>String
|-valign="top" 
|-

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

|-valign="top" 
|Bank Account No
|Bank Account No
|Bank Account Number 
|null
|BankAccountNo<br>character varying(20)<br>String
|-valign="top" 
|-

|-valign="top" 
|Bank Account
|Bank Account
|Account at the Bank 
|The Bank Account identifies an account at this Bank.
|C_BankAccount_ID<br>numeric(10)<br>Table Direct
|-valign="top" 
|-

|-valign="top" 
|Statement date
|Statement date
|Date of the statement 
|The Statement Date field defines the date of the statement.
|StatementDate<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Line No
|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
|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
|Line Description
|Description of the Line 
|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
|Account Date
|Accounting Date 
|The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.
|DateAcct<br>timestamp without time zone<br>Date
|-valign="top" 
|-

|-valign="top" 
|Effective date
|Effective date
|Date when money is available 
|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
|Reversal
|This is a reversing transaction 
|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 Currency Code
|Three letter ISO 4217 Code of the Currency 
|For details - http://www.unece.org/trade/rec/rec09en.htm
|ISO_Code<br>character(3)<br>String
|-valign="top" 
|-

|-valign="top" 
|Currency
|Currency
|The Currency for this record 
|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
|Transaction Amount
|Amount of a transaction 
|The Transaction Amount indicates the amount for a single transaction.
|TrxAmt<br>numeric<br>Amount
|-valign="top" 
|-

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

|-valign="top" 
|Charge Name
|Charge Name
|Name of the Charge 
|null
|ChargeName<br>character varying(60)<br>String
|-valign="top" 
|-

|-valign="top" 
|Charge
|Charge
|Additional document charges 
|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
|Interest Amount
|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
|Charge amount
|Charge Amount 
|The Charge Amount indicates the amount for an additional charge.
|ChargeAmt<br>numeric<br>Amount
|-valign="top" 
|-

|-valign="top" 
|Memo
|Memo
|Memo Text 
|null
|Memo<br>character varying(255)<br>String
|-valign="top" 
|-

|-valign="top" 
|Business Partner Key
|Business Partner Key
|Key of the Business Partner 
|null
|BPartnerValue<br>character varying(40)<br>String
|-valign="top" 
|-

|-valign="top" 
|Business Partner 
|Business Partner 
|Identifies a 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
|Invoice Document No
|Document Number of the Invoice 
|null
|InvoiceDocumentNo<br>character varying(30)<br>String
|-valign="top" 
|-

|-valign="top" 
|Invoice
|Invoice
|Invoice Identifier 
|The 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
|Payment
|Payment identifier 
|The Payment is a unique identifier of this payment.
|C_Payment_ID<br>numeric(10)<br>Search
|-valign="top" 
|-

|-valign="top" 
|Transaction Type
|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
|Create Payment from Bank Statement Info 
|null
|CreatePayment<br>character(1)<br>Button
|-valign="top" 
|-

|-valign="top" 
|Processed
|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 Payee 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" 
|-
|}