iiCompanyId | integer | Company id |
iiPeriod | integer |
field name | data type | db field | description |
---|---|---|---|
tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
tcDivisionCode | character | Division.DivisionCode | Sub-Account |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tcLayerCode | character | Layer.LayerCode | Layer Code |
tcPeriodMarkCode | character | PeriodMark.PeriodMarkCode | Mark |
tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
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 |
tdPostingLineQTY | decimal | PostingLine.PostingLineQTY | Quantity |
api annotation: | Value for this field defaults to 0.0000. | ||
tiPostingSafInputSequence | integer | PostingSaf.PostingSafInputSequence | Sequence number of this SAF within all the SAF lines for the same posting line. |
tcPostingSafParentType | character | PostingSaf.PostingSafParentType | Parent Type. Indicates the parent type of this SAF record. |
tcProjectCode | character | Project.ProjectCode | Project |
tiSaf_ID | integer | PostingSaf.Saf_ID | SAF Code |
tcSafCode | character | Saf.SafCode | SAF Code |
tiSafStructure_ID | integer | PostingSaf.SafStructure_ID | Structure Code |
tcSafStructureCode | character | SafStructure.SafStructureCode | Structure Code |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Period),rowid(Posting),rowid(Journal),rowid(Layer),rowid(PeriodMark),rowid(PostingLine),rowid(BusinessRelation),rowid(CostCentre),rowid(Currency),rowid(Division),rowid(GL),rowid(PostingSaf),rowid(Saf),rowid(SafStructure),rowid(Project) |