Originating_leads

The Entity Fields custom field is available for the Originating Leads table.

Columns

Name Type Length Precision Scale References In Description
accountnumber VARCHAR2 99 Account number
altemail VARCHAR2 254 Alternate email address
alternate_contact_id NUMBER 39 0 Alternate contact
altphone VARCHAR2 100 Alternate phone
amount_complete NUMBER 5 2 Amount complete
billaddress VARCHAR2 999 Billing address
calculated_end TIMESTAMP Estimated end date
category_0 VARCHAR2 30 Category
city VARCHAR2 50 City
comments VARCHAR2 4000 Comments
companyname VARCHAR2 83 Company name
consol_days_overdue NUMBER 39 0 Consolidated days overdue
consol_deposit_balance NUMBER 39 0 Consolidated deposit balance
consol_deposit_balance_foreign NUMBER 39 0 Consolidated foreign currency deposit balance
consol_openbalance NUMBER 39 0 Consolidated balance
consol_openbalance_foreign NUMBER 39 0 Consolidated foreign currency balance
consol_unbilled_orders NUMBER 39 0 Consolidated unbilled orders
consol_unbilled_orders_foreign NUMBER 39 0 Consolidated foreign currency unbilled orders
converted_to_contact_id NUMBER 39 0 Contact the lead was converted to
converted_to_id NUMBER 39 0 Customer the lead was converted to
cost_estimate NUMBER 25 5 Cost estimate
country VARCHAR2 50 Country
create_date TIMESTAMP Create date (GMT)
credithold VARCHAR2 4 Credit hold
creditlimit NUMBER 20 2 Credit limit
currency_id NUMBER 39 0 Currency ID
customer_id NUMBER 39 0 Customer ID
customer_type_id NUMBER 39 0 Customer type ID
date_closed TIMESTAMP Date closed (GMT)
date_convsersion TIMESTAMP Conversion from lead date (GMT)
date_first_order TIMESTAMP Date of first order (GMT)
date_first_sale TIMESTAMP Date of first sale (GMT)
date_gross_lead TIMESTAMP Gross lead date (GMT)
date_last_modified TIMESTAMP Date last modified
date_last_order TIMESTAMP Last sales order date (GMT)
date_last_sale TIMESTAMP Last sale (cash sale, invoice) date (GMT)
date_lead TIMESTAMP Lead date (GMT)
date_prospect TIMESTAMP Prospect date (GMT)
days_overdue NUMBER 39 0 Days overdue (GMT)
default_order_priority NUMBER 20 2 Default order priority
default_receivables_account_id NUMBER 39 0 Default receivables account
deposit_balance NUMBER 20 2 Deposit balance
deposit_balance_foreign NUMBER 39 0 Foreign currency deposit balance
email VARCHAR2 254 Email
expected_close TIMESTAMP Expected close date (start date on financial history subtab)
fax VARCHAR2 100 Fax
first_sale_period_id NUMBER 39 0 Accounting period of first sale (cash sale, invoice)
first_visit TIMESTAMP First visit
firstname VARCHAR2 32 First name
full_name VARCHAR2 1800 Full name
home_phone VARCHAR2 100 Home phone
is_exempt_time VARCHAR2 3 Exempt time
is_explicit_conversion VARCHAR2 3 Explicitly converted from lead
is_job VARCHAR2 3 Job
is_person VARCHAR2 3 Type (company or individual)
is_productive_time VARCHAR2 3 Is productive time
is_utilized_time VARCHAR2 3 Is utilized time
isemailhtml VARCHAR2 3 Email as HTML
isemailpdf VARCHAR2 3 Email as PDF
isinactive VARCHAR2 3 Customer is inactive
istaxable VARCHAR2 3 Taxable
job_end TIMESTAMP End date
job_start TIMESTAMP Start date
job_type_id NUMBER 39 0 Job type ID
last_modified_date TIMESTAMP Last modified date (GMT)
last_sale_period_id NUMBER 39 0 Accounting period of last sale (cash sale, invoice)
last_visit TIMESTAMP Last visit
lastname VARCHAR2 32 Last name
lead_source_id NUMBER 39 0 Lead source ID
line1 VARCHAR2 150 Address line 1
line2 VARCHAR2 150 Address line 2
line3 VARCHAR2 150 Address line 3
loginaccess VARCHAR2 3 Give Aacess
middlename VARCHAR2 32 Middle name
mobile_phone VARCHAR2 100 Mobile phone
multiple_price_id NUMBER 39 0 Multiple price ID
name VARCHAR2 83 Name
openbalance NUMBER 39 0 Balance (on financial history subtab)
openbalance_foreign NUMBER 39 0 Foreign currency balance
parent_id NUMBER 39 0 Child of
partner_id NUMBER 39 0 Partner ID
payment_terms_id NUMBER 39 0 Payment terms
phone VARCHAR2 100 Phone
primary_contact_id NUMBER 39 0 Primary contact
print_on_check_as VARCHAR2 83 Print on check as
probability NUMBER 6 2 Probability
projected_end TIMESTAMP Projected end
referrer VARCHAR2 4000 Referrer
reminderdays NUMBER 39 0 Reminder days
renewal TIMESTAMP Renewal
resalenumber VARCHAR2 20 Resale number
rev_rec_forecast_rule_id NUMBER 39 0 Revenue recognition forecast rule ID
rev_rec_forecast_template NUMBER 39 0 Template to use for revenue recognition forecast
revenue_estimate NUMBER 25 5 Revenue estimate
sales_rep_id NUMBER 39 0 Sales rep ID
sales_territory_id NUMBER 39 0 Sales territory ID
salutation VARCHAR2 30 Salutation
ship_complete VARCHAR2 3 Ship complete
shipaddress VARCHAR2 999 Shipping address
state VARCHAR2 50 State
status VARCHAR2 199 Status
status_descr VARCHAR2 199 Status description
status_probability NUMBER 6 2 Status probability
status_read_only VARCHAR2 3 Read only status
subsidiary_id NUMBER 39 0 Subsidiary ID
tax_item_id NUMBER 39 0 Tax item ID
third_party_acct VARCHAR2 32 Third party account
third_party_carrier VARCHAR2 64 Third party carrier
third_party_country VARCHAR2 6 Third party country
third_party_zip_code VARCHAR2 10 Third party zip code
top_level_parent_id NUMBER 39 0 customer_id
Originating_leads
Top level parent ID
unbilled_orders NUMBER 20 2 Unbilled orders
unbilled_orders_foreign NUMBER 39 0 Unbilled foreign currency orders
url VARCHAR2 100 Web address
use_percent_complete_override VARCHAR2 3 Use percent complete override
web_lead VARCHAR2 3 Web Lead
zipcode VARCHAR2 36 Zip code

Primary key

PK Column Name
customer_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
top_level_originating_lead_fk top_level_parent_id Originating_leads customer_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Top_level_originating_lead_fk customer_id Originating_leads top_level_parent_id 1