Commission

Tables (12)

Category (Untitled8)

  • CategoryId (Key) — bigint — Primary key — NOT NULL
  • Lvl (Field) — int
  • Field2

Copy Of vendor_contract_plan_detail_history (CopyOfUntitled2)

  • vendor_contract_plan_detail_history_id (Key) — bigint — Primary key — NOT NULL
  • vendor_contract_plan_detail_id (Key2) — bigint — Foreign key → vendor_contract_plan_detail.vendor_contract_plan_detail_id — NOT NULL
  • change data (Field5) — nvarchar
  • created_on (Field6) — datetime
  • created_by (Field7) — nvarchar

Products (Untitled9)

  • ProductId (Key) — bigint — Primary key — NOT NULL
  • CategoryId (Key2) — bigint — Foreign key → Category.CategoryId — NOT NULL
  • Field

referral_order_detail_snapshot (Untitled10)

  • referral_order_detail_snapshot_id (Key) — bigint — Primary key — NOT NULL
  • OrderDetailId (Key2) — bigInt — Foreign key → tblOrderDetails.OrderDetailId — NOT NULL
  • referall_fee (Field) — decimal
  • penalty_rate (Field2) — decimal
  • fee1 (Field3) — decimal
  • fee2 (Field4) — decimal
  • fee3 (Field5) — decimal
  • ProductId (Field6) — bigint
  • CategoryId (Field7) — bigint
  • Field8

referral_order_snapshot (CopyOfUntitled10)

  • referral_order_snapshot_id (Key) — bigint — Primary key — NOT NULL
  • OrderId (Key2) — bigInt — Foreign key → tblOrders.OrderId — NOT NULL
  • total_referral_fee (Field) — decimal
  • vendor_id (Field2) — bigint
  • Field3

tblOrderDetails (Untitled7)

  • OrderDetailId (Key) — bigInt — Primary key — NOT NULL
  • OrderId (Key2) — bigInt — Foreign key → tblOrders.OrderId — NOT NULL
  • ProductId (Key4) — bigint — Foreign key → Products.ProductId — NOT NULL
  • CategoryId (Key3) — bigint — Foreign key → Category.CategoryId — NOT NULL
  • Field

tblOrders (Untitled6)

  • OrderId (Key) — bigInt — Primary key — NOT NULL
  • vendor_id (Key2) — bigint — Foreign key → vendor.vendor_id — NOT NULL
  • Field

vendor (Untitled5)

  • vendor_id (Key) — bigint — Primary key — NOT NULL
  • Field

vendor_contract_history (Untitled4)

  • vendor_contract_history_id (Key) — bigint — Primary key — NOT NULL
  • vendor_contract_plan_id (Key2) — bigint — Foreign key → vendor_contract_plan.vendor_contract_plan_id — NOT NULL
  • vendor_id (Key3) — bigint — Foreign key → vendor.vendor_id — NOT NULL
  • contract_type_code (Field2) — int
  • setup_fee (Field4) — decimal
  • last_month_service_fee (Field5) — decimal
  • monthly_fee (Field6) — decimal
  • is_setup_fee_waived (Field7) — bit
  • is_last_month_service_fee_waived (Field8) — bit
  • commission_rate (Field9) — decimal
  • commission_base_date_code (Field10) — int
  • monthly_item_cap (Field11) — int
  • memo (Field12) — nvarchar
  • contract_date_from (Field13) — datetime
  • contract_date_to (Field14) — datetime
  • account_executive_id (Field15) — int
  • account_executive_by (Field16) — nvarchar
  • created_on (Field17) — datetime
  • created_by (Field18) — nvarchar
  • modified_on (Field19) — datetime
  • modified_by (Field20) — nvarchar
  • expired_date (Field21) — datetime
  • conract_commission_rate (Field22) — decimal
  • penalty_rate (Field23) — decimal
  • penalty_start_date (Field24) — datetime
  • penalty_reason_code (Field25) — int

vendor_contract_penalty_history (Untitled)

  • vendor_contract_penalty_history_id (Key) — bigint — Primary key — NOT NULL
  • vendor_id (Key2) — bigint — Foreign key → vendor.vendor_id — NOT NULL
  • penalty_rate (Field2) — decimal(18,4)
  • penalty_start_date (Field3) — datetime
  • penalty_end_date (Field4) — datetimep
  • enalty_reason_code (Field5) — int
  • created_on (Field6) — datetime
  • created_by (Field7) — nvarchar
  • modified_on (Field8) — datetime
  • modiefied_by (Field9) — nvarchar

vendor_contract_plan (Untitled3)

  • vendor_contract_plan_id (Key) — bigint — Primary key — NOT NULL
  • contract_plan_name (Field) — nvarchar — NOT NULL
  • contract_type_code (Field2) — int — NOT NULL
  • setup_fee (Field3) — decimal — NOT NULL
  • last_month_service_fee (Field4) — decimal — NOT NULL
  • monthly_fee (Field5) — decimal — NOT NULL
  • monthly_item_cap (Field6) — int — NOT NULL
  • commission_rate (Field7) — decimal — NOT NULL
  • commission_base_date_code (Field8) — int — NOT NULL
  • memo (Field9) — nvarchar
  • is_editable (Field10) — bit — NOT NULL
  • is_active (Field11) — bit — NOT NULL
  • created_on (Field12) — datetime — NOT NULL
  • created_by (Field13) — nvarchar — NOT NULL
  • modified_on (Field14) — datetime — NOT NULL
  • modified_by (Field15) — nvarchar — NOT NULL

vendor_contract_plan_detail (Untitled2)

  • vendor_contract_plan_detail_id (Key) — bigint — Primary key — NOT NULL
  • vendor_contract_plan_id (Key2) — bigint — Foreign key → vendor_contract_plan.vendor_contract_plan_id — NOT NULL
  • CategoryId (Key3) — bigint — Foreign key → Category.CategoryId — NOT NULL
  • Lvl (Field2) — int
  • commission_rate (Field3) — decimal
  • sort (Field5) — int
  • created_on (Field6) — datetime
  • created_by (Field7) — nvarchar
  • modified_on (Field) — datetime
  • modified_by (Field4) — nvarchar