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.

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.

 

  •