| iiCompanyId | integer | Company id |
| iiPostingLineId | integer | Posting Line ID |
| icJournalTypeCode | character | Daybook Type Code |
each PostingLine where
first Posting (inner-join) where
first Company (inner-join) where
first Journal (inner-join) where
first Layer (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | Posting.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tiCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
| tcCustomCombo0 | character | PostingLine.CustomCombo0 | Custom Combo Field |
| tcCustomCombo1 | character | PostingLine.CustomCombo1 | Custom Combo Field |
| tcCustomCombo2 | character | PostingLine.CustomCombo2 | Custom Combo Field |
| tcCustomCombo3 | character | PostingLine.CustomCombo3 | Custom Combo Field |
| tcCustomCombo4 | character | PostingLine.CustomCombo4 | Custom Combo Field |
| tcCustomCombo5 | character | PostingLine.CustomCombo5 | Custom Combo Field |
| tcCustomCombo6 | character | PostingLine.CustomCombo6 | Custom Combo Field |
| tcCustomCombo7 | character | PostingLine.CustomCombo7 | Custom Combo Field |
| tcCustomCombo8 | character | PostingLine.CustomCombo8 | Custom Combo Field |
| tcCustomCombo9 | character | PostingLine.CustomCombo9 | Custom Combo Field |
| ttCustomDate0 | date | PostingLine.CustomDate0 | Custom Date Field |
| ttCustomDate1 | date | PostingLine.CustomDate1 | Custom Date Field |
| ttCustomDate2 | date | PostingLine.CustomDate2 | Custom Date Field |
| ttCustomDate3 | date | PostingLine.CustomDate3 | Custom Date Field |
| ttCustomDate4 | date | PostingLine.CustomDate4 | Custom Date Field |
| tdCustomDecimal0 | decimal | PostingLine.CustomDecimal0 | Custom Decimal Field |
| tdCustomDecimal1 | decimal | PostingLine.CustomDecimal1 | Custom Decimal Field |
| tdCustomDecimal2 | decimal | PostingLine.CustomDecimal2 | Custom Decimal Field |
| tdCustomDecimal3 | decimal | PostingLine.CustomDecimal3 | Custom Decimal Field |
| tdCustomDecimal4 | decimal | PostingLine.CustomDecimal4 | Custom Decimal Field |
| tiCustomInteger0 | integer | PostingLine.CustomInteger0 | Custom Integer Field |
| tiCustomInteger1 | integer | PostingLine.CustomInteger1 | Custom Integer Field |
| tiCustomInteger2 | integer | PostingLine.CustomInteger2 | Custom Integer Field |
| tiCustomInteger3 | integer | PostingLine.CustomInteger3 | Custom Integer Field |
| tiCustomInteger4 | integer | PostingLine.CustomInteger4 | Custom Integer Field |
| tcCustomLong0 | character | PostingLine.CustomLong0 | Custom Long Field |
| tcCustomLong1 | character | PostingLine.CustomLong1 | Custom Long Field |
| tcCustomNote | character | PostingLine.CustomNote | Custom Note Field |
| tcCustomShort0 | character | PostingLine.CustomShort0 | Custom Short Field |
| tcCustomShort1 | character | PostingLine.CustomShort1 | Custom Short Field |
| tcCustomShort2 | character | PostingLine.CustomShort2 | Custom Short Field |
| tcCustomShort3 | character | PostingLine.CustomShort3 | Custom Short Field |
| tcCustomShort4 | character | PostingLine.CustomShort4 | Custom Short Field |
| tcCustomShort5 | character | PostingLine.CustomShort5 | Custom Short Field |
| tcCustomShort6 | character | PostingLine.CustomShort6 | Custom Short Field |
| tcCustomShort7 | character | PostingLine.CustomShort7 | Custom Short Field |
| tcCustomShort8 | character | PostingLine.CustomShort8 | Custom Short Field |
| tcCustomShort9 | character | PostingLine.CustomShort9 | Custom Short Field |
| tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
| tiGL_ID | integer | PostingLine.GL_ID | GL Description |
| tiIntercoBusinessRelation_ID | integer | PostingLine.IntercoBusinessRelation_ID | Intercompany Code |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcJournalTypeCode | character | Journal.JournalTypeCode | A daybook type code. |
| api annotation: | Value for this field defaults to "Journal Entries". | ||
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiPosting_ID | integer | PostingLine.Posting_ID | Link to 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). |
| tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
| 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 |
| 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 |
| tlPostingLineIsProjPosting | logical | PostingLine.PostingLineIsProjPosting | Project Posting |
| tiPostingLineMaster_ID | integer | PostingLine.PostingLineMaster_ID | Link to Master |
| 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. | ||
| 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 |
| 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. | ||
| tiProject_ID | integer | PostingLine.Project_ID | Description |
QadFinancials