Zero Copy Connector for ERP table join conditions field descriptions

The Table join condition form in Zero Copy Connector for ERP enables you to create and edit join conditions for tables in a ERP (Enterprise Resource Planning) model.

Table joins link different tables through shared fields. Joins enable you to access data from multiple tables based on logical relationships between them. The relationship can be conditional, which you specify using join conditions. Use inner joins or outer joins. An inner join returns records that have matching values in both tables. Outer joins combine left and right join results to return all rows with matches or NULLS.

Join fields defines the common attribute or key used to connect records in a child table with their corresponding parent records.

For process details, see Add joins between ERP tables.

Table 1. Create new table join condition fields

Field	Description
ERP model table field	Name of the join field on the ERP system of record, which represents an attribute or column in the table where data is stored.
ERP model	ERP model that the join condition applies to.
Field value	Value for the field in the ERP model table that triggers the join.
Order	Numerical value that indicates which part of the join occurs first. This number determines the order join condition position relative to other items, helping to establish the prioritization.
Operator	Operator that defines the conditions for your query. Operators determine how the values are evaluated and filtered in the query results. The following are supported operators: equals contains greater than greater than or equal less than less than or equal not equals
Statement operator	Operator that defines the condition or comparison in your statement. The options are AND and OR.