 |
 |
|
|
This view shows the final accounts figures for each client using the view ibvFinalAccountsFigs and the additional client details shown below.
This view is suitable for any user wanting access the final accounts details for a client incorporating the view ibvFinalAccountsFigs
This view includes the columns specified below plus those in the view:
ClientId |
Client visible id |
ClientName |
Client name |
Category1 |
First client category set up in the practice options |
Category1Desc |
First client category description |
Category2 |
Second client category set up in the practice options |
Category2Desc |
Second client category description |
Category3 |
Third client category set up in the practice options |
Category3Desc |
Third client category description |
Category4 |
Fourth client category set up in the practice options |
Category4Desc |
Fourth client category description |
Category5 |
Fifth client category set up in the practice options |
Category5Desc |
Fifth client category description |
Category6 |
Sixth client category set up in the practice options |
Category6Desc |
Sixth client category description |
Partner |
The partner responsible for client |
PartnerName |
The name of the partner responsible for client |
PartnerBranch |
The branch identifier associated to the client through the partner responsible for the client |
PartnerBranchDesc |
The branch identifier associated to the client through the partner responsible for the client |
Manager |
The manager responsible for the client |
ManagerName |
The name of the manager responsible for client |
ManagerBranch |
The branch identifier associated to the client through the manager responsible for the client |
ManagerBranchDesc |
The branch description associated to the client through the manager responsible for the client |
ClientGroup |
Client group |
ClientGroupDesc |
Description of client group |
AddressLine1 |
First line of main address |
AddressLine2 |
Second line of main address |
AddressLine3 |
Third line of main address |
Town |
Main address town |
County |
Main address county |
Postcode |
Main address postcode |
PhoneNumber |
Main address phone number |
FAXNumber |
Main address FAX number |
eMailAddress |
Main address eMail address |
SICCode |
The SIC code |
SICCodeDesc |
Description of SIC code |