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;
}