Variable girasolCardTransactionSelectionConst

Type Declaration

• amount: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• clearingData: PgBuildColumn<
      "girasol_card_transaction",
      Set$Type<
          PgJsonbBuilder,
          {
              amountAdjusted: string;
              amountCleared: string;
              receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
              type: "OVER_CLEARED" | "UNDER_CLEARED" | "MATCH";
          },
      >,
      {
          data: {
              amountAdjusted: string;
              amountCleared: string;
              receipt?: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
              type: "OVER_CLEARED" | "UNDER_CLEARED" | "MATCH";
          };
          dataType: "object json";
          driverParam: unknown;
          enumValues: undefined;
          generated: undefined;
          hasDefault: false;
          hasRuntimeDefault: false;
          identity: undefined;
          isAutoincrement: false;
          isPrimaryKey: false;
          name: string;
          notNull: false;
          tableName: "girasol_card_transaction";
      },
  >

• clearingTypeDescription: SQL<string | null>

• createdAt: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• currency: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• customerExternalId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• customerId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• data: PgBuildColumn<
      "girasol_card_transaction",
      Set$Type<
          PgJsonbBuilder,
          {
              girasolEvent?: object;
              merchant?: {
                  categoryCode?: string;
                  city?: string;
                  country?: string;
                  mcc: string;
                  name: string;
              };
          },
      >,
      {
          data: {
              girasolEvent?: object;
              merchant?: {
                  categoryCode?: string;
                  city?: string;
                  country?: string;
                  mcc: string;
                  name: string;
              };
          };
          dataType: "object json";
          driverParam: unknown;
          enumValues: undefined;
          generated: undefined;
          hasDefault: false;
          hasRuntimeDefault: false;
          identity: undefined;
          isAutoincrement: false;
          isPrimaryKey: false;
          name: string;
          notNull: false;
          tableName: "girasol_card_transaction";
      },
  >

• externalId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• girasolCardExternalId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• girasolCardId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• girasolTransactionId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• id: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• idempotencyKey: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

  Delivery key of the row, today the Hookdeck event id; the only replay key for a notification Girasol sends without an id

• originalGirasolTransactionId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

  Reference to original Girasol authorization for reversals

• reason: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• receipt: PgBuildColumn<
      "girasol_card_transaction",
      Set$Type<
          PgJsonbBuilder,
          { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" },
      >,
      {
          data: { id: string; type: "SOLANA_TRANSACTION_SIGNATURE" };
          dataType: "object json";
          driverParam: unknown;
          enumValues: undefined;
          generated: undefined;
          hasDefault: false;
          hasRuntimeDefault: false;
          identity: undefined;
          isAutoincrement: false;
          isPrimaryKey: false;
          name: string;
          notNull: false;
          tableName: "girasol_card_transaction";
      },
  >

  Reference to successful on-chain transaction

• settlementLedgerAccountExternalId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

• settlementLedgerAccountId: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >

  Reference to Girasol mastercard ledger account

• status: PgBuildColumn<
      "girasol_card_transaction",
      Set$Type<
          SetNotNull<PgTextBuilder<[string, ...string[]]>>,
  
              | "PENDING"
              | "FAILED"
              | "COMPLETED"
              | "PROCESSING"
              | "RETURNED"
              | "CANCELLED",
      >,
      {
          data: | "PENDING"
          | "FAILED"
          | "COMPLETED"
          | "PROCESSING"
          | "RETURNED"
          | "CANCELLED";
          dataType: "string";
          driverParam: string;
          enumValues: undefined;
          generated: undefined;
          hasDefault: false;
          hasRuntimeDefault: false;
          identity: undefined;
          isAutoincrement: false;
          isPrimaryKey: false;
          name: string;
          notNull: true;
          tableName: "girasol_card_transaction";
      },
  >

• statusDescription: SQL<string>

• statusReason: PgBuildColumn<
      "girasol_card_transaction",
      Set$Type<
          PgTextBuilder<[string, ...string[]]>,
          "DECLINED" | "REVERSED" | "WORKFLOW_CANCELLED" | "AUTH_EXPIRED",
      >,
      {
          data: "DECLINED" | "REVERSED" | "WORKFLOW_CANCELLED" | "AUTH_EXPIRED";
          dataType: "string";
          driverParam: string;
          enumValues: undefined;
          generated: undefined;
          hasDefault: false;
          hasRuntimeDefault: false;
          identity: undefined;
          isAutoincrement: false;
          isPrimaryKey: false;
          name: string;
          notNull: false;
          tableName: "girasol_card_transaction";
      },
  >

  Why the row ended FAILED, RETURNED or CANCELLED (API_V2.md §4.4.1); written with status.

• type: PgBuildColumn<
      "girasol_card_transaction",
      Set$Type<
          SetNotNull<PgTextBuilder<[string, ...string[]]>>,
          "authorization" | "notification" | "reversal" | "refund",
      >,
      {
          data: "authorization" | "notification" | "reversal" | "refund";
          dataType: "string";
          driverParam: string;
          enumValues: undefined;
          generated: undefined;
          hasDefault: false;
          hasRuntimeDefault: false;
          identity: undefined;
          isAutoincrement: false;
          isPrimaryKey: false;
          name: string;
          notNull: true;
          tableName: "girasol_card_transaction";
      },
  >

  Girasol's request_type, except an approved or declined authorization whose payload.transaction_type is refund, which is a refund: a credit to the card with no authorization behind it.

• typeDescription: SQL<string>

• updatedAt: PgBuildColumn<
      "girasol_card_transaction",
      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: "girasol_card_transaction";
      },
  >