DMS FSL Custom

Tables (7)

Department (Department__c)

  • Department Id (Id) — Primary key — NOT NULL

Parts Inventory (PartsInventory__c)

  • Parts Inventory Id (Id) — Primary key — NOT NULL
  • Product Id (Product__c) — Foreign key → Product.Product Id — NOT NULL
  • Department Id (Department__c) — Foreign key → Department.Department Id — NOT NULL

Parts Inventory Transaction (PartsInventoryTransaction__c)

  • Transaction Id (Id) — Primary key — NOT NULL
  • Parts Inventory Id (PartsInventory__c) — Foreign key → Parts Inventory.Parts Inventory Id — NOT NULL

Parts Invoice (PartsInvoice__c)

  • Parts Invoice Id (Id) — Primary key — NOT NULL
  • Product Id (Product__c) — Foreign key → Product.Product Id — NOT NULL
  • Parts Order Line Item Id (PartsOrderLineItem__c) — Foreign key → Parts Order Line Item.Parts Order Line Item Id — NOT NULL

Parts Order (PartsOrder__c)

  • Parts Order Id (Id) — Primary key — NOT NULL
  • Department Id (Department__c) — Foreign key → Department.Department Id — NOT NULL

Parts Order Line Item (PartsOrderLineItem__c)

  • Parts Order Line Item Id (Id) — Primary key — NOT NULL
  • Product Id (Product__c) — Foreign key → Product.Product Id — NOT NULL
  • Parts Order Id (PartsOrder__c) — Foreign key → Parts Order.Parts Order Id — NOT NULL

Product (Product2)

  • Product Id (Id) — Primary key — NOT NULL