Microsoft Dynamics NAV Adapter Stored Procedures

Name	Description
CreateAssociation	Creates an association between two entities. This will only work for tables that have in-line columns.
ListAssociations	Lists associations for a given entity Id. This will only work for tables that have in-line columns.
RemoveAssociation	Removes an association between two entities. This will only work for tables that have in-line columns.

CreateAssociation

Creates an association between two entities. This will only work for tables that have in-line columns.

Input

Name	Type	Description
SourceId	String	The Id of the entity you are listing associations for.
DestinationId	String	The Id of the entity you are associating with the SourceId.
SourceTable	String	The table where the SourceId is listed. For example, if the SourceId was from a table called Customers, enter Customers.
DestinationTable	String	The table where the DestinationId is listed. For example, if the DestinationId comes from a table called Orders, enter Orders.

Result Set Columns

Name	Type	Description
*	String	Output will vary for each entity.

ListAssociations

Lists associations for a given entity Id. This will only work for tables that have in-line columns.

Input

Name	Type	Description
SourceId	String	The Id of the entity you are listing associations for.
SourceTable	String	The table where the entity comes from that you are listing entities for. For example, if the SourceId was from a table called Customers, set this parameter to Customers.
DestinationTable	String	The table you are looking for associations with. For example, if you are looking for associations with the Orders table, set this parameter to Orders.

Result Set Columns

Name	Type	Description
*	String	Output will vary for each entity.

RemoveAssociation

Removes an association between two entities. This will only work for tables that have in-line columns.

Input

Name	Type	Description
SourceId	String	The Id of the entity you are removing an association from.
DestinationId	String	The Id of the entity you are removing as an association.