project QadFinancials > class BExpenseNote > business logic query ExpNoteLineSafByLine
Parameters
query condition
each ExpNoteLineSaf where
ExpNoteLineSaf.ExpNoteLine_ID = iiExpNoteLine_ID
first Saf (inner-join) where
Saf.Saf_ID = ExpNoteLineSaf.Saf_ID AND
first SafConcept (inner-join) where
SafConcept.SafConcept_ID = Saf.SafConcept_ID AND
first SafStructure (inner-join) where
SafStructure.SafStructure_ID = ExpNoteLineSaf.SafStructure_ID AND
query resultset tqExpNoteLineSafByLine
| field name | data type | db field | description |
|---|
| tiExpNoteLineSafInputSeq | integer | ExpNoteLineSaf.ExpNoteLineSafInputSeq | Sequence |
| tcSafCode | character | Saf.SafCode | SAF Code |
| tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
| tcSafStructureCode | character | SafStructure.SafStructureCode | Structure Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(ExpNoteLineSaf),rowid(Saf),rowid(SafConcept),rowid(SafStructure) |
Internal usage
QadFinancials