project QadFinancials > class BDDocument > business logic query GetPostingInfoByDocumentID
Parameters
iiCompanyId | integer | Company id |
iiDDocumentID | integer | |
query condition
each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = iiDDocumentID
each DDocumentPostingLine (inner-join) where
DDocumentPostingLine.DDocument_ID = DDocument.DDocument_ID AND
first PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = DDocumentPostingLine.PostingLine_ID AND
first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
query resultset tqGetPostingInfoByDocumentID
field name | data type | db field | description |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tiPostingVoucher | integer | Posting.PostingVoucher | Voucher 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. |
tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
Internal usage
QadFinancials