field name | data type | db field | description |
tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tlJournalIsActive | logical | Journal.JournalIsActive | Indicate if this is an active daybook. |
| api annotation: | | Value for this field defaults to false. |
tcJournalTypeCode | character | Journal.JournalTypeCode | A daybook type code. |
| api annotation: | | Value for this field defaults to "Journal Entries". |
tiLayer_ID | integer | Journal.Layer_ID | Link to Layer |
tcLayerCode | character | Layer.LayerCode | Layer Code |
tlLayerIsActive | logical | Layer.LayerIsActive | Active |
tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
tiPosting_ID | integer | Posting.Posting_ID | Record ID |
tcPostingAutoReversalType | character | Posting.PostingAutoReversalType | If this posting is involved in automatic reversal activity of posting, value of this field will indicate whether this posting is the original one or the reversing one. It is calculated by the system. |
| api annotation: | | If the flag PostingIsAutoReversal is "true", the field value defaults to "ORIGINAL ENTRY" for the original posting, and to "REVERSING ENTRY" for the reversing posting. |
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). |
tlPostingIsAutoReversal | logical | Posting.PostingIsAutoReversal | Indicate whether the posting leads to an automatic reversal. |
| api annotation: | | Value for this field defaults to "false". |
tiPostingPeriod | integer | Posting.PostingPeriod | The GL period for the posting. The period must be open. |
tiPostingTemplate_ID | integer | PostingTemplate.PostingTemplate_ID | Record ID |
tcPostingTemplateCode | character | PostingTemplate.PostingTemplateCode | Template Code |
tcPostingText | character | Posting.PostingText | Free text describing the posting. |
| api annotation: | | Value for this field defaults to blank |
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. |
tiPostingYearPeriod | integer | Posting.PostingYearPeriod | The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear". |
| api annotation: | | If Partial Update is true, the value defaults using PostingPeriod and PostingYear. |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Layer),rowid(Journal),rowid(Posting),rowid(PostingTemplate) |