Posts

Showing posts from February, 2026

newxml

This XML file does not appear to have any style information associated with it. The document tree is shown below. 2026008-COM-20034-COM 2026008-COM-20034-COM 88001 2026008 09/26/2025 20034 300000472449727 08/02/2025 01/30/2026 SEPFY26_NA_US_REGULAR_COM_20034 DELl_NA_US_20034_PAYGROUP 83.3190 USD 300000718852909 178.5714 59.5179 23.8012 N 83.319 1 2HFY26 Final Payout ACQ & Non-ACQ (IC_SA) A US Enterprise: AE & ISR ACQ (IC_SA)-ISR 23.8012 83.319 83.319 2142.8572 0.0111 COMMISSION Y 59.5179 MAV_DIR_BB_ACTION_1000 MVA_DIR_BB_REASON_1018 Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country. 300000777907847 300002668033938 Jana Wynelle Frank 2026008--75976-ALL 2026008--75976-ALL 26004 2026008 09/26/2025 75976 300000472435126 75976 -1 75976 0.0000 JPY 0.0000 0 .8153 N 0 0.007 A JP 116.9880 116.988 .8...

ealier it iwas working fine.1

SELECT rules.RecordName AS "RecordName", rules.RecordNumber AS "RecordNumber", rules.PaysheetId_c AS "PaysheetId_c", rules.PayPeriodID_c AS "PayPeriodID_c", rules.PayDate_c AS "PayDate_c", rules.BadgeIDWorkerNumber_c AS "BadgeIDWorkerNumber_c", rules.ParticipantId_c AS "ParticipantId_c", rules.RoleStartDate_c AS "RoleStartDate_c", rules.RoleEndDate_c AS "RoleEndDate_c", rules.PaymentBatch_c AS "PaymentBatch_c", rules.PayGroup_c AS "PayGroup_c", NVL(TO_CHAR(rules.TotalPaysheetAmount_c, 'FM9999999990.0000'), '0') AS "TotalPaysheetAmount_c", rules.CurrencyCode AS "CurrencyCode", rules.PlanComponentId_c AS "PlanComponentId_c", NVL(TO_CHAR(rules.ProratedTI_c, 'FM9999999990.0000'), '0') AS "ProratedTI_c", TO_CHAR(rules.PTDUSD_c) AS "PTDU...

XML-2

2026008-COM-20034-COM 2026008-COM-20034-COM 88001 2026008 09/26/2025 20034 300000472449727 08/02/2025 01/30/2026 SEPFY26_NA_US_REGULAR_COM_20034 DELl_NA_US_20034_PAYGROUP 83.3190 USD 300000718852909 178.5714 59.5179 23.8012 N 83.319 1 2HFY26 Final Payout ACQ & Non-ACQ (IC_SA) A US Enterprise: AE & ISR ACQ (IC_SA)-ISR 23.8012 83.319 83.319 2142.8572 0.0111 COMMISSION Y 59.5179 MAV_DIR_BB_ACTION_1000 MVA_DIR_BB_REASON_1018 Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country. 300000777907847 300002668033938 Jana Wynelle Frank 2026008--75976-ALL 2026008--75976-ALL 26004 2026008 09/26/2025 75976 300000472435126 75976 -1 75976 0.0000 JPY 0.0000 0 .8153 N 0 0.007 A JP 116.9880 116.988 .8153 0.0000 0 ALL Y 0.0000 MAV_DIR_MPA_CODE_1008 Auto approved Y 300001270618276 Yuzo Kikuchi 1309158 2026008-SEP-128484-COM 2026008-SEP-128484-COM 142001 2026008 09/26/2...

xml

This XML file does not appear to have any style information associated with it. The document tree is shown below. 2026008-COM-20034-COM 2026008-COM-20034-COM 88001 2026008 09/26/2025 20034 300000472449727 08/02/2025 01/30/2026 SEPFY26_NA_US_REGULAR_COM_20034 DELl_NA_US_20034_PAYGROUP 83.3190 USD 300000718852909 178.5714 59.5179 23.8012 N 83.319 1 2HFY26 Final Payout ACQ & Non-ACQ (IC_SA) A US Enterprise: AE & ISR ACQ (IC_SA)-ISR 23.8012 83.319 83.319 2142.8572 0.0111 COMMISSION Y 59.5179 MAV_DIR_BB_ACTION_1000 MVA_DIR_BB_REASON_1018 Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country. 300000777907847 300002668033938 Jana Wynelle Frank 2026008--75976-ALL 2026008--75976-ALL 26004 2026008 09/26/2025 75976 300000472435126 75976 -1 75976 0.0000 JPY 0.0000 0 .8153 N 0 0.007 A JP 116.9880 ...

final_query

SELECT rules.RecordName, rules.RecordNumber, rules.PaysheetId_c, rules.PayPeriodID_c, rules.PayDate_c, rules.BadgeIDWorkerNumber_c, rules.ParticipantId_c, rules.RoleStartDate_c, rules.RoleEndDate_c, rules.PaymentBatch_c, rules.PayGroup_c, NVL(TO_CHAR(rules.TotalPaysheetAmount_c, 'FM9999999990.0000'), '0') AS TotalPaysheetAmount_c, rules.CurrencyCode, rules.PlanComponentId_c, NVL(TO_CHAR(rules.ProratedTI_c, 'FM9999999990.0000'), '0') AS ProratedTI_c, TO_CHAR(rules.PTDUSD_c) AS PTDUSD_c, TO_CHAR(rules.BBUSD_c) AS BBUSD_c, rules.MultiCurrency_c, rules.PaysheetAutomatedRefreshStartCST_c, rules.PaysheetAutomatedRefreshEndCST_c, TO_CHAR(rules.TotalPaysheetAmountUSD_c) AS TotalPaysheetAmountUSD_c, rules.ConversionRateHomeToUSD_c, rules.PlanComponentName_c, rules.OwnerEmailId_c, rules.HRStatus_c, rules.EmploymentCountry_c, rules.RoleName_c, NVL(TO_CHAR(ru...