General informations
Fields (20)
| Name | Label | Type | Description |
|---|---|---|---|
| Id | Order Product ID | ID | |
| Product2Id | Product ID | LOOKUP | |
| IsDeleted | Deleted | CHECKBOX | |
| OrderId | Order ID | LOOKUP | |
| PricebookEntryId | Price Book Entry ID | LOOKUP | |
| OriginalOrderItemId | Original Order Item ID | LOOKUP | |
| AvailableQuantity | Available Quantity | NUMBER(16,2) | |
| Quantity | Quantity | NUMBER(16,2) | |
| UnitPrice | Unit Price | CURRENCY(16,2) | |
| ListPrice | List Price | CURRENCY(16,2) | |
| TotalPrice | Total Price | CURRENCY(16,2) | |
| ServiceDate | Start Date | DATE | |
| EndDate | End Date | DATE | |
| Description | Line Description | TEXT(255) | |
| CreatedDate | Created Date | DATETIME | |
| CreatedById | Created By ID | LOOKUP | |
| LastModifiedDate | Last Modified Date | DATETIME | |
| LastModifiedById | Last Modified By ID | LOOKUP | |
| SystemModstamp | System Modstamp | DATETIME | |
| OrderItemNumber | Order Product Number | AUTO NUMBER |
Fields Details (20)
| Name | Id |
| Label | Order Product ID |
| Type | ID |
| Required | Yes |
| Name | Product2Id |
| Label | Product ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | IsDeleted |
| Label | Deleted |
| Type | CHECKBOX |
| Required | Yes |
| Default value | false |
| Name | OrderId |
| Label | Order ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Required | Yes |
| Name | PricebookEntryId |
| Label | Price Book Entry ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Required | Yes |
| Name | OriginalOrderItemId |
| Label | Original Order Item ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | AvailableQuantity |
| Label | Available Quantity |
| Type | NUMBER(16,2) |
| Name | Quantity |
| Label | Quantity |
| Type | NUMBER(16,2) |
| Required | Yes |
| Name | UnitPrice |
| Label | Unit Price |
| Type | CURRENCY(16,2) |
| Name | ListPrice |
| Label | List Price |
| Type | CURRENCY(16,2) |
| Name | TotalPrice |
| Label | Total Price |
| Type | CURRENCY(16,2) |
| Name | ServiceDate |
| Label | Start Date |
| Type | DATE |
| Name | EndDate |
| Label | End Date |
| Type | DATE |
| Name | Description |
| Label | Line Description |
| Type | TEXT(255) |
| Name | CreatedDate |
| Label | Created Date |
| Type | DATETIME |
| Required | Yes |
| Name | CreatedById |
| Label | Created By ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Required | Yes |
| Name | LastModifiedDate |
| Label | Last Modified Date |
| Type | DATETIME |
| Required | Yes |
| Name | LastModifiedById |
| Label | Last Modified By ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Required | Yes |
| Name | SystemModstamp |
| Label | System Modstamp |
| Type | DATETIME |
| Required | Yes |
| Name | OrderItemNumber |
| Label | Order Product Number |
| Type | AUTO NUMBER |
| Required | Yes |
Parents relationships(11)
Children relationships(6)
| Name | Parent object | Child object | Parent object field | Child object field |
|---|---|---|---|---|
| Product2 | Product2 | OrderItem |
|
|
| Order | Order | OrderItem |
|
|
| PricebookEntry | PricebookEntry | OrderItem |
|
|
| OriginalOrderItem | OrderItem | OrderItem |
|
|
| CreatedBy | User | OrderItem |
|
|
| LastModifiedBy | User | OrderItem |
|
|
Object User-defined metadata (0)
| Label | Value |
|---|