objid | contract | objid | Contract internal record number | 3 (UNIQUE) |
user_objid | user | objid | User owner internal record number | |
acct_objid | bus_org | objid | Account internal record number | |
status_objid | gbst_elm | objid | Quote status internal record number | |
contact_objid | contact | objid | Contact internal record number | |
currency_objid | currency | objid | Currency internal record number | |
quote_id | contract | id | System-generated quote ID number | |
quote_title | contract | title | Title of the quote | |
quote_amount | contract | total_net | Total net amount of the quote | |
quote_owner | user | login_name | Owner's login name | |
quote_status | gbst_elm | title | Title of the quote status | |
q_start_date | contract | q_start_date | Quote start date | |
q_end_date | contract | q_end_date | Quote end date | |
acct_name | bus_org | name | Name of the prospect Account | |
contact_fname | contact | first_name | Contact's first name | |
contact_lname | contact | last_name | Contact's last name | |
contact_phone | contact | phone | Contact's phone | |
quote_currency | currency | name | Name of the quote's currency | |
sub_scale | currency | sub_scale | Gives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 | |
q_issue_date | contract | q_issue_dt | Quote issue date | |
create_date | contract | create_dt | Date the quote/order was created | |
submit_date | contract | ord_submit_dt | Date the quote/order was submitted | |
order_status | contract | order_status | MACD order status | |