Import Bank Statement (Window ID-277)

From iDempiere en

Table of Contents

Window: Import Bank Statement

Description: Import Bank Statements

Help:

Tab: Bank Statement

Description: Import Bank Statement

Help:

Import Bank Statement - Bank Statement - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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 here

Details 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


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.