iiCompanyId | integer | Company id |
iiPostingLineId | integer | Posting Line ID |
icJournalTypeCode | character | Daybook Type Code |
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 |