GetRelationshipColumns
Retrieves columns that define relationships (e.g., parent-child) in Sage Intacct for the specified table.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC GetRelationshipColumns TableName='GLACCOUNT'
Input
| Name | Type | Description |
| TableName | String | The name of the table containing the relationship columns to retrieve. |
Result Set Columns
| Name | Type | Description |
| Id | String | The unique identifier for the relationship column. |
| Name | String | The name of the relationship column. |
| Relationship | String | A description of the relationship represented by the column. |
| RelatedObject | String | The related object (table or entity) that this column is associated with. |