tcBusinessFieldName | tcDataType | tcOperator |
iiCompanyId | i | |
tGL.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPeriod.PeriodPeriod | i | =,>=,>,<>,<=,< |
tPeriod.PeriodYear | i | =,>=,>,<>,<=,< |
tPosting.PostingDate | t | =,>=,>,<>,<=,< |
tPosting.PostingInvoiceReferenceTxt | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPostingLine.PostingLineQTY | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxCreditCC | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxCreditLC | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxCreditTC | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxDebitCC | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxDebitLC | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxDebitTC | d | =,>=,>,<>,<=,< |
tPostingVat.PostingVatTaxPointDate | t | =,>=,>,<>,<=,< |
tPosting.PostingVoucher | i | =,>=,>,<>,<=,< |
tVatPeriod.VatPeriodPeriod | i | =,>=,>,<>,<=,< |
tVatPeriod.VatPeriodYear | i | =,>=,>,<>,<=,< |
field name | data type | db field | description |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
ttPostingDate | date | Posting.PostingDate | The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod). |
tcPostingInvoiceReferenceTxt | character | Posting.PostingInvoiceReferenceTxt | When the posting is part of an invoice posting, then this field contains the invoice number (Year/Daybook/Voucher extended with supplier invoice Reference in case of a supplier invoice). Used for information purpose on reports and browsers. |
| api annotation: | | Value for this field defaults to blank |
tdPostingLineQTY | decimal | PostingLine.PostingLineQTY | Quantity |
| api annotation: | | Value for this field defaults to 0.0000. |
tdPostingVatBalanceCCCalc | decimal | calculated | PostingVatBalanceCCCalc |
tdPostingVatBalanceLCCalc | decimal | calculated | PostingVatBalanceLCCalc |
tdPostingVatBalanceTCCalc | decimal | calculated | PostingVatBalanceTCCalc |
tdPostingVatTaxCreditCC | decimal | PostingVat.PostingVatTaxCreditCC | SC (Statutory Currency) Tax Credit amount. |
| api annotation: | | ? |
tdPostingVatTaxCreditLC | decimal | PostingVat.PostingVatTaxCreditLC | BC (Base/Local) Tax Credit amount. |
| api annotation: | | ? |
tdPostingVatTaxCreditTC | decimal | PostingVat.PostingVatTaxCreditTC | TC (Transaction Currency) Tax Credit amount. |
| api annotation: | | ? |
tdPostingVatTaxDebitCC | decimal | PostingVat.PostingVatTaxDebitCC | SC (Statutory Currency) Tax Debit amount. |
| api annotation: | | ? |
tdPostingVatTaxDebitLC | decimal | PostingVat.PostingVatTaxDebitLC | BC (Base Currency) Tax Debit amount. |
| api annotation: | | ? |
tdPostingVatTaxDebitTC | decimal | PostingVat.PostingVatTaxDebitTC | TC (Transaction Currency) Tax Debit amount. |
| api annotation: | | ? |
ttPostingVatTaxPointDate | date | PostingVat.PostingVatTaxPointDate | The date when this posting is taken into account in the Tax sub-adminstration. |
| api annotation: | | ? |
tiPostingVoucher | integer | Posting.PostingVoucher | Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code). |
| api annotation: | | In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record. |
tiVatPeriodPeriod | integer | VatPeriod.VatPeriodPeriod | Tax Period |
tiVatPeriodYear | integer | VatPeriod.VatPeriodYear | Tax Year |
PeriodCustom | character | calculated | custom fields |
PostingCustom | character | calculated | custom fields |
JournalCustom | character | calculated | custom fields |
PostingLineCustom | character | calculated | custom fields |
GLCustom | character | calculated | custom fields |
PostingVatCustom | character | calculated | custom fields |
VatPeriodCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Period),rowid(Posting),rowid(Journal),rowid(PostingLine),rowid(GL),rowid(PostingVat),rowid(VatPeriod) |