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