project QadFinancials > class BPaymentSelection > business logic query PaySelLineByPaySelIdPrepayment
Description
This query is created to improve the performance on the Payment Selection load (GetPublicTables). To get more information, check BTS 3934.
Parameters
| icObjectTypeList | character | A comma seperated list of object types. |
| iiPaySelId | integer | The payment selection ID |
| iiCompanyId | integer | Company id |
query condition
each PaySelLine where
PaySelLine.PaySel_ID = iiPaySelId AND
PaySelLine.PaySelLineObjectType = icObjectTypeList AND
PaySelLine.PaySelLineParentObject_ID > 0
first PaySelPrepay (inner-join) where
PaySelPrepay.PaySelPrepay_ID = PaySelLine.PaySelLineParentObject_ID AND
first BusinessRelation (conditional-join) where
BusinessRelation.BusinessRelation_ID = PaySelPrepay.BusinessRelation_ID AND
first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = PaySelPrepay.Creditor_ID AND
first Currency (inner-join) where
Currency.Currency_ID = PaySelPrepay.Currency_ID AND
query resultset tqPaySelLineByPaySelIdPrepayment
| field name | data type | db field | description |
|---|
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tcCreditorCode | character | Creditor.CreditorCode | Supplier Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiPaySel_ID | integer | PaySelLine.PaySel_ID | Link to PaySel |
| tiPaySelLine_ID | integer | PaySelLine.PaySelLine_ID | Record ID |
| tcPaySelLineObjectType | character | PaySelLine.PaySelLineObjectType | Type |
| tiPaySelLineParentObject_ID | integer | PaySelLine.PaySelLineParentObject_ID | Parent Object |
| tiPaySelPrepay_ID | integer | PaySelPrepay.PaySelPrepay_ID | Record ID |
| tdPaySelPrepayAmountToPayTC | decimal | PaySelPrepay.PaySelPrepayAmountToPayTC | Amount to Pay |
| tcPaySelPrepayReferenceText | character | PaySelPrepay.PaySelPrepayReferenceText | Reference |
Internal usage
QadFinancials