Importar Extracto Bancário (Janela ID-277)

Fonte: iDempiere pt



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


Contributions / Posts

Os cookies ajudam-nos a fornecer os nossos serviços. Ao navegar no sítio, está a consentir o uso de cookies.