Class FedAchDirService

new FedAchDirService(
    args: { db: B2bDatabase; valkeyClient: ValkeyClient | null },
): FedAchDirService

get(
    args: { id: string } | { routingNumber: string },
): Promise<
    {
        ok: true;
        value: | {
            address: string;
            changeDate: Date
            | null;
            city: string;
            createdAt: Date;
            customerName: string;
            dataViewCode: string;
            fullPhoneNumber: string;
            id: string;
            institutionStatusCode: string;
            newRoutingNumber: string | null;
            officeCode: "O" | "B";
            phoneAreaCode: string;
            phonePrefix: string;
            phoneSuffix: string;
            recordTypeCode: "0" | "1" | "2";
            routingNumber: string;
            servicingFRBNumber: string;
            stateCode: string;
            updatedAt: Date;
            zipcode: string;
            zipcodeExtension: string | null;
        }
        | null;
    },
>

search(
    args: {
        createdAt?: DbTimestampCriteria;
        ids?: string[];
        nameLike?: string;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            address: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            changeDate: PgBuildColumn<
                                "fed_ach_directory",
                                PgTimestampBuilder,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "fed_ach_directory";
                                },
                            >;
                            city: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            customerName: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            dataViewCode: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            fullPhoneNumber: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            id: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            institutionStatusCode: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            newRoutingNumber: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            officeCode: PgBuildColumn<
                                "fed_ach_directory",
                                Set$Type<SetNotNull<(...)>, (...) | (...)>,
                                {
                                    data: (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                            >;
                            phoneAreaCode: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            phonePrefix: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            phoneSuffix: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            recordTypeCode: PgBuildColumn<
                                "fed_ach_directory",
                                Set$Type<SetNotNull<(...)>, (...) | (...) | (...)>,
                                {
                                    data: (...) | (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                            >;
                            routingNumber: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            servicingFRBNumber: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            stateCode: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            zipcode: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                            zipcodeExtension: PgBuildColumn<
                                "fed_ach_directory",
                                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: "fed_ach_directory";
                                },
                            >;
                        };
                        dialect: "pg";
                        name: "fed_ach_directory";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        routingNumbers?: string[];
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: {
                address: string;
                changeDate: Date
                | null;
                city: string;
                createdAt: Date;
                customerName: string;
                dataViewCode: string;
                fullPhoneNumber: string;
                id: string;
                institutionStatusCode: string;
                newRoutingNumber: string | null;
                officeCode: "O" | "B";
                phoneAreaCode: string;
                phonePrefix: string;
                phoneSuffix: string;
                recordTypeCode: "0" | "1" | "2";
                routingNumber: string;
                servicingFRBNumber: string;
                stateCode: string;
                updatedAt: Date;
                zipcode: string;
                zipcodeExtension: string | null;
            }[];
            total: number;
        };
    },
>