| iiCompanyId | integer | Company id |
| iiPostingLineId | integer | Posting Line ID |
each PostingLine where
first Posting (inner-join) where
first Period (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
| tiGL_ID | integer | PostingLine.GL_ID | GL Description |
| tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
| tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
| 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. | ||
| tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
| 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. | ||
| tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
| tiProject_ID | integer | PostingLine.Project_ID | Description |
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
| 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. | ||
| 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. | ||
| tiCompany_ID | integer | Posting.Company_ID | Link to Company |
| 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). |
| 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. | ||
| ttPostingValueDate | date | Posting.PostingValueDate | The value date (used for banking entries). |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
QadFinancials