tcBusinessFieldName | tcDataType | tcOperator |
iiCompanyId | i | |
tCompany.CompanyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCostCentre.CostCentreCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDivision.DivisionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tFRWCubeDim.FRWCubeDimSafCode01 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tFRWCubeDim.FRWCubeDimSafCode02 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tFRWCubeDim.FRWCubeDimSafCode03 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tFRWCubeDim.FRWCubeDimSafCode04 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tFRWCubeDim.FRWCubeDimSafCode05 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tLayer.LayerCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPostingHist.PostingHistBalanceCreditCC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceCreditLC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceCreditPC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceCreditTC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceDebitCC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceDebitLC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceDebitPC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceDebitTC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistBalanceQTY | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntCreditCC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntCreditLC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntCreditPC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntCreditTC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntDebitCC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntDebitLC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntDebitPC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntDebitTC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistMovemntQTY | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYearPeriodFrom | i | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYearPeriodTill | i | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDCreditCC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDCreditLC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDCreditPC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDCreditTC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDDebitCC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDDebitLC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDDebitPC | d | =,>=,>,<>,<=,< |
tPostingHist.PostingHistYTDDebitTC | d | =,>=,>,<>,<=,< |
tProject.ProjectCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
field name | data type | db field | description |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
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 |
tcFRWCubeDimSafCode01 | character | FRWCubeDim.FRWCubeDimSafCode01 | Saf 1 |
tcFRWCubeDimSafCode02 | character | FRWCubeDim.FRWCubeDimSafCode02 | Saf 2 |
tcFRWCubeDimSafCode03 | character | FRWCubeDim.FRWCubeDimSafCode03 | Saf 3 |
tcFRWCubeDimSafCode04 | character | FRWCubeDim.FRWCubeDimSafCode04 | Saf 4 |
tcFRWCubeDimSafCode05 | character | FRWCubeDim.FRWCubeDimSafCode05 | Saf 5 |
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 |
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 |
tiPostingHistYearPeriodTill | integer | PostingHist.PostingHistYearPeriodTill | To 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) |
tcProjectCode | character | Project.ProjectCode | Project |
FRWCubeDimCustom | character | calculated | custom fields |
PostingHistCustom | character | calculated | custom fields |
GLCustom | character | calculated | custom fields |
CostCentreCustom | character | calculated | custom fields |
DivisionCustom | character | calculated | custom fields |
JournalCustom | character | calculated | custom fields |
LayerCustom | character | calculated | custom fields |
ProjectCustom | character | calculated | custom fields |
CurrencyCustom | character | calculated | custom fields |
CompanyCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(FRWCubeDim),rowid(FRWCubeMeas),rowid(FRWCubeHistLink),rowid(PostingHist),rowid(Company),rowid(CostCentre),rowid(Currency),rowid(Division),rowid(GL),rowid(Journal),rowid(Layer),rowid(Project),rowid(FRWCubePeriod) |