iiCompanyId | integer | Company id |
itEndOfDate | date |
field name | data type | db field | description |
---|---|---|---|
tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
tcCInvoicePostingType | character | CInvoicePosting.CInvoicePostingType | Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined. |
tiCInvoiceVoucher | integer | CInvoice.CInvoiceVoucher | Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field. |
tiCIRECPostingLine_ID | integer | CInvoicePosting.CIRECPostingLine_ID | Link to PostingLine |
tiGL_ID | integer | GL.GL_ID | Record ID |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcGLDescription | character | GL.GLDescription | A description of the GL account. |
tiJournal_ID | integer | CInvoice.Journal_ID | Daybook Code |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tdPostingLineCreditCC | decimal | PostingLine.PostingLineCreditCC | SC Credit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field | ||
tdPostingLineCreditLC | decimal | PostingLine.PostingLineCreditLC | BC Credit |
api annotation: | Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field. | ||
tdPostingLineDebitCC | decimal | PostingLine.PostingLineDebitCC | SC Debit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field. | ||
tdPostingLineDebitLC | decimal | PostingLine.PostingLineDebitLC | BC Debit |
api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field. | ||
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(CInvoice),rowid(CInvoicePosting),rowid(PostingLine),rowid(GL),rowid(Posting),rowid(Journal) |