Unit Transaction Positions

Submitted by Brutus5000 on Thu, 07/21/2016 - 23:07
Parent element
Semantic

Unit transaction positions contain one certain unit type with a quantity.

It's like a one of many lines of an invoice.

Table name
unit_transaction_details
Table structure
  • id [INT, PRIMARY_KEY, AUTO_INCREMENT]
  • fk_unit_transaction [INT]
  • fk_unit [INT]
  • quantity [INT]: quantity is negative on dispatch
Calculated Fields
  • Amount (in Credits): SELECT unit_transaction_details.quantity * units.price AS amount FROM unit_transaction_details JOIN units ON units.id = unit_transaction_details.fk_unit

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.