https://filetransfer.io/data-package/7DTAA9aK#link

https://filetransfer.io/data-package/No4U22go#link
https://filetransfer.io/data-package/flYoUGD7#link 

https://community.dynamics.com/forums/thread/details/?threadid=58f9c824-d2d0-4f21-b47b-28550390329c

https://www.dynamicsuser.net/t/how-to-create-purchase-agreement-via-job/60843/2

https://filetransfer.io/data-package/syh2BNQi#link

"AccountNumber": "PNJ01",
   "D_VALN_AS_OF": "2022-06-30 00:00:00.0",
     "T_DTL_DESC": "EWTP ARABIA TECHONLOGY INNOVATION FUND ILP",
       "N-INV-SUB-CATG": "Partnerships",
         "Asset Super Category Name": "Venture Capital and Partnerships",
           "A_ADJ_BAS_BSE": "47947573",
             "A_UNRL_MKT_GNLS": "50275681",
               "ProprietarySymbol": "993FD3998",
              
              
              86e7ad1e-c84f-438a-a309-cd1216565dab 

"Success": "True",
    "Error": "",
    "results": [
        {
            "ID": 88,
            "LASTNAME": "Duhaish                                                         ",
            "FIRSTNAME": "Hamad                                                           ",
            "MIDNAME": "                                ",
            "SSNO": "27079        ",
            "DAYNAME": "Sunday         ",
            "DAYNUM": 23,
            "MONTHNAME": "June           ",
            "MONTHNUM": 6,
            "QUARTER": 2,
            "YEAR": 2024,
            "DATE": "2024-06-23",
            "ATTENDANCESTATUS": 1,
            "TIMEIN": "09:02:32",
            "DATETIMEIN": "2024-06-23 09:02:32.0",
            "TIMEOUT": "16:48:18",
            "DATETIMEOUT": "2024-06-23 16:48:18.0",
            "NUMBEROFTIMEIN": 2,
            "NUMBEROFTIMEOUT": 1,
            "WEEKEND": 0,
            "EARLYACCESSIN": 0,
            "EARLYACCESSINHOURS": 0.00,
            "LATEACCESSIN": 0,
            "LATEACCESSOUT": 0,
            "LATEACCESSOUTHOURS": 0.00,
            "EARLYACCESSOUT": 0,
            "TOTALHOURS": 7.77,
            "ACTUALTOTALWORKINGHOURS": 7.77,
            "RECID": null
        },
        {
            "ID": 88,
            "LASTNAME": "Duhaish                                                         ",
            "FIRSTNAME": "Hamad    


https://filetransfer.io/data-package/QFOWGJiY#link
[3:31 PM] Ahmed Saadeldin
IBAN = SA0380000000608010167519
 
[3:31 PM] Ahmed Saadeldin
Account Num = 000000608010167519
 
[3:31 PM] Ahmed Saadeldin
SABBSARI 
 
https://filetransfer.io/data-package/e6Y8IQRT#link
https://filetransfer.io/data-package/n9iLVidY#link
https://filetransfer.io/data-package/yzmQNeGK#link
https://filetransfer.io/data-package/NuQIKmYd#link
https://usnconeboxax1aos.cloud.onebox.dynamics.com/api/services/NW_AttachementServiceGroup/NW_AttatchementService/getAttachment
?cmp=shc&mi=sysclassrunner&cls=NW_UpdateVendTrans
public void processReport()
    {
        NW_GeneralContract              contract;
        PurchTable                      PurchTable;
        PurchLine                       PurchLine;
        //LOGISTICSELECTRONICADDRESS      LOGISTICSELECTRONICADDRESS;
        VendTable                       VendTable;
        DirPartyTable                   DirPartyTable;
        PurchTotals                 PurchTotals;
        HcmWorker                   HcmWorker;
        //DLVMODE DLVMODE;
        //PURCHREQTABLE PURCHREQTABLE;
        //DlvTerm                     DlvTerm;
        //VENDPAYMMODETABLE VENDPAYMMODETABLE;
        //PAYMTERM PAYMTERM;
        //PURCHRFQCASETABLE PURCHRFQCASETABLE;
        //PURCHREQLINE PURCHREQLINE,PURCHREQLINESelected;
        //LOGISTICSPOSTALADDRESS LOGISTICSPOSTALADDRESS;
        //VendPurchOrderJour VendPurchOrderJour;
        //LOGISTICSLOCATION LOGISTICSLOCATION;
        //DIRPARTYLOCATION DIRPARTYLOCATION;
        //TaxOnItem TaxOnItem;
        //TAXDATA TAXDATA;
        contract = this.parmDataContract() as NW_GeneralContract;
    
        select PurchTable
           where PurchTable.RecId == contract.parmRecordId();
       
        while select PurchLine where PurchLine.PurchId == PurchTable.PurchId
        {   
            PurchTableTmp.clear();

            PurchTableTmp.PurchId = PurchTable.PurchId;
            PurchTableTmp.DeliveryDate = PurchTable.DeliveryDate;
            PurchTableTmp.PurchName = PurchTable.PurchName;
            PurchTableTmp.Payment = PurchTable.Payment;
            PurchTableTmp.AdditionalNotes = PurchTable.AdditionalNotes;

            PurchTableTmp.PURCHQTY = PurchLine.PURCHQTY;
            PurchTableTmp.PURCHPRICE = PurchLine.PURCHPRICE;
            PurchTableTmp.LINEPERCENT = PurchLine.LINEPERCENT;
            PurchTableTmp.PurchUnit = PurchLine.PurchUnit;
            PurchTableTmp.LineAmount = PurchLine.LineAmount;
            PurchTableTmp.NameDescription = PurchLine.itemName();

            HcmWorker = HcmWorker::find(PurchTable.Requester);
            PurchTableTmp.Requester = HcmWorker.name();
            PurchTableTmp.RequesterAdd = HcmWorker.primaryAddress();
            PurchTableTmp.RequesterPhone = HcmWorker.phone();
            PurchTableTmp.RequesterDep = PurchTable.DepartmentName();

            VendTable = VendTable::find(PurchTable.OrderAccount);
            PurchTableTmp.Phone = VendTable.phone();
            PurchTableTmp.Email = VendTable.email();
            PurchTableTmp.VendName = PurchTable.PurchName;
            PurchTableTmp.Fax = PurchTable.NonPrimaryVendPhone();
            PurchTableTmp.Termnote = PurchTable.ContcatPersonName();
            PurchTableTmp.Warranty = PurchTable.Warranty;

            PurchTotals = PurchTotals::newPurchTable(PurchTable);
            PurchTotals.calc();

            PurchTableTmp.SubTotal = PurchTotals.purchBalance(); // sub
            PurchTableTmp.Total = PurchTotals.purchTotalAmount(); // total
            PurchTableTmp.Currency = PurchTotals.purchCurrency();
            PurchTableTmp.VAT = PurchTotals.taxTotal();
            PurchTableTmp.TotalTxt = numeralsToTxt(PurchTableTmp.Total);
            PurchTableTmp.SubTotalTxt = numeralsToTxt(PurchTableTmp.SubTotal);
            PurchTableTmp.TaxCode = any2Str((PurchTableTmp.VAT / PurchTableTmp.SubTotal)*100);
            //select PURCHREQTABLE where PURCHREQTABLE.PURCHREQID==PURCHLINE.PURCHREQID;
            //Select  DLVMODE where DLVMODE.CODE==PURCHREQTABLE.DLVMODE;
            //Select  DlvTerm where DlvTerm.Code == PurchTable.DlvTerm;

            //Select  VENDPAYMMODETABLE  where VENDPAYMMODETABLE.PAYMMODE==PURCHREQTABLE.PAYMMODE;
            //Select  PAYMTERM where PAYMTERM.PAYMTERMID==PURCHREQTABLE.PAYMENT;

            PurchTableTmp.DlvModeTxt = DlvMode::find(PurchTable.DlvMode).Txt;
            PurchTableTmp.DlvTermTxt = DlvTerm::find(PurchTable.DlvTerm).Txt;
            //PurchTableTmp.PayModeName=VENDPAYMMODETABLE.NAME;
            PurchTableTmp.PAYTERMNAME = PaymTerm::find(PurchTable.Payment).DESCRIPTION;
            //PurchTableTmp.Termnote=PURCHREQTABLE.termsnote;
            PurchTableTmp.Address = CompanyInfo::find().postalAddress().Address;

            //select PURCHREQLINE where PURCHREQLINE.PURCHREQTABLE == PURCHREQTABLE.RECID;
            //select PURCHRFQCASETABLE where PURCHRFQCASETABLE.RFQCASEID == PURCHREQLINE.PURCHRFQCASEID;

            //PurchTableTmp.RFQCASEID=PURCHRFQCASETABLE.RFQCASEID;

            //select PURCHREQLINESelected where PURCHREQLINESelected.LINEREFID==PURCHLINE.PURCHREQLINEREFID;
            //PurchTableTmp.Name=PURCHREQLINESelected.ITEMIDNONCATALOG;
            //PurchTableTmp.NameDescription=PURCHREQLINESelected.ITEMIDNONCATALOG + ' - ' + PURCHREQLINESelected.NAME;
            //PurchTableTmp.Currency=PURCHREQLINESelected.CurrencyCode;



            //Select  firstonly VendPurchOrderJour   where VendPurchOrderJour.purchid==PURCHTABLE.purchid;
            //PurchTableTmp.DateConf=VendPurchOrderJour.PurchOrderDate;

            //Select LOGISTICSPOSTALADDRESS where PURCHTABLE.DELIVERYPOSTALADDRESS==LOGISTICSPOSTALADDRESS.RECID;

            //PurchTableTmp.ShipingAddress=LOGISTICSPOSTALADDRESS.ADDRESS;

            //select DIRPARTYTABLE where VENDTABLE::find(PurchTable.OrderAccount).PARTY==DIRPARTYTABLE.RECID;
            //select DIRPARTYLOCATION  where DIRPARTYTABLE.RECID == DIRPARTYLOCATION.PARTY;
            //select  LOGISTICSLOCATION where DIRPARTYLOCATION.LOCATION == LOGISTICSLOCATION.RECID;
            //select LOGISTICSPOSTALADDRESS where LOGISTICSPOSTALADDRESS.Location==LOGISTICSLOCATION.RECID;

            //PurchTableTmp.VendAdress=LOGISTICSPOSTALADDRESS.Address;

            //select TaxOnItem where TaxOnItem.TAXITEMGROUP==PURCHLINE.TaxItemGroup;

            //select TAXDATA where TAXDATA.TAXCODE==TAXONITEM.TAXCODE
            //    && TAXDATA.TAXFROMDATE<=PURCHTABLE.ACCOUNTINGDATE && TAXDATA.TAXTODATE>=PURCHTABLE.ACCOUNTINGDATE;

           
            PurchTableTmp.insert();

                
        }


        
    }