field name | data type | db field | description |
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). |
tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
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. |
tcPostingOriginatorReference | character | Posting.PostingOriginatorReference | Original Posting Reference. this field must contain the key values of the refered posting, if this posting is a manual reversal or replacement of an existing posting. |
| api annotation: | | Value for this field defaults to blank. |
tlPostingIsReplacement | logical | Posting.PostingIsReplacement | Indicate whether the posting is a replacement of an existing posting. |
| api annotation: | | Value for this field defaults to "false". For reversal postings, either automatic or manual - this value defaults to "true". |
tlPostingIsReversing | logical | Posting.PostingIsReversing | Indicate whether the posting is a reversal of an existing posting. |
| api annotation: | | Value for this field defaults to "false". |
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. |
tiPosting_ID | integer | Posting.Posting_ID | Record ID |
tiCompany_ID | integer | Posting.Company_ID | Link to Company |
tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Posting),rowid(Journal) |