| iiCompanyId | integer | Company id |
| iiPostingLine_ID | integer |
each PostingLine where
first Posting (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 |
| tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
| tdPostingLineCCRate | decimal | PostingLine.PostingLineCCRate | The exchange rate used to convert between transaction (TC) and statutory(SC) amounts. |
| api annotation: | Default value for this field depends on the exchangerate shared set specified for the current domain. | ||
| tdPostingLineCCScale | decimal | PostingLine.PostingLineCCScale | A decimal number that must be multiplied by the exchange rate to get the real exchange rate. Its format is 9999999.9999999 and it was introduced to extend the accuracy of the exchange rate. |
| api annotation: | The default value is 1. | ||
| 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 |
| 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. | ||
| 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. | ||
| tiProject_ID | integer | PostingLine.Project_ID | Description |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(PostingLine),rowid(Posting) |
QadFinancials