InvoiceItemDao.sql.stg

14 lines | 369 B Blame History Raw Download
group InvoiceItemDao;

getInvoiceItemsByInvoice() ::= <<
>>

getInvoiceItemsByAccount() ::= <<
>>

createInvoiceItem() ::= <<
  INSERT INTO invoice_items(invoice_item_id, subscription_id, start_date, end_date, description, amount, rate, currency)
  VALUES(:invoiceItemId, :invoiceId, :subscriptionId, :startDate, :endDate, :description, :amount, :rate, :currency)
>>
;