In this topic, an excerpt of the SQL code for the Commissions Source Order Lines view is listed and identifies the Source Trigger Date aliases and Available Commission Base Formula aliases referenced in the documentation. To view the complete code for the vwCommissionSourceOrderLines, open the Source SQL View from the Commission Source record installed with Aptify Commissions.
vwCommissionSourceOrderLines
The following excerpt of code is from the SQL select statement used in the vwCommissionSourceOrderLines view installed with the Commission & Royalty Management application.
...
/*Date fields available for CommissionPeriod*/
| Info |
|---|
The Source Trigger Date field aliases shown below require a # in the alias name |
...
o.OrderDate [#Order Date],
...
| Info |
|---|
The Available Commission Base Formula field aliases shown below require a $ in the alias name |
...
od.Quantity [$Quantity],
...