Parameters
- __namedParameters: {
amount?: BigNumber;
createdAt?: DbTimestampCriteria;
customerId?: string;
customerIds?: string[];
idempotencyKey?: string;
ids?: string[];
orderBy?: DbOrderByCriterion<
Omit<
PgTableWithColumns<
{
columns: {
amount: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgNumericBuilder>,
{
data: string;
dataType: "string numeric";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
commitExternalId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
commitTargets: PgBuildColumn<
"ledger_account_withdrawal",
Set$Type<PgJsonbBuilder, (...) | (...)>,
{
data: (...) | (...);
dataType: "object json";
driverParam: unknown;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
commitTxId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
createdAt: PgBuildColumn<
"ledger_account_withdrawal",
SetHasDefault<SetNotNull<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
customerExternalId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
customerId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgIntegerBuilder>,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
data: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<Set$Type<(...), (...)>>,
{
data: { rewardClaimId?: ...; withdrawalId?: ... };
dataType: "object json";
driverParam: unknown;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
externalId: PgBuildColumn<
"ledger_account_withdrawal",
SetHasRuntimeDefault<SetNotNull<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
id: PgBuildColumn<
"ledger_account_withdrawal",
HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: "byDefault";
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
idempotencyKey: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
ik: PgBuildColumn<
"ledger_account_withdrawal",
SetHasGenerated<SetNotNull<(...)>>,
{
data: string;
dataType: "string uuid";
driverParam: string;
enumValues: undefined;
generated: true;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
initiateTxId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
ledgerAccountExternalId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
ledgerAccountId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgIntegerBuilder>,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
searchDocument: PgBuildColumn<
"ledger_account_withdrawal",
SetHasGenerated<SetNotNull<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: true;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
searchDocumentAdmin: PgBuildColumn<
"ledger_account_withdrawal",
SetHasGenerated<SetNotNull<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: true;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
status: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<Set$Type<(...), (...)>>,
{
data: (...) | (...) | (...) | (...);
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
updatedAt: PgBuildColumn<
"ledger_account_withdrawal",
SetHasDefault<SetHasDefault<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
voidTxId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
withdrawalExternalId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
withdrawalId: PgBuildColumn<
"ledger_account_withdrawal",
PgIntegerBuilder,
{
data: number;
dataType: "number int32";
driverParam: (...)
| (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
};
dialect: "pg";
isAlias: false;
name: "ledger_account_withdrawal";
schema: "b2b";
},
>,
"enableRLS",
>,
"createdAt"
| "updatedAt",
>[];
page?: number;
pageSize?: number;
q?: string;
rewardClaimIds?: string[];
statuses?: ("PROCESSING" | "COMPLETED" | "PENDING" | "RETURNED")[];
tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
updatedAt?: DbTimestampCriteria;
withdrawalIds?: string[];
}
-
Optionalamount?: BigNumber
-
-
OptionalcustomerId?: string
-
OptionalcustomerIds?: string[]
-
OptionalidempotencyKey?: string
-
Optionalids?: string[]
-
OptionalorderBy?: DbOrderByCriterion<
Omit<
PgTableWithColumns<
{
columns: {
amount: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgNumericBuilder>,
{
data: string;
dataType: "string numeric";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
commitExternalId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
commitTargets: PgBuildColumn<
"ledger_account_withdrawal",
Set$Type<PgJsonbBuilder, (...) | (...)>,
{
data: (...) | (...);
dataType: "object json";
driverParam: unknown;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
commitTxId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
createdAt: PgBuildColumn<
"ledger_account_withdrawal",
SetHasDefault<SetNotNull<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
customerExternalId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
customerId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgIntegerBuilder>,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
data: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<Set$Type<(...), (...)>>,
{
data: { rewardClaimId?: ...; withdrawalId?: ... };
dataType: "object json";
driverParam: unknown;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
externalId: PgBuildColumn<
"ledger_account_withdrawal",
SetHasRuntimeDefault<SetNotNull<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
id: PgBuildColumn<
"ledger_account_withdrawal",
HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: "byDefault";
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
idempotencyKey: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
ik: PgBuildColumn<
"ledger_account_withdrawal",
SetHasGenerated<SetNotNull<(...)>>,
{
data: string;
dataType: "string uuid";
driverParam: string;
enumValues: undefined;
generated: true;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
initiateTxId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
ledgerAccountExternalId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
ledgerAccountId: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<PgIntegerBuilder>,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
searchDocument: PgBuildColumn<
"ledger_account_withdrawal",
SetHasGenerated<SetNotNull<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: true;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
searchDocumentAdmin: PgBuildColumn<
"ledger_account_withdrawal",
SetHasGenerated<SetNotNull<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: true;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
status: PgBuildColumn<
"ledger_account_withdrawal",
SetNotNull<Set$Type<(...), (...)>>,
{
data: (...) | (...) | (...) | (...);
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
updatedAt: PgBuildColumn<
"ledger_account_withdrawal",
SetHasDefault<SetHasDefault<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "ledger_account_withdrawal";
},
>;
voidTxId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
withdrawalExternalId: PgBuildColumn<
"ledger_account_withdrawal",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
withdrawalId: PgBuildColumn<
"ledger_account_withdrawal",
PgIntegerBuilder,
{
data: number;
dataType: "number int32";
driverParam: (...)
| (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "ledger_account_withdrawal";
},
>;
};
dialect: "pg";
isAlias: false;
name: "ledger_account_withdrawal";
schema: "b2b";
},
>,
"enableRLS",
>,
"createdAt"
| "updatedAt",
>[]
-
Optionalpage?: number
-
OptionalpageSize?: number
-
Optionalq?: string
-
OptionalrewardClaimIds?: string[]
-
Optionalstatuses?: ("PROCESSING" | "COMPLETED" | "PENDING" | "RETURNED")[]
-
Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>
-
-
OptionalwithdrawalIds?: string[]
Returns Promise<
{
ok: true;
value: {
hasNext: boolean;
items: (
{
amount: BigNumber;
commitId?: string;
commitTargets?: {
address: Address;
amount: BigNumber;
owner?: Address;
}[];
commitTxId?: string;
createdAt: Date;
id: string;
idempotencyKey: string;
initiateTxId?: string;
ledgerAccountId: string;
status: "PROCESSING"
| "COMPLETED"
| "PENDING"
| "RETURNED";
updatedAt: Date;
voidTxId?: string;
} & {
customerId: string;
customerName: string;
failureReason: string
| null;
}
)[];
total: number;
};
},
>
customer ledgerAccountWithdrawal records
The process default: built from each dependency's own
instance().