Class FedAchDirService

new FedAchDirService(args: { sqlClient: Sql }): 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;
        id?: string[];
        nameLike?: string;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            address: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "address";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            changeDate: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "changeDate";
                                    notNull: false;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            city: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "city";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            createdAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "createdAt";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            customerName: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "customerName";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            dataViewCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "dataViewCode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            externalId: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: true;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "externalId";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            fullPhoneNumber: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "fullPhoneNumber";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            id: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgInteger";
                                    data: number;
                                    dataType: "number";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: true;
                                    name: "id";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            institutionStatusCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "institutionStatusCode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            newRoutingNumber: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "newRoutingNumber";
                                    notNull: false;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            officeCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: (...)
                                    | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "officeCode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                { $type: (...)
                                | (...) },
                            >;
                            phoneAreaCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "phoneAreaCode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            phonePrefix: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "phonePrefix";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            phoneSuffix: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "phoneSuffix";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            recordTypeCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: (...)
                                    | (...)
                                    | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "recordTypeCode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                { $type: (...)
                                | (...)
                                | (...) },
                            >;
                            routingNumber: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "routingNumber";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            servicingFRBNumber: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "servicingFRBNumber";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            stateCode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "stateCode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            updatedAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "updatedAt";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            zipcode: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "zipcode";
                                    notNull: true;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                            zipcodeExtension: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "zipcodeExtension";
                                    notNull: false;
                                    tableName: "fed_ach_directory";
                                },
                                {},
                                {},
                            >;
                        };
                        dialect: "pg";
                        name: "fed_ach_directory";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        routingNumber?: string[];
        updatedAt?: DbTimestampCriteria;
    },
): 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;
        }[];
    },
>