iiCompanyId | integer | Company id |
iiPeriod | integer | |
iiTillPeriod | integer | |
iiMaxPeriod | 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. |
tcCCSafStructure | character | SafStructure3.SafStructureCode | Structure Code |
tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
tiCurrencyNumberOfDecimals | integer | Currency.CurrencyNumberOfDecimals | Number of Decimals |
tcDivisionCode | character | Division.DivisionCode | Sub-Account |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tlGLIsBalanceAccount | logical | GL.GLIsBalanceAccount | This field will be calculated by the system based on the value of tcBalance. If the account is a Balance Sheet account the value will be true, if it is a Profit and Loss account then it will be false. |
api annotation: | This field can be left blank as it will be calculated by the system. | ||
tcGLSafStructure | character | SafStructure2.SafStructureCode | Structure Code |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tcLayerCode | character | Layer.LayerCode | Layer Code |
tiPostingHist_ID | integer | PostingHist.PostingHist_ID | Record ID |
tdPostingHistBalanceCreditCC | decimal | PostingHist.PostingHistBalanceCreditCC | SC Credit Balance |
tdPostingHistBalanceCreditLC | decimal | PostingHist.PostingHistBalanceCreditLC | BC Balance Credit |
tdPostingHistBalanceCreditPC | decimal | PostingHist.PostingHistBalanceCreditPC | PC Credit Balance |
tdPostingHistBalanceCreditTC | decimal | PostingHist.PostingHistBalanceCreditTC | TC Credit Balance |
tdPostingHistBalanceDebitCC | decimal | PostingHist.PostingHistBalanceDebitCC | SC Debit Balance |
tdPostingHistBalanceDebitLC | decimal | PostingHist.PostingHistBalanceDebitLC | BC Balance Debit |
tdPostingHistBalanceDebitPC | decimal | PostingHist.PostingHistBalanceDebitPC | PC Debit Balance |
tdPostingHistBalanceDebitTC | decimal | PostingHist.PostingHistBalanceDebitTC | TC Debit Balance |
tdPostingHistBalanceQTY | decimal | PostingHist.PostingHistBalanceQTY | Quantity Balance |
tdPostingHistMovemntCreditCC | decimal | PostingHist.PostingHistMovemntCreditCC | SC Credit Activity |
tdPostingHistMovemntCreditLC | decimal | PostingHist.PostingHistMovemntCreditLC | BC Movement Credit |
tdPostingHistMovemntCreditPC | decimal | PostingHist.PostingHistMovemntCreditPC | PC Credit Activity |
tdPostingHistMovemntCreditTC | decimal | PostingHist.PostingHistMovemntCreditTC | TC Credit Activity |
tdPostingHistMovemntDebitCC | decimal | PostingHist.PostingHistMovemntDebitCC | SC Debit Activity |
tdPostingHistMovemntDebitLC | decimal | PostingHist.PostingHistMovemntDebitLC | BC Movement Debit |
tdPostingHistMovemntDebitPC | decimal | PostingHist.PostingHistMovemntDebitPC | PC Debit Activity |
tdPostingHistMovemntDebitTC | decimal | PostingHist.PostingHistMovemntDebitTC | TC Debit Activity |
tdPostingHistMovemntQTY | decimal | PostingHist.PostingHistMovemntQTY | Qty Activity |
tiPostingHistYearPeriodFrom | integer | PostingHist.PostingHistYearPeriodFrom | From Year/GL Period |
tdPostingHistYTDCreditCC | decimal | PostingHist.PostingHistYTDCreditCC | SC Credit (YTD) |
tdPostingHistYTDCreditLC | decimal | PostingHist.PostingHistYTDCreditLC | BC YTD Credit |
tdPostingHistYTDCreditPC | decimal | PostingHist.PostingHistYTDCreditPC | PC Credit (YTD) |
tdPostingHistYTDCreditTC | decimal | PostingHist.PostingHistYTDCreditTC | TC Credit (YTD) |
tdPostingHistYTDDebitCC | decimal | PostingHist.PostingHistYTDDebitCC | SC Debit (YTD) |
tdPostingHistYTDDebitLC | decimal | PostingHist.PostingHistYTDDebitLC | BC YTD Debit |
tdPostingHistYTDDebitPC | decimal | PostingHist.PostingHistYTDDebitPC | PC Debit (YTD) |
tdPostingHistYTDDebitTC | decimal | PostingHist.PostingHistYTDDebitTC | TC Debit (YTD) |
tdPostingHistYTDQTY | decimal | PostingHist.PostingHistYTDQTY | Quantity (YTD) |
tiPostingSafCombined_ID | integer | PostingHist.PostingSafCombined_ID | Link to PostingSafCombined |
tcProjectCode | character | Project.ProjectCode | Project |
tcProjectSafStructure | character | SafStructure1.SafStructureCode | Structure Code |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(PostingHist),rowid(BusinessRelation),rowid(CostCentre),rowid(Currency),rowid(Division),rowid(GL),rowid(Journal),rowid(Layer),rowid(PostingSafCombined),rowid(SafStructure1),rowid(SafStructure2),rowid(SafStructure3),rowid(Project) |