project QadFinancials > class BJournalEntry > business logic query PostingByApproveStatus

Parameters


iiCompanyIdintegerCompany id
itPostingDateFromdate
itPostingDateTodate
itPostingVerifiedDatedate
icPostingTextcharacter
iiPostingYearinteger
iiPostingVoucherinteger
icPostingApproveStatuscharacter
icJournalCodeFromcharacter
icUsrLogincharacter
iiPeriodPeriodinteger
itPostingSystemDatedate
iiLastVerifiedUsr_IDinteger
icPostingVerifyStatuscharacter
icJournalCodeTocharacter
icJournalTypeCodecharacter
itPostingDatedate
icJournalCodecharacter

query condition


  each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.PostingDate >= itPostingDateFrom AND
Posting.PostingDate <= itPostingDateTo AND
Posting.PostingVerifiedDate = itPostingVerifiedDate AND
Posting.PostingText = icPostingText AND
Posting.PostingYear = iiPostingYear AND
Posting.PostingVoucher = iiPostingVoucher AND
Posting.PostingApproveStatus = icPostingApproveStatus AND
Posting.PostingSystemDate = itPostingSystemDate AND
Posting.LastVerifiedUsr_ID = iiLastVerifiedUsr_ID AND
Posting.PostingVerifyStatus = icPostingVerifyStatus AND
Posting.PostingDate = itPostingDate

      first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
Journal.JournalCode >= icJournalCodeFrom AND
Journal.JournalCode <= icJournalCodeTo AND
Journal.JournalTypeCode = icJournalTypeCode AND
Journal.JournalCode = icJournalCode

      first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodPeriod = iiPeriodPeriod

      first Usr (inner-join) where
Usr.Usr_ID = Posting.CreatorUsr_ID AND
Usr.UsrLogin = icUsrLogin

query resultset tqPostingByApproveStatus


field namedata typedb fielddescription
tiAutoReversalPosting_IDintegerPosting.AutoReversalPosting_IDAutomatic Reversal Posting
tiCompany_IDintegerPosting.Company_IDLink to Company
tiCreatorUsr_IDintegerPosting.CreatorUsr_IDLogin
tcCustomCombo0characterPosting.CustomCombo0Custom Combo Field
tcCustomCombo1characterPosting.CustomCombo1Custom Combo Field
tcCustomCombo10characterPosting.CustomCombo10Custom Combo Field
tcCustomCombo11characterPosting.CustomCombo11Custom Combo Field
tcCustomCombo12characterPosting.CustomCombo12Custom Combo Field
tcCustomCombo13characterPosting.CustomCombo13Custom Combo Field
tcCustomCombo14characterPosting.CustomCombo14Custom Combo Field
tcCustomCombo2characterPosting.CustomCombo2Custom Combo Field
tcCustomCombo3characterPosting.CustomCombo3Custom Combo Field
tcCustomCombo4characterPosting.CustomCombo4Custom Combo Field
tcCustomCombo5characterPosting.CustomCombo5Custom Combo Field
tcCustomCombo6characterPosting.CustomCombo6Custom Combo Field
tcCustomCombo7characterPosting.CustomCombo7Custom Combo Field
tcCustomCombo8characterPosting.CustomCombo8Custom Combo Field
tcCustomCombo9characterPosting.CustomCombo9Custom Combo Field
ttCustomDate0datePosting.CustomDate0Custom Date Field
ttCustomDate1datePosting.CustomDate1Custom Date Field
ttCustomDate2datePosting.CustomDate2Custom Date Field
ttCustomDate3datePosting.CustomDate3Custom Date Field
ttCustomDate4datePosting.CustomDate4Custom Date Field
ttCustomDate5datePosting.CustomDate5Custom Date Field
ttCustomDate6datePosting.CustomDate6Custom Date Field
ttCustomDate7datePosting.CustomDate7Custom Date Field
ttCustomDate8datePosting.CustomDate8Custom Date Field
ttCustomDate9datePosting.CustomDate9Custom Date Field
tdCustomDecimal0decimalPosting.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalPosting.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalPosting.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalPosting.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalPosting.CustomDecimal4Custom Decimal Field
tdCustomDecimal5decimalPosting.CustomDecimal5Custom Decimal Field
tdCustomDecimal6decimalPosting.CustomDecimal6Custom Decimal Field
tdCustomDecimal7decimalPosting.CustomDecimal7Custom Decimal Field
tdCustomDecimal8decimalPosting.CustomDecimal8Custom Decimal Field
tdCustomDecimal9decimalPosting.CustomDecimal9Custom Decimal Field
tiCustomInteger0integerPosting.CustomInteger0Custom Integer Field
tiCustomInteger1integerPosting.CustomInteger1Custom Integer Field
tiCustomInteger2integerPosting.CustomInteger2Custom Integer Field
tiCustomInteger3integerPosting.CustomInteger3Custom Integer Field
tiCustomInteger4integerPosting.CustomInteger4Custom Integer Field
tcCustomLong0characterPosting.CustomLong0Custom Long Field
tcCustomLong1characterPosting.CustomLong1Custom Long Field
tcCustomNotecharacterPosting.CustomNoteCustom Note Field
tcCustomShort0characterPosting.CustomShort0Custom Short Field
tcCustomShort1characterPosting.CustomShort1Custom Short Field
tcCustomShort10characterPosting.CustomShort10Custom Short Field
tcCustomShort11characterPosting.CustomShort11Custom Short Field
tcCustomShort12characterPosting.CustomShort12Custom Short Field
tcCustomShort13characterPosting.CustomShort13Custom Short Field
tcCustomShort14characterPosting.CustomShort14Custom Short Field
tcCustomShort2characterPosting.CustomShort2Custom Short Field
tcCustomShort3characterPosting.CustomShort3Custom Short Field
tcCustomShort4characterPosting.CustomShort4Custom Short Field
tcCustomShort5characterPosting.CustomShort5Custom Short Field
tcCustomShort6characterPosting.CustomShort6Custom Short Field
tcCustomShort7characterPosting.CustomShort7Custom Short Field
tcCustomShort8characterPosting.CustomShort8Custom Short Field
tcCustomShort9characterPosting.CustomShort9Custom Short Field
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tiLastApprovedUsr_IDintegerPosting.LastApprovedUsr_IDLink to Usr
ttLastModifiedDatedatePosting.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerPosting.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterPosting.LastModifiedUserLast Modified User
tiLastVerifiedUsr_IDintegerPosting.LastVerifiedUsr_IDLink to Usr
tiObsoleteClosing_IDintegerPosting.ObsoleteClosing_IDLink to Closing
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPeriodMark_IDintegerPosting.PeriodMark_IDLink to PeriodMark
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPosting_IDintegerPosting.Posting_IDRecord ID
tiPostingAddGLNbrintegerPosting.PostingAddGLNbrWhen additional GL numbering is enabled for an entity, all postings for this entity are assigned a continuous, uninterrupted incremental sequence numbers as the value for this field.
api annotation:When additional GL numbering is not enabled for the current entity, value for this field defaults to 0.
ttPostingAddGLNbrDatedatePosting.PostingAddGLNbrDateAdditional GL Numbering Date
ttPostingAddGLNbrRevDatedatePosting.PostingAddGLNbrRevDateAdditional GL Numbering Reversal Date
tcPostingApproveCommentscharacterPosting.PostingApproveCommentsWhen running the process of approval, the approver can add some comments on the transaction.
api annotation:Value for this field defaults to blank.
ttPostingApprovedDatedatePosting.PostingApprovedDateThe date on which this posting was last approved.
api annotation:Value for this field defaults to blank.
tiPostingApprovedTimeintegerPosting.PostingApprovedTimeLast Approved Time.
api annotation:The system generates default values for this field, depending on when this posting was last approved. The combination of "PostingApprovedDate" and "PostingApprovedTime" uniquely identify the time at which this posting was last approved.
tcPostingApproveStatuscharacterPosting.PostingApproveStatusChina Financial Regulation requires that all the GL transactions must be verified as well as approved. This field holds the Approval status.
api annotation:Value for this field defaults to "INITIAL".
ttPostingAutoReversalDatedatePosting.PostingAutoReversalDateAutomatic Reversal Date.
api annotation:When the flag PostingIsAutoReversal is "true" - If partialupdate="false", complete this field manually with a date in a later period than the one of the original entry; If partialupdate="true", value of this field will default to the first day of the next period.
tcPostingAutoReversalTypecharacterPosting.PostingAutoReversalTypeIf this posting is involved in automatic reversal activity of posting, value of this field will indicate whether this posting is the original one or the reversing one. It is calculated by the system.
api annotation:If the flag PostingIsAutoReversal is "true", the field value defaults to "ORIGINAL ENTRY" for the original posting, and to "REVERSING ENTRY" for the reversing posting.
tcPostingBankImpRefcharacterPosting.PostingBankImpRefBank Importing Reference
tcPostingBatchNumbercharacterPosting.PostingBatchNumberSome financial input programs allow you to enter a batch number and to keep a control total on the screen of all the transactions entered with the same batch number.
api annotation:Not applicable for application integration.
tcPostingBusinessRelationTxtcharacterPosting.PostingBusinessRelationTxtWhen the posting is a transaction linked to a business relation (for example, an invoice posting), this field contains the Business Relation Name. Used for information purposes on reports and browses.
api annotation:Value for this field defaults to blank.
ttPostingCreationDatedatePosting.PostingCreationDateCreation Date
tcPostingCreationTimeStringcharacterPosting.PostingCreationTimeStringSeconds since midnight in HH:MM:SS
ttPostingDatedatePosting.PostingDateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tcPostingInvoiceReferenceTxtcharacterPosting.PostingInvoiceReferenceTxtWhen the posting is part of an invoice posting, then this field contains the invoice number (Year/Daybook/Voucher extended with supplier invoice Reference in case of a supplier invoice). Used for information purpose on reports and browsers.
api annotation:Value for this field defaults to blank
tlPostingIsAutoReversallogicalPosting.PostingIsAutoReversalIndicate whether the posting leads to an automatic reversal.
api annotation:Value for this field defaults to "false".
tlPostingIsCorrectionlogicalPosting.PostingIsCorrectionIndicates whether the posting is part of a correction action.
api annotation:Value for this field defaults to "false".
tlPostingIsReplacementlogicalPosting.PostingIsReplacementIndicate whether the posting is a replacement of an existing posting.
api annotation:Value for this field defaults to "false". For reversal postings, either automatic or manual - this value defaults to "true".
tlPostingIsReversinglogicalPosting.PostingIsReversingIndicate whether the posting is a reversal of an existing posting.
api annotation:Value for this field defaults to "false".
tlPostingIsReversingBySignlogicalPosting.PostingIsReversingBySignIndicate whether the mathematical inversion - inverse the mathematic sign of the amounts (+ => - and - => +) - has been applied.
api annotation:Value for this field defaults to "false".
tlPostingIsSkipAutoAssignLClogicalPosting.PostingIsSkipAutoAssignLCWhen a LC field (Base Currency Amount field of PostingLine) is left zero, but the TC field (transaction currency amount) is not zero, then the posting component automatically calculates the corresponding value for the LC field. With some postings, this behavior is not wanted and can be suppressed by setting this flag to "true".
api annotation:Value for this field defaults to "false".
tlPostingIsZeroValueAllowedlogicalPosting.PostingIsZeroValueAllowedIndicate whether zero values are allowed in the posting lines.
api annotation:Value for this field defaults to "false".
tcPostingMirrorRefcharacterPosting.PostingMirrorRefWhen Mirror Accounting is activated, postings that are mirrored get a reference to their paired posting. The reference contains year, daybook and voucher.
api annotation:Value for this field defaults to blank.
tcPostingOriginAddressCodecharacterPosting.PostingOriginAddressCodeFor invoices created with Invoice Post and Print, the address code of the bill-to customer is stored in this field.
tcPostingOriginatorReferencecharacterPosting.PostingOriginatorReferenceOriginal Posting Reference. this field must contain the key values of the refered posting, if this posting is a manual reversal or replacement of an existing posting.
api annotation:Value for this field defaults to blank.
tcPostingOriginDaybookCodecharacterPosting.PostingOriginDaybookCodeDaybook Code (normally this corresponds with our JournalCode)
MfgPro equivalent: glt_dy_code
tcPostingOriginDaybookNumbercharacterPosting.PostingOriginDaybookNumberDaybook Number (normally this corresponds with our PostingVoucher)
MfgPro equivalent: glt_dy_num
tcPostingOriginDocumentcharacterPosting.PostingOriginDocumentTransaction History Number (Inventory or Operations) or Invoice Number (Sales Order)
MfgPro equivalent: glt_doc
tcPostingOriginDocumentTypecharacterPosting.PostingOriginDocumentTypeDocument Type (I for Invoice, OP for Work Orders)
MfgPro equivalent: glt_doc_type
tlPostingOriginIsExternallogicalPosting.PostingOriginIsExternalIndicate whether the posting is from an External Origin. When creating cross company postings, set this to true.
api annotation:Value for this field defaults to false.
tcPostingOriginReferencecharacterPosting.PostingOriginReferenceGL Reference Number. Format is ZZYYMMDD999999 where ZZ = module (IC, SO, WO) YY = Year, MM = Month, DD = Day, 999999 = Running Journal Number.
MfgPro equivalent: glt_ref
tcPostingOriginTransTypecharacterPosting.PostingOriginTransTypeSystem generated code used to identify a transaction (IC for Inventory, WO for Work Orders, SO for Sales Orders, FA for Fixed Assets)
MfgPro equivalent: glt_tr_type
tcPostingParentTextcharacterPosting.PostingParentTextContains the description field from the parent object that triggered the posting. When the posting is an invoice posting, this field contains the invoice description. When the posting is a banking entry posting, the description of the bank statement line is copied to this field, etc. Used for information purposes on reports and browses.
api annotation:Value for this field defaults to blank.
tiPostingPeriodintegerPosting.PostingPeriodThe GL period for the posting. The period must be open.
tcPostingSecondTextcharacterPosting.PostingSecondTextSecond Description
ttPostingSystemDatedatePosting.PostingSystemDateThe system date of the posting corresponding to "PostingDate".
api annotation:In Create mode, when Partial Update = yes - this field gets a default value which is the current date of the system.
tcPostingTextcharacterPosting.PostingTextFree text describing the posting.
api annotation:Value for this field defaults to blank
ttPostingValueDatedatePosting.PostingValueDateThe value date (used for banking entries).
ttPostingVerifiedDatedatePosting.PostingVerifiedDateThe date when this posting is last verified.
api annotation:Value for this field defaults to blank.
tiPostingVerifiedTimeintegerPosting.PostingVerifiedTimeLast Verified Time.
api annotation:System generates a default value for this field depending on when this posting was last verified. The combination of "PostingVerifiedDate" and "PostingVerifiedTime" uniquely identify the time at which this posting was last verified.
tcPostingVerifyCommentscharacterPosting.PostingVerifyCommentsWhen running the process of verification, the verifier can add some comments on the transaction.
api annotation:Value for this field defaults to blank.
tcPostingVerifyStatuscharacterPosting.PostingVerifyStatusChina Financial Regulation requires that all GL transactions be verified as well as approved. This field holds the verification status.
api annotation:Value for this field defaults to "INITIAL".
tiPostingVoucherintegerPosting.PostingVoucherVoucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
api annotation:In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.
tiPostingYearPeriodintegerPosting.PostingYearPeriodThe GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
api annotation:If Partial Update is true, the value defaults using PostingPeriod and PostingYear.
tcQADC01characterPosting.QADC01unused QAD reserved field
tcQADC02characterPosting.QADC02unused QAD reserved field
tdQADD01decimalPosting.QADD01unused QAD reserved field
ttQADT01datePosting.QADT01unused QAD reserved field
tiReportingJournal_IDintegerPosting.ReportingJournal_IDReporting Daybook
tcUsrLogincharacterUsr.UsrLoginLogin
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Posting),rowid(Journal),rowid(Period),rowid(Usr)

Internal usage


QadFinancials
method BJournalEntry.GetPostingStatusChange