Cloud Billing

Tables (9)

CLD_TB_BILLING_TYPE

  • BILLING_TYPE_ID — varchar(50) — Primary key — NOT NULL
  • BILLING_TYPE_NAME — nvarchar(50) — NOT NULL
  • DESCRIPTION — nvarchar(2500)
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_GROBAL_PRICING_RULES

  • RULES_ID — varchar(50) — NOT NULL
  • RESOURCE_TYPE — NVARCHAR(50) — NOT NULL
  • BILLING_TYPE — NVARCHAR(50) — NOT NULL
  • UNIT_PRICE — DECIMAL(18, 6) — NOT NULL
  • UNIT — NVARCHAR(50) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_RESOURCE_METADATA

  • RESOURCE_ID — varchar(50) — Primary key — NOT NULL
  • RESOURCE_NAME — nvarchar(50) — NOT NULL
  • DESCRIPTION — nvarchar(2500)
  • RESOURCE_TYPE — varchar(50) — NOT NULL
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_RESOURCE_TYPE

  • RESOURCE_TYPE_ID — varchar(50) — Primary key — NOT NULL
  • RESOURCE_TYPE_NAME — nvarchar(50) — NOT NULL
  • DESCRIPTION — nvarchar(2500)
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_TENANTS_PRICING_RULES

  • RULES_ID — varchar(50) — Primary key — NOT NULL
  • TENANT_ID — varchar(50)
  • RESOURCE_TYPE — NVARCHAR(50) — NOT NULL
  • BILLING_TYPE — NVARCHAR(50) — NOT NULL
  • UNIT_PRICE — DECIMAL(18, 6) — NOT NULL
  • UNIT — NVARCHAR(50) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_TENANT_BILLS

  • BILL_ID — varchar(50) — Primary key — NOT NULL
  • TENANT_ID — varchar(50) — NOT NULL
  • USAGE_DATE — DATE — NOT NULL
  • RESOURCE_TYPE — NVARCHAR(50) — NOT NULL
  • BILLING_TYPE — NVARCHAR(50) — NOT NULL
  • TOTAL_AMOUNT — DECIMAL(18, 0) — NOT NULL
  • TOTAL_COST — DECIMAL(18, 6) — NOT NULL
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_TENANT_BILLS_DETAIL

  • BILLS_DETAIL_ID — INT — Primary key — NOT NULL
  • BILL_ID — varchar(50) — NOT NULL
  • RESOURCE_ID — VARCHAR(50) — NOT NULL
  • USAGE_AMOUNT — DECIMAL(18,6)
  • UNIT_PRICE — DECIMAL(18,6) — NOT NULL
  • DISCOUNT_RATE — DECIMAL(5,2)
  • FINAL_AMOUNT — DECIMAL(18,6) — NOT NULL
  • CALCULATION_FORMULA — VARCHAR(255) — NOT NULL
  • CREATED_AT — DATETIME

CLD_TB_TENANT_RESOURCE_BILLING

  • BILLING_ID — varchar(50) — Primary key — NOT NULL
  • TENANT_ID — varchar(50) — NOT NULL
  • USAGE_DATE — date — NOT NULL
  • RESOURCE_TYPE — NVARCHAR(50) — NOT NULL
  • RESOURCE_ID — varchar(255) — NOT NULL
  • CALCULATED_COST — DECIMAL(18, 6) — NOT NULL
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL

CLD_TB_TENANT_RESOURCE_USAGE

  • USAGE_ID — varchar(50) — Primary key — NOT NULL
  • TENANT_ID — varchar(50) — NOT NULL
  • USAGE_DATE — date — NOT NULL
  • RESOURCE_TYPE — NVARCHAR(50) — NOT NULL
  • RESOURCE_ID — varchar(255) — NOT NULL
  • USAGE_AMOUNT — DECIMAL(18, 6) — NOT NULL
  • USAGE_DIFF_AMOUNT — DECIMAL(18, 6) — NOT NULL
  • UNIT — VARCHAR(50) — NOT NULL
  • DESCRIPTION — varchar(2500)
  • CREATOR — varchar(50)
  • CREATED_TIME — datetime2
  • MODIFIER — varchar(50)
  • MODIFIED_TIME — datetime2
  • LAST_TXN_HIST_KEY — varchar(50)
  • LAST_TXN_ID — varchar(50)
  • LAST_TXN_USER — varchar(50)
  • LAST_TXN_TIME — datetime2
  • LAST_TXN_COMMENT — varchar(2500) — archar(2500) NUL
  • VALID_STATE — varchar(50) — NOT NULL