project QadFinancials > class BPosting > business logic query PostingVATByPeriodPeriodMark
Description
PostingVATByPeriodPeriodMark; Get VAT-postings based on the Period and the PeriodMark
Parameters
| iiCompanyId | integer | Company id |
| iiVATPeriodID | integer | VATPeriodID |
| iiPeriodMarkID | integer | PeriodMarkID |
query condition
each PostingVat where
PostingVat.PeriodMark_ID = iiPeriodMarkID AND
PostingVat.VatPeriod_ID = iiVATPeriodID
first PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = PostingVat.PostingLine_ID AND
first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND
query sort order
Posting.Company_ID (ascending)
query resultset tqPostingVATByPeriodPeriodMark
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Posting.Company_ID | Link to Company |
| tiPeriodMark_ID | integer | PostingVat.PeriodMark_ID | Link to PeriodMark |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
| ttPostingDate | date | Posting.PostingDate | The 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). |
| 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. |
| tiVatPeriod_ID | integer | PostingVat.VatPeriod_ID | Link to VatPeriod |
Internal usage
QadFinancials