GME Master

Tables (27)

Asset

  • Vehicle-Type (Vehicle_Type__c) — Lookup(Vehicle Model) — Foreign key → Vehicle Model.Product Name — NOT NULL
  • Product (Poroduct2Id) — Lookup(Product) — Foreign key → Product.ID — NOT NULL

Color Master (ColorMaster__c)

  • Color Master Name (Name) — TEXT — Primary key — NOT NULL
  • SAP Key (SAPKey__c) — TEXT

Contract

  • Id — Auto Number — Primary key — NOT NULL
  • QuoteName (QouteId) — Lookup(Quote) — Foreign key → Quote.Quote Number — NOT NULL

Contract Line Item (ContractLineItem)

  • Id — Auto Number — Primary key — NOT NULL
  • Contract NameId (ContractId) — M-D(Contract) — Foreign key → Contract.Id — NOT NULL

Delivery

  • Delivery Name (Name) — Auto Number — Primary key — NOT NULL
  • Order (OrderId) — Lookup(Order) — Foreign key → Order.Id — NOT NULL
  • ID — Id — Foreign key → Product.ID — NOT NULL

FSC Standard Information (FSCStandardInformation__c)

  • FSC Standard Information Name (Name) — TEXT — Primary key — NOT NULL
  • SAP Key (SAPKey__c) — TEXT

Finance Detail (FinanceDetail__c)

  • Finance Detail No (Name) — Auto Number — Primary key — NOT NULL
  • Qoute (Qoute__c) — Lookup(Quote) — Foreign key → Quote.Quote Number — NOT NULL
  • Contract (Contract__c) — Lookup(Contract) — Foreign key → Contract.Id — NOT NULL

Invoice

  • Invoice Name (Name) — Auto Number — Primary key — NOT NULL
  • Finance Detail No (Finance_Detail__c) — Lookup(Finance Detail) — Foreign key → Finance Detail.Finance Detail No — NOT NULL
  • Contract (Contract__c) — Lookup(Contract) — Foreign key → Contract.Id — NOT NULL

Invoice Line Item (InvoiceLineItem__c)

  • Invoice (Invoice__c) — M-D(Invoice) — Foreign key → Invoice.Invoice Name — NOT NULL
  • Contract Line Item (ContractLineItem__c) — Lookup(ContractLineItem) — Foreign key → Contract Line Item.Id — NOT NULL

MC Master (MCMaster__c)

  • MC Master Name (Name) — TEXT — Primary key — NOT NULL
  • SAP Key (SAPKey__c) — TEXT

MC Trim Master (MCTrimMaster__c)

  • MC Trim Master Name (Name) — TEXT — Primary key — NOT NULL
  • SAP Key (SAPKey__c) — TEXT

Opportunity

  • Name — Primary key — NOT NULL

Option Master (OptionMaster__c)

  • Option Master (Name) — TEXT — Primary key — NOT NULL
  • SAP Key (SAPKey__c) — TEXT

Order

  • Id — Auto Number — Primary key — NOT NULL
  • Contract Name (ContractId) — Lookup(Contract) — Foreign key → Contract.Id — NOT NULL

Order Line Item (OrderLineItem__c)

  • Id — Auto Number — Primary key — NOT NULL
  • OrderName (OrderId) — M-D(Order) — Foreign key → Order.Id — NOT NULL

Order Status (???)

  • Order — M-D(Order) — Foreign key → Order.Id — NOT NULL

Order To Delivery (OrderToDelivery__c)

  • Order (OrderId) — M-D(Order) — Foreign key → Order.Id — NOT NULL
  • Delivery Name (Name) — Lookup(Delivery) — Foreign key → Delivery.Delivery Name — NOT NULL

Package Master (PackageMaster__c)

  • Package Master Name (Name) — TEXT — Primary key — NOT NULL
  • SAP Key (SAPKey__c) — TEXT

Payment (Payment__c)

  • Id — Auto Number — Primary key — NOT NULL
  • Contract Name (ContractId) — M-D(Contract) — Foreign key → Contract.Id — NOT NULL

Plants (Plants__c)

  • Plants Name (Name) — TEXT — Primary key — NOT NULL

Price Book (Untitled3)

  • Price Bok Name (Name) — Primary key — NOT NULL

Price Book Entry (PricebookEntry)

  • Key — Primary key — NOT NULL
  • Product (Product2Id) — Lookup(Product) — Foreign key → Product.ID — NOT NULL
  • Price Bok Name (Pricebook2Id) — Lookup(Pricebook) — Foreign key → Price Book.Price Bok Name — NOT NULL

Product (Product2)

  • ID — Id — Primary key — NOT NULL
  • Vehicle Model (LTM) (VehicleModelLabor__c) — Lookup — Foreign key → Vehicle Model.Product Name — NOT NULL
  • Vehicle Model (DPOS) (VehicleModelPart__c) — Lookup — Foreign key → Vehicle Model.Product Name — NOT NULL
  • SAP Key (SAPKey__c) — TEXT
  • Field

Qoute Line Item (QuoteLineItem)

  • Line Item Number (LineNumber) — Auto Number — Primary key — NOT NULL
  • Quote Name (QuoteId) — M-D(Quote) — Foreign key → Quote.Quote Number — NOT NULL
  • Product Name (Name) — Lookup(Product) — Foreign key → Product.Vehicle Model (LTM) — NOT NULL
  • Key — Foreign key → Quote.Quote Name — NOT NULL
  • Name (Name2) — Foreign key → Quote.Opportunity Name — NOT NULL

Quote

  • Quote Number (QuoteNumber) — Auto Number — Primary key — NOT NULL
  • Quote Name (Name) — TEXT — Primary key — NOT NULL
  • Opportunity Name (OpportunityId) — M-D(Opportunity) — Foreign key → Opportunity.Name — NOT NULL

Vehicle Model (VehicleModel__c)

  • Product Name (Name) — TEXT — Primary key — NOT NULL
  • External ID (External_ID__c) — TEXT
  • Field

Vehicle Reservation (VehicleReservation__c)