Class FIN_Reconciliation
- java.lang.Object
-
- org.openbravo.base.structure.BaseOBObject
-
- org.openbravo.model.financialmgmt.payment.FIN_Reconciliation
-
- All Implemented Interfaces:
Serializable
,BaseOBObjectDef
,OBNotSingleton
,OBProvidable
,ActiveEnabled
,ClientEnabled
,DynamicEnabled
,Identifiable
,OrganizationEnabled
,Traceable
public class FIN_Reconciliation extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled
Entity class for entity FIN_Reconciliation (stored in table FIN_Reconciliation).
Help: Reconciliation event of the financial account
NOTE: This class should not be instantiated directly. To instantiate this class theOBProvider
should be used.- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description static String
COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITITEMSAMOUNT
Computed column for property aPRMOutstandingDepositItemsAmount
Computed from:
(SELECT COALESCE(sum(t.depositamt), 0) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.depositamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITSITEMNO
Computed column for property aPRMOutstandingDepositsItemNo
Computed from:
(SELECT count(*) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.depositamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMNO
Computed column for property aPRMOutstandingPaymentsItemNo
Computed from:
(SELECT count(*) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.paymentamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMSAMOUNT
Computed column for property aPRMOutstandingPaymentsItemsAmount
Computed from:
(SELECT COALESCE(sum(t.paymentamt), 0) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.paymentamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMRECONCILEDITEMAMOUNT
Computed column for property aPRMReconciledItemAmount
Computed from:
(SELECT COALESCE(sum(fin_finacc_transaction.depositamt - fin_finacc_transaction.paymentamt), 0) FROM fin_finacc_transaction WHERE fin_finacc_transaction.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMRECONCILEDITEMNO
Computed column for property aPRMReconciledItemNo
Computed from:
( SELECT count(*) FROM fin_finacc_transaction WHERE fin_finacc_transaction.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMUNRECONCILEDITEMAMOUNT
Computed column for property aPRMUnReconciledItemAmount
Computed from:
(SELECT COALESCE(sum(bl.cramount - bl.dramount), 0) FROM fin_bankstatementline bl, fin_bankstatement b, fin_reconciliation r WHERE (bl.fin_finacc_transaction_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_finacc_transaction t, fin_reconciliation rec WHERE t.fin_reconciliation_id = rec.fin_reconciliation_id AND bl.fin_finacc_transaction_id = t.fin_finacc_transaction_id AND t.fin_financial_account_id = b.fin_financial_account_id AND rec.created > r.created))) AND bl.datetrx <= r.dateto AND b.fin_bankstatement_id = bl.fin_bankstatement_id AND b.fin_financial_account_id = r.fin_financial_account_id and r.fin_reconciliation_id = fin_reconciliation_id)
static String
COMPUTED_COLUMN_APRMUNRECONCILEDITEMNO
Computed column for property aPRMUnReconciledItemNo
Computed from:
(SELECT count(*) FROM fin_bankstatementline bl, fin_bankstatement b, fin_reconciliation r WHERE (bl.fin_finacc_transaction_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_finacc_transaction t, fin_reconciliation rec WHERE t.fin_reconciliation_id = rec.fin_reconciliation_id AND bl.fin_finacc_transaction_id = t.fin_finacc_transaction_id AND t.fin_financial_account_id = b.fin_financial_account_id AND rec.created > r.created))) AND bl.datetrx <= r.dateto AND b.fin_bankstatement_id = bl.fin_bankstatement_id AND b.fin_financial_account_id = r.fin_financial_account_id and r.fin_reconciliation_id = fin_reconciliation_id)
static String
ENTITY_NAME
static String
PROPERTY__COMPUTEDCOLUMNS
Property _computedColumns stored in column _computedColumns in table FIN_Reconciliationstatic String
PROPERTY_ACCOUNT
Property account stored in column FIN_Financial_Account_ID in table FIN_Reconciliation
Help: Financial account used to deposit / withdrawal money such as bank accounts or petty cashstatic String
PROPERTY_ACTIVE
Property active stored in column Isactive in table FIN_Reconciliationstatic String
PROPERTY_APRMFINACCTRANSACTIONVLIST
Property aPRMFinaccTransactionVList stored in table FIN_Reconciliationstatic String
PROPERTY_APRMPRINTDETAILED
Property aPRMPrintDetailed stored in column EM_APRM_PrintDetailed in table FIN_Reconciliation
Help: Print Detailed reconciliation reportstatic String
PROPERTY_APRMPRINTSUMMARY
Property aPRMPrintSummary stored in column EM_APRM_PrintSummary in table FIN_Reconciliation
Help: Print Summary reconciliation reportstatic String
PROPERTY_APRMPROCESSREC
Property aprmProcessRec stored in column EM_Aprm_Process_Rec in table FIN_Reconciliation
Help: Used to process and reactivate reconciliation documentsstatic String
PROPERTY_APRMPROCESSRECONCILIATION
Property aPRMProcessReconciliation stored in column EM_APRM_Process_Reconciliation in table FIN_Reconciliation
Help: Used to process and reactivate reconciliation documentsstatic String
PROPERTY_APRMPROCESSRECONCILIATIONFORCE
Property aPRMProcessReconciliationForce stored in column EM_APRM_Process_Rec_Force in table FIN_Reconciliationstatic String
PROPERTY_CLIENT
Property client stored in column AD_Client_ID in table FIN_Reconciliationstatic String
PROPERTY_CREATEDBY
Property createdBy stored in column Createdby in table FIN_Reconciliationstatic String
PROPERTY_CREATIONDATE
Property creationDate stored in column Created in table FIN_Reconciliationstatic String
PROPERTY_DOCUMENTNO
Property documentNo stored in column DocumentNo in table FIN_Reconciliationstatic String
PROPERTY_DOCUMENTSTATUS
Property documentStatus stored in column Docstatus in table FIN_Reconciliation
Help: 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.static String
PROPERTY_DOCUMENTTYPE
Property documentType stored in column C_Doctype_ID in table FIN_Reconciliation
Help: The Document Type determines document sequence and processing rulesstatic String
PROPERTY_ENDINGBALANCE
Property endingBalance stored in column Endingbalance in table FIN_Reconciliation
Help: The Ending Balance is the result of adjusting the Beginning Balance by any payments or disbursements.static String
PROPERTY_ENDINGDATE
Property endingDate stored in column Dateto in table FIN_Reconciliation
Help: The Date To indicates the end date of a range (inclusive)static String
PROPERTY_FINFINACCTRANSACTIONLIST
Property fINFinaccTransactionList stored in table FIN_Reconciliationstatic String
PROPERTY_FINRECONCILIATIONLINEVLIST
Property fINReconciliationLineVList stored in table FIN_Reconciliationstatic String
PROPERTY_ID
Property id stored in column FIN_Reconciliation_ID in table FIN_Reconciliation
Help: Reconciliation events related to the financial accountstatic String
PROPERTY_ORGANIZATION
Property organization stored in column AD_Org_ID in table FIN_Reconciliationstatic String
PROPERTY_POSTED
Property posted stored in column Posted in table FIN_Reconciliation
Help: 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.static String
PROPERTY_PRINTDETAILED
Deprecated.Property marked as deprecated on field Development Statusstatic String
PROPERTY_PRINTSUMMARY
Deprecated.Property marked as deprecated on field Development Statusstatic String
PROPERTY_PROCESSED
Property processed stored in column Processed in table FIN_Reconciliation
Help: The Processed checkbox indicates that a document has been processed.static String
PROPERTY_PROCESSNOW
Property processNow stored in column Processing in table FIN_Reconciliation
Help: When this field is set as 'Y' a process is being performed on this record.static String
PROPERTY_STARTINGBALANCE
Property startingbalance stored in column Startingbalance in table FIN_Reconciliation
Help: Starting Balancestatic String
PROPERTY_TRANSACTIONDATE
Property transactionDate stored in column Statementdate in table FIN_Reconciliationstatic String
PROPERTY_UPDATED
Property updated stored in column Updated in table FIN_Reconciliationstatic String
PROPERTY_UPDATEDBY
Property updatedBy stored in column Updatedby in table FIN_Reconciliationstatic String
TABLE_NAME
-
Fields inherited from class org.openbravo.base.structure.BaseOBObject
ID
-
-
Constructor Summary
Constructors Constructor Description FIN_Reconciliation()
-
Method Summary
-
Methods inherited from class org.openbravo.base.structure.BaseOBObject
checkDerivedReadable, get, get, getEntity, getIdentifier, getValue, isAllowRead, isNewOBObject, isOrgClientAccessCheckEnabled, isWriteAccessCheckEnabled, set, setAccessChecks, setAllowRead, setDefaultValue, setId, setNewOBObject, setValue, toString, validate
-
-
-
-
Field Detail
-
TABLE_NAME
public static final String TABLE_NAME
- See Also:
- Constant Field Values
-
ENTITY_NAME
public static final String ENTITY_NAME
- See Also:
- Constant Field Values
-
PROPERTY_ID
public static final String PROPERTY_ID
Property id stored in column FIN_Reconciliation_ID in table FIN_Reconciliation
Help: Reconciliation events related to the financial account- See Also:
- Constant Field Values
-
PROPERTY_CLIENT
public static final String PROPERTY_CLIENT
Property client stored in column AD_Client_ID in table FIN_Reconciliation- See Also:
ClientEnabled
, Constant Field Values
-
PROPERTY_ORGANIZATION
public static final String PROPERTY_ORGANIZATION
Property organization stored in column AD_Org_ID in table FIN_Reconciliation- See Also:
OrganizationEnabled
, Constant Field Values
-
PROPERTY_CREATIONDATE
public static final String PROPERTY_CREATIONDATE
Property creationDate stored in column Created in table FIN_Reconciliation- See Also:
Traceable
, Constant Field Values
-
PROPERTY_CREATEDBY
public static final String PROPERTY_CREATEDBY
Property createdBy stored in column Createdby in table FIN_Reconciliation- See Also:
Traceable
, Constant Field Values
-
PROPERTY_UPDATED
public static final String PROPERTY_UPDATED
Property updated stored in column Updated in table FIN_Reconciliation- See Also:
Traceable
, Constant Field Values
-
PROPERTY_UPDATEDBY
public static final String PROPERTY_UPDATEDBY
Property updatedBy stored in column Updatedby in table FIN_Reconciliation- See Also:
Traceable
, Constant Field Values
-
PROPERTY_ACTIVE
public static final String PROPERTY_ACTIVE
Property active stored in column Isactive in table FIN_Reconciliation- See Also:
ActiveEnabled
, Constant Field Values
-
PROPERTY_ACCOUNT
public static final String PROPERTY_ACCOUNT
Property account stored in column FIN_Financial_Account_ID in table FIN_Reconciliation
Help: Financial account used to deposit / withdrawal money such as bank accounts or petty cash- See Also:
- Constant Field Values
-
PROPERTY_DOCUMENTNO
public static final String PROPERTY_DOCUMENTNO
Property documentNo stored in column DocumentNo in table FIN_Reconciliation- See Also:
- Constant Field Values
-
PROPERTY_DOCUMENTTYPE
public static final String PROPERTY_DOCUMENTTYPE
Property documentType stored in column C_Doctype_ID in table FIN_Reconciliation
Help: The Document Type determines document sequence and processing rules- See Also:
- Constant Field Values
-
PROPERTY_ENDINGDATE
public static final String PROPERTY_ENDINGDATE
Property endingDate stored in column Dateto in table FIN_Reconciliation
Help: The Date To indicates the end date of a range (inclusive)- See Also:
- Constant Field Values
-
PROPERTY_TRANSACTIONDATE
public static final String PROPERTY_TRANSACTIONDATE
Property transactionDate stored in column Statementdate in table FIN_Reconciliation- See Also:
- Constant Field Values
-
PROPERTY_ENDINGBALANCE
public static final String PROPERTY_ENDINGBALANCE
Property endingBalance stored in column Endingbalance in table FIN_Reconciliation
Help: The Ending Balance is the result of adjusting the Beginning Balance by any payments or disbursements.- See Also:
- Constant Field Values
-
PROPERTY_STARTINGBALANCE
public static final String PROPERTY_STARTINGBALANCE
Property startingbalance stored in column Startingbalance in table FIN_Reconciliation
Help: Starting Balance- See Also:
- Constant Field Values
-
PROPERTY_DOCUMENTSTATUS
public static final String PROPERTY_DOCUMENTSTATUS
Property documentStatus stored in column Docstatus in table FIN_Reconciliation
Help: 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.- See Also:
- Constant Field Values
-
PROPERTY_PROCESSNOW
public static final String PROPERTY_PROCESSNOW
Property processNow stored in column Processing in table FIN_Reconciliation
Help: When this field is set as 'Y' a process is being performed on this record.- See Also:
- Constant Field Values
-
PROPERTY_PROCESSED
public static final String PROPERTY_PROCESSED
Property processed stored in column Processed in table FIN_Reconciliation
Help: The Processed checkbox indicates that a document has been processed.- See Also:
- Constant Field Values
-
PROPERTY_POSTED
public static final String PROPERTY_POSTED
Property posted stored in column Posted in table FIN_Reconciliation
Help: 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.- See Also:
- Constant Field Values
-
PROPERTY_PRINTDETAILED
@Deprecated public static final String PROPERTY_PRINTDETAILED
Deprecated.Property marked as deprecated on field Development StatusProperty printdetailed stored in column Printdetailed in table FIN_Reconciliation
Help: Print Detailed- See Also:
- Constant Field Values
-
PROPERTY_PRINTSUMMARY
@Deprecated public static final String PROPERTY_PRINTSUMMARY
Deprecated.Property marked as deprecated on field Development StatusProperty printsummary stored in column Printsummary in table FIN_Reconciliation
Help: Print Summary- See Also:
- Constant Field Values
-
PROPERTY_APRMPROCESSRECONCILIATION
public static final String PROPERTY_APRMPROCESSRECONCILIATION
Property aPRMProcessReconciliation stored in column EM_APRM_Process_Reconciliation in table FIN_Reconciliation
Help: Used to process and reactivate reconciliation documents- See Also:
- Constant Field Values
-
PROPERTY_APRMPRINTDETAILED
public static final String PROPERTY_APRMPRINTDETAILED
Property aPRMPrintDetailed stored in column EM_APRM_PrintDetailed in table FIN_Reconciliation
Help: Print Detailed reconciliation report- See Also:
- Constant Field Values
-
PROPERTY_APRMPRINTSUMMARY
public static final String PROPERTY_APRMPRINTSUMMARY
Property aPRMPrintSummary stored in column EM_APRM_PrintSummary in table FIN_Reconciliation
Help: Print Summary reconciliation report- See Also:
- Constant Field Values
-
PROPERTY_APRMPROCESSREC
public static final String PROPERTY_APRMPROCESSREC
Property aprmProcessRec stored in column EM_Aprm_Process_Rec in table FIN_Reconciliation
Help: Used to process and reactivate reconciliation documents- See Also:
- Constant Field Values
-
PROPERTY_APRMPROCESSRECONCILIATIONFORCE
public static final String PROPERTY_APRMPROCESSRECONCILIATIONFORCE
Property aPRMProcessReconciliationForce stored in column EM_APRM_Process_Rec_Force in table FIN_Reconciliation- See Also:
- Constant Field Values
-
PROPERTY__COMPUTEDCOLUMNS
public static final String PROPERTY__COMPUTEDCOLUMNS
Property _computedColumns stored in column _computedColumns in table FIN_Reconciliation- See Also:
- Constant Field Values
-
PROPERTY_APRMFINACCTRANSACTIONVLIST
public static final String PROPERTY_APRMFINACCTRANSACTIONVLIST
Property aPRMFinaccTransactionVList stored in table FIN_Reconciliation- See Also:
- Constant Field Values
-
PROPERTY_FINFINACCTRANSACTIONLIST
public static final String PROPERTY_FINFINACCTRANSACTIONLIST
Property fINFinaccTransactionList stored in table FIN_Reconciliation- See Also:
- Constant Field Values
-
PROPERTY_FINRECONCILIATIONLINEVLIST
public static final String PROPERTY_FINRECONCILIATIONLINEVLIST
Property fINReconciliationLineVList stored in table FIN_Reconciliation- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITITEMSAMOUNT
public static final String COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITITEMSAMOUNT
Computed column for property aPRMOutstandingDepositItemsAmount
Computed from:
(SELECT COALESCE(sum(t.depositamt), 0) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.depositamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITSITEMNO
public static final String COMPUTED_COLUMN_APRMOUTSTANDINGDEPOSITSITEMNO
Computed column for property aPRMOutstandingDepositsItemNo
Computed from:
(SELECT count(*) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.depositamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMNO
public static final String COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMNO
Computed column for property aPRMOutstandingPaymentsItemNo
Computed from:
(SELECT count(*) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.paymentamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMSAMOUNT
public static final String COMPUTED_COLUMN_APRMOUTSTANDINGPAYMENTSITEMSAMOUNT
Computed column for property aPRMOutstandingPaymentsItemsAmount
Computed from:
(SELECT COALESCE(sum(t.paymentamt), 0) FROM fin_finacc_transaction t, fin_reconciliation rec WHERE (t.fin_reconciliation_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_reconciliation r WHERE r.dateto > rec.dateto AND t.fin_reconciliation_id = r.fin_reconciliation_id ))) AND t.statementdate <= rec.dateto AND t.paymentamt <> 0 AND t.fin_financial_account_id = rec.fin_financial_account_id AND rec.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMRECONCILEDITEMAMOUNT
public static final String COMPUTED_COLUMN_APRMRECONCILEDITEMAMOUNT
Computed column for property aPRMReconciledItemAmount
Computed from:
(SELECT COALESCE(sum(fin_finacc_transaction.depositamt - fin_finacc_transaction.paymentamt), 0) FROM fin_finacc_transaction WHERE fin_finacc_transaction.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMRECONCILEDITEMNO
public static final String COMPUTED_COLUMN_APRMRECONCILEDITEMNO
Computed column for property aPRMReconciledItemNo
Computed from:
( SELECT count(*) FROM fin_finacc_transaction WHERE fin_finacc_transaction.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMUNRECONCILEDITEMAMOUNT
public static final String COMPUTED_COLUMN_APRMUNRECONCILEDITEMAMOUNT
Computed column for property aPRMUnReconciledItemAmount
Computed from:
(SELECT COALESCE(sum(bl.cramount - bl.dramount), 0) FROM fin_bankstatementline bl, fin_bankstatement b, fin_reconciliation r WHERE (bl.fin_finacc_transaction_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_finacc_transaction t, fin_reconciliation rec WHERE t.fin_reconciliation_id = rec.fin_reconciliation_id AND bl.fin_finacc_transaction_id = t.fin_finacc_transaction_id AND t.fin_financial_account_id = b.fin_financial_account_id AND rec.created > r.created))) AND bl.datetrx <= r.dateto AND b.fin_bankstatement_id = bl.fin_bankstatement_id AND b.fin_financial_account_id = r.fin_financial_account_id and r.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
COMPUTED_COLUMN_APRMUNRECONCILEDITEMNO
public static final String COMPUTED_COLUMN_APRMUNRECONCILEDITEMNO
Computed column for property aPRMUnReconciledItemNo
Computed from:
(SELECT count(*) FROM fin_bankstatementline bl, fin_bankstatement b, fin_reconciliation r WHERE (bl.fin_finacc_transaction_id IS NULL OR (EXISTS ( SELECT 1 FROM fin_finacc_transaction t, fin_reconciliation rec WHERE t.fin_reconciliation_id = rec.fin_reconciliation_id AND bl.fin_finacc_transaction_id = t.fin_finacc_transaction_id AND t.fin_financial_account_id = b.fin_financial_account_id AND rec.created > r.created))) AND bl.datetrx <= r.dateto AND b.fin_bankstatement_id = bl.fin_bankstatement_id AND b.fin_financial_account_id = r.fin_financial_account_id and r.fin_reconciliation_id = fin_reconciliation_id)
- See Also:
- Constant Field Values
-
-
Method Detail
-
getEntityName
public String getEntityName()
- Specified by:
getEntityName
in interfaceIdentifiable
- Specified by:
getEntityName
in classBaseOBObject
-
getId
public String getId()
- Specified by:
getId
in interfaceBaseOBObjectDef
- Specified by:
getId
in interfaceIdentifiable
- Overrides:
getId
in classBaseOBObject
- See Also:
PROPERTY_ID
-
setId
public void setId(String id)
- See Also:
PROPERTY_ID
-
getClient
public Client getClient()
Description copied from interface:ClientEnabled
Client field- Specified by:
getClient
in interfaceClientEnabled
- Returns:
- client
- See Also:
PROPERTY_CLIENT
-
setClient
public void setClient(Client client)
Description copied from interface:ClientEnabled
Client field- Specified by:
setClient
in interfaceClientEnabled
- See Also:
PROPERTY_CLIENT
-
getOrganization
public Organization getOrganization()
Description copied from interface:OrganizationEnabled
Gets organization field- Specified by:
getOrganization
in interfaceOrganizationEnabled
- Returns:
- organization
- See Also:
PROPERTY_ORGANIZATION
-
setOrganization
public void setOrganization(Organization organization)
Description copied from interface:OrganizationEnabled
Sets organization field- Specified by:
setOrganization
in interfaceOrganizationEnabled
- See Also:
PROPERTY_ORGANIZATION
-
getCreationDate
public Date getCreationDate()
Description copied from interface:Traceable
Creation date of audit- Specified by:
getCreationDate
in interfaceTraceable
- Returns:
- Date of creation
- See Also:
PROPERTY_CREATIONDATE
-
setCreationDate
public void setCreationDate(Date creationDate)
Description copied from interface:Traceable
Creation date of audit- Specified by:
setCreationDate
in interfaceTraceable
- See Also:
PROPERTY_CREATIONDATE
-
getCreatedBy
public User getCreatedBy()
Description copied from interface:Traceable
Created by audit user- Specified by:
getCreatedBy
in interfaceTraceable
- Returns:
- User
- See Also:
PROPERTY_CREATEDBY
-
setCreatedBy
public void setCreatedBy(User createdBy)
Description copied from interface:Traceable
Created by audit user- Specified by:
setCreatedBy
in interfaceTraceable
- See Also:
PROPERTY_CREATEDBY
-
getUpdated
public Date getUpdated()
Description copied from interface:Traceable
Update date of audit- Specified by:
getUpdated
in interfaceTraceable
- Returns:
- Date of update
- See Also:
PROPERTY_UPDATED
-
setUpdated
public void setUpdated(Date updated)
Description copied from interface:Traceable
Update date of audit- Specified by:
setUpdated
in interfaceTraceable
- See Also:
PROPERTY_UPDATED
-
getUpdatedBy
public User getUpdatedBy()
Description copied from interface:Traceable
Update by audit user- Specified by:
getUpdatedBy
in interfaceTraceable
- Returns:
- User who updated
- See Also:
PROPERTY_UPDATEDBY
-
setUpdatedBy
public void setUpdatedBy(User updatedBy)
Description copied from interface:Traceable
Update by audit user- Specified by:
setUpdatedBy
in interfaceTraceable
- See Also:
PROPERTY_UPDATEDBY
-
isActive
public Boolean isActive()
Description copied from interface:ActiveEnabled
Gets active field- Specified by:
isActive
in interfaceActiveEnabled
- Returns:
- active
- See Also:
PROPERTY_ACTIVE
-
setActive
public void setActive(Boolean active)
Description copied from interface:ActiveEnabled
Sets active field- Specified by:
setActive
in interfaceActiveEnabled
- See Also:
PROPERTY_ACTIVE
-
getAccount
public FIN_FinancialAccount getAccount()
- See Also:
PROPERTY_ACCOUNT
-
setAccount
public void setAccount(FIN_FinancialAccount account)
- See Also:
PROPERTY_ACCOUNT
-
getDocumentNo
public String getDocumentNo()
- See Also:
PROPERTY_DOCUMENTNO
-
setDocumentNo
public void setDocumentNo(String documentNo)
- See Also:
PROPERTY_DOCUMENTNO
-
getDocumentType
public DocumentType getDocumentType()
- See Also:
PROPERTY_DOCUMENTTYPE
-
setDocumentType
public void setDocumentType(DocumentType documentType)
- See Also:
PROPERTY_DOCUMENTTYPE
-
getEndingDate
public Date getEndingDate()
- See Also:
PROPERTY_ENDINGDATE
-
setEndingDate
public void setEndingDate(Date endingDate)
- See Also:
PROPERTY_ENDINGDATE
-
getTransactionDate
public Date getTransactionDate()
- See Also:
PROPERTY_TRANSACTIONDATE
-
setTransactionDate
public void setTransactionDate(Date transactionDate)
- See Also:
PROPERTY_TRANSACTIONDATE
-
getEndingBalance
public BigDecimal getEndingBalance()
- See Also:
PROPERTY_ENDINGBALANCE
-
setEndingBalance
public void setEndingBalance(BigDecimal endingBalance)
- See Also:
PROPERTY_ENDINGBALANCE
-
getStartingbalance
public BigDecimal getStartingbalance()
- See Also:
PROPERTY_STARTINGBALANCE
-
setStartingbalance
public void setStartingbalance(BigDecimal startingbalance)
- See Also:
PROPERTY_STARTINGBALANCE
-
getDocumentStatus
public String getDocumentStatus()
- See Also:
PROPERTY_DOCUMENTSTATUS
-
setDocumentStatus
public void setDocumentStatus(String documentStatus)
- See Also:
PROPERTY_DOCUMENTSTATUS
-
isProcessNow
public Boolean isProcessNow()
- See Also:
PROPERTY_PROCESSNOW
-
setProcessNow
public void setProcessNow(Boolean processNow)
- See Also:
PROPERTY_PROCESSNOW
-
isProcessed
public Boolean isProcessed()
- See Also:
PROPERTY_PROCESSED
-
setProcessed
public void setProcessed(Boolean processed)
- See Also:
PROPERTY_PROCESSED
-
getPosted
public String getPosted()
- See Also:
PROPERTY_POSTED
-
setPosted
public void setPosted(String posted)
- See Also:
PROPERTY_POSTED
-
isPrintdetailed
@Deprecated public Boolean isPrintdetailed()
Deprecated.Property marked as deprecated on field Development Status- See Also:
PROPERTY_PRINTDETAILED
-
setPrintdetailed
@Deprecated public void setPrintdetailed(Boolean printdetailed)
Deprecated.Property marked as deprecated on field Development Status- See Also:
PROPERTY_PRINTDETAILED
-
isPrintsummary
@Deprecated public Boolean isPrintsummary()
Deprecated.Property marked as deprecated on field Development Status- See Also:
PROPERTY_PRINTSUMMARY
-
setPrintsummary
@Deprecated public void setPrintsummary(Boolean printsummary)
Deprecated.Property marked as deprecated on field Development Status- See Also:
PROPERTY_PRINTSUMMARY
-
getAPRMProcessReconciliation
public String getAPRMProcessReconciliation()
- See Also:
PROPERTY_APRMPROCESSRECONCILIATION
-
setAPRMProcessReconciliation
public void setAPRMProcessReconciliation(String aPRMProcessReconciliation)
- See Also:
PROPERTY_APRMPROCESSRECONCILIATION
-
isAPRMPrintDetailed
public Boolean isAPRMPrintDetailed()
- See Also:
PROPERTY_APRMPRINTDETAILED
-
setAPRMPrintDetailed
public void setAPRMPrintDetailed(Boolean aPRMPrintDetailed)
- See Also:
PROPERTY_APRMPRINTDETAILED
-
isAPRMPrintSummary
public Boolean isAPRMPrintSummary()
- See Also:
PROPERTY_APRMPRINTSUMMARY
-
setAPRMPrintSummary
public void setAPRMPrintSummary(Boolean aPRMPrintSummary)
- See Also:
PROPERTY_APRMPRINTSUMMARY
-
getAprmProcessRec
public String getAprmProcessRec()
- See Also:
PROPERTY_APRMPROCESSREC
-
setAprmProcessRec
public void setAprmProcessRec(String aprmProcessRec)
- See Also:
PROPERTY_APRMPROCESSREC
-
getAPRMProcessReconciliationForce
public String getAPRMProcessReconciliationForce()
- See Also:
PROPERTY_APRMPROCESSRECONCILIATIONFORCE
-
setAPRMProcessReconciliationForce
public void setAPRMProcessReconciliationForce(String aPRMProcessReconciliationForce)
- See Also:
PROPERTY_APRMPROCESSRECONCILIATIONFORCE
-
getAPRMOutstandingDepositItemsAmount
public BigDecimal getAPRMOutstandingDepositItemsAmount()
-
setAPRMOutstandingDepositItemsAmount
public void setAPRMOutstandingDepositItemsAmount(BigDecimal aPRMOutstandingDepositItemsAmount)
-
getAPRMOutstandingDepositsItemNo
public Long getAPRMOutstandingDepositsItemNo()
-
setAPRMOutstandingDepositsItemNo
public void setAPRMOutstandingDepositsItemNo(Long aPRMOutstandingDepositsItemNo)
-
getAPRMOutstandingPaymentsItemNo
public Long getAPRMOutstandingPaymentsItemNo()
-
setAPRMOutstandingPaymentsItemNo
public void setAPRMOutstandingPaymentsItemNo(Long aPRMOutstandingPaymentsItemNo)
-
getAPRMOutstandingPaymentsItemsAmount
public BigDecimal getAPRMOutstandingPaymentsItemsAmount()
-
setAPRMOutstandingPaymentsItemsAmount
public void setAPRMOutstandingPaymentsItemsAmount(BigDecimal aPRMOutstandingPaymentsItemsAmount)
-
getAPRMReconciledItemAmount
public BigDecimal getAPRMReconciledItemAmount()
- See Also:
COMPUTED_COLUMN_APRMRECONCILEDITEMAMOUNT
-
setAPRMReconciledItemAmount
public void setAPRMReconciledItemAmount(BigDecimal aPRMReconciledItemAmount)
- See Also:
COMPUTED_COLUMN_APRMRECONCILEDITEMAMOUNT
-
getAPRMReconciledItemNo
public Long getAPRMReconciledItemNo()
- See Also:
COMPUTED_COLUMN_APRMRECONCILEDITEMNO
-
setAPRMReconciledItemNo
public void setAPRMReconciledItemNo(Long aPRMReconciledItemNo)
- See Also:
COMPUTED_COLUMN_APRMRECONCILEDITEMNO
-
getAPRMUnReconciledItemAmount
public BigDecimal getAPRMUnReconciledItemAmount()
-
setAPRMUnReconciledItemAmount
public void setAPRMUnReconciledItemAmount(BigDecimal aPRMUnReconciledItemAmount)
-
getAPRMUnReconciledItemNo
public Long getAPRMUnReconciledItemNo()
- See Also:
COMPUTED_COLUMN_APRMUNRECONCILEDITEMNO
-
setAPRMUnReconciledItemNo
public void setAPRMUnReconciledItemNo(Long aPRMUnReconciledItemNo)
- See Also:
COMPUTED_COLUMN_APRMUNRECONCILEDITEMNO
-
get_computedColumns
public FIN_Reconciliation_ComputedColumns get_computedColumns()
- See Also:
PROPERTY__COMPUTEDCOLUMNS
-
set_computedColumns
public void set_computedColumns(FIN_Reconciliation_ComputedColumns _computedColumns)
- See Also:
PROPERTY__COMPUTEDCOLUMNS
-
getAPRMFinaccTransactionVList
public List<APRM_FinaccTransactionV> getAPRMFinaccTransactionVList()
- See Also:
APRM_FinaccTransactionV
-
setAPRMFinaccTransactionVList
public void setAPRMFinaccTransactionVList(List<APRM_FinaccTransactionV> aPRMFinaccTransactionVList)
- See Also:
APRM_FinaccTransactionV
-
getFINFinaccTransactionList
public List<FIN_FinaccTransaction> getFINFinaccTransactionList()
- See Also:
FIN_FinaccTransaction
-
setFINFinaccTransactionList
public void setFINFinaccTransactionList(List<FIN_FinaccTransaction> fINFinaccTransactionList)
- See Also:
FIN_FinaccTransaction
-
getFINReconciliationLineVList
public List<FIN_ReconciliationLine_v> getFINReconciliationLineVList()
- See Also:
FIN_ReconciliationLine_v
-
setFINReconciliationLineVList
public void setFINReconciliationLineVList(List<FIN_ReconciliationLine_v> fINReconciliationLineVList)
- See Also:
FIN_ReconciliationLine_v
-
get
public Object get(String propName)
Description copied from class:BaseOBObject
Returns the value of theProperty
identified by the propName. This method does security checking. If a security violation occurs then a OBSecurityException is thrown.- Specified by:
get
in interfaceBaseOBObjectDef
- Specified by:
get
in interfaceDynamicEnabled
- Overrides:
get
in classBaseOBObject
- Parameters:
propName
- the name of theProperty
for which the value is requested- See Also:
BaseOBObject.get(String, Language)
-
-