 |
 |
|
|
This view exposes the rows in the database table that represent practice clients (people, businesses and trusts).
The InternalId in this view is only unique when combined with the ObjectType column.
Base view suitable for advanced users.
ObjectType |
The object type of the client 1 = person, 2 = business, 5 = trust |
InternalId |
The internal identifier of the client object |
VisibleId |
The user visible identifier of the client object |
Personal |
'Y' for a personal client, 'N' otherwise |
ClientGroup |
The internal identifier of the parent client group (if relevant) |
ClientForAP |
'Y' if the client is registered as a client for Accounts Production 'N' otherwise |
ClientForFAR |
'Y' if the client is registered as a client for Fixed Assets 'N' otherwise |
ClientForPT |
'Y' if the client is registered as a client for Personal Tax 'N' otherwise |
ClientForBT |
'Y' if the client is registered as a client for Business Tax 'N' otherwise |
ClientForTT |
'Y' if the client is registered as a client for Trust Tax 'N' otherwise |
ClientForP11D |
'Y' if the client is registered as a client for P11d 'N' otherwise |
ClientForCS |
'Y' if the client is registered as a client for Company Secretarial 'N' otherwise |
ClientForCF |
'Y' if the client is registered as a client for Company Formations 'N' otherwise |
ClientForTF |
'Y' if the client is registered as a client for Time and Fees 'N' otherwise |
ClientName |
A single string name for the client |
This view is directly inherited by the following views: