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