 |
 |
|
|
This presents a subset of columns in idvTimePosting with the posting amount broken out into separate columns according to posting type and other criteria.
Refer to the definitions of individual columns for an indication of what the criteria are, and how they are applied.
Only chargeable postings are included in this view, and pending postings are not included.
Type = End user business view, incorporating business logic
JobInternalId |
The internal identifier of the client job that the posting applies to |
Year |
Time posting year |
Period |
Time posting period in year |
Posting |
Unique posting number in period (to support logical primary keys for reporting services). |
Date |
The date of the posting |
CalendarYear |
Calendar year independant of period structure on ledger |
CalendarMonth |
Calendar month (1 = Jan, 2 = Feb etc) |
Type |
The type of the posting (see idvTimePosting) |
PostTypeDesc |
The type of the posting in human readable form |
ChargeableTime |
If the posting is of category WIP and include expenses is set to no then this is the posting amount (uniformly credit negative) |
ChargeableExpenses |
If the posting is of category WIP and include expenses is set to yes then this is the posting amount (uniformly credit negative) |
WriteOutThisPd |
If the posting is a write out or an interim invoice related posting and the originating instruction is in the same period as the posting then this is the posting amount (uniformly credit negative) |
WriteOffThisPd |
If the posting is a write off and the originating instruction is in the same period as the posting then this is the posting amount (uniformly credit negative) |
WriteBackThisPd |
If the posting is a write back and the originating instruction is in the same period as the posting then this is the posting amount (uniformly credit negative) |
WriteOutOtherPd |
If the posting is a write out or an interim invoice related posting and the originating instruction is not in the same period as the posting then this is the posting amount (uniformly credit negative) |
WriteOffOtherPd |
If the posting is a write off and the originating instruction is not in the same period as the posting then this is the posting amount (uniformly credit negative) |
WriteBackOtherPd |
If the posting is a write back and the originating instruction is not in the same period as the posting then this is the posting amount (uniformly credit negative) |
OtherPostings |
If the posting is not included in any of the previous columns then this is the posting amount (uniformly credit negative) |
ActualMinutes |
The actual number of chargebale minutes represented by the posting (where relevant) |
Matched |
The currently matched amount on the posting (also credit negative). Note that this figure is not fixed, even if the period is closed, because further matching actions are always possible against a posting. |
ChargeRateInternalId |
The charge rate internal identifier used when the posting was made (where relevant) |
Reference |
Any reference on the posting |
Narrative |
Any narrative on the posting |