This view returns time ledger write out/back postings and joins them to the other postings that they are matched to. Write off postings are also included.
There will be at least one row for each write out (or off or back).
If the posting is unmatched the 'other' posting fields will be null.
If the posting is matched then there will be one row for each matching action (incorporating the full history of the matching). The details of the write out (off/back) will be replicated on each row.
In the event of multiple matchings it is also possible that there will be more than one row for a particular write out (off/back) and other posting combination (for example, if a bill was originally matched to part of a posting and subsequently manually matched to the rest of it).
Because it is perfectly possible to match a write back to a write out (or off) it is equally possible that the same posting can appear both as a prime posting and an 'other' posting in the result set.
Pending postings are not included in the results.
Cancelled and contra postings are included in the results. This is primarily because the contra may be in a different period to the cancelled posting, and the cancelled posting might have been included in last month's figures before it was cancelled. If we now didn't show the contra it would be difficult to reconcile.
This view is restricted to the current ledger year as determined by current ledger period.
Type = End user business view, incorporating business logic (for advanced user use)
JobInternalId |
The internal identifier of the client job that the posting is for. |
Year |
Time posting year |
Period |
Time posting period in year |
Posting |
Unique posting number in period (to support logical primary keys for reporting services). |
CalendarYear |
Calendar year independant of period structure on ledger |
CalendarMonth |
Calendar month (1 = Jan, 2 = Feb etc) |
Date |
The date of the posting |
Type |
The type of the posting (see idvTimePostingType) |
PostTypeDesc |
The type of the posting in human readable form |
Contra |
'Y' if the posting is a contra. This allows you to distinguish between a bill and a bill cancellation for example (other than by the sign of the amount). |
Amount |
The posting write out amount as credit positive (i.e. a write out or off is positive, a write back is negative) |
TotalMatched |
The amount currently matched to the posting (same sign convention as the posting amount) |
Reference |
Any reference on the posting |
Narrative |
Any narrative on the posting |
OtherPostYear |
The time ledger year in which the posting that the write out is matched to is made |
OtherPostPeriod |
The time ledger period within year in which the posting that the write out is matched to is made |
OtherPostPosting |
The posting number within time ledger year and period for the posting that the write out is matched to. |
OtherPostCalendarYear |
Calendar year for the posting that the write out is matched to independant of period structure on ledger |
OtherPostCalendarMonth |
Calendar month for the posting that the write out is matched to (1 = Jan, 2 = Feb etc) |
OtherPostDate |
The date of the posting that the write out is matched to |
OtherPostStaffInternalId |
The intenal identifier of the staff member associated with the posting that the write out is matched to (may be null if the posting is not a staff member posting) |
OtherPostType |
The type of the posting that the write out is matched to (see idvTimePostingType) |
OtherPostReference |
Any reference on the posting that the write out is matched to |
OtherPostNarrative |
Any narative on the posting that the write out is matched to |
OtherPostMinutes |
The number of minutes of time recorded on the posting that the write out is matched to (if relevant). This follows the same sign convention as OtherPostAmount below. |
OtherPostChargeRate |
The internal identifier of the charge rate used on the posting that the write out is matched to (may be null if the posting was not calculated from a charge rate. |
OtherPostAmount |
The amount on the posting that the write out is matched to. This is credit negative. Thus, typically, a write out will have a positive amount in the prime posting details AND this amount (typically representing a timesheet posting) will also be positive. |
MatchedToOtherPost |
The amount matched between the two postings. For a matching action this will have the SAME sign as both the amounts. If it has an opposite sign to the amounts then it signifies an unmatching action. |