Bancos (Janela ID-158)
Janela: Bancos
Descrição: Maintain Bank
Ajudar: The Bank Window is used to define the banks and accounts associated with an organization or business partner
TAB: Banco
Descrição: Maintain Bank
Ajudar The Bank Tab defines a bank that is used by an organization or business partner. Each Bank is given an identifying Name, Address, Routing No and Swift Code
Ficheiro:Bancos - Banco - 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 |
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 |
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 |
Address | Localização/Endereço | Location or Address | The Location / Address field defines the location of an entity. | C_Location_ID numeric(10) Location (Address) |
Own Bank | Nosso Banco | Bank for this Organization | The Own Bank field indicates if this bank is for this Organization as opposed to a Bank for a Business Partner. | IsOwnBank character(1) NOT NULL Yes-No |
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) NOT NULL String |
Swift code | Código Swift | Swift Code (Society of Worldwide Interbank Financial Telecommunications) | The SWIFT code is an identifier of a Bank | SwiftCode character varying(20) String |
TAB: Conta Bancária
Descrição: Maintain Bank Account
Ajudar The Account Tab is used to define one or more accounts for a Bank. Each account has a unique Account No and Currency.
Ficheiro:Bancos - Conta Bancária - 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 |
Search Key | Codigo para Selecção | Codigo principal para selecção de registos - deve ser unico | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
Value character varying(40) NOT NULL String |
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 |
Bank | Banco | Bank | The Bank is a unique identifier of a Bank for this Organization or for a Business Partner with whom this Organization transacts. | C_Bank_ID numeric(10) NOT NULL Table Direct |
Account No | Conta, Numero | Account Number | The Account Number indicates the Number assigned to this account | AccountNo character varying(20) NOT NULL String |
BBAN | BBAN | Basic Bank Account Number | The Basic (or Domestic) Bank Account Number is used in Bank transfers (see also IBAN). For details see ISO 13616 and http://www.ecbs.org/ | BBAN character varying(40) String |
IBAN | 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 Adempiere. |
IBAN character varying(40) String |
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 |
Default | Padrão | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) NOT NULL Yes-No |
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 |
Bank Account Type | Conta de Banco, Tipo | Bank Account Type | The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as. | BankAccountType character(1) NOT NULL List |
Credit limit | Limite de Crédito | Amount of Credit allowed | The Credit Limit field indicates the credit limit for this account. | CreditLimit numeric NOT NULL Number |
Payment Export Class | Payment Export Class | null | null | PaymentExportClass character varying(60) String |
Current balance | Saldo Actual | Current Balance | The Current Balance field indicates the current balance in this account. | CurrentBalance numeric NOT NULL Number |
TAB: Documentos Bancários
Descrição: Maintain Bank Account Documents
Ajudar In this tab, you define the documents used for this bank account. You define your check and other payment document (sequence) number as well as format.
Ficheiro:Bancos - Documentos Bancários - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Bank Account Document | Documento Bancário | Checks, Transfers, etc. | Bank documents, you generate or track | C_BankAccountDoc_ID numeric(10) NOT NULL ID |
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 |
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 |
Payment Rule | Modo de Pagamento | How you pay the invoice | The Payment Rule indicates the method of invoice payment. | PaymentRule character(1) NOT NULL List |
Current Next | Nº Documento Seguinte | The next number to be used | The Current Next indicates the next number to use for this document | CurrentNext numeric(10) NOT NULL Integer |
Check Print Format | Cheque, formato de Impressão | Print Format for printing Checks | You need to define a Print Format to print the document. | Check_PrintFormat_ID numeric(10) Table |
TAB: Bank Account Processor
Descrição: Maintain Bank Account Payment Processors
Ajudar null
Ficheiro:Bancos - Bank Account Processor - 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 |
Payment Processor | Processamento de Pagamentos | Payment processor for electronic payments | The Payment Processor indicates the processor to be used for electronic payments | C_PaymentProcessor_ID numeric(10) NOT NULL Table Direct |
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 |
TAB: Importacão Extracto
Descrição: Definition of Bank Statement Loader (SWIFT, OFX)
Ajudar The loader definition privides the parameters to load bank statements from EFT formats like SWIFT (MT940) or OFX. The required parameters depend on the actual statement loader class
Ficheiro:Bancos - Importacão Extracto - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Bank Statement Loader | Formatar Importação Extracto Bancário | Definition of Bank Statement Loader (SWIFT, OFX) | The loader definition privides the parameters to load bank statements from EFT formats like SWIFT (MT940) or OFX | C_BankStatementLoader_ID numeric(10) NOT NULL ID |
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 |
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 |
Financial Institution ID | ID Instituição Financeira | The ID of the Financial Institution / Bank | Depending on the loader, it might require a ID of the financial institution | FinancialInstitutionID character varying(20) String |
Branch ID | ID Filial | Bank Branch ID | Dependent on the loader, you may have to provide a bank branch ID | BranchID character varying(20) String |
Account No | Conta, Numero | Account Number | The Account Number indicates the Number assigned to this account | AccountNo character varying(20) String |
PIN | PIN | Personal Identification Number | null | PIN character varying(20) String |
User ID | Utilizador | User ID | The User ID identifies a user and allows access to records or processes. | UserID character varying(60) String |
Password | Password | Password of any length (case sensitive) | The Password indicates the Password for this User Id. Passwords are required to identify authorized users. | Password character varying(60) String |
Host Address | IP do servidor | Host Address URL or DNS | The Host Address identifies the URL or DNS of the target host | HostAddress character varying(60) String |
Host port | Porta do servidor | Host Communication Port | The Host Port identifies the port to communicate with the host. | HostPort numeric(10) Integer |
Proxy address | IP do servidor Proxy | Address of your proxy server | The Proxy Address must be defined if you must pass through a firewall to access your payment processor. | ProxyAddress character varying(60) String |
Proxy port | Porta servidor Proxy | Port of your proxy server | The Proxy Port identifies the port of your proxy server. | ProxyPort numeric(10) Integer |
Proxy logon | Utilizador servidor Proxy | Logon of your proxy server | The Proxy Logon identifies the Logon ID for your proxy server. | ProxyLogon character varying(60) String |
Proxy password | Password servidor Proxy | Password of your proxy server | The Proxy Password identifies the password for your proxy server. | ProxyPassword character varying(60) String |
File Name | Nome Ficheiro | Name of the local file or URL | Name of a file in the local directory space - or URL (file://.., http://.., ftp://..) | FileName character varying(120) String |
Statement Loader Class | Rotina Carregamento (JAVA Classname) | Class name of the bank statement loader | The name of the actual bank statement loader implementing the interface org.compiere.impexp.BankStatementLoaderInterface | StmtLoaderClass character varying(60) String |
Date Format | Data, Formato | Date format used in the imput format | The date format is usually detected, but sometimes need to be defined. | DateFormat character varying(20) String |
Date last run | Data último processamento | Date the process was last run. | The Date Last Run indicates the last time that a process was run. | DateLastRun timestamp without time zone Date+Time |
TAB: Contabilidade
Descrição: Maintain Accounting Data
Ajudar The Accounting Tab is used to define the accounts used for transactions with this Bank.
Ficheiro:Bancos - Contabilidade - 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 |
Accounting Schema | Modelo de Contabilidade | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) NOT NULL Table Direct |
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 |
Bank Asset | Activos no Banco | Bank Asset Account | The Bank Asset Account identifies the account to be used for booking changes to the balance in this bank account | B_Asset_Acct numeric(10) NOT NULL Account |
Bank In Transit | Banco, Pendente | Bank In Transit Account | The Bank in Transit Account identifies the account to be used for funds which are in transit. | B_InTransit_Acct numeric(10) NOT NULL Account |
Unallocated Cash | Pagamentos não atribuídos | Unallocated Cash Clearing Account | Receipts not allocated to Invoices | B_UnallocatedCash_Acct numeric(10) NOT NULL Account |
Bank Unidentified Receipts | Bank Unidentified Receipts | Bank Unidentified Receipts Account | The Bank Unidentified Receipts Account identifies the account to be used when recording receipts that can not be reconciled at the present time. | B_Unidentified_Acct numeric(10) Account |
Payment Selection | Selecção Pagamentos | AP Payment Selection Clearing Account | null | B_PaymentSelect_Acct numeric(10) NOT NULL Account |
Bank Expense | Bank Expense | Bank Expense Account | The Bank Expense Account identifies the account to be used for recording charges or fees incurred from this Bank. | B_Expense_Acct numeric(10) Account |
Bank Interest Expense | Juros Bancários, Despesas | Bank Interest Expense Account | The Bank Interest Expense Account identifies the account to be used for recording interest expenses. | B_InterestExp_Acct numeric(10) NOT NULL Account |
Bank Interest Revenue | Juros Bancários, Ganhos | Bank Interest Revenue Account | The Bank Interest Revenue Account identifies the account to be used for recording interest revenue from this Bank. | B_InterestRev_Acct numeric(10) NOT NULL Account |
Bank Revaluation Gain | Bank Revaluation Gain | Bank Revaluation Gain Account | The Bank Revaluation Gain Account identifies the account to be used for recording gains that are recognized when converting currencies. | B_RevaluationGain_Acct numeric(10) Account |
Bank Revaluation Loss | Bank Revaluation Loss | Bank Revaluation Loss Account | The Bank Revaluation Loss Account identifies the account to be used for recording losses that are recognized when converting currencies. | B_RevaluationLoss_Acct numeric(10) Account |
Bank Settlement Gain | Bank Settlement Gain | Bank Settlement Gain Account | The Bank Settlement Gain account identifies the account to be used when recording a currency gain when the settlement and receipt currency are not the same. | B_SettlementGain_Acct numeric(10) Account |
Bank Settlement Loss | Bank Settlement Loss | Bank Settlement Loss Account | The Bank Settlement loss account identifies the account to be used when recording a currency loss when the settlement and receipt currency are not the same. | B_SettlementLoss_Acct numeric(10) Account |