AM
AMBomItemActive2
Projection for max valid revision and to display unique bom ids for Active BOMs only
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActiveFlgNonexistent in DBObsolete | bool? | Active | - | |
Description:Unbound field indicating BOM Status = Active. Obsolete field for endpoint support only. | ||||
Approved | bit | Approved | - | |
Description:A Boolean value that indicates whether the BOM item is approved. | ||||
BOMID | nvarchar(15) | BOM ID | AMBomItem | |
Description:The identifier of the bill of material. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:A description of the bill of material. The system copies the description to production orders that are created by using the bill of material. | ||||
EffEndDate | datetime | End Date | - | |
Description:The last date when the BOM revision was effective. | ||||
EffStartDate | datetime | Start Date | - | |
Description:The date when the BOM revision becomes effective. | ||||
Hold | bit | Hold | - | |
Description:A Boolean value that indicates whether the BOM item is on hold. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The identifier of the stock item that is produced by using the bill of material. | ||||
IsProcessMFG | bit | Process Manufacturing | - | |
Description:Is the document linked to the Process Manufacturing feature. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineCntrAttribute | int | - | ||
Description:The counter for attribute lines. | ||||
LineCntrOperation | int | Operation Line Cntr | - | |
Description:The counter for operation lines. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:The owner of the BOM. | ||||
RejectedNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the BOM item is rejected. | ||||
RevisionID | nvarchar(10) | Revision | AMBomItem | |
Description:The identifier of the BOM revision, which is the modification of the bill of material. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Unbound Selected field | ||||
SiteID | int | Warehouse | INSite | |
Description:The warehouse ID. | ||||
Status | char(1) | Status | - | |
Description:The status of the revision. | ||||
SubItemID | int | Subitem | INSubItem | |
Description:The subitem of the stock item. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:The work group. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||