iiCompanyId | integer | Company id |
itPostingDateFrom | date | |
itPostingDateTo | date | |
itPostingDate | date |
field name | data type | db field | description |
---|---|---|---|
tiClosing_ID | integer | Posting.ObsoleteClosing_ID | Link to Closing |
tiCompany_ID | integer | Posting.Company_ID | Link to Company |
tiCompanyCurrency_ID | integer | CompanyProperty.Currency_ID | Base Currency |
tiCompanyProperty_ID | integer | CompanyProperty.CompanyProperty_ID | Record ID |
tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
tiCreatorUsr_ID | integer | Posting.CreatorUsr_ID | Login |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
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. |
tlGLIsAutomaticAccount | logical | GL.GLIsAutomaticAccount | Automatic Account: Indicate what types of posting this account accepts. Its value is decided by the value of tcPostingType. |
api annotation: | This field can be left blank as it will be calculated by the system. | ||
tlGLIsDebitAccount | logical | GL.GLIsDebitAccount | Debit/Credit: The posting designation for this account. |
api annotation: | This field can be left blank as it will be calculated by the system. | ||
tcGLTypeCode | character | GL.GLTypeCode | A code identifying the type of account. |
tiJournal_ID | integer | Journal.Journal_ID | Record ID |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tcJournalDescription | character | Journal.JournalDescription | A brief description of the daybook. |
api annotation: | Value for this field defaults to null. | ||
tcJournalTypeCode | character | Journal.JournalTypeCode | A daybook type code. |
api annotation: | Value for this field defaults to "Journal Entries". | ||
tiLastVerifiedUsr_ID | integer | Posting.LastVerifiedUsr_ID | Link to Usr |
tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
tiPosting_ID | integer | Posting.Posting_ID | Record ID |
tiPostingAddGLNbr | integer | Posting.PostingAddGLNbr | When additional GL numbering is enabled for an entity, all postings for this entity are assigned a continuous, uninterrupted incremental sequence numbers as the value for this field. |
api annotation: | When additional GL numbering is not enabled for the current entity, value for this field defaults to 0. | ||
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 | ||
tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
tiPostingLineCompanyId | integer | PostingLine.Company_ID | Link to Company |
tcPostingLineCostCentreText | character | PostingLine.PostingLineCostCentreText | Cost Center |
api annotation: | Value for this field defaults to blank. | ||
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. | ||
tdPostingLineCreditPC | decimal | PostingLine.PostingLineCreditPC | PC Credit |
api annotation: | This field is obsolete and can be left blank. | ||
tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
tiPostingLineCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
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. | ||
tdPostingLineDebitPC | decimal | PostingLine.PostingLineDebitPC | PC Debit |
api annotation: | This field is obsolete. | ||
tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
tdPostingLineExchangeRate | decimal | PostingLine.PostingLineExchangeRate | Exchange Rate |
api annotation: | Default value for this field depends on the exchang erate shared set specified for the current domain. | ||
tlPostingLineIsProjPosting | logical | PostingLine.PostingLineIsProjPosting | Project Posting |
tiPostingLineMaster_ID | integer | PostingLine.PostingLineMaster_ID | Link to Master |
tiPostingLinePeriodId | integer | PostingLine.Period_ID | Link to Period |
tiPostingLinePostingId | integer | PostingLine.Posting_ID | Link to Posting |
tcPostingLineProjectText | character | PostingLine.PostingLineProjectText | Project |
api annotation: | Value for this field defaults to blank. | ||
tdPostingLineQTY | decimal | PostingLine.PostingLineQTY | Quantity |
api annotation: | Value for this field defaults to 0.0000. | ||
tdPostingLineRateScale | decimal | PostingLine.PostingLineRateScale | Scale Factor |
api annotation: | The default value is 1. | ||
tcPostingLineSafText | character | PostingLine.PostingLineSafText | SAF |
api annotation: | Value for this field defaults to blank. | ||
tiPostingLineSequence | integer | PostingLine.PostingLineSequence | Sequence |
tcPostingLineText | character | PostingLine.PostingLineText | Description |
api annotation: | Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting. | ||
tiPostingLineTransaction_ID | integer | PostingLine.PostingLineTransaction_ID | Link to Transaction |
tiPostingLineYearPeriod | integer | PostingLine.PostingYearPeriod | The GL calendar year/period for the journal entry. |
api annotation: | In Create mode, it will get be defaulted to the value for the field PostingYearPeriod of tPosting. | ||
ttPostingSystemDate | date | Posting.PostingSystemDate | The system date of the posting corresponding to "PostingDate". |
api annotation: | In Create mode, when Partial Update = yes - this field gets a default value which is the current date of the system. | ||
tcPostingText | character | Posting.PostingText | Free text describing the posting. |
api annotation: | Value for this field defaults to blank | ||
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. | ||
tiProject_ID | integer | PostingLine.Project_ID | Description |