project QadFinancials > class BDebtor > business logic query DebtorForSSMProfSalesGL
Description
Used for shared set merge validation - compatibility of profiles definition
Parameters
| iiCompanyId | integer | Company id |
| iiSharedSetId | integer | |
query condition
each Debtor where
Debtor.SharedSet_Id = iiSharedSetId
first Profile (inner-join) where
Profile.Profile_ID = Debtor.SalesAccountGLProfile_ID AND
each ProfileLink (inner-join) where
ProfileLink.Profile_ID = Profile.Profile_ID AND
first GL (inner-join) where
GL.GL_ID = ProfileLink.ProfileLinkObject_ID AND
(GL.SharedSet_Id = 0 or true )
query resultset tqDebtorForSSMProfSalesGL
| field name | data type | db field | description |
|---|
| tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
| tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
| api annotation: | | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. |
| tiGL_ID | integer | GL.GL_ID | Record ID |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tiGLSharedSet_ID | integer | GL.SharedSet_ID | Link to SharedSet |
| tcProfileCode | character | Profile.ProfileCode | A code (maximum 20 characters) that identifies a profile. |
| tiSharedSet_ID | integer | Debtor.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials