Uploaded image for project: 'Shell OneHub'
  1. Shell OneHub
  2. SO-2807

P8-TTS Web Service satış datasına yeni parametre eklenmesi

    XMLWordPrintable

    Details

      Description

      Analiz linki:https://docs.google.com/document/d/15VxsiW7mr0Bsq8WyynfVXXVneYg9TfOssSBEmgyMVEo/edit#heading=h.6rur03ezgxn7

      GetCustomerSalesTransaction ve GetCustomerSalesTransaction_with_rid servisine aşağıdaki bilgi eklenecektir. Bu bilgi vis_sales_detail tablosunda satış bazlı olarak bulunmaktadır. İlgili satış kaydı bu bilgi ile zenginleştirilmelidir.
      <SALESTRANSACTIONINFO>
      <Sales_type>Normal</Sales_type>
      <Customer_code>11842524</Customer_code>
      <Customer_name>Tts</Customer_name>
      <Department_code>1</Department_code>
      <Department_name>1</Department_name>
      <Card_no>7083261138629491</Card_no>
      <Plate_cd>34DHY816</Plate_cd>
      <Viu_type>Akıllı Halka</Viu_type>
      <Transaction_date>2024-01-01T11:34:17</Transaction_date>
      <Retail_outlet_code>2048</Retail_outlet_code>
      <Retail_outlet_name>Yeniköy İstanbul.</Retail_outlet_name>
      <Rtl_otlt_province>İstanbul</Rtl_otlt_province>
      <Fuel_name>Kurşunsuz 95 - Shell Vp</Fuel_name>
      <Group_code/>
      <Vehicle_km>0</Vehicle_km>
      <Unit_price>34.59</Unit_price>
      <Volume>28.49</Volume>
      <Sales_total_amount>985.47</Sales_total_amount>
      <Sales_vat_amount>164.24</Sales_vat_amount>
      <Inv_tot_amount>985.47</ Inv_tot_amount >
      <Inv_vat_amount>164.24</ Inv_tot_amount >
      <Invoice_no>4218360</Invoice_no>
      <Customer_Reference>?</Customer_Reference>
      <Shell_Reference>13942083133</Shell_Reference>
      </SALESTRANSACTIONINFO>
      -Eklenecek olan parametre: inv_tot_amount,inv_vat_amount
      -Ekleneceği Web Servisler: GetCustomerSalesTransaction, GetCustomerSalesTransaction_with_rid
      Not: Web Service dokümanı ilgili geliştirmeyi dahil edecek şekilde güncellenmelidir.

      DB Tarafında Yapılacaklar
      Eklenecek parametrelerin db kolon adları parametre inv_tot_amount, inv_vat_amount
      2. Ekleme yapılacak sp: PCK_WEB.GETSALES

        Attachments

          Activity

            People

            Assignee:
            selma Selma Öztaşkın
            Reporter:
            Şerife Şerife Şahin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: