iiCompanyId | integer | Company id |
iiPeriodID | integer | |
iiGLId | integer | |
icLayerType | character | |
iiDivisionId | integer | |
icBusinessRelationICCode | character |
field name | data type | db field | description |
---|---|---|---|
tcBusinessRelationICCode | character | BusinessRelation.BusinessRelationICCode | Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation. |
tiCompany_ID | integer | Posting.Company_ID | Link to Company |
tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
tiCurrency_ID | integer | PostingLine.Currency_ID | Currency Code |
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 |
tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tiLayer_ID | integer | Journal.Layer_ID | Link to Layer |
tcLayerCode | character | Layer.LayerCode | Layer Code |
tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
tiPeriod_ID | integer | Posting.Period_ID | Link to Period |
tiPeriodMark_ID | integer | Posting.PeriodMark_ID | Link to PeriodMark |
tiPosting_ID | integer | Posting.Posting_ID | Record ID |
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 |
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. | ||
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. | ||
tdPostingLineQTY | decimal | PostingLine.PostingLineQTY | Quantity |
api annotation: | Value for this field defaults to 0.0000. | ||
tiPostingYear | integer | Posting.PostingYear | The GL calendar year for the posting. |
tiPostingYearPeriod | integer | Posting.PostingYearPeriod | The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear". |
api annotation: | If Partial Update is true, the value defaults using PostingPeriod and PostingYear. | ||
tiProject_ID | integer | PostingLine.Project_ID | Description |