Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- InvoiceItemView Dataset
- SELECT InvoicedItemView.*
- FROM [Reporting].[InvoicedItemView] InvoicedItemView
- WHERE InvoicedItemView.InvoiceID = 1--INSERT the report InvoiceID parameter here
- -- InvoiceLineItemAdjustment Dataset
- SELECT PenaltyBonusTypeGroup.PBTypeGroup, InvoiceLineItemAdjustment.*
- FROM [Invoicing].[InvoiceLineItemAdjustment] InvoiceLineItemAdjustment
- JOIN [dbo].[PenaltyBonusTypeGroup] PenaltyBonusTypeGroup ON PenaltyBonusTypeGroup.PBTypeGroupID = InvoiceLineItemAdjustment.PBTypeGroupID
- JOIN [Invoicing].[InvoiceLineItem] InvoiceLineItem ON InvoiceLineItem.InvoiceLineItemID = InvoiceLineItemAdjustment.InvoiceLineItemID
- JOIN [Invoicing].[Invoice] Invoice ON Invoice.InvoiceID = InvoiceLineItem.InvoiceID
- WHERE Invoice.InvoiceID = 1--INSERT the report InvoiceID parameter here
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement