AM
AMBOMCurySettings
Multiple base currency table that is also used for all standard currencies when the FeaturesSet.Multicurrency feature is not enabled, to store the currency-specific costs against a bill of material. The table supports the costs for the types linked to the AMBomMatl (Material), AMBomOper (Operations), and (Tools) classes.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BOMID | nvarchar(15) | BOM ID | - | |
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 | ||||
CuryID | nvarchar(10) | Currency | - | |
Description:The currency ID. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineID | int | LineID | - | |
Description:The line ID. | ||||
LineType | char(1) | Line Type | - | |
Description:The line type. | ||||
LocationID | int | Location ID | - | |
Description:The warehouse location. | ||||
OperationID | int | Operation ID | - | |
Description:The operation ID. | ||||
RevisionID | nvarchar(10) | Revision | - | |
Description:The revision ID. | ||||
SiteID | int | Site ID | - | |
Description:The warehouse. | ||||
UnitCost | decimal | Unit Cost | - | |
Description:The unit cost. | ||||
VendorID | int | Vendor ID | - | |
Description:The vendor ID. | ||||
VendorLocationID | int | Vendor Location ID | - | |
Description:The vendor location. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||