 |
 |
|
|
This view exposes the rows in TFPriorBill and that represent records of previous billing action on time ledger accounts.
Due to the precise working of the Iris Practice Suite system the precise contents of this view may be variable. In particular either the time ledger or fees ledger foreign keys may be null. This is also not a complete history of bills on the account. Once data is not relevant to the current system it is discarded from this table.
Type = Base view suitable for advanced end user use
| JobInternalId | The internal id of the job that this bill is for |
| Date | The bill date |
| Amount | The bill amount |
| Reference | The bill reference |
| Interim | 'Y' if bill is interim, else 'N' |
| DirectTimeLedger | 'Y' if bill posted diretly to time ledger, else 'N' |
| LastFinalBill | 'Y' if bill is the last final bill, else 'N' |
| CurrentCycle | 'Y' if the bill is part of the current billing cycle (i.e. needed for recovery apportionment on the next final bill to be posted), else 'N' |
| TimeYear | This, and the next two fields, act as a foreign key to the time ledger instruction representing the bill |
| TimePeriod | See TimeYear |
| TimeInstruction | See TimeYear |
| FeesYear | This, and the next two fields, act as a foreign key to the fees ledger posting representing the bill |
| FeesPeriod | See FeesYear |
| FeesPosting | See FeesYear |