AM
AMProdItem
PX.Objects.AM112 of 112 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | - | |
Description:No description available | ||||
AutoBackwardReporting | bit | Automatic Backward Reporting | - | |
Description:No description available | ||||
BaseQtyComplete | decimal(25, 6) | Base Qty Complete | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal | Base Qty Remaining | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQtytoProd | decimal(25, 6) | Base Qty to Produce | - | |
Description:No description available | ||||
BOMEffDate | datetime2 | Source Date | - | |
Description:No description available | ||||
BOMID | nvarchar(15) | BOM ID | - | |
Description:No description available | ||||
BOMRevisionID | nvarchar(10) | BOM Revision | AMBomItem | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
BuildProductionBomNonexistent in DB | bit | - | ||
Description:No description available | ||||
Canceled | bit | Canceled | - | |
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
ConstDate | datetime2 | Constraint | - | |
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
CostMethod | int | Costing Method | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CustomerID | int | Customer | BAccount | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
DemandPlanID | bigint | Demand Plan ID | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Order Description | - | |
Description:No description available | ||||
DetailSource | int | Source | - | |
Description:No description available | ||||
DueDate | datetime2 | Due Date | - | |
Description:No description available | ||||
DueDateDiff | int | Due Date Diff. | - | |
Description:No description available | ||||
EndDate | datetime2 | End Date | - | |
Description:No description available | ||||
EstimateID | nvarchar(15) | Estimate ID | AMEstimateItem | |
Description:No description available | ||||
EstimateRevisionID | nvarchar(10) | Estimate Revision | AMEstimateItem | |
Description:No description available | ||||
ExcludeFromMRP | bit | Exclude from MRP | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
FirmSchedule | bit | Firm Schedule | - | |
Description:No description available | ||||
FirstOperationID | int | First Operation ID | AMProdOper | |
Description:No description available | ||||
FMLTime | bit | Use Fixed Mfg Lead Times for Order Dates | - | |
Description:No description available | ||||
FMLTMRPOrdorOP | bit | Use Order Start Date for MRP | - | |
Description:No description available | ||||
Function | int | Function | - | |
Description:No description available | ||||
HasTransactions | bit | HasTransactions | - | |
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsConfigurableNonexistent in DB | bit | Is Configurable | - | |
Description:No description available | ||||
IsOnTimeOverhead | bit | On-Time Overhead | - | |
Description:No description available | ||||
IsOpen | bit | IsOpen | - | |
Description:No description available | ||||
IsProcessMFG | bit | Process Manufacturing | - | |
Description:No description available | ||||
IsReportPrinted | bit | Report Printed | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastOperationID | int | Last Operation ID | AMProdOper | |
Description:No description available | ||||
LineCntrAttribute | int | - | ||
Description:No description available | ||||
LineCntrEvnt | int | Event Line Cntr | - | |
Description:No description available | ||||
LineCntrOperation | int | Operation Line Cntr | - | |
Description:No description available | ||||
LineQtyAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LineQtyHardAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
Locked | bit | Locked | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrdLineRef | int | SO Line Nbr. | - | |
Description:No description available | ||||
OrdNbr | nvarchar(15) | SO Order Nbr. | SOOrder | |
Description:No description available | ||||
OrdTypeRef | char(2) | SO Order Type | - | |
Description:No description available | ||||
ParentLotSerialRequired | char(1) | Require Parent Lot/Serial Number | - | |
Description:No description available | ||||
ParentOrderType | char(2) | Parent Order Type | AMOrderType | |
Description:No description available | ||||
ParentOrdID | nvarchar(19) | Parent Production Nbr. | - | |
Description:No description available | ||||
PerClose | char(6) | Period Closed | - | |
Description:No description available | ||||
PerEnt | char(6) | Entered Period | - | |
Description:No description available | ||||
PreassignLotSerial | bit | Allow Preassigning Lot/Serial Numbers | - | |
Description:No description available | ||||
ProdDate | datetime2 | Order Date | - | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | Contact | |
Description:No description available | ||||
ProductOrderType | char(2) | Product Order Type | AMOrderType | |
Description:No description available | ||||
ProductOrdID | nvarchar(19) | Product Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
QtyComplete | decimal(25, 6) | Qty. Complete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal | Qty. Remaining | - | |
Description:No description available | ||||
QtyScrapped | decimal(25, 6) | Qty. Scrapped | - | |
Description:No description available | ||||
QtytoProd | decimal(25, 6) | Qty. to Produce | - | |
Description:No description available | ||||
RelDate | datetime2 | Release Date | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
RescheduleNonexistent in DB | bit | - | ||
Description:No description available | ||||
ScheduleStatus | char(1) | Schedule Status | - | |
Description:No description available | ||||
SchedulingMethod | char(1) | Scheduling Method | - | |
Description:No description available | ||||
SchPriority | smallint | Dispatch Priority | - | |
Description:No description available | ||||
ScrapLocationID | int | Scrap Location | INLocation | |
Description:No description available | ||||
ScrapOverride | bit | Scrap Override | - | |
Description:No description available | ||||
ScrapSiteID | int | Scrap Warehouse | INSite | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SourceOrderType | char(2) | Source Order Type | AMOrderType | |
Description:No description available | ||||
SourceProductionNbr | nvarchar(19) | Source Production Nbr | AMProdItem | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
StartDate | datetime2 | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
SubItemID | int | Subitem | AMBomItem | |
Description:No description available | ||||
SupplyType | int | Supply Type | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TranDateNonexistent in DB | datetime | Tran. Date | - | |
Description:No description available | ||||
TranType | nchar(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UpdateProject | bit | Update Project | - | |
Description:No description available | ||||
WIPAcctID | int | WIP Account | Account | |
Description:No description available | ||||
WIPBalanceNonexistent in DB | decimal | WIP Balance | - | |
Description:No description available | ||||
WIPComp | decimal(19, 4) | MFG to Inventory | - | |
Description:No description available | ||||
WIPSubID | int | WIP Subaccount | Sub | |
Description:No description available | ||||
WIPTotal | decimal(19, 4) | WIP Total | - | |
Description:No description available | ||||
WIPVarianceAcctID | int | WIP Variance Account | Account | |
Description:No description available | ||||
WIPVarianceSubID | int | WIP Variance Subaccount | Sub | |
Description:No description available | ||||