|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
reference_code
|
varchar(255)
|
|
|
|
|
start_date
|
date
|
|
|
|
|
end_date
|
date
|
|
|
|
|
total_contract_value
|
decimal(26,6)
|
|
|
|
|
total_contract_value_usdollar
|
decimal(26,6)
|
|
|
|
|
currency_id
|
char(36)
|
|
|
|
|
status
|
varchar(100)
|
|
|
Not Started
|
|
customer_signed_date
|
date
|
|
|
|
|
company_signed_date
|
date
|
|
|
|
|
renewal_reminder_date
|
datetime
|
|
|
|
|
contract_type
|
varchar(100)
|
|
|
Type
|
|
contract_account_id
|
char(36)
|
|
|
|
|
opportunity_id
|
char(36)
|
|
|
|
|
contact_id
|
char(36)
|
|
|
|
|
call_id
|
char(36)
|
|
|
|
|
total_amt
|
decimal(26,6)
|
|
|
|
|
total_amt_usdollar
|
decimal(26,6)
|
|
|
|
|
subtotal_amount
|
decimal(26,6)
|
|
|
|
|
subtotal_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
discount_amount
|
decimal(26,6)
|
|
|
|
|
discount_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
tax_amount
|
decimal(26,6)
|
|
|
|
|
tax_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
shipping_amount
|
decimal(26,6)
|
|
|
|
|
shipping_amount_usdollar
|
decimal(26,6)
|
|
|
|
|
shipping_tax
|
varchar(100)
|
|
|
|
|
shipping_tax_amt
|
decimal(26,6)
|
|
|
|
|
shipping_tax_amt_usdollar
|
decimal(26,6)
|
|
|
|
|
total_amount
|
decimal(26,6)
|
|
|
|
|
total_amount_usdollar
|
decimal(26,6)
|
|
|
|