@cfxlabsinc/b2b-services
    Preparing search index...

    Variable greendotSettlementEntryTableConst

    greendotSettlementEntryTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    amount: PgBuildColumn<
                        "greendot_settlement_entry",
                        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: "greendot_settlement_entry";
                        },
                    >;
                    barcodeReferenceNumber: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    batchExternalId: PgBuildColumn<
                        "greendot_settlement_entry",
                        SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    batchId: PgBuildColumn<
                        "greendot_settlement_entry",
                        SetNotNull<PgIntegerBuilder>,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    createdAt: PgBuildColumn<
                        "greendot_settlement_entry",
                        SetHasDefault<SetNotNull<PgTimestampBuilder>>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    customerReferenceNumber: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    depositExternalId: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    depositId: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgIntegerBuilder,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    depositQuoteExternalId: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    depositQuoteId: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgIntegerBuilder,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    externalId: PgBuildColumn<
                        "greendot_settlement_entry",
                        SetHasRuntimeDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    id: PgBuildColumn<
                        "greendot_settlement_entry",
                        HasIdentity<SetIsPrimaryKey<PgIntegerBuilder>, "byDefault">,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: "byDefault";
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    matchMethod: PgBuildColumn<
                        "greendot_settlement_entry",
                        Set$Type<
                            PgTextBuilder<[string, ...string[]]>,
                            "PARTNER_REFERENCE" | "BARCODE",
                        >,
                        {
                            data: "PARTNER_REFERENCE" | "BARCODE";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    matchStatus: PgBuildColumn<
                        "greendot_settlement_entry",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            "MATCHED" | "UNMATCHED",
                        >,
                        {
                            data: "MATCHED" | "UNMATCHED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    partnerAccountNumber: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    partnerReferenceNumber: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    pinReferenceNumber: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    productType: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    raw: PgBuildColumn<
                        "greendot_settlement_entry",
                        Set$Type<SetNotNull<PgJsonbBuilder>, Record<string, string>>,
                        {
                            data: TData;
                            dataType: "object json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    transactionReferenceNumber: PgBuildColumn<
                        "greendot_settlement_entry",
                        SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    transDate: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgDateStringBuilder,
                        {
                            data: string;
                            dataType: "string date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "greendot_settlement_entry";
                        },
                    >;
                    transTime: PgBuildColumn<
                        "greendot_settlement_entry",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                    updatedAt: PgBuildColumn<
                        "greendot_settlement_entry",
                        SetHasDefault<SetHasDefault<SetNotNull<PgTimestampBuilder>>>,
                        {
                            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: "greendot_settlement_entry";
                        },
                    >;
                };
                dialect: "pg";
                isAlias: false;
                name: "greendot_settlement_entry";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    One detail line of a settlement transmission. matchStatus and matchMethod are the match ladder's result and nothing else; raw is the verbatim CSV row, so a re-match never re-reads S3.

    dbmate owns the DDL: 20261017173109_greendot_settlement_tables.sql.