Business View ibvTimeWriteOutMatchedLCPY

Description

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 latest closed ledger period plus earlier periods in same ledger year.

Type = End user business view, incorporating business logic (for advanced user use)

Columns

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.