Description
Prim-query on table RecEntry that allows you convert the logical key into the physical one and vice-versa
Parameters
| iiCompanyId | integer | Company id |
| icRecEntryCode | character | |
| iiRecEntryID | integer | |
query condition
each RecEntry where
RecEntry.Company_Id = iiCompanyId AND
RecEntry.RecEntry_ID = iiRecEntryID AND
RecEntry.RecEntryCode = icRecEntryCode
query resultset tqRecEntryPrim
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | RecEntry.Company_ID | Link to Company |
| tiRecEntry_ID | integer | RecEntry.RecEntry_ID | Record ID |
| tcRecEntryCode | character | RecEntry.RecEntryCode | Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(RecEntry) |
Internal usage
QadFinancials