{v_cf_customer.position}

                {v_cf_customer.name}

                {v_cf_customer.data type}

                {v_cf_customer.field}

The {v_cf_customer table} is linked to the {v_txn_sales_order_line table} through the id fields.  The {v_cf_customer.name} field specifies what detail in the {v_cf_customer.field} field goes to status or rep group.  The {v_cf_customer.name} field is where the actual name "status" or "rep group" is.  The {v_cf_customer.field} field is where description like "W/other orders","Shipped", "RTG-OT" is that is a status. "Tom-mayo","....." is also in the {v_cf_customer.field} field but it is a "rep group" from the {v_cf_customer.name} field.

 

  Other tables that are linked to the sales order table are;

 

{v_lst_customer}

{v_lst_item}

{v_lst_sales_rep}

{v_lst_ship_via}

 

The sales rep table is for our sales people and is different than our outside sales reps.

 

Does that help at all?