View source | Discuss this page | Page history | Printable version   
Main Page
Upload file
What links here
Recent changes

PDF Books
Add page
Show collection (0 pages)
Collections help


ERP/3.0/Developers Guide/Reference/Entity Model/FIN Reconciliation

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers_Guide/Reference/Entity_Model#FIN_Reconciliation


Reconciliation event of the financial account

To the database table (FIN_Reconciliation) of this entity.



Property Column Constraints Type Description
id* FIN_Reconciliation_ID Mandatory
Max Length: 32
java.lang.String Reconciliation events related to the financial account
client AD_Client_ID Mandatory
ADClient A Client is a company or a legal entity. You cannot share data between Clients.
organization AD_Org_ID Mandatory
Organization An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
creationDate Created Mandatory
java.util.Date The Created field indicates the date that this record was created.
createdBy Createdby Mandatory
ADUser The Created By field indicates the user who created this record.
updated Updated Mandatory
java.util.Date The Updated field indicates the date that this record was updated.
updatedBy Updatedby Mandatory
ADUser The Updated By field indicates the user who updated this record.
active Isactive java.lang.Boolean 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 reporting. There are two reasons for de-activating and not deleting records:

(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

account FIN_Financial_Account_ID Mandatory
FIN_Financial_Account Financial account used to deposit / withdrawal money such as bank accounts or petty cash
documentNo# DocumentNo Mandatory
Max Length: 30
java.lang.String The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>". If the document type of your document has no automatic document sequence defined, the field will be empty when creating a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Document Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table inside the database (e.g. C_Order).
documentType C_Doctype_ID Mandatory
DocumentType The Document Type determines document sequence and processing rules
endingDate Dateto Mandatory
java.util.Date The Date To indicates the end date of a range (inclusive)
transactionDate# Statementdate Mandatory
java.util.Date The Statement Date field defines the date of the statement being processed.
endingBalance Endingbalance Mandatory
java.math.BigDecimal The Ending Balance is the result of adjusting the Beginning Balance by any payments or disbursements.
startingbalance Startingbalance Mandatory
java.math.BigDecimal Starting Balance
documentStatus Docstatus Mandatory
Max Length: 60
java.lang.String The Document Status indicates the status of a document at this time. To change the status of a document, use one of the buttons usually located at the bottom of the document window.
processNow Processing java.lang.Boolean When this field is set as 'Y' a process is being performed on this record.
processed Processed Mandatory
java.lang.Boolean The Processed checkbox indicates that a document has been processed.
posted Posted Mandatory
Max Length: 60
java.lang.String An accounting status button that indicates if the transaction has already been posted to the general ledger or not. When doing the accounting manually this button can be used to post or unpost the transaction from the general ledger by hand.
printdetailed Printdetailed Mandatory
java.lang.Boolean Print Detailed
printsummary Printsummary Mandatory
java.lang.Boolean Print Summary
aPRMProcessReconciliation EM_APRM_Process_Reconciliation Max Length: 60
java.lang.String Used to process and reactivate reconciliation documents
aPRMPrintDetailed EM_APRM_PrintDetailed Mandatory
java.lang.Boolean Print Detailed reconciliation report
aPRMPrintSummary EM_APRM_PrintSummary Mandatory
java.lang.Boolean Print Summary reconciliation report
aprmProcessRec EM_Aprm_Process_Rec Max Length: 60
java.lang.String Used to process and reactivate reconciliation documents
aPRMProcessReconciliationForce EM_APRM_Process_Rec_Force Max Length: 60
aPRMOutstandingDepositItemsAmount EM_APRM_OutstandingDepositItemsAmount java.math.BigDecimal
aPRMOutstandingDepositsItemNo EM_APRM_OutstandingDepositsItemNo java.lang.Long
aPRMOutstandingPaymentsItemNo EM_APRM_OutstandingPaymentsItemNo java.lang.Long
aPRMOutstandingPaymentsItemsAmount EM_APRM_OutstandingPaymentsItemsAmount java.math.BigDecimal
aPRMReconciledItemAmount EM_APRM_ReconciledItemAmount java.math.BigDecimal
aPRMReconciledItemNo EM_APRM_ReconciledItemNo java.lang.Long
aPRMUnReconciledItemAmount EM_APRM_UnReconciledItemAmount java.math.BigDecimal
aPRMUnReconciledItemNo EM_APRM_UnReconciledItemNo java.lang.Long
aPRMFinaccTransactionVList APRM_Finacc_Transaction_v
fINFinaccTransactionList FIN_Finacc_Transaction
fINReconciliationLineVList FIN_ReconciliationLine_v

Java Entity Class

  * The contents of this file are subject to the Openbravo  Public  License
  * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
  * Version 1.1  with a permitted attribution clause; you may not  use this
  * file except in compliance with the License. You  may  obtain  a copy of
  * the License at
  * Software distributed under the License  is  distributed  on  an "AS IS"
  * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
  * License for the specific  language  governing  rights  and  limitations
  * under the License.
  * The Original Code is Openbravo ERP.
  * The Initial Developer of the Original Code is Openbravo SLU
  * All portions are Copyright (C) 2008-2019 Openbravo SLU
  * All Rights Reserved.
  * Contributor(s):  ______________________________________.
 package org.openbravo.model.financialmgmt.payment;
 import java.math.BigDecimal;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
 import org.openbravo.advpaymentmngt.APRM_FinaccTransactionV;
 import org.openbravo.base.structure.ActiveEnabled;
 import org.openbravo.base.structure.BaseOBObject;
 import org.openbravo.base.structure.ClientEnabled;
 import org.openbravo.base.structure.OrganizationEnabled;
 import org.openbravo.base.structure.Traceable;
 import org.openbravo.model.common.enterprise.DocumentType;
 import org.openbravo.model.common.enterprise.Organization;
  * Entity class for entity FIN_Reconciliation (stored in table FIN_Reconciliation).
  * NOTE: This class should not be instantiated directly. To instantiate this
  * class the {@link org.openbravo.base.provider.OBProvider} should be used.
 public class FIN_Reconciliation extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled {
     private static final long serialVersionUID = 1L;
     public static final String TABLE_NAME = "FIN_Reconciliation";
     public static final String ENTITY_NAME = "FIN_Reconciliation";
     public static final String PROPERTY_ID = "id";
     public static final String PROPERTY_CLIENT = "client";
     public static final String PROPERTY_ORGANIZATION = "organization";
     public static final String PROPERTY_CREATIONDATE = "creationDate";
     public static final String PROPERTY_CREATEDBY = "createdBy";
     public static final String PROPERTY_UPDATED = "updated";
     public static final String PROPERTY_UPDATEDBY = "updatedBy";
     public static final String PROPERTY_ACTIVE = "active";
     public static final String PROPERTY_ACCOUNT = "account";
     public static final String PROPERTY_DOCUMENTNO = "documentNo";
     public static final String PROPERTY_DOCUMENTTYPE = "documentType";
     public static final String PROPERTY_ENDINGDATE = "endingDate";
     public static final String PROPERTY_TRANSACTIONDATE = "transactionDate";
     public static final String PROPERTY_ENDINGBALANCE = "endingBalance";
     public static final String PROPERTY_STARTINGBALANCE = "startingbalance";
     public static final String PROPERTY_DOCUMENTSTATUS = "documentStatus";
     public static final String PROPERTY_PROCESSNOW = "processNow";
     public static final String PROPERTY_PROCESSED = "processed";
     public static final String PROPERTY_POSTED = "posted";
     public static final String PROPERTY_PRINTDETAILED = "printdetailed";
     public static final String PROPERTY_PRINTSUMMARY = "printsummary";
     public static final String PROPERTY_APRMPROCESSRECONCILIATION = "aPRMProcessReconciliation";
     public static final String PROPERTY_APRMPRINTDETAILED = "aPRMPrintDetailed";
     public static final String PROPERTY_APRMPRINTSUMMARY = "aPRMPrintSummary";
     public static final String PROPERTY_APRMPROCESSREC = "aprmProcessRec";
     public static final String PROPERTY_APRMPROCESSRECONCILIATIONFORCE = "aPRMProcessReconciliationForce";
     public static final String PROPERTY__COMPUTEDCOLUMNS = "_computedColumns";
     public static final String PROPERTY_APRMFINACCTRANSACTIONVLIST = "aPRMFinaccTransactionVList";
     public static final String PROPERTY_FINFINACCTRANSACTIONLIST = "fINFinaccTransactionList";
     public static final String PROPERTY_FINRECONCILIATIONLINEVLIST = "fINReconciliationLineVList";
     // Computed columns properties, these properties cannot be directly accessed, they need
     // to be read through _commputedColumns proxy. They cannot be directly used in HQL, OBQuery
     // nor OBCriteria. 
     public static final String COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITITEMSAMOUNT = "aPRMOutstandingDepositItemsAmount";
     public static final String COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITSITEMNO = "aPRMOutstandingDepositsItemNo";
     public static final String COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMNO = "aPRMOutstandingPaymentsItemNo";
     public static final String COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMSAMOUNT = "aPRMOutstandingPaymentsItemsAmount";
     public static final String COMPUTED_COLUMN_APRMRECONCILEDITEMAMOUNT = "aPRMReconciledItemAmount";
     public static final String COMPUTED_COLUMN_APRMRECONCILEDITEMNO = "aPRMReconciledItemNo";
     public static final String COMPUTED_COLUMN_APRMUNRECONCILEDITEMAMOUNT = "aPRMUnReconciledItemAmount";
     public static final String COMPUTED_COLUMN_APRMUNRECONCILEDITEMNO = "aPRMUnReconciledItemNo";
     public FIN_Reconciliation() {
         setDefaultValue(PROPERTY_CREATIONDATE, new Date());
         setDefaultValue(PROPERTY_UPDATED, new Date());
         setDefaultValue(PROPERTY_ACTIVE, true);
         setDefaultValue(PROPERTY_ENDINGBALANCE, new BigDecimal(0));
         setDefaultValue(PROPERTY_STARTINGBALANCE, new BigDecimal(0));
         setDefaultValue(PROPERTY_PROCESSNOW, false);
         setDefaultValue(PROPERTY_PROCESSED, false);
         setDefaultValue(PROPERTY_POSTED, "N");
         setDefaultValue(PROPERTY_PRINTDETAILED, false);
         setDefaultValue(PROPERTY_PRINTSUMMARY, false);
         setDefaultValue(PROPERTY_APRMPRINTDETAILED, false);
         setDefaultValue(PROPERTY_APRMPRINTSUMMARY, false);
         setDefaultValue(PROPERTY_APRMPROCESSREC, "P");
         setDefaultValue(PROPERTY_APRMFINACCTRANSACTIONVLIST, new ArrayList<Object>());
         setDefaultValue(PROPERTY_FINFINACCTRANSACTIONLIST, new ArrayList<Object>());
         setDefaultValue(PROPERTY_FINRECONCILIATIONLINEVLIST, new ArrayList<Object>());
     public String getEntityName() {
         return ENTITY_NAME;
     public String getId() {
         return (String) get(PROPERTY_ID);
     public void setId(String id) {
         set(PROPERTY_ID, id);
     public Client getClient() {
         return (Client) get(PROPERTY_CLIENT);
     public void setClient(Client client) {
         set(PROPERTY_CLIENT, client);
     public Organization getOrganization() {
         return (Organization) get(PROPERTY_ORGANIZATION);
     public void setOrganization(Organization organization) {
         set(PROPERTY_ORGANIZATION, organization);
     public Date getCreationDate() {
         return (Date) get(PROPERTY_CREATIONDATE);
     public void setCreationDate(Date creationDate) {
         set(PROPERTY_CREATIONDATE, creationDate);
     public User getCreatedBy() {
         return (User) get(PROPERTY_CREATEDBY);
     public void setCreatedBy(User createdBy) {
         set(PROPERTY_CREATEDBY, createdBy);
     public Date getUpdated() {
         return (Date) get(PROPERTY_UPDATED);
     public void setUpdated(Date updated) {
         set(PROPERTY_UPDATED, updated);
     public User getUpdatedBy() {
         return (User) get(PROPERTY_UPDATEDBY);
     public void setUpdatedBy(User updatedBy) {
         set(PROPERTY_UPDATEDBY, updatedBy);
     public Boolean isActive() {
         return (Boolean) get(PROPERTY_ACTIVE);
     public void setActive(Boolean active) {
         set(PROPERTY_ACTIVE, active);
     public FIN_FinancialAccount getAccount() {
         return (FIN_FinancialAccount) get(PROPERTY_ACCOUNT);
     public void setAccount(FIN_FinancialAccount account) {
         set(PROPERTY_ACCOUNT, account);
     public String getDocumentNo() {
         return (String) get(PROPERTY_DOCUMENTNO);
     public void setDocumentNo(String documentNo) {
         set(PROPERTY_DOCUMENTNO, documentNo);
     public DocumentType getDocumentType() {
         return (DocumentType) get(PROPERTY_DOCUMENTTYPE);
     public void setDocumentType(DocumentType documentType) {
         set(PROPERTY_DOCUMENTTYPE, documentType);
     public Date getEndingDate() {
         return (Date) get(PROPERTY_ENDINGDATE);
     public void setEndingDate(Date endingDate) {
         set(PROPERTY_ENDINGDATE, endingDate);
     public Date getTransactionDate() {
         return (Date) get(PROPERTY_TRANSACTIONDATE);
     public void setTransactionDate(Date transactionDate) {
         set(PROPERTY_TRANSACTIONDATE, transactionDate);
     public BigDecimal getEndingBalance() {
         return (BigDecimal) get(PROPERTY_ENDINGBALANCE);
     public void setEndingBalance(BigDecimal endingBalance) {
         set(PROPERTY_ENDINGBALANCE, endingBalance);
     public BigDecimal getStartingbalance() {
         return (BigDecimal) get(PROPERTY_STARTINGBALANCE);
     public void setStartingbalance(BigDecimal startingbalance) {
         set(PROPERTY_STARTINGBALANCE, startingbalance);
     public String getDocumentStatus() {
         return (String) get(PROPERTY_DOCUMENTSTATUS);
     public void setDocumentStatus(String documentStatus) {
         set(PROPERTY_DOCUMENTSTATUS, documentStatus);
     public Boolean isProcessNow() {
         return (Boolean) get(PROPERTY_PROCESSNOW);
     public void setProcessNow(Boolean processNow) {
         set(PROPERTY_PROCESSNOW, processNow);
     public Boolean isProcessed() {
         return (Boolean) get(PROPERTY_PROCESSED);
     public void setProcessed(Boolean processed) {
         set(PROPERTY_PROCESSED, processed);
     public String getPosted() {
         return (String) get(PROPERTY_POSTED);
     public void setPosted(String posted) {
         set(PROPERTY_POSTED, posted);
     public Boolean isPrintdetailed() {
         return (Boolean) get(PROPERTY_PRINTDETAILED);
     public void setPrintdetailed(Boolean printdetailed) {
         set(PROPERTY_PRINTDETAILED, printdetailed);
     public Boolean isPrintsummary() {
         return (Boolean) get(PROPERTY_PRINTSUMMARY);
     public void setPrintsummary(Boolean printsummary) {
         set(PROPERTY_PRINTSUMMARY, printsummary);
     public String getAPRMProcessReconciliation() {
     public void setAPRMProcessReconciliation(String aPRMProcessReconciliation) {
         set(PROPERTY_APRMPROCESSRECONCILIATION, aPRMProcessReconciliation);
     public Boolean isAPRMPrintDetailed() {
         return (Boolean) get(PROPERTY_APRMPRINTDETAILED);
     public void setAPRMPrintDetailed(Boolean aPRMPrintDetailed) {
         set(PROPERTY_APRMPRINTDETAILED, aPRMPrintDetailed);
     public Boolean isAPRMPrintSummary() {
         return (Boolean) get(PROPERTY_APRMPRINTSUMMARY);
     public void setAPRMPrintSummary(Boolean aPRMPrintSummary) {
         set(PROPERTY_APRMPRINTSUMMARY, aPRMPrintSummary);
     public String getAprmProcessRec() {
         return (String) get(PROPERTY_APRMPROCESSREC);
     public void setAprmProcessRec(String aprmProcessRec) {
         set(PROPERTY_APRMPROCESSREC, aprmProcessRec);
     public String getAPRMProcessReconciliationForce() {
     public void setAPRMProcessReconciliationForce(String aPRMProcessReconciliationForce) {
     public BigDecimal getAPRMOutstandingDepositItemsAmount() {
     public void setAPRMOutstandingDepositItemsAmount(BigDecimal aPRMOutstandingDepositItemsAmount) {
     public Long getAPRMOutstandingDepositsItemNo() {
     public void setAPRMOutstandingDepositsItemNo(Long aPRMOutstandingDepositsItemNo) {
     public Long getAPRMOutstandingPaymentsItemNo() {
     public void setAPRMOutstandingPaymentsItemNo(Long aPRMOutstandingPaymentsItemNo) {
     public BigDecimal getAPRMOutstandingPaymentsItemsAmount() {
     public void setAPRMOutstandingPaymentsItemsAmount(BigDecimal aPRMOutstandingPaymentsItemsAmount) {
     public BigDecimal getAPRMReconciledItemAmount() {
     public void setAPRMReconciledItemAmount(BigDecimal aPRMReconciledItemAmount) {
     public Long getAPRMReconciledItemNo() {
     public void setAPRMReconciledItemNo(Long aPRMReconciledItemNo) {
     public BigDecimal getAPRMUnReconciledItemAmount() {
     public void setAPRMUnReconciledItemAmount(BigDecimal aPRMUnReconciledItemAmount) {
     public Long getAPRMUnReconciledItemNo() {
     public void setAPRMUnReconciledItemNo(Long aPRMUnReconciledItemNo) {
     public FIN_Reconciliation_ComputedColumns get_computedColumns() {
         return (FIN_Reconciliation_ComputedColumns) get(PROPERTY__COMPUTEDCOLUMNS);
     public void set_computedColumns(FIN_Reconciliation_ComputedColumns _computedColumns) {
         set(PROPERTY__COMPUTEDCOLUMNS, _computedColumns);
     public List<APRM_FinaccTransactionV> getAPRMFinaccTransactionVList() {
       return (List<APRM_FinaccTransactionV>) get(PROPERTY_APRMFINACCTRANSACTIONVLIST);
     public void setAPRMFinaccTransactionVList(List<APRM_FinaccTransactionV> aPRMFinaccTransactionVList) {
     public List<FIN_FinaccTransaction> getFINFinaccTransactionList() {
       return (List<FIN_FinaccTransaction>) get(PROPERTY_FINFINACCTRANSACTIONLIST);
     public void setFINFinaccTransactionList(List<FIN_FinaccTransaction> fINFinaccTransactionList) {
         set(PROPERTY_FINFINACCTRANSACTIONLIST, fINFinaccTransactionList);
     public List<FIN_ReconciliationLine_v> getFINReconciliationLineVList() {
       return (List<FIN_ReconciliationLine_v>) get(PROPERTY_FINRECONCILIATIONLINEVLIST);
     public void setFINReconciliationLineVList(List<FIN_ReconciliationLine_v> fINReconciliationLineVList) {
     public Object get(String propName) {
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMOutstandingDepositItemsAmount();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMOutstandingDepositsItemNo();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMOutstandingPaymentsItemNo();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMOutstandingPaymentsItemsAmount();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMReconciledItemAmount();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMReconciledItemNo();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMUnReconciledItemAmount();
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getAPRMUnReconciledItemNo();
       return super.get(propName);

Retrieved from ""

This page has been accessed 1,443 times. This page was last modified on 8 July 2019, at 01:48. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.