Databricks metadata

The type definitions below describe the data that is defined in each table's metadata column for Databricks data export.

rate_cards.metadata

interface RateCardMetadata {
  custom_fields?: { [k: string]: string };
}

product_list_item_versions.metadata

interface ProductListItemVersionMetadata {
  netsuite_internal_item_id: string | null;
  /** Only for "usage" products */
  netsuite_overage_item_id: string | null;
  custom_fields?: { [k: string]: string };
  exclude_free_usage?: boolean;
}

contracts.metadata

interface ContractMetadata {
  netsuite_sales_order_id: string | null;
  salesforce_opportunity_id: string | null;
  net_payment_terms_days: number | null;
  reseller_royalties: Array<AWSRoyalty | GCPRoyalty>;
  total_contract_value?: number;
  custom_fields?: { [k: string]: string };
}

balances.metadata

interface CommitMetadata {
  netsuite_sales_order_id: string | null;
  salesforce_opportunity_id: string | null;
  custom_fields?: { [k: string]: string };
}

commits.metadata

interface CommitMetadata {
  netsuite_sales_order_id: string | null;
  salesforce_opportunity_id: string | null;
  custom_fields?: { [k: string]: string };
}

amendments.metadata

interface AmendmentMetadata {
  netsuite_sales_order_id: string | null;
  salesforce_opportunity_id: string | null;
  reseller_royalties: Array<
    AWSRoyalty | AWSRoyaltyUpdate | GCPRoyalty | GCPRoyaltyUpdate
  >;
  custom_fields?: { [k: string]: string };
}

discounts.metadata

interface DiscountMetadata {
  netsuite_sales_order_id: string | null;
}

scheduled_charges.metadata

interface ScheduledChargeMetadata {
  netsuite_sales_order_id: string | null;
}

pro_services.metadata

interface ProServiceMetadata {
  netsuite_sales_order_id: string | null;
  max_amount: number | null;
  custom_fields?: { [k: string]: string };
}

reseller_royalties and updates

interface AWSRoyalty {
  type: "aws";
  applicable_product_ids: string[];
  applicable_product_tags: string[];
  aws_payer_reference_id: string | null;
  aws_account_number: string | null;
  netsuite_reseller_id: string;
  /** Float, 0.5 = 50% */
  fraction: number;
  /** ISO-8601 encoded timestamp */
  starting_at: string;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

/** This has all the same fields as AWSRoyalty, except all fields are optional/null-able */
interface AWSRoyaltyUpdate {
  type: "aws_update";
  applicable_product_ids: string[] | null;
  applicable_product_tags: string[] | null;
  aws_payer_reference_id: string | null;
  aws_account_number: string | null;
  netsuite_reseller_id: string | null;
  /** Float, 0.5 = 50% */
  fraction: number | null;
  /** ISO-8601 encoded timestamp */
  starting_at: string | null;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

interface GCPRoyalty {
  type: "gcp";
  applicable_product_ids: string[];
  applicable_product_tags: string[];
  gcp_account_id: string | null;
  gcp_offer_id: string | null;
  netsuite_reseller_id: string;
  /** Float, 0.5 = 50% */
  fraction: number;
  /** ISO-8601 encoded timestamp */
  starting_at: string;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

/** This has all the same fields as GCPRoyalty, except all fields are optional/null-able */
interface GCPRoyaltyUpdate {
  type: "gcp_update";
  applicable_product_ids: string[] | null;
  applicable_product_tags: string[] | null;
  gcp_account_id: string | null;
  gcp_offer_id: string | null;
  netsuite_reseller_id: string | null;
  /** Float, 0.5 = 50% */
  fraction: number | null;
  /** ISO-8601 encoded timestamp */
  starting_at: string | null;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

interface AWSProServiceRoyalty {
  type: "aws_pro_service";
  applicable_product_ids: string[];
  aws_payer_reference_id: string | null;
  aws_account_number: string | null;
  netsuite_reseller_id: string;
  /** Float, 0.5 = 50% */
  fraction: number;
  /** ISO-8601 encoded timestamp */
  starting_at: string;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

/** This has all the same fields as AWSProServiceRoyalty, except all fields are optional/null-able */
interface AWSProServiceRoyaltyUpdate {
  type: "aws_pro_service_update";
  applicable_product_ids: string[] | null;
  aws_payer_reference_id: string | null;
  aws_account_number: string | null;
  netsuite_reseller_id: string | null;
  /** Float, 0.5 = 50% */
  fraction: number | null;
  /** ISO-8601 encoded timestamp */
  starting_at: string | null;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

interface GCPProServiceRoyalty {
  type: "gcp_pro_service";
  applicable_product_ids: string[];
  gcp_account_id: string | null;
  gcp_offer_id: string | null;
  netsuite_reseller_id: string;
  /** Float, 0.5 = 50% */
  fraction: number;
  /** ISO-8601 encoded timestamp */
  starting_at: string;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}

/** This has all the same fields as GCPProServiceRoyalty, except all fields are optional/null-able */
interface GCPProServiceRoyaltyUpdate {
  type: "gcp_pro_service_update";
  applicable_product_ids: string[] | null;
  gcp_account_id: string | null;
  gcp_offer_id: string | null;
  netsuite_reseller_id: string | null;
  /** Float, 0.5 = 50% */
  fraction: number | null;
  /** ISO-8601 encoded timestamp */
  starting_at: string | null;
  /** ISO-8601 encoded timestamp */
  ending_before: string | null;
}