 |
 |
|
|
This presents a subset of columns in idvTimeInstruction with the billed amount broken out into separate columns according to posting type.
Refer to the definitions of individual columns for an indication of what the criteria are, and how they are applied.
Pending postings are not included.
Since this view is steered by the presence of postings, after any aggregation there will be no rows present for accounts and/or period combinations that have no postings present. Absence of an expected row should be taken as implying zero figures.
Type = End user business view, incorporating business logic
JobInternalId |
The internal identifier of the client job that the instruction applies to |
Year |
The time ledger year that the instruction exists in |
Period |
The time ledger period that the instruction exists in |
Instruction |
The instruction number within time ledger year and period |
Date |
The date of the instruction |
CalendarYear |
Calendar year independant of period structure on ledger |
CalendarMonth |
Calendar month (1 = Jan, 2 = Feb etc) |
Type |
The type of the instruction (see idvTimeInstruction) |
InstTypeDesc |
The type of the instruction in human readbale form |
Billed |
If the instruction represents a normal (i.e. final) bill this is the ex VAT billed amount. The sign convention is that a billed amount is positive (so a credit note will be negative) |
InterimBilled |
If the instruction represents an interim bill this is the ex VAT billed amount. The sign convention is that a billed amount is positive (so a credit note will be negative) |
CreditNote |
If the instruction represents a credit note this is the ex VAT billed amount. The sign convention is that a billed amount is positive (so a credit note will be negative) |
CurrentWriteOut |
The currently currently written out amount arising from the instruction (also credit positive). Note that this is not fixed, even if the period has been closed, because more time can always be matched to an instruction |
Reference |
Any reference on the posting |
Narrative |
Any narrative on the posting |