Base View idvTimeMatching

Description

This view exposes the rows in TFTimeMatching that represent matching between time ledger postings.

Type = Base view suitable for advanced end user use

 

Columns

JobInternalId The internal id of the job object this matching is for
Year The year part of the time period
Period The time period number within the year
Matching Unique matching number within period
WhoMatched The internal identifier of the staff member who did the matching action
WhenMatched When the matching action was done
Posting1Year This, and the next two columns, reference the first posting that is matched (as year, period and posting number).
Posting1Period See Posting1Year
Posting1 See Posting1Year
AmountForPosting1 The amount to be added to the matched amount on posting 1 as a result of this matching action
Posting2Year This, and the next two columns, reference the SECOND posting that is matched (as year, period and posting number).
Posting2Period See Posting2Year
Posting2 See Posting2Year
AmountForPosting2 The amount to be added to the matched amount on posting 2 as a result of this matching action
InstructionYear When the matching arises as a result of an instruction this, and the next two columns, identify the instruction by year, period and instruction number in period
InstructionPeriod See InstructionYear
InstructionNumber See InstructionYear

 

  •