Insert  Data into CustomTable(Based purch ID)

static void dLSPurchOrderDetails(Args _args)
{
    PurchId                             purchId;
    PurchTable                         purchtable;
     PurchLine                          purchline;
    DLSPurchaseorderDetails1_1016       dLSPurchOrderDetails;
     LogisticsPostalAddress              logisticsPostalAddress;
    DimensionAttribute                  DimensionAttribute;
    DimensionAttributeValueSetItemView  DimensionAttributeValueSetItemView;


     delete_from dLSPurchOrderDetails;
     while select  purchId from purchtable
         group by purchtable.PurchId,purchtable.DefaultDimension,purchtable.DeliveryPostalAddress
         where purchtable.PurchId == purchtable.PurchId
    {
        select DisplayValue from DimensionAttributeValueSetItemView
              join DimensionAttribute
              where DimensionAttributeValueSetItemView.DimensionAttributeValueSet == purchtable.DefaultDimension
                    && DimensionAttribute.Name == "BusinessUnit"
                    && DimensionAttribute.RecId == DimensionAttributeValueSetItemView.DimensionAttribute;

             // && DimensionAttribute.RecId == DimensionAttributeValueSetItemView.DimensionAttribute



    {
            dLSPurchOrderDetails.PurchId               = purchtable.PurchId;

            dLSPurchOrderDetails.BusinessUnit = DimensionAttributeValueSetItemView.DisplayValue;
            select DisplayValue from DimensionAttributeValueSetItemView
              join DimensionAttribute
              where DimensionAttributeValueSetItemView.DimensionAttributeValueSet == purchtable.DefaultDimension
                    && DimensionAttribute.Name == "CostCenter"
                    && DimensionAttribute.RecId == DimensionAttributeValueSetItemView.DimensionAttribute;
                    dLSPurchOrderDetails.CostCenter = DimensionAttributeValueSetItemView.DisplayValue;
            select DisplayValue from DimensionAttributeValueSetItemView
                join DimensionAttribute
                where DimensionAttributeValueSetItemView.DimensionAttributeValueSet == purchtable.DefaultDimension
                    && DimensionAttribute.Name == "Department"
                    && DimensionAttribute.RecId == DimensionAttributeValueSetItemView.DimensionAttribute;
                    dLSPurchOrderDetails.Department = DimensionAttributeValueSetItemView.DisplayValue;
            select DisplayValue from DimensionAttributeValueSetItemView
                 join DimensionAttribute
                 where DimensionAttributeValueSetItemView.DimensionAttributeValueSet == purchtable.DefaultDimension
                    && DimensionAttribute.Name == "Project"
                    && DimensionAttribute.RecId == DimensionAttributeValueSetItemView.DimensionAttribute;
            dLSPurchOrderDetails.Project = DimensionAttributeValueSetItemView.DisplayValue;
            select DisplayValue from DimensionAttributeValueSetItemView
                join DimensionAttribute
                where DimensionAttributeValueSetItemView.DimensionAttributeValueSet == purchtable.DefaultDimension
                    && DimensionAttribute.Name == "ItemGroup"
                    && DimensionAttribute.RecId == DimensionAttributeValueSetItemView.DimensionAttribute;
            dLSPurchOrderDetails.ItemGroup = DimensionAttributeValueSetItemView.DisplayValue;
            select Address from logisticspostalAddress
                where logisticspostalAddress.RecId == purchtable.DeliveryPostalAddress;
                   dLSPurchOrderDetails.Address       = logisticsPostalAddress.Address;
            dLSPurchOrderDetails.insert();
        }

        }
    info('Records Inserted');


}