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