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 |
---|