Innocean

Tables (16)

Account

  • Id — SFId — Primary key — NOT NULL

Case

  • Id — SFId — Primary key — NOT NULL
  • Opportunity__c (Opportunity) — Lookup — Foreign key → Opportunity.Id — NOT NULL
  • AccountId (Account) — Lookup — Foreign key → Account.Id — NOT NULL

Contact

  • Id — SFId — Primary key — NOT NULL
  • AccountId (Account) — Lookup — Foreign key → Account.Id — NOT NULL

CustomOrderLineItem__c (Order Line Item)

  • Id — SFId — Primary key — NOT NULL
  • CustomOrder__c (Order) — Lookup — Foreign key → CustomOrder__c.Id — NOT NULL
  • CustomQuoteLineItem__c (Quote Line Item) — Lookup — Foreign key → CustomQuoteLineItem__c.Id — NOT NULL
  • ManufactureMilestone__c (Manufacture Milestone) — Lookup — Foreign key → ManufactureMilestone__c.Id — NOT NULL

CustomOrder__c (Order)

  • Id — SFId — Primary key — NOT NULL
  • CustomQuote__c (Quote__c) — Lookup — Foreign key → CustomQuote__c.Id — NOT NULL
  • Opportunity__c (Project) — Lookup — Foreign key → Opportunity.Id — NOT NULL

CustomQuoteLineItem__c (Quote Line Item)

  • Id — SFId — Primary key — NOT NULL
  • CustomQuote__c (Quote) — MD — Foreign key → CustomQuote__c.Id — NOT NULL
  • OpportunityLineItem__c (Project Line Item) — Lookup — Foreign key → OpportunityLineItem.Id — NOT NULL

CustomQuote__c (Quote)

  • Id — SFId — Primary key — NOT NULL
  • Opportunity__c (Project) — MD — Foreign key → Opportunity.Id — NOT NULL

Dummy

  • Id — SFId — Primary key — NOT NULL

ManufactureMilestone__c (Supplier Milestone)

  • Id — SFId — Primary key — NOT NULL
  • Supplier__c (Supplier) — Lookup — Foreign key → Account.Id — NOT NULL
  • Opportunity__c (Project) — Lookup — Foreign key → Opportunity.Id — NOT NULL

Opportunity (Project)

  • Id — SFId — Primary key — NOT NULL
  • AccountId (Account) — SFId — Foreign key → Account.Id — NOT NULL
  • Pricebook2 (Price Book) — SFId — Foreign key → Price Book.Id — NOT NULL
  • Site__c (Site) — Lookup — Foreign key → Site__c.Id — NOT NULL

OpportunityLineItem (Project Line Item)

  • Id — SFId — Primary key — NOT NULL
  • Product2Id (Product) — Lookup — Foreign key → Product2.Id — NOT NULL
  • OpportnityId (Project) — MD — Foreign key → Opportunity.Id — NOT NULL

OpportunityMilestone__c (Project Milestone)

  • Id — SFId — Primary key — NOT NULL
  • Opportunity__c (Project) — MD — Foreign key → Opportunity.Id — NOT NULL

Price Book (PriceBook)

  • Id — SFId — Primary key — NOT NULL

Price Book Entry (PriceBookEntry)

  • Id — SFId — Primary key — NOT NULL
  • PriceBookId (Price Book) — Lookup — Foreign key → Price Book.Id — NOT NULL
  • Product2Id (Product) — Lookup — Foreign key → Product2.Id — NOT NULL

Product2 (Product)

  • Id — SFId — Primary key — NOT NULL

Site__c (Site)

  • Id — SFId — Primary key — NOT NULL
  • Account__c (Account) — Lookup — Foreign key → Account.Id — NOT NULL