project QadFinancials > class BAltCOAStruct > business logic query AltCOAStructDetPrim
Parameters
| iiAltCOAStructDetId | integer | |
| icAltCOAStructDetCode | character | |
| icAltCOAStructCode | character | |
query condition
each AltCOAStructDet where
AltCOAStructDet.AltCOAStructDet_ID = iiAltCOAStructDetId AND
AltCOAStructDet.AltCOAStructDetCode = icAltCOAStructDetCode
first AltCOAStruct (inner-join) where
AltCOAStruct.AltCOAStruct_ID = AltCOAStructDet.AltCOAStruct_ID AND
AltCOAStruct.AltCOAStructCode = icAltCOAStructCode
query resultset tqAltCOAStructDetPrim
| field name | data type | db field | description |
|---|
| tiAltCOAStruct_ID | integer | AltCOAStruct.AltCOAStruct_ID | Alternate COA Structure |
| tcAltCOAStructCode | character | AltCOAStruct.AltCOAStructCode | Code |
| tiAltCOAStructDet_ID | integer | AltCOAStructDet.AltCOAStructDet_ID | Alternate COA |
| tcAltCOAStructDetCode | character | AltCOAStructDet.AltCOAStructDetCode | Alternate COA |
Internal usage
QadFinancials