SafStructure1.SafStructure_ID = RevalGLSafCombined.CostCentreSafStructure_ID AND
field name | data type | db field | description |
tiCostCentre1Saf_ID | integer | RevalGLSafCombined.CostCentre1Saf_ID | Link to Saf |
tiCostCentre2Saf_ID | integer | RevalGLSafCombined.CostCentre2Saf_ID | Link to Saf |
tiCostCentre3Saf_ID | integer | RevalGLSafCombined.CostCentre3Saf_ID | Link to Saf |
tiCostCentre4Saf_ID | integer | RevalGLSafCombined.CostCentre4Saf_ID | Link to Saf |
tiCostCentre5Saf_ID | integer | RevalGLSafCombined.CostCentre5Saf_ID | Link to Saf |
tiCostCentreSafStructure_ID | integer | RevalGLSafCombined.CostCentreSafStructure_ID | Link to SafStructure |
tiGL1Saf_ID | integer | RevalGLSafCombined.GL1Saf_ID | Link to Saf |
tiGL2Saf_ID | integer | RevalGLSafCombined.GL2Saf_ID | Link to Saf |
tiGL3Saf_ID | integer | RevalGLSafCombined.GL3Saf_ID | Link to Saf |
tiGL4Saf_ID | integer | RevalGLSafCombined.GL4Saf_ID | Link to Saf |
tiGL5Saf_ID | integer | RevalGLSafCombined.GL5Saf_ID | Link to Saf |
tiGLSafStructure_ID | integer | RevalGLSafCombined.GLSafStructure_ID | Link to SafStructure |
tiProject1Saf_ID | integer | RevalGLSafCombined.Project1Saf_ID | Link to Saf |
tiProject2Saf_ID | integer | RevalGLSafCombined.Project2Saf_ID | Link to Saf |
tiProject3Saf_ID | integer | RevalGLSafCombined.Project3Saf_ID | Link to Saf |
tiProject4Saf_ID | integer | RevalGLSafCombined.Project4Saf_ID | Link to Saf |
tiProject5Saf_ID | integer | RevalGLSafCombined.Project5Saf_ID | Link to Saf |
tiProjectSafStructure_ID | integer | RevalGLSafCombined.ProjectSafStructure_ID | Link to SafStructure |
tiRevalGLSafCombined_ID | integer | RevalGLSafCombined.RevalGLSafCombined_ID | Record ID |
tcSafStructureCode | character | SafStructure1.SafStructureCode | Structure Code |
tcSafStructureCode2 | character | SafStructure2.SafStructureCode | Structure Code |
tcSafStructureCode3 | character | SafStructure3.SafStructureCode | Structure Code |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(RevalGLSafCombined),rowid(SafStructure1),rowid(SafStructure2),rowid(SafStructure3) |