Class FIN_Reconciliation

    • Field Detail

      • 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_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_UPDATEDBY

        public static final String PROPERTY_UPDATEDBY
        Property updatedBy stored in column Updatedby in table FIN_Reconciliation
        See Also:
        Traceable, 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 Status
        Property 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 Status
        Property 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
    • Constructor Detail

      • FIN_Reconciliation

        public FIN_Reconciliation()