Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
→Form Management
=== Revenue Header and associated capability ===
This engine allows for the previously conceived "Campaign Accounts" module to be implemented. Within the CCL are a number of fields to allow for an amount to be logged.
* strCCL_[i]_Amount_Price decimal (9,4)
* strCCL_[i]_Amount_VAT decimal (9,4)
* strCCL_[i]_Amount_Total decimal (9,4)
5 new fields are being added to every CCL
* strCCL_[i]_Amount_Cost decimal (9,4)
* strCCL_[i]_Amount_NetMargin decimal (9,4)
* strCCL_[i]_Amount_GrossMargin decimal (9,4)
* strCCL_[i]_Amount_CurrencyPrice varchar(3)
* strCCL_[i]_Amount_CurrencyCost varchar(3)
Also being added to the engine will be a complex type called Revenue Header (these are all hidden fields on the form)
* Price
* VAT
* Total
* Cost
* NetMargin
* GrossMargin
* Price Currency
* Cost Currency
There are then form level settings which allow the engine to be used.
{|
! Field
! Type
! Use
! Options
|-
| strCamapign_Revenue_Model || text || Where is the calculate stored || None,CDA,CCL,Both
|-
| strCamapign_Revenue_CDAConfig || text || For CDAs, what happens if already filled in || Replace (CDA recalculate),Ignore (CDA if filled do nothing)
|-
| strCamapign_Revenue_CCLConfig || text || What if other CCL has data || One Only (CCL Historic check),Update (CCL Historic wipe),All (CCL new)
|-
| strCamapign_Revenue_Outcomes || text || String separated commas on which the process executes ||
|-
| strCamapign_Revenue_MarginReport || text || Reporting Marings, which fields to use || None,Net,Gross,Both
|-
| strCamapign_Revenue_Prods_Field || text || Which field contains the product || All CDA fields
|-
| strCamapign_Revenue_Prods_Values || text || Top has to be filled out (text or list), Only consider SOME products in the field ||
|-
| strCamapign_Revenue_Price_Values || text || If only using SOME then, count must match. If using field then leave it to JavaScript on the page to manage ||
|-
| strCamapign_Revenue_VAT_Values || text || These are all percentages without the symbols. ||
|-
| strCamapign_Revenue_PriceCurrency_Values || text || Three letter text codes || Default to system currency of EUR to start
|-
| strCamapign_Revenue_Costs_Values || text || A straight one off price per cost ||
|-
| strCamapign_Revenue_CostCurrency_Values || text || Again three letter text codes. ||
|-
| strCamapign_Revenue_Store_CDAPriceField || text || Once the calculations are done, an update to the CDA table can be done, what to store where. Great for testing and if using the header type, then all hidden. ||
|-
| strCamapign_Revenue_Store_CDAVATField || text || ||
|-
| strCamapign_Revenue_Store_CDATotalField || text || ||
|-
| strCamapign_Revenue_Store_CDACostField || text || ||
|-
| strCamapign_Revenue_Store_CDANETMarginField || text || ||
|-
| strCamapign_Revenue_Store_CDAGrossMarginField || text || ||
|-
| strCamapign_Revenue_Store_CDAPriceCurrencyField || text || ||
|-
| strCamapign_Revenue_Store_CDACostCurrencyField || text || ||
|-
|}
== Information Centre ==
