Importar Extracto Bancário (Janela ID-277)

Janela: Importar Extracto Bancário

Descrição: Import Bank Statements

Ajudar: null

TAB: Banco, Extracto

Descrição: Import Bank Statement

Ajudar null

Ficheiro:Importar Extracto Bancário - Banco, Extracto - Janela (iDempiere 1.0.0).png

Nome	Nome	Descrição	Ajudar	Especificações
Active	Activo	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 character(1) Yes-No
Import Bank Statement	Importar Extractos Bancários	Import of the Bank Statement	null	I_BankStatement_ID numeric(10) NOT NULL ID
Imported	Importado	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	Extracto Bancário	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 numeric(10) Search
Bank statement line	Extracto Bancário, linha	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	Mensagens da Importação	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	Empresa	A Empresa instalada neste sistema.	A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.	AD_Client_ID numeric(10) Table Direct
Organization	Organismo	Unidade organizacional componente da Empresa	A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.	AD_Org_ID numeric(10) Table Direct
Name	Nome	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	Descrição	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Routing No	N.º Rota	Bank Routing Number	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	N.º Conta Bancária	Bank Account Number	null	BankAccountNo character varying(20) String
Bank Account	Conta de Banco	Account at the Bank	The Bank Account identifies an account at this Bank.	C_BankAccount_ID numeric(10) Table Direct
Statement date	Data Extracto	Date of the statement	The Statement Date field defines the date of the statement.	StatementDate timestamp without time zone Date
Line No	N.º Linha	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	N.º Referência	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	Linha, descrição	Description of the Line	null	LineDescription character varying(255) String
Statement Line Date	Data Linha Extracto	Date of the Statement Line	null	StatementLineDate timestamp without time zone Date
Account Date	Data de Lançamento	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 cirrency conversion.	DateAcct timestamp without time zone Date
Effective date	Data Efectiva	Date when money is available	The Effective Date indicates the date that money is available from the bank.	ValutaDate timestamp without time zone Date
Reversal	Estorno	This is a reversing transaction	The Reversal check box indicates if this is a reversal of a prior transaction.	IsReversal character(1) Yes-No
ISO Currency Code	Código ISO de Divisa	Three letter ISO 4217 Code of the Currency	For details - http://www.unece.org/trade/rec/rec09en.htm	ISO_Code character(3) String
Currency	Divisa	The Currency for this record	Indicates the Currency to be used when processing or reporting on this record	C_Currency_ID numeric(10) Table Direct
Transaction Amount	Montante Transacção	Amount of a transaction	The Transaction Amount indicates the amount for a single transaction.	TrxAmt numeric Amount
Statement amount	Montante do Extracto	Statement Amount	The Statement Amount indicates the amount of a single statement line.	StmtAmt numeric Amount
Charge Name	Encargos, Nome	Name of the Charge	null	ChargeName character varying(60) String
Charge	Encargos	Additional document charges	The Charge indicates a type of Charge (Handling, Shipping, Restocking)	C_Charge_ID numeric(10) Table Direct
Interest Amount	Juros, Montante	Interest Amount	The Interest Amount indicates any interest charged or received on a Bank Statement.	InterestAmt numeric Amount
Charge amount	Montante de Encargos	Charge Amount	The Charge Amount indicates the amount for an additional charge.	ChargeAmt numeric Amount
Memo	Memo	Memo Text	null	Memo character varying(255) String
Business Partner Key	Código de Terceiros	Código identificador unico das Entidades	null	BPartnerValue character varying(40) String
Business Partner	Terceiros	Identifica uma entidade externa à empresa (cliente, fornecedor, vendedor, etc. )	Terceiros são todas as instituições, sociedades ou individuos com quem a empresa tem um relacionamento comercial ou de trabalho. Exemplos: clientes, fornecedores, funcionários, vendedores ou representantes comerciais, etc.	C_BPartner_ID numeric(10) Search
Invoice Document No	Factura, N.º Documento	Document Number of the Invoice	null	InvoiceDocumentNo character varying(30) String
Invoice	Factura	Invoice Identifier	The Invoice Document.	C_Invoice_ID numeric(10) Search
Payment Document No	N.º Doc. Pagamento	Document number of the Payment	null	PaymentDocumentNo character varying(30) String
Payment	ID Pagamento	Payment identifier	The Payment is a unique identifier of this payment.	C_Payment_ID numeric(10) Search
Transaction Type	Tipo Transacção	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	Conciliar Extracto Bancário	Match Bank Statement Info to Business Partners, Invoices and Payments	null	MatchStatement character(1) Button
Import Bank Statement	Importar Extracto Bancário	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	Criar Pagamento	Create Payment from Bank Statement Info	null	CreatePayment character(1) Button
Processed	Processado	The document has been processed	The Processed checkbox indicates that a document has been processed.	Processed character(1) Yes-No
EFT Statement Reference	Referência Transf.Bancária	Electronic Funds Transfer Statement Reference	Information from EFT media	EftStatementReference character varying(60) String
EFT Statement Date	Data Extracto Transf.Bancária	Electronic Funds Transfer Statement Date	Information from EFT media	EftStatementDate timestamp without time zone Date
EFT Trx ID	ID Transmissão Transf.Bancária	Electronic Funds Transfer Transaction ID	Information from EFT media	EftTrxID character varying(40) String
EFT Trx Type	Tipo Transmissão Transf.Bancária	Electronic Funds Transfer Transaction Type	Information from EFT media	EftTrxType character varying(20) String
EFT Check No	N.º Transf.Bancária	Electronic Funds Transfer Check No	Information from EFT media	EftCheckNo character varying(20) String
EFT Reference	Referência Transf.Bancária	Electronic Funds Transfer Reference	Information from EFT media	EftReference character varying(60) String
EFT Memo	N/Credito Transf.Bancária	Electronic Funds Transfer Memo	Information from EFT media	EftMemo character varying(2000) String
EFT Payee	Transf.Bancária, Terceiro	Terceiro que recebe a Transferência Bancária ou TEF (Transferência Electrónica de Fundos)	Informação para Transferências Bancárias ou TEF (Transferência Electrónica de Fundos)	EftPayee character varying(255) String
EFT Payee Account	Transf.Bancária, NIB Terceiro	Numero de conta (NIB) de quem recebe a Transferência Bancária ou TEF (Transferência Electrónica de Fundos)	Informação para Transferências Bancárias ou TEF (Transferência Electrónica de Fundos)	EftPayeeAccount character varying(40) String
EFT Statement Line Date	Data Linha Extracto Transf.Bancária	Electronic Funds Transfer Statement Line Date	Information from EFT media	EftStatementLineDate timestamp without time zone Date
EFT Effective Date	Data Efectiva Transf.Bancária	Electronic Funds Transfer Valuta (effective) Date	Information from EFT media	EftValutaDate timestamp without time zone Date
EFT Currency	Moeda Transf.Bancária	Electronic Funds Transfer Currency	Information from EFT media	EftCurrency character varying(20) String
EFT Amount	Montante Transf.Bancária	Electronic Funds Transfer Amount	null	EftAmt numeric Amount