| tcBusinessFieldName | tcDataType | tcOperator |
|---|
| iiCompanyId | i | |
| tFRWCubeDim.FRWCubeDimCompanyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimCostCentreCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimCostCentreDescr | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimCurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimDivisionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimDivsionDescr | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimDomainCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimFRWCubeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimGLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimGLDescr | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimICInterco | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimJournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimJournalTypeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimLayerCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimLayerTypeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimProjectCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimProjectDescr | 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 |
| tFRWCubeDim.FRWCubeDimSafCode06 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimSafCode07 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimSafCode08 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimSafCode09 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeDim.FRWCubeDimSafCode10 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeMeas.FRWCubeMeasAcitivtyQTY | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityCRLC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityCRPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityCRTC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityDifPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityDRLC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityDRPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasActivityDRTC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasCloseBalLC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasCloseBalPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasCloseBalTC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasClosingBalDifPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasClosingBalQTY | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasLCCCCurCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeMeas.FRWCubeMeasOpenBalDifPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasOpenBalLC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasOpenBalLTC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasOpenBalPC | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasOpenBalQTY | d | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasPCCurCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| tFRWCubeMeas.FRWCubeMeasReportPeriod | i | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasReportYear | i | =,>=,>,<>,<=,< |
| tFRWCubeMeas.FRWCubeMeasTCCurCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
| field name | data type | db field | description |
|---|
| tcDayBookTypeCalc | character | calculated | |
| tiFRWCubeDim_ID | integer | FRWCubeDim.FRWCubeDim_ID | Record ID |
| tcFRWCubeDimCompanyCode | character | FRWCubeDim.FRWCubeDimCompanyCode | Entity |
| tcFRWCubeDimCostCentreCode | character | FRWCubeDim.FRWCubeDimCostCentreCode | Cost Center |
| tcFRWCubeDimCostCentreDescr | character | FRWCubeDim.FRWCubeDimCostCentreDescr | Cost Center Descr |
| tcFRWCubeDimCurrencyCode | character | FRWCubeDim.FRWCubeDimCurrencyCode | Currency |
| tcFRWCubeDimDivisionCode | character | FRWCubeDim.FRWCubeDimDivisionCode | Sub-Account |
| tcFRWCubeDimDivsionDescr | character | FRWCubeDim.FRWCubeDimDivsionDescr | Sub-Account Descr |
| tcFRWCubeDimDomainCode | character | FRWCubeDim.FRWCubeDimDomainCode | Domain |
| tcFRWCubeDimFRWCubeCode | character | FRWCubeDim.FRWCubeDimFRWCubeCode | Cube Name |
| tcFRWCubeDimGLCode | character | FRWCubeDim.FRWCubeDimGLCode | GL |
| tcFRWCubeDimGLDescr | character | FRWCubeDim.FRWCubeDimGLDescr | GL Descr |
| tcFRWCubeDimICInterco | character | FRWCubeDim.FRWCubeDimICInterco | IC Interco |
| tcFRWCubeDimJournalCode | character | FRWCubeDim.FRWCubeDimJournalCode | Daybook |
| tcFRWCubeDimJournalTypeCode | character | FRWCubeDim.FRWCubeDimJournalTypeCode | Daybook Type |
| tcFRWCubeDimLayerCode | character | FRWCubeDim.FRWCubeDimLayerCode | Layer |
| tcFRWCubeDimLayerTypeCode | character | FRWCubeDim.FRWCubeDimLayerTypeCode | Layer Type |
| tcFRWCubeDimProjectCode | character | FRWCubeDim.FRWCubeDimProjectCode | Project |
| tcFRWCubeDimProjectDescr | character | FRWCubeDim.FRWCubeDimProjectDescr | Project Descr |
| 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 |
| tcFRWCubeDimSafCode06 | character | FRWCubeDim.FRWCubeDimSafCode06 | Saf 6 |
| tcFRWCubeDimSafCode07 | character | FRWCubeDim.FRWCubeDimSafCode07 | Saf 7 |
| tcFRWCubeDimSafCode08 | character | FRWCubeDim.FRWCubeDimSafCode08 | Saf 8 |
| tcFRWCubeDimSafCode09 | character | FRWCubeDim.FRWCubeDimSafCode09 | Saf 9 |
| tcFRWCubeDimSafCode10 | character | FRWCubeDim.FRWCubeDimSafCode10 | Saf 10 |
| tdFRWCubeMeasAcitivtyQTY | decimal | FRWCubeMeas.FRWCubeMeasAcitivtyQTY | Qty Activity |
| tdFRWCubeMeasActivityCRLC | decimal | FRWCubeMeas.FRWCubeMeasActivityCRLC | BC/SC Activity CR |
| tdFRWCubeMeasActivityCRPC | decimal | FRWCubeMeas.FRWCubeMeasActivityCRPC | PC Activity CR |
| tdFRWCubeMeasActivityCRTC | decimal | FRWCubeMeas.FRWCubeMeasActivityCRTC | TC Activity CR |
| tdFRWCubeMeasActivityDifPC | decimal | FRWCubeMeas.FRWCubeMeasActivityDifPC | PC ActivityTranslation Difference |
| tdFRWCubeMeasActivityDRLC | decimal | FRWCubeMeas.FRWCubeMeasActivityDRLC | BC/SC Activity DR |
| tdFRWCubeMeasActivityDRPC | decimal | FRWCubeMeas.FRWCubeMeasActivityDRPC | PC Activity DR |
| tdFRWCubeMeasActivityDRTC | decimal | FRWCubeMeas.FRWCubeMeasActivityDRTC | TC Activity DR |
| tdFRWCubeMeasCloseBalLC | decimal | FRWCubeMeas.FRWCubeMeasCloseBalLC | BC/SC Closing Balance |
| tdFRWCubeMeasCloseBalPC | decimal | FRWCubeMeas.FRWCubeMeasCloseBalPC | PC Closing Balance |
| tdFRWCubeMeasCloseBalTC | decimal | FRWCubeMeas.FRWCubeMeasCloseBalTC | TC Closing Balance |
| tdFRWCubeMeasClosingBalDifPC | decimal | FRWCubeMeas.FRWCubeMeasClosingBalDifPC | PC Closing Translation Difference |
| tdFRWCubeMeasClosingBalQTY | decimal | FRWCubeMeas.FRWCubeMeasClosingBalQTY | Qty Closing Balance |
| tcFRWCubeMeasLCCCCurCode | character | FRWCubeMeas.FRWCubeMeasLCCCCurCode | BC/SC Currency Code |
| tdFRWCubeMeasOpenBalDifPC | decimal | FRWCubeMeas.FRWCubeMeasOpenBalDifPC | PC Opening Translation Difference |
| tdFRWCubeMeasOpenBalLC | decimal | FRWCubeMeas.FRWCubeMeasOpenBalLC | BC/SC Opening Balance |
| tdFRWCubeMeasOpenBalLTC | decimal | FRWCubeMeas.FRWCubeMeasOpenBalLTC | TC Opening Balance |
| tdFRWCubeMeasOpenBalPC | decimal | FRWCubeMeas.FRWCubeMeasOpenBalPC | PC Opening Balance |
| tdFRWCubeMeasOpenBalQTY | decimal | FRWCubeMeas.FRWCubeMeasOpenBalQTY | Qty Opening Balance |
| tcFRWCubeMeasPCCurCode | character | FRWCubeMeas.FRWCubeMeasPCCurCode | PC Currency Code |
| tiFRWCubeMeasReportPeriod | integer | FRWCubeMeas.FRWCubeMeasReportPeriod | Period |
| tiFRWCubeMeasReportYear | integer | FRWCubeMeas.FRWCubeMeasReportYear | Year |
| tcFRWCubeMeasTCCurCode | character | FRWCubeMeas.FRWCubeMeasTCCurCode | TC Currency Code |
| tcLayerTypeCalc | character | calculated | |
| FRWCubeDimCustom | character | calculated | custom fields |
| FRWCubeMeasCustom | character | calculated | custom fields |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(FRWCubeDim),rowid(FRWCubeMeas) |
each FRWCubeDim where