project QadFinancials > class BBillReport > business logic query GetDDocumentByPostingID
Parameters
| iiCompanyId | integer | Company id |
| icPosting_IDs | character | |
query condition
each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID can-do icPosting_IDs
each PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting.Posting_ID AND
each DDocumentPostingLine (inner-join) where
DDocumentPostingLine.PostingLine_ID = PostingLine.PostingLine_ID AND
first DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = DDocumentPostingLine.DDocument_ID AND
query resultset tqGetDDocumentByPostingID
| field name | data type | db field | description |
|---|
| tiDDocument_ID | integer | DDocument.DDocument_ID | Record ID |
| tiDDocumentPostingLine_ID | integer | DDocumentPostingLine.DDocumentPostingLine_ID | Record ID |
| tcDDocumentReference | character | DDocument.DDocumentReference | Reference. Reference text for the payment. |
| tcDDocumentStatus | character | DDocument.DDocumentStatus | Status. The payment status. The default value for a new record is Initial. |
| tcDDocumentType | character | DDocument.DDocumentType | Payment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank. |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
Internal usage
QadFinancials