Extracto Bancário (Janela ID-194)

Janela: Extracto Bancário

Descrição: Process Bank Statements

Ajudar: The Process Bank Statements window allows you to reconcile your Bank Statements. You can either enter the line items from the statement in the Statement Line tab or select the 'Create From' button to automatically generate the statement from all unreconciled payments to this bank account. Once you have completed reconciling, select the 'Process Statement' button to mark the payments as reconciled and update the appropriate GL accounts.

TAB: Movimento

Descrição: Bank Statement

Ajudar The Bank Statement Tab defines the Bank Statement to be reconciled.

Ficheiro:Extracto Bancário - Movimento - Janela (iDempiere 1.0.0).png

Nome	Nome	Descrição	Ajudar	Especificações
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) NOT NULL 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) NOT NULL Table Direct
Bank Account	Conta de Banco	Account at the Bank	The Bank Account identifies an account at this Bank.	C_BankAccount_ID numeric(10) NOT NULL 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) NOT NULL String
Statement date	Data Extracto	Date of the statement	The Statement Date field defines the date of the statement.	StatementDate timestamp without time zone NOT NULL Date
Description	Descrição	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
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) NOT NULL Yes-No
Manual	Manual	This is a manual process	The Manual check box indicates if the process will done manually.	IsManual character(1) NOT NULL Yes-No
Beginning Balance	Saldo Inicial	Balance prior to any transactions	The Beginning Balance is the balance prior to making any adjustments for payments or disbursements.	BeginningBalance numeric Amount
Create lines from	Criar linhas de	Process which will generate a new document lines based on an existing document	The Create From process will create a new document based on information in an existing document selected by the user.	CreateFrom character(1) Button
Statement difference	Diferença Extracto	Difference between statement ending balance and actual ending balance	The Statement Difference reflects the difference between the Statement Ending Balance and the Actual Ending Balance.	StatementDifference numeric Amount
Match Bank Statement	Conciliar Extracto Bancário	Match Bank Statement Info to Business Partners, Invoices and Payments	null	MatchStatement character(1) Button
Ending balance	Saldo Final	Ending or closing balance	The Ending Balance is the result of adjusting the Beginning Balance by any payments or disbursements.	EndingBalance numeric NOT NULL Amount
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
Document Status	Documento Status	The current status of the document	The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field	DocStatus character(2) NOT NULL List
Process Statement	Processar Extracto	null	null	DocAction character(2) NOT NULL Button
Approved	Aprovado	Indicates if this document requires approval	The Approved checkbox indicates if this document requires approval before it can be processed.	IsApproved character(1) NOT NULL Yes-No
Posted	Lançado	Posting status	The Posted field indicates the status of the Generation of General Ledger Accounting Lines	Posted character(1) NOT NULL Button

TAB: Linhas

Descrição: Statement Line

Ajudar The Statement Line Tab defines the individual line items on the Bank Statement. They can be entered manually or generated from payments entered.

Ficheiro:Extracto Bancário - Linhas - Janela (iDempiere 1.0.0).png

Nome	Nome	Descrição	Ajudar	Especificações
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) NOT NULL 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) NOT NULL Table Direct
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) NOT NULL Table Direct
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) NOT NULL Integer
Description	Descrição	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
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) NOT NULL Yes-No
Manual	Manual	This is a manual process	The Manual check box indicates if the process will done manually.	IsManual character(1) NOT NULL Yes-No
Statement Line Date	Data Linha Extracto	Date of the Statement Line	null	StatementLineDate timestamp without time zone NOT NULL 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 NOT NULL 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 NOT NULL Date
Statement amount	Montante do Extracto	Statement Amount	The Statement Amount indicates the amount of a single statement line.	StmtAmt numeric NOT NULL Amount
Payment	ID Pagamento	Payment identifier	The Payment is a unique identifier of this payment.	C_Payment_ID numeric(10) Search
Transaction Amount	Montante Transacção	Amount of a transaction	The Transaction Amount indicates the amount for a single transaction.	TrxAmt numeric NOT NULL Amount
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) NOT NULL Table Direct
Charge amount	Montante de Encargos	Charge Amount	The Charge Amount indicates the amount for an additional charge.	ChargeAmt numeric NOT NULL Amount
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 NOT NULL Amount
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
Memo	Memo	Memo Text	null	Memo character varying(255) String
Match Bank Statement	Conciliar Extracto Bancário	Match Bank Statement Info to Business Partners, Invoices and Payments	null	MatchStatement character(1) Button
Create Payment	Criar Pagamento	Create Payment from Bank Statement Info	null	CreatePayment character(1) Button
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	Factura	Invoice Identifier	The Invoice Document.	C_Invoice_ID numeric(10) Search
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