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