Description
PaySelLine
Parameters
| iiParentObject_ID | integer | Parent Object ID |
| icObjectType | character | Object Type |
| iiPaySel_ID | integer | |
| iiCompanyId | integer | Company id |
| icPaySelStatus | character | |
query condition
each PaySelLine where
PaySelLine.PaySelLineParentObject_ID = iiParentObject_ID AND
PaySelLine.PaySelLineObjectType = icObjectType AND
PaySelLine.PaySel_ID = iiPaySel_ID
first PaySel (inner-join) where
PaySel.Company_Id = iiCompanyId AND
PaySel.PaySel_ID = PaySelLine.PaySel_ID AND
PaySel.PaySelStatus can-do icPaySelStatus
query resultset tqPaySelLineByIDs
| field name | data type | db field | description |
|---|
| 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 |
| tcPaySelStatus | character | PaySel.PaySelStatus | Status |
Internal usage
QadFinancials