https://wiki.catglobe.com/index.php?action=history&feed=atom&title=Build_logic%3A_Invoice_detail_columnsBuild logic: Invoice detail columns - Revision history2026-04-20T11:48:26ZRevision history for this page on the wikiMediaWiki 1.43.0https://wiki.catglobe.com/index.php?title=Build_logic:_Invoice_detail_columns&diff=18313&oldid=prevCg huyphong at 04:37, 26 April 20112011-04-26T04:37:10Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 04:37, 26 April 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<del style="font-weight: bold; text-decoration: none;">HelpBooks</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<ins style="font-weight: bold; text-decoration: none;">Resource data caches</ins>]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<!-- diff cache key wiki:diff:1.41:old-15440:rev-18313:php=table -->
</table>Cg huyphonghttps://wiki.catglobe.com/index.php?title=Build_logic:_Invoice_detail_columns&diff=15440&oldid=prevCatglobe: jrfconvert import2011-03-07T08:56:02Z<p>jrfconvert import</p>
<p><b>New page</b></p><div>[[Category:HelpBooks]]<br />
<br />
<br />
===Build logic: Invoice detail columns===<br />
<br />
When we are generating caches for invoices it is important that we understand one major difference -- caches may have more than one row per invoice! This will happen when we choose to include columns that take information from the invoice detail records. The number of rows in our cache that an invoice will create will then be one for each invoice detail record that exists in the invoice.<br />
<br />
The columns that belong to the invoice details are:<br />
<br />
* [[_Column:_Account_|Account]]<br />
* [[_Column:_Account_as_text_|Account as text]]<br />
* [[_Column:_Amount_in_default_currency_|Amount in default currency]]<br />
* [[_Column:_Amount_in_selected_currency_|Amount in selected currency]]<br />
* [[_Column:_Cost_|Cost]]<br />
* [[_Column:_Currency_|Currency]]<br />
* [[_Column:_Currency_as_text_|Currency as text]]<br />
* [[_Column:_Description_|Description]]<br />
* [[_Column:_Unit_|Unit]]<br />
<br />
Below is a small example, where we choose to make a resource cache with just IDs of six invoice resources.<br />
<br />
[[Image:7782.png|80px|RCS58-1]]<br />
<br />
As you will notice, the addition of six invoices will create six rows in our resource cache, since we have not added any invoice detail columns.<br />
<br />
Now let us try to add the 'Cost' column, which is one of the invoice detail columns, and see what will happen.<br />
<br />
[[Image:7783.png|177px|RCS58-2]]<br />
<br />
Now, with the same number of included resources, we have seven rows rather than only six as before. If we look at the data, we will see that the invoice with Id = 85007 actually possesses two rows. The reason is that it needs to show information from two invoice detail records that exist in it. The other 5 invoices obviously only has one detail invoice record each and do therefore not need an extra row to present their information.<br />
<br />
It is therefore important to understand which data relates to invoice details and which relates to the invoice. Invoice detail information will always only be shown once in a resource cache, whereas invoice information may be shown multiple times if the invoice has more than one detail invoice row.<br />
__NOTOC__<br />
<!-- imported from file: 7781.htm--></div>Catglobe