Window: Import Bank Statement
[Created: 07/06/2003 - Updated: 03/06/2021 ]
Description: Import Bank Statements
Help:
Tab: Bank Statement
[Created: 07/06/2003 - Updated: 02/01/2000 ]
Description: Import Bank Statement
Help:
Tab Level: 0
Table 10: Bank Statement - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Import Bank Statement | Import of the Bank Statement | i_bankstatement.I_BankStatement_ID numeric(10) ID | |
| Imported | Has this import been processed | The Imported check box indicates if this import has been processed. | i_bankstatement.I_IsImported character(1) Yes-No |
| 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 | i_bankstatement.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. | i_bankstatement.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_bankstatement.I_ErrorMsg character varying(2000) String |
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | i_bankstatement.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | i_bankstatement.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. | i_bankstatement.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | i_bankstatement.Description character varying(255) String |
| Routing No | Bank Routing Number | The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. | i_bankstatement.RoutingNo character varying(20) String |
| Bank Account No | Bank Account Number | i_bankstatement.BankAccountNo character varying(20) String | |
| IBAN | International Bank Account Number | If your bank provides an International Bank Account Number, enter it hereDetails 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 iDempiere. | i_bankstatement.IBAN character varying(40) String |
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | i_bankstatement.C_BankAccount_ID numeric(10) Table Direct |
| Statement date | Date of the statement | The Statement Date field defines the date of the statement. | i_bankstatement.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. | i_bankstatement.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. | i_bankstatement.ReferenceNo character varying(255) String |
| Line Description | Description of the Line | i_bankstatement.LineDescription character varying(1000) String | |
| Statement Line Date | Date of the Statement Line | i_bankstatement.StatementLineDate timestamp without time zone 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. | i_bankstatement.DateAcct timestamp without time zone Date |
| Effective date | Date when money is available | The Effective Date indicates the date that money is available from the bank. | i_bankstatement.ValutaDate timestamp without time zone Date |
| Reversal | This is a reversing transaction | The Reversal check box indicates if this is a reversal of a prior transaction. | i_bankstatement.IsReversal character(1) Yes-No |
| ISO Currency Code | Three letter ISO 4217 Code of the Currency | For details - http://www.unece.org/trade/rec/rec09en.htm | i_bankstatement.ISO_Code character(3) String |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | i_bankstatement.C_Currency_ID numeric(10) Table Direct |
| Transaction Amount | Amount of a transaction | The Transaction Amount indicates the amount for a single transaction. | i_bankstatement.TrxAmt numeric Amount |
| Statement amount | Statement Amount | The Statement Amount indicates the amount of a single statement line. | i_bankstatement.StmtAmt numeric Amount |
| Charge Name | Name of the Charge | i_bankstatement.ChargeName character varying(60) String | |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | i_bankstatement.C_Charge_ID numeric(10) Table Direct |
| Interest Amount | Interest Amount | The Interest Amount indicates any interest charged or received on a Bank Statement. | i_bankstatement.InterestAmt numeric Amount |
| Charge amount | Charge Amount | The Charge Amount indicates the amount for an additional charge. | i_bankstatement.ChargeAmt numeric Amount |
| Memo | Memo Text | i_bankstatement.Memo character varying(4000) String | |
| Business Partner Key | Key of the Business Partner | i_bankstatement.BPartnerValue character varying(40) String | |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | i_bankstatement.C_BPartner_ID numeric(10) Search |
| Invoice Document No | Document Number of the Invoice | i_bankstatement.InvoiceDocumentNo character varying(30) String | |
| Invoice | Invoice Identifier | The Invoice Document. | i_bankstatement.C_Invoice_ID numeric(10) Search |
| Payment Document No | Document number of the Payment | i_bankstatement.PaymentDocumentNo character varying(30) String | |
| Payment | Payment identifier | The Payment is a unique identifier of this payment. | i_bankstatement.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. | i_bankstatement.TrxType character varying(20) List |
| Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | i_bankstatement.MatchStatement character(1) Button | |
| Import Bank Statement | Import Bank Statement | The Parameters are default values for null import record values, they do not overwrite any data. | i_bankstatement.Processing character(1) Button |
| Create Payment | Create Payment from Bank Statement Info | i_bankstatement.CreatePayment character(1) Button | |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | i_bankstatement.Processed character(1) Yes-No |
| EFT Statement Reference | Electronic Funds Transfer Statement Reference | Information from EFT media | i_bankstatement.EftStatementReference character varying(60) String |
| EFT Statement Date | Electronic Funds Transfer Statement Date | Information from EFT media | i_bankstatement.EftStatementDate timestamp without time zone Date |
| EFT Trx ID | Electronic Funds Transfer Transaction ID | Information from EFT media | i_bankstatement.EftTrxID character varying(40) String |
| EFT Trx Type | Electronic Funds Transfer Transaction Type | Information from EFT media | i_bankstatement.EftTrxType character varying(255) String |
| EFT Check No | Electronic Funds Transfer Check No | Information from EFT media | i_bankstatement.EftCheckNo character varying(20) String |
| EFT Reference | Electronic Funds Transfer Reference | Information from EFT media | i_bankstatement.EftReference character varying(255) String |
| EFT Memo | Electronic Funds Transfer Memo | Information from EFT media | i_bankstatement.EftMemo character varying(4000) String |
| EFT Payee | Electronic Funds Transfer Payee information | Information from EFT media | i_bankstatement.EftPayee character varying(255) String |
| EFT Payee Account | Electronic Funds Transfer Payee Account Information | Information from EFT media | i_bankstatement.EftPayeeAccount character varying(40) String |
| EFT Statement Line Date | Electronic Funds Transfer Statement Line Date | Information from EFT media | i_bankstatement.EftStatementLineDate timestamp without time zone Date |
| EFT Effective Date | Electronic Funds Transfer Valuta (effective) Date | Information from EFT media | i_bankstatement.EftValutaDate timestamp without time zone Date |
| EFT Currency | Electronic Funds Transfer Currency | Information from EFT media | i_bankstatement.EftCurrency character varying(20) String |
| EFT Amount | Electronic Funds Transfer Amount | i_bankstatement.EftAmt numeric Amount |