6829 build 5 - 5 new keywords for Sub Agent Statements.

The following 5 keywords are for Sub Agent Statements, to show the amount of Sub Agent Commission & VAT on both an individual transaction, and on multiple transactions.

*SAGTCOMM* - sub agent commission for each transaction
*SAGTVAT* - VAT on sub agent commission for each transaction
*SAGTVATRATE* - VAT rate for sub agent commission in %
*TOTSAGTCOMM* - total sub agent commission for the consultation
*TOTSAGTVAT* - total VAT on sub agent commission for the consultation

If a site needs a Sub Agent Statement (SNS) setting up within their data, Support will need to run the following SQL:

Select * Into #DT From Docc0r Where doccode = 'STA';
Update #DT Set DocCode = 'SNS', DocName = 'Sub Agent Statement';
Alter Table #DT Alter ID ID AutoInc;
Delete from #DT Where DocSection in (Select DocSection From Docc0r Where DocCode = 'SNS');
Insert into Docc0r Select * From #DT;

The SNS document will feature within Document Designer anyway, but you may find that when trying to save the new keywords to the document will produce errors, if the above SQL isn't ran.

The data is taken from HIST0r.adt

The keywords will need to be added to both:

- The TRAILER within the SNS document.

- Within each TRANSACTION TYPE, for the SNS document.

~ Version Contents ~ Select Version ~ Main Contents ~