project QadFinancials > class BPaymentSelection > business logic query PaySelLineByPaySelIDCInvoice
Parameters
iiPaySelID | integer | |
iiCompanyId | integer | Company id |
iiBankPayFormatID | integer | |
query condition
each PaySelLine where
PaySelLine.PaySel_ID = iiPaySelID
first CInvoice (inner-join) where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = PaySelLine.PaySelLineParentObject_ID AND
first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CInvoice.Creditor_ID AND
each BankNumber (inner-join) where
BankNumber.ParentObject_ID = Creditor.Creditor_ID AND
BankNumber.BankPayFormat_ID = iiBankPayFormatID
query resultset tqPaySelLineByPaySelIDCInvoice
field name | data type | db field | description |
tcBankNumber | character | BankNumber.BankNumber | Bank Number |
tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
tcBankNumberExtension | character | BankNumber.BankNumberExtension | Bank Extension |
tlBankNumberIsActive | logical | BankNumber.BankNumberIsActive | Active |
tcBankNumberValidation | character | BankNumber.BankNumberValidation | Validation |
tiBankPayFormat_ID | integer | BankNumber.BankPayFormat_ID | Link to BankPayFormat |
tiCreditor_ID | integer | Creditor.Creditor_ID | Record ID |
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 |
Internal usage
QadFinancials