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

Hatalı yakıt alımları belirtilen kod için globalden veri gelmesine rağmen bo dan veri gelmemesi.

    XMLWordPrintable

    Details

      Description

      0012476381 bu kod için globalden veri gelmesine ragmen bo’dan veri gelmiyor. Sadece tüm ayı seçtiğimde veri alabildim. Dün,bugün gelmedi.
      select * from SFSBI_TRANSACTION where cust_cd = '0012476381' and day > sysdate-2

      {

      "AggregatedData": {

      "InputParameters":

      { "accountNumber": null, "productCode": null, "payerNumber": "TR00540687", "purchasedInCountry": null, "pan": null, "transactionStatus": null, "productGroupLevel3": null, "productGroupLevel2": null, "transactionStartDate": null, "transactionEndDate": null, "fromDatetime": null, "toDatetime": null, "pageSize": "10", "currentPage": "1", "includeDeclines": null, "colCoCode": null, "sourceCardId": null, "vehicleRegistrationNumber": null, "cardIssuerName": "EVIAS-Turkey", "CardDriverNm": null, "rowCount": "57", "columnList": "" }

      ,

      "RecentTransactions": [

      { "accountNumber": "TR00540687", "cardIssueNumber": "1", "collectingCompanyCurrencyISOCode": "TRY", "custDataCustomerEntered": "", "custDataDriverId": "1", "custDataFleetDescription": "", "fleetIdInput": "", "amount": "1335.61", "euroshellSiteNumber": "5811", "forwardStandardProductCode": "", "productCode": "25", "productName": "Leaded and Lead Replacement", "siteCode": 31933, "hostingCollectingCompanyName": "", "hostingCollectingCompanyNumber": "41", "iccdataTranType": "", "transactionType": "Purchase advice", "colCoCode": "41", "latitudeNo": "40.84925", "payerNumber": "TR00540687", "longitudeNo": "31.05395", "merchantCategory": "5541", "merchantCategoryDescription": "", "purchasedInCountry": "Turkey", "merchantId": "TR5811000000000", "siteName": "DÜZCE GIRISI.", "network": "0000000792", "delCoCode": "041", "odometerInput": "0", "odometerReadingKm": "0", "odometerReadingMiles": "0.0", "cardPAN": "708326****878995", "pinUsedIndicator": "N", "poiReceiptNumber": "", "productsCodeAdditional": "", "productsTaxCode": "f", "volume": "56.45", "sfgwCardDateOfExpiry": "2029-01", "transactionCurrencyCode": "TRY", "sourceCardId": "059347", "transactionDate": "2023-01-31", "transactionDateTime": "2023-01-31 09:55:53.000", "transactionId": "1271493159", "transactionStatus": "APPROVED", "unitOfMeasure": "L", "vehicleRegistrationNumber": "35AVE240", "declinedReason": "", "networkDeliveryCompanyName": "Shell and Turcas Petrol A.S.", "productGroupLevel3": "Motor gasoline", "productGroupLevel2": "All Fuels", "accountCustomerName": "TO PET P.U.D.VE P.S.T.A.S.", "legalEntityCustomerName": "TO PET PET.UR.DAG. VE PAZ. SAN", "transactionTime": "09:55:53", "transactionCurrencySymbol": "₺", "unitPrice": "23.66", "authorisedFlag": "Y", "transactionTimeGMT": "06:55:53", "reasonCode": "00", "issuerActionCode": "", "issuerActionCodeDescription": "", "reasonDescription": "Approved or completed successfully", "transactionCountry": "", "issuingCollectingCompanyName": "", "cardIssuerName": "EVIAS-Turkey", "CardDriverNm": "", "BearerDesc": "", "CardCategoryDesc": "", "CardTypeDesc": "", "TokenTypeDesc": "", "EmbossType": "" }

      ,

      { "accountNumber": "TR00540687", "cardIssueNumber": "1", "collectingCompanyCurrencyISOCode": "TRY", "custDataCustomerEntered": "", "custDataDriverId": "1", "custDataFleetDescription": "", "fleetIdInput": "", "amount": "423.83", "euroshellSiteNumber": "6227", "forwardStandardProductCode": "", "productCode": "25", "productName": "Leaded and Lead Replacement", "siteCode": 64816, "hostingCollectingCompanyName": "", "hostingCollectingCompanyNumber": "41", "iccdataTranType": "", "transactionType": "Purchase advice", "colCoCode": "41", "latitudeNo": "41.00790", "payerNumber": "TR00540687", "longitudeNo": "29.18070", "merchantCategory": "5541", "merchantCategoryDescription": "", "purchasedInCountry": "Turkey", "merchantId": "TR6227000000000", "siteName": "SARIGAZI BARAJYOLU", "network": "0000000792", "delCoCode": "041", "odometerInput": "0", "odometerReadingKm": "0", "odometerReadingMiles": "0.0", "cardPAN": "708326****878706", "pinUsedIndicator": "N", "poiReceiptNumber": "", "productsCodeAdditional": "", "productsTaxCode": "f", "volume": "18.12", "sfgwCardDateOfExpiry": "2040-01", "transactionCurrencyCode": "TRY", "sourceCardId": "705179", "transactionDate": "2023-01-31", "transactionDateTime": "2023-01-31 09:18:39.000", "transactionId": "1271447860", "transactionStatus": "APPROVED", "unitOfMeasure": "L", "vehicleRegistrationNumber": "35ATM358", "declinedReason": "", "networkDeliveryCompanyName": "Shell and Turcas Petrol A.S.", "productGroupLevel3": "Motor gasoline", "productGroupLevel2": "All Fuels", "accountCustomerName": "TO PET P.U.D.VE P.S.T.A.S.", "legalEntityCustomerName": "TO PET PET.UR.DAG. VE PAZ. SAN", "transactionTime": "09:18:39", "transactionCurrencySymbol": "₺", "unitPrice": "23.39", "authorisedFlag": "Y", "transactionTimeGMT": "06:18:39", "reasonCode": "00", "issuerActionCode": "", "issuerActionCodeDescription": "", "reasonDescription": "Approved or completed successfully", "transactionCountry": "", "issuingCollectingCompanyName": "", "cardIssuerName": "EVIAS-Turkey", "CardDriverNm": "", "BearerDesc": "", "CardCategoryDesc": "", "CardTypeDesc": "", "TokenTypeDesc": "", "EmbossType": "" }

      ,

      "vehicleRegistrationNumber": "35AUB328",

      "declinedReason": "",

      "networkDeliveryCompanyName": "Shell and Turcas Petrol A.S.",

      "productGroupLevel3": "Motor gasoline",

        Attachments

          Activity

            People

            Assignee:
            bedir Bedir Bayar
            Reporter:
            Seher Seher Bayar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: