-
Type: Bug
-
Status: Done
-
Priority: High
-
Resolution: Done
-
Labels:
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",