[$250] Add Withdrawal ID to Custom Columns in Expenses Search

[heyjennahay]

Problem:

On the Expensify Card reconciliation report, you can use Withdrawal ID in both the filters and columns.

However, in the Expenses reports we only allow you to filter but not set it as a column.

Since this is important information for an accountant to export, we should allow them to display it.

Solution

Add Withdrawal ID to columns for the Expenses search

Withdrawal ID in filters

Withdrawal ID missing in columns

Issue Owner

Current Issue Owner: @samranahm

Upwork Automation - Do Not Edit

• Upwork Job URL: https://www.upwork.com/jobs/~022046551965114245077
• Upwork Job ID: 2046551965114245077
• Last Price Increase: 2026-04-21
• Automatic offers:
• samranahm | Contributor | 111271316

[JS00001]

Let's get a FE contributor on this one

[melvin-bot]

Triggered auto assignment to Contributor-plus team member for initial proposal review - @dmkt9 (External)

[melvin-bot]

Job added to Upwork: https://www.upwork.com/jobs/~022046551965114245077

[KJ21-ENG]

🚨 Edited by proposal-police: This proposal was edited at 2026-04-21 11:59:08 UTC.

Replaces my earlier proposal. The prior version framed this as a pure config gap and initially excluded sort as out-of-scope. After empirically verifying the fix on branch kj/88384-add-withdrawal-id-column (commit ced97cdba909) and per @JS00001's guidance that click-to-sort on Withdrawal ID is required, the real fix touches five places: column allowlist, per-row cell renderer, Transaction type field, visibility gate in SearchUIUtils, and client-side sort wiring. The updated body below reflects that.

Proposal

Please re-state the problem that we are trying to solve in this issue.

In the Expenses search, "Withdrawal ID" is available as a filter but cannot be added as a column. The Expensify Card reconciliation report offers it as both, and accountants need column-level parity — display and sort — in Expenses exports to reconcile card withdrawals without switching views.

What is the root cause of that problem?

Five independent gaps keep Withdrawal ID off the Expenses column picker, unrendered in rows, silently dropped by a visibility gate, and un-sortable even when selected.

Defect 1 — not in the EXPENSE column allowlist. CONST.SEARCH.TYPE_CUSTOM_COLUMNS.EXPENSE in src/CONST/index.ts (~L7591–7623) omits WITHDRAWAL_ID, so SearchColumnsPage never offers the toggle for Expenses.

Defect 2 — no row cell renderer. SearchTableHeader.tsx L121–124 registers the header, but the switch in src/components/TransactionItemRow/index.tsx (~L282) has no case WITHDRAWAL_ID, so enabling the column yields a header with empty body cells.

Defect 3 — withdrawalID is not on Transaction. In src/types/onyx/Transaction.ts, per-transaction withdrawalID doesn't exist — it lives only on SearchWithdrawalIDGroup for the grouped "withdrawal-id" view. Ungrouped Expenses responses don't carry it, so nothing is client-derivable.

Defect 4 — visibility gate in SearchUIUtils.getColumnsToShow filters it out. src/libs/SearchUIUtils.ts (~L5200 and L5411) keeps a ColumnVisibility map and a nonDataColumns set; the final customResult.filter((col) => nonDataColumns.has(col) || columns[col]) drops any column absent from both. WITHDRAWAL_ID is in neither, so even after a successful Save the header never mounts. Additionally, getSearchColumnTranslationKey has no case for it — the picker label would fall through to common.expenses.

Defect 5 — no sort wiring. transactionColumnNamesToSortingProperty in src/libs/SearchUIUtils.ts (~L257–L277) and sortableColumnNames / getTransactionSortValue in src/libs/ReportUtils.ts (~L13407–L13467) both omit WITHDRAWAL_ID. nonSortableColumns doesn't contain it, so the header would be clickable, but getSortByOptions would produce no sorting property and MoneyRequestReportTransactionList sort would no-op. Since the issue is framed as parity with the reconciliation report — which supports sort — this needs to be in scope.

Empirical confirmation of Defect 4: post-save URL was sortBy:tag sortOrder:desc type:expense columns:receipt,date,status,merchant,from,category,tag,amount,withdrawalID — the column was serialised correctly, yet Defect 4 stripped it at render time.

App/src/CONST/index.ts

Lines 7591 to 7623 in b31fcf6

	get TYPE_CUSTOM_COLUMNS() {
	return {
	EXPENSE: {
	RECEIPT: this.TABLE_COLUMNS.RECEIPT,
	DATE: this.TABLE_COLUMNS.DATE,
	STATUS: this.TABLE_COLUMNS.STATUS,
	SUBMITTED: this.TABLE_COLUMNS.SUBMITTED,
	APPROVED: this.TABLE_COLUMNS.APPROVED,
	POSTED: this.TABLE_COLUMNS.POSTED,
	EXPORTED: this.TABLE_COLUMNS.EXPORTED,
	MERCHANT: this.TABLE_COLUMNS.MERCHANT,
	DESCRIPTION: this.TABLE_COLUMNS.DESCRIPTION,
	FROM: this.TABLE_COLUMNS.FROM,
	TO: this.TABLE_COLUMNS.TO,
	POLICY_NAME: this.TABLE_COLUMNS.POLICY_NAME,
	CARD: this.TABLE_COLUMNS.CARD,
	CATEGORY: this.TABLE_COLUMNS.CATEGORY,
	ATTENDEES: this.TABLE_COLUMNS.ATTENDEES,
	TOTAL_PER_ATTENDEE: this.TABLE_COLUMNS.TOTAL_PER_ATTENDEE,
	TAG: this.TABLE_COLUMNS.TAG,
	EXCHANGE_RATE: this.TABLE_COLUMNS.EXCHANGE_RATE,
	ORIGINAL_AMOUNT: this.TABLE_COLUMNS.ORIGINAL_AMOUNT,
	REPORT_ID: this.TABLE_COLUMNS.REPORT_ID,
	BASE_62_REPORT_ID: this.TABLE_COLUMNS.BASE_62_REPORT_ID,
	REIMBURSABLE: this.TABLE_COLUMNS.REIMBURSABLE,
	BILLABLE: this.TABLE_COLUMNS.BILLABLE,
	TAX_RATE: this.TABLE_COLUMNS.TAX_RATE,
	TAX_AMOUNT: this.TABLE_COLUMNS.TAX_AMOUNT,
	TITLE: this.TABLE_COLUMNS.TITLE,
	AMOUNT: this.TABLE_COLUMNS.TOTAL_AMOUNT,
	EXPORTED_TO: this.TABLE_COLUMNS.EXPORTED_TO,
	ACTION: this.TABLE_COLUMNS.ACTION,
	},

App/src/components/TransactionItemRow/index.tsx

Lines 282 to 294 in b31fcf6

	case CONST.SEARCH.TABLE_COLUMNS.TYPE:
	return (
	<View
	key={column}
	style={[StyleUtils.getReportTableColumnStyles(CONST.SEARCH.TABLE_COLUMNS.TYPE)]}
	>
	<TypeCell
	transactionItem={transactionItem}
	shouldShowTooltip={shouldShowTooltip}
	shouldUseNarrowLayout={shouldUseNarrowLayout}
	/>
	</View>
	);

App/src/libs/SearchUIUtils.ts

Lines 5181 to 5431 in b31fcf6

	[CONST.SEARCH.TABLE_COLUMNS.RECEIPT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.TYPE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.DATE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.MERCHANT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.DESCRIPTION]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CATEGORY]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAG]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CARD]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE]: shouldShowReimbursableColumn,
	[CONST.SEARCH.TABLE_COLUMNS.BILLABLE]: shouldShowBillableColumn,
	[CONST.SEARCH.TABLE_COLUMNS.COMMENTS]: true,
	[CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT]: true,
	}
	: {
	[CONST.SEARCH.TABLE_COLUMNS.AVATAR]: true,
	[CONST.SEARCH.TABLE_COLUMNS.RECEIPT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.TYPE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.DATE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.STATUS]: true,
	[CONST.SEARCH.TABLE_COLUMNS.POSTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXPORTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.SUBMITTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.APPROVED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.MERCHANT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.DESCRIPTION]: false,
	[CONST.SEARCH.TABLE_COLUMNS.FROM]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TO]: false,
	[CONST.SEARCH.TABLE_COLUMNS.POLICY_NAME]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CARD]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CATEGORY]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAG]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.BILLABLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.BASE_62_REPORT_ID]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REPORT_ID]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TITLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXPORTED_TO]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.ACTION]: false,
	[CONST.SEARCH.TABLE_COLUMNS.COMMENTS]: false,
	};
	// If the user has set custom columns for the search, we need to respect their preference and order
	const allowedColumns: string[] = isExpenseReportView ? Object.values(CONST.SEARCH.REPORT_DETAILS_CUSTOM_COLUMNS) : Object.values(CONST.SEARCH.TYPE_CUSTOM_COLUMNS.EXPENSE);
	const filteredVisibleColumns = visibleColumns.filter((column) => allowedColumns.includes(column));
	let customResult: SearchColumnType[] | undefined;
	if (!arraysEqual(Object.values(CONST.SEARCH.TYPE_DEFAULT_COLUMNS.EXPENSE), filteredVisibleColumns) && filteredVisibleColumns.length > 0) {
	const result: SearchColumnType[] = [];
	const addedColumns = new Set<SearchColumnType>();
	if (isExpenseReportView) {
	// If RECEIPT is first, TYPE goes second; otherwise TYPE goes first
	for (const col of filteredVisibleColumns) {
	result.push(col);
	addedColumns.add(col);
	}
	if (!addedColumns.has(CONST.SEARCH.TABLE_COLUMNS.TYPE)) {
	const isReceiptFirst = result.at(0) === CONST.SEARCH.TABLE_COLUMNS.RECEIPT;
	if (isReceiptFirst) {
	result.splice(1, 0, CONST.SEARCH.TABLE_COLUMNS.TYPE);
	} else {
	result.unshift(CONST.SEARCH.TABLE_COLUMNS.TYPE);
	}
	}
	if (!addedColumns.has(CONST.SEARCH.TABLE_COLUMNS.COMMENTS)) {
	result.push(CONST.SEARCH.TABLE_COLUMNS.COMMENTS);
	}
	// Don't return early — fall through to updateColumns to detect empty columns
	customResult = result;
	} else {
	// Search page: prepend AVATAR, TYPE
	result.push(CONST.SEARCH.TABLE_COLUMNS.AVATAR);
	addedColumns.add(CONST.SEARCH.TABLE_COLUMNS.AVATAR);
	result.push(CONST.SEARCH.TABLE_COLUMNS.TYPE);
	addedColumns.add(CONST.SEARCH.TABLE_COLUMNS.TYPE);
	// Add remaining visible columns that weren't already added
	for (const col of filteredVisibleColumns) {
	if (!addedColumns.has(col)) {
	result.push(col);
	}
	}
	// Don't return early — fall through to updateColumns to detect empty columns
	customResult = result;
	}
	}
	const {moneyRequestReportActionsByTransactionID} = Array.isArray(data) ? {} : createReportActionsLookupMaps(data);
	const updateColumns = (transaction: OnyxTypes.Transaction) => {
	const merchant = transaction.modifiedMerchant ? transaction.modifiedMerchant : (transaction.merchant ?? '');
	if (!isInvalidMerchantValue(merchant) || isScanning(transaction)) {
	columns[CONST.SEARCH.TABLE_COLUMNS.MERCHANT] = true;
	}
	if (getDescription(transaction) !== '') {
	columns[CONST.SEARCH.TABLE_COLUMNS.DESCRIPTION] = true;
	}
	const hasCategory = (() => {
	const category = getCategory(transaction);
	return category !== '' && category !== CONST.SEARCH.CATEGORY_EMPTY_VALUE;
	})();
	const hasTag = (() => {
	const tag = getTag(transaction);
	return tag !== '' && tag !== CONST.SEARCH.TAG_EMPTY_VALUE;
	})();
	// Category/tag: set for all paths (default search, custom search, report view).
	// Will be refined later for search page non-IOU check.
	if (hasCategory) {
	columns[CONST.SEARCH.TABLE_COLUMNS.CATEGORY] = !isExpenseReportViewFromIOUReport;
	}
	if (hasTag) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TAG] = !isExpenseReportViewFromIOUReport;
	}
	// Data-presence checks for columns that are hidden when empty.
	// Only update when we have custom columns to filter (customResult) or in expense report view,
	// so that the default search page path doesn't show extra columns.
	if (customResult || isExpenseReportView) {
	if (transaction.cardName && transaction.cardName !== CONST.EXPENSE.TYPE.CASH_CARD_NAME) {
	columns[CONST.SEARCH.TABLE_COLUMNS.CARD] = true;
	}
	if (transaction.taxCode) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TAX_RATE] = true;
	}
	if (transaction.taxAmount) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT] = true;
	}
	const hasExchangeRate = getExchangeRate(transaction, reportCurrency) !== '';
	if (hasExchangeRate || transaction.originalAmount) {
	columns[CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT] = true;
	columns[CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE] = true;
	}
	if (!Array.isArray(data)) {
	const report = data[`${ONYXKEYS.COLLECTION.REPORT}${transaction.reportID}`];
	if (report?.submitted) {
	columns[CONST.SEARCH.TABLE_COLUMNS.SUBMITTED] = true;
	}
	if (report?.policyID) {
	columns[CONST.SEARCH.TABLE_COLUMNS.POLICY_NAME] = true;
	}
	const reportAction = moneyRequestReportActionsByTransactionID?.get(transaction.transactionID);
	const toFieldValue = getToFieldValueForTransaction(transaction, report, data.personalDetailsList, reportAction);
	if (toFieldValue.accountID) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TO] = true;
	}
	}
	}
	if (isExpenseReportView) {
	if (hasCategory) {
	columns[CONST.SEARCH.TABLE_COLUMNS.CATEGORY] = !isExpenseReportViewFromIOUReport;
	}
	if (hasTag) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TAG] = !isExpenseReportViewFromIOUReport;
	}
	return;
	}
	// The From/To columns display logic depends on the passed report/reportAction i.e. if data is SearchResults and not an array (Transaction[])
	if (!Array.isArray(data)) {
	const report = data[`${ONYXKEYS.COLLECTION.REPORT}${transaction.reportID}`];
	const reportAction = moneyRequestReportActionsByTransactionID?.get(transaction.transactionID);
	// Handle From&To columns that are only shown in the Reports page
	// if From or To differ from current user in any transaction, show the columns
	const accountID = reportAction?.actorAccountID;
	if (accountID && accountID !== currentAccountID) {
	columns[CONST.SEARCH.TABLE_COLUMNS.FROM] = true;
	}
	// Show category/tag if any non-IOU transaction has them.
	// Only set to true, never reset — so a previous non-IOU match is preserved.
	if (hasCategory && !isIOUReportReportUtil(report)) {
	columns[CONST.SEARCH.TABLE_COLUMNS.CATEGORY] = true;
	}
	if (hasTag && !isIOUReportReportUtil(report)) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TAG] = true;
	}
	// eslint-disable-next-line @typescript-eslint/no-deprecated
	const toFieldValue = getToFieldValueForTransaction(transaction, report, data.personalDetailsList, reportAction);
	if (!shouldUseStrictDefaultExpenseColumns && toFieldValue.accountID && toFieldValue.accountID !== currentAccountID && !columns[CONST.SEARCH.TABLE_COLUMNS.TO]) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TO] = !!report && !isOpenReport(report);
	}
	}
	};
	if (Array.isArray(data)) {
	for (const item of data) {
	updateColumns(item);
	}
	} else {
	for (const key of Object.keys(data)) {
	if (!isTransactionEntry(key)) {
	continue;
	}
	updateColumns(data[key]);
	}
	}
	if (customResult) {
	// Columns that always have content and don't need data-presence checks.
	// These are false in the default columns map (so they don't appear by default)
	// but should be kept when explicitly selected by the user in custom columns.
	const nonDataColumns = new Set<SearchColumnType>([
	CONST.SEARCH.TABLE_COLUMNS.AVATAR,
	CONST.SEARCH.TABLE_COLUMNS.RECEIPT,
	CONST.SEARCH.TABLE_COLUMNS.TYPE,
	CONST.SEARCH.TABLE_COLUMNS.DATE,
	CONST.SEARCH.TABLE_COLUMNS.STATUS,
	CONST.SEARCH.TABLE_COLUMNS.COMMENTS,
	CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT,
	CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE,
	CONST.SEARCH.TABLE_COLUMNS.BILLABLE,
	CONST.SEARCH.TABLE_COLUMNS.BASE_62_REPORT_ID,
	CONST.SEARCH.TABLE_COLUMNS.REPORT_ID,
	CONST.SEARCH.TABLE_COLUMNS.TITLE,
	CONST.SEARCH.TABLE_COLUMNS.ACTION,
	CONST.SEARCH.TABLE_COLUMNS.ATTENDEES,
	CONST.SEARCH.TABLE_COLUMNS.TOTAL_PER_ATTENDEE,
	]);
	return customResult.filter((col) => nonDataColumns.has(col) || columns[col]);
	}
	return (Object.keys(columns) as SearchColumnType[]).filter((col) => columns[col]);
	}

App/src/libs/ReportUtils.ts

Lines 13407 to 13467 in b31fcf6

	CONST.SEARCH.TABLE_COLUMNS.CATEGORY,
	CONST.SEARCH.TABLE_COLUMNS.TAG,
	CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT,
	CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE,
	CONST.SEARCH.TABLE_COLUMNS.BILLABLE,
	CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE,
	CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT,
	CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT,
	CONST.SEARCH.TABLE_COLUMNS.TAX_RATE,
	CONST.SEARCH.TABLE_COLUMNS.CARD,
	] as const;
	type SortableColumnName = TupleToUnion<typeof sortableColumnNames>;
	/**
	* Type guard to check if a column name is sortable
	*/
	function isSortableColumnName(key: unknown): key is SortableColumnName {
	return !!sortableColumnNames.find((val) => val === key);
	}
	/**
	* Get the sortable value for a transaction based on the column type.
	* Used for sorting transactions in MoneyRequestReportTransactionList.
	*/
	function getTransactionSortValue(transaction: Transaction, key: SortableColumnName, report: Report, policy: OnyxEntry<Policy>): string | number {
	switch (key) {
	case CONST.SEARCH.TABLE_COLUMNS.DATE:
	return getTransactionCreated(transaction);
	case CONST.SEARCH.TABLE_COLUMNS.MERCHANT:
	return getMerchant(transaction);
	case CONST.SEARCH.TABLE_COLUMNS.CATEGORY:
	return getCategory(transaction);
	case CONST.SEARCH.TABLE_COLUMNS.TAG:
	return getTag(transaction);
	case CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT:
	return getTransactionAmount(transaction, isExpenseReport(report), transaction.reportID === CONST.REPORT.UNREPORTED_REPORT_ID);
	case CONST.SEARCH.TABLE_COLUMNS.DESCRIPTION:
	return Parser.htmlToText(transaction.comment?.comment ?? '');
	case CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE:
	return getReimbursable(transaction) ? 1 : 0;
	case CONST.SEARCH.TABLE_COLUMNS.BILLABLE:
	return transaction.billable ? 1 : 0;
	case CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE:
	return getExchangeRate(transaction, report?.currency);
	case CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT:
	return getOriginalAmountForDisplay(transaction, isExpenseReport(report));
	case CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT:
	return getTaxAmount(transaction, isExpenseReport(report));
	case CONST.SEARCH.TABLE_COLUMNS.TAX_RATE:
	return getTaxName(policy, transaction) ?? '';
	case CONST.SEARCH.TABLE_COLUMNS.CARD:
	return transaction.cardID ?? CONST.DEFAULT_NUMBER_ID;
	default:
	return '';
	}
	}
	function getLinkedIOUTransaction(reportAction: OnyxEntry<ReportAction | OptimisticIOUReportAction>, transactions: Transaction[]): OnyxEntry<Transaction> {
	const transactionID = isMoneyRequestAction(reportAction) ? getOriginalMessage(reportAction)?.IOUTransactionID : undefined;
	return transactionID ? transactions.find((item) => item.transactionID === transactionID) : undefined;

What changes do you think we should make in order to solve the problem?

1. src/CONST/index.ts → add WITHDRAWAL_ID: this.TABLE_COLUMNS.WITHDRAWAL_ID to TYPE_CUSTOM_COLUMNS.EXPENSE. Leave TYPE_DEFAULT_COLUMNS.EXPENSE unchanged (opt-in, matching reconciliation-report UX).
2. src/components/TransactionItemRow/index.tsx → add a case CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID arm rendering TextCell with transaction.withdrawalID ?? '', wrapped in StyleUtils.getReportTableColumnStyles(CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID) (same style key as WithdrawalIDListItemHeader.tsx L139–140).
3. src/types/onyx/Transaction.ts → add optional withdrawalID?: string on Transaction. Backend: populate it on each transaction in the Expenses Search response (it already exists on the grouped payload) — flag to the backend owner as a separate task if needed.
4. src/libs/SearchUIUtils.ts → (a) add [WITHDRAWAL_ID]: false to the ColumnVisibility map in getColumnsToShow; (b) add WITHDRAWAL_ID to nonDataColumns so it renders whenever selected (matching REPORT_ID, BASE_62_REPORT_ID, TITLE); (c) add a case WITHDRAWAL_ID: return 'common.withdrawalID'; in getSearchColumnTranslationKey; (d) add [WITHDRAWAL_ID]: 'withdrawalID' to transactionColumnNamesToSortingProperty so header sort dispatches correctly.
5. src/libs/ReportUtils.ts → add WITHDRAWAL_ID to sortableColumnNames and add a case WITHDRAWAL_ID: return transaction.withdrawalID ?? ''; arm in getTransactionSortValue so client-side sort in MoneyRequestReportTransactionList produces a stable string comparison. nonSortableColumns already doesn't include WITHDRAWAL_ID, so the header stays clickable.

Scope boundaries.

• Files: src/CONST/index.ts, src/components/TransactionItemRow/index.tsx, src/types/onyx/Transaction.ts, src/libs/SearchUIUtils.ts, src/libs/ReportUtils.ts. Backend must also emit withdrawalID per transaction.
• All platforms via shared Search components.
• Not touched: SearchTableHeader.tsx (header exists and is already sortable by default), grouped withdrawal-id view, reconciliation-report path, filter pipeline, TYPE_DEFAULT_COLUMNS. No API contract change beyond the additive field; client is null-safe.
• Verified on kj/88384-add-withdrawal-id-column at ced97cdba909 — Columns sheet → tick Withdrawal ID → Save → column header + empty cells render + header click toggles sort order. Populates once backend ships.

What alternative solutions did you explore? (Optional)

• Derive withdrawalID client-side from cached SearchWithdrawalIDGroup. Rejected: ungrouped responses omit the grouped payload, so it's not derivable without an extra round-trip.
• Default the column on. Rejected: the reconciliation report keeps it opt-in; defaulting on would unexpectedly widen every user's table.
• Reuse GROUP_WITHDRAWAL_ID. Rejected: it's bound to TransactionWithdrawalIDGroupListItemType (grouped rows) and doesn't fit per-transaction Expenses rows.
• Leave sort out of scope. Initially proposed; rejected after @JS00001 feedback — column-level parity with the reconciliation report includes sort, and the wiring is client-side via sortableColumnNames (no backend dependency).

[neerajbachani]

🚨 Edited by proposal-police: This proposal was edited at 2026-04-21 11:40:05 UTC.

Proposal

What is the root cause of that problem?

Four gaps block Withdrawal ID from working as a flat Expenses search column:

1. TYPE_CUSTOM_COLUMNS.EXPENSE in src/CONST/index.ts omits WITHDRAWAL_ID — so the column picker never shows it as a toggleable option for Expenses search.

2. getColumnsToShow() in src/libs/SearchUIUtils.ts has no entry for WITHDRAWAL_ID in the flat ColumnVisibility map or nonDataColumns set — so even if forced into the URL query, it gets stripped at render time.

3. getSearchColumnTranslationKey() and transactionColumnNamesToSortingProperty in SearchUIUtils.ts have no WITHDRAWAL_ID entries — breaking the picker label and sort dispatch.

4. The renderColumn switch in src/components/TransactionItemRow/index.tsx has no WITHDRAWAL_ID case — so selected rows render empty cells.

What changes do you think we should make in order to solve the problem?

src/CONST/index.ts — add to TYPE_CUSTOM_COLUMNS.EXPENSE alongside other optional metadata columns like CARD:

WITHDRAWAL_ID: this.TABLE_COLUMNS.WITHDRAWAL_ID,

---

src/libs/SearchUIUtils.ts — three additions:

Add to transactionColumnNamesToSortingProperty:

[CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID]: 'withdrawalID',

Add case in getSearchColumnTranslationKey:

case CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID:
    return 'common.withdrawalID';

In getColumnsToShow(), add to flat ColumnVisibility map with default false:

[CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID]: false,

Add to nonDataColumns set:

CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID,

No updateColumns check for transaction.withdrawalID is needed. nonDataColumns is the correct mechanism here — it guarantees the column stays visible whenever explicitly selected, even when all rows have empty values. Adding a data-presence gate in updateColumns would be contradictory: it would hide the column when no transactions carry a withdrawalID yet, violating JS00001's confirmed requirement: "if the column is selected in columns, yes we should show it." nonDataColumns = always show when selected; updateColumns = show only when data exists. For Withdrawal ID, the former is correct.

---

src/components/TransactionItemRow/index.tsx — add to renderColumn switch, modeled on the CARD case:

case CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID:
    return (
        <View
            key={column}
            style={[StyleUtils.getReportTableColumnStyles(CONST.SEARCH.TABLE_COLUMNS.WITHDRAWAL_ID)]}
        >
            <TextCell text={transactionItem.withdrawalID ?? ''} />
        </View>
    );

---

src/types/onyx/Transaction.ts — add optional field near card/payment metadata:

withdrawalID?: string;

---

Sort: transactionColumnNamesToSortingProperty in SearchUIUtils.ts is sufficient for Expenses search sort. ReportUtils.ts sort helpers serve the Money Request Report view, not the Search page — no changes needed there.

Backend dependency: JS00001 is handling the BE PR to emit withdrawalID per transaction on the flat Expenses search payload. Frontend is null-safe — until BE lands, the column header stays visible via nonDataColumns and cells render empty string gracefully.

Files changed: src/CONST/index.ts, src/libs/SearchUIUtils.ts, src/components/TransactionItemRow/index.tsx, src/types/onyx/Transaction.ts

No changes to SearchTableHeader.tsx (header entry already exists), ReportUtils.ts, filter pipeline, or grouped reconciliation path.

What alternative solutions did you explore? (Optional)

• Adding WITHDRAWAL_ID to updateColumns data-presence gate instead of nonDataColumns: Rejected — this would hide the column whenever rows have no withdrawal ID yet, breaking the confirmed requirement that selected columns must always remain visible.
• Deriving withdrawalID client-side from SearchWithdrawalIDGroup: Rejected — ungrouped Expenses responses don't carry the grouped payload, so derivation would require an extra round-trip.
• Adding sort via ReportUtils.ts sortableColumnNames: Not needed — that path serves Money Request Report view. Sort for Expenses search is fully covered by transactionColumnNamesToSortingProperty in SearchUIUtils.ts.

[github-actions]

⚠️ @neerajbachani Your proposal is a duplicate of an already existing proposal and has been automatically withdrawn to prevent spam. Please review the existing proposals before submitting a new one.