field name | data type | db field | description |
tiCompany_ID | integer | Posting.Company_ID | Link to Company |
tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
tiCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
tcDivisionCode | character | Division.DivisionCode | Sub-Account |
tiGL_ID | integer | PostingLine.GL_ID | GL Description |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
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). |
tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
tdPostingLineQTY | decimal | PostingLine.PostingLineQTY | Quantity |
| api annotation: | | Value for this field defaults to 0.0000. |
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. |
tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
tiProject_ID | integer | PostingLine.Project_ID | Description |
tcProjectCode | character | Project.ProjectCode | Project |
tiUnit_ID | integer | GL.Unit_ID | GL Account Unit of Measure |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(PostingLine),rowid(CostCentre),rowid(Division),rowid(GL),rowid(Posting),rowid(Journal),rowid(Period),rowid(Project) |