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)