Variable transactionDerivedColumnDdl`Const`

transactionDerivedColumnDdl: {
    accountRef: (c: TransactionColumnRef) => string;
    cardLabel: (c: TransactionColumnRef) => string;
    impliedRate: (c: TransactionColumnRef) => string;
    methodColumnLabel: (c: TransactionColumnRef) => string;
    organizationId: (c: TransactionColumnRef) => string;
    outcome: (c: TransactionColumnRef) => string;
    personId: (c: TransactionColumnRef) => string;
    railFamily: (c: TransactionColumnRef) => string;
    rewardKind: (c: TransactionColumnRef) => string;
    signedAmount: (c: TransactionColumnRef) => string;
} = ...

The derived columns as literal SQL. One fragment per column, so every arm and the b2b.transaction generated columns share an expression; the migration pastes the output, as it does transactionSearchTextDdl's.

Type Declaration

ReadonlyaccountRef: (c: TransactionColumnRef) => string
ReadonlycardLabel: (c: TransactionColumnRef) => string

Card arm only; every other arm projects NULL.
ReadonlyimpliedRate: (c: TransactionColumnRef) => string
ReadonlymethodColumnLabel: (c: TransactionColumnRef) => string
ReadonlyorganizationId: (c: TransactionColumnRef) => string
Readonlyoutcome: (c: TransactionColumnRef) => string
ReadonlypersonId: (c: TransactionColumnRef) => string
ReadonlyrailFamily: (c: TransactionColumnRef) => string
ReadonlyrewardKind: (c: TransactionColumnRef) => string

Reward arm only; every other arm projects NULL.
ReadonlysignedAmount: (c: TransactionColumnRef) => string

Variable transactionDerivedColumnDdl`Const`

Type Declaration

`Readonly`accountRef: (c: TransactionColumnRef) => string

`Readonly`cardLabel: (c: TransactionColumnRef) => string

`Readonly`impliedRate: (c: TransactionColumnRef) => string

`Readonly`methodColumnLabel: (c: TransactionColumnRef) => string

`Readonly`organizationId: (c: TransactionColumnRef) => string

`Readonly`outcome: (c: TransactionColumnRef) => string

`Readonly`personId: (c: TransactionColumnRef) => string

`Readonly`railFamily: (c: TransactionColumnRef) => string

`Readonly`rewardKind: (c: TransactionColumnRef) => string

`Readonly`signedAmount: (c: TransactionColumnRef) => string

Settings

Variable transactionDerivedColumnDdlConst

Type Declaration

ReadonlyaccountRef: (c: TransactionColumnRef) => string

ReadonlycardLabel: (c: TransactionColumnRef) => string

ReadonlyimpliedRate: (c: TransactionColumnRef) => string

ReadonlymethodColumnLabel: (c: TransactionColumnRef) => string

ReadonlyorganizationId: (c: TransactionColumnRef) => string

Readonlyoutcome: (c: TransactionColumnRef) => string

ReadonlypersonId: (c: TransactionColumnRef) => string

ReadonlyrailFamily: (c: TransactionColumnRef) => string

ReadonlyrewardKind: (c: TransactionColumnRef) => string

ReadonlysignedAmount: (c: TransactionColumnRef) => string

Settings

Variable transactionDerivedColumnDdl`Const`

`Readonly`accountRef: (c: TransactionColumnRef) => string

`Readonly`cardLabel: (c: TransactionColumnRef) => string

`Readonly`impliedRate: (c: TransactionColumnRef) => string

`Readonly`methodColumnLabel: (c: TransactionColumnRef) => string

`Readonly`organizationId: (c: TransactionColumnRef) => string

`Readonly`outcome: (c: TransactionColumnRef) => string

`Readonly`personId: (c: TransactionColumnRef) => string

`Readonly`railFamily: (c: TransactionColumnRef) => string

`Readonly`rewardKind: (c: TransactionColumnRef) => string

`Readonly`signedAmount: (c: TransactionColumnRef) => string