ManPageW ImportBankStatement es

From ADempiere ERP Wiki
Jump to navigationJump to search

Volver al Indice

¡Disfrútalo y ayuda a completarlo! Pero por favor, siempre respetando los derechos de autor.

Por favor, escriba sus contribuciones bajo la Sección Contribuciones


Window: Import Bank Statement[edit]

Description : Import Bank Statements

Help :



Tab: Bank Statement[edit]

Description : Import Bank Statement

Help :

Table Name  : I_BankStatement

ManPageW ImportBankStatement BankStatement.png

Fields

Name Description Help Technical Data
Import Bank Statement Import of the Bank Statement I_BankStatement_ID

NUMBER(10)

ID

Imported Has this import been processed The Imported check box indicates if this import has been processed. I_IsImported

CHAR(1)

YesNo

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

NUMBER(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

NUMBER(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

NVARCHAR2(2000)

String

Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

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

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(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. RoutingNo

NVARCHAR2(20)

String

Bank Account No Bank Account Number BankAccountNo

NVARCHAR2(20)

String

Bank Account Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID

NUMBER(10)

TableDir

Statement date Date of the statement The Statement Date field defines the date of the statement. StatementDate

DATE

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

NUMBER(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

NVARCHAR2(40)

String

Line Description Description of the Line LineDescription

NVARCHAR2(255)

String

Statement Line Date Date of the Statement Line StatementLineDate

DATE

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

DATE

Date

Effective date Date when money is available The Effective Date indicates the date that money is available from the bank. ValutaDate

DATE

Date

Reversal This is a reversing transaction The Reversal check box indicates if this is a reversal of a prior transaction. IsReversal

CHAR(1)

YesNo

ISO Currency Code Three letter ISO 4217 Code of the Currency For details - http://www.unece.org/trade/rec/rec09en.htm ISO_Code

CHAR(3)

String

Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID

NUMBER(10)

TableDir

Transaction Amount Amount of a transaction The Transaction Amount indicates the amount for a single transaction. TrxAmt

NUMBER

Amount

Statement amount Statement Amount The Statement Amount indicates the amount of a single statement line. StmtAmt

NUMBER

Amount

Charge Name Name of the Charge ChargeName

NVARCHAR2(60)

String

Charge Additional document charges The Charge indicates a type of Charge (Handling, Shipping, Restocking) C_Charge_ID

NUMBER(10)

TableDir

Interest Amount Interest Amount The Interest Amount indicates any interest charged or received on a Bank Statement. InterestAmt

NUMBER

Amount

Charge amount Charge Amount The Charge Amount indicates the amount for an additional charge. ChargeAmt

NUMBER

Amount

Memo Memo Text Memo

NVARCHAR2(255)

String

Business Partner Key Key of the Business Partner BPartnerValue

NVARCHAR2(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 C_BPartner_ID

NUMBER(10)

Search

Invoice Document No Document Number of the Invoice InvoiceDocumentNo

NVARCHAR2(30)

String

Invoice Invoice Identifier The Invoice Document. C_Invoice_ID

NUMBER(10)

Search

Payment Document No Document number of the Payment PaymentDocumentNo

NVARCHAR2(30)

String

Payment Payment identifier The Payment is a unique identifier of this payment. C_Payment_ID

NUMBER(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

VARCHAR2

List

Match Bank Statement Match Bank Statement Info to Business Partners, Invoices and Payments MatchStatement

CHAR(1)

Button

Import Bank Statement Import Bank Statement The Parameters are default values for null import record values, they do not overwrite any data. Processing

CHAR(1)

Button

Create Payment Create Payment from Bank Statement Info CreatePayment

CHAR(1)

Button

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo

EFT Statement Reference Electronic Funds Transfer Statement Reference Information from EFT media EftStatementReference

NVARCHAR2(60)

String

EFT Statement Date Electronic Funds Transfer Statement Date Information from EFT media EftStatementDate

DATE

Date

EFT Trx ID Electronic Funds Transfer Transaction ID Information from EFT media EftTrxID

NVARCHAR2(40)

String

EFT Trx Type Electronic Funds Transfer Transaction Type Information from EFT media EftTrxType

NVARCHAR2(20)

String

EFT Check No Electronic Funds Transfer Check No Information from EFT media EftCheckNo

NVARCHAR2(20)

String

EFT Reference Electronic Funds Transfer Reference Information from EFT media EftReference

NVARCHAR2(60)

String

EFT Memo Electronic Funds Transfer Memo Information from EFT media EftMemo

NVARCHAR2(2000)

String

EFT Payee Electronic Funds Transfer Payee information Information from EFT media EftPayee

NVARCHAR2(255)

String

EFT Payee Account Electronic Funds Transfer Payyee Account Information Information from EFT media EftPayeeAccount

NVARCHAR2(40)

String

EFT Statement Line Date Electronic Funds Transfer Statement Line Date Information from EFT media EftStatementLineDate

DATE

Date

EFT Effective Date Electronic Funds Transfer Valuta (effective) Date Information from EFT media EftValutaDate

DATE

Date

EFT Currency Electronic Funds Transfer Currency Information from EFT media EftCurrency

NVARCHAR2(20)

String

EFT Amount Electronic Funds Transfer Amount EftAmt

NUMBER

Amount

Contribuciones[edit]