Skip to main content
AM

ProductionReadinessByProdItem

PX.Objects.AM
Field NameTypeDisplay NameForeign Key
ProdOrdIDDefault Navigation
nvarchar(19)Production Nbr.-
Description:No description available
AutoBackwardReporting
bitAutomatic Backward Reporting-
Description:No description available
BaseQtyComplete
decimalBase Qty Complete-
Description:No description available
BaseQtyRemainingNonexistent in DB
decimalBase Qty Remaining-
Description:No description available
BaseQtyScrapped
decimal-
Description:No description available
BaseQtytoProd
decimalBase Qty to Produce-
Description:No description available
BOMEffDate
datetime2Source Date-
Description:No description available
BOMIDDefault Navigation
nvarchar(15)BOM ID-
Description:No description available
BOMRevisionIDDefault Navigation
nvarchar(10)BOM RevisionAMBomItem
Description:No description available
BranchIDDefault Navigation
intBranchBranch
Description:No description available
BuildProductionBomNonexistent in DB
bit-
Description:No description available
Canceled
bitCanceled-
Description:No description available
Closed
bitClosed-
Description:No description available
Completed
bitCompleted-
Description:No description available
ConstDate
datetime2Constraint-
Description:No description available
CostCenterID
intINLotSerialStatusByCostCenter
Description:No description available
CostCodeIDDefault Navigation
intCost Code-
Description:No description available
CostMethod
intCosting Method-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
varchar(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CustomerIDDefault Navigation
intCustomerBAccount
Description:No description available
CustomerLocationIDDefault Navigation
intLocationLocation
Description:No description available
DemandPlanID
bigintDemand Plan ID-
Description:No description available
Descr
nvarchar(256)Order Description-
Description:No description available
DetailSource
intSource-
Description:No description available
DueDate
datetime2Due Date-
Description:No description available
DueDateDiff
intDue Date Diff.-
Description:No description available
EndDate
datetime2End Date-
Description:No description available
EstimateIDDefault Navigation
nvarchar(15)Estimate IDAMEstimateItem
Description:No description available
EstimateRevisionIDDefault Navigation
nvarchar(10)Estimate RevisionAMEstimateItem
Description:No description available
ExcludeFromMRP
bitExclude from MRP-
Description:No description available
ExpireDate
datetime2Expiration Date-
Description:No description available
FirmSchedule
bitFirm Schedule-
Description:No description available
FirstOperationIDDefault Navigation
intFirst Operation ID-
Description:No description available
FMLTime
bitUse Fixed Mfg Lead Times for Order Dates-
Description:No description available
FMLTMRPOrdorOP
bitUse Order Start Date for MRP-
Description:No description available
Function
intFunction-
Description:No description available
HasTransactions
bitHasTransactions-
Description:No description available
Hold
bitHold-
Description:No description available
InventoryIDDefault Navigation
intInventory IDInventoryItem
Description:No description available
InvtMult
smallint-
Description:No description available
IsConfigurableNonexistent in DB
bitIs Configurable-
Description:No description available
IsOnTimeOverhead
bitOn-Time Overhead-
Description:No description available
IsOpen
bitIsOpen-
Description:No description available
IsProcessMFG
bitProcess Manufacturing-
Description:No description available
IsReportPrinted
bitReport Printed-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
varchar(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LastOperationIDDefault Navigation
intLast Operation ID-
Description:No description available
LineCntrAttribute
int-
Description:No description available
LineCntrEvnt
intEvent Line Cntr-
Description:No description available
LineCntrOperation
intOperation Line Cntr-
Description:No description available
LineQtyAvailNonexistent in DB
decimal-
Description:No description available
LineQtyHardAvailNonexistent in DB
decimal-
Description:No description available
LocationIDDefault Navigation
intLocation-
Description:No description available
Locked
bitLocked-
Description:No description available
LotSerialNbrDefault Navigation
nvarchar(100)Lot/Serial Nbr.-
Description:No description available
MaxQtyToProd
decimalMax Qty. to Produce-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OrderTypeDefault Navigation
char(2)Order TypeAMOrderType
Description:No description available
OrdLineRef
intSO Line Nbr.-
Description:No description available
OrdNbrDefault Navigation
nvarchar(15)SO Order Nbr.SOOrder
Description:No description available
OrdTypeRef
char(2)SO Order Type-
Description:No description available
ParentLotSerialRequired
varchar(1)Require Parent Lot/Serial Number-
Description:No description available
ParentOrderTypeDefault Navigation
char(2)Parent Order TypeAMOrderType
Description:No description available
ParentOrdIDDefault Navigation
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
bitAllow Preassigning Lot/Serial Numbers-
Description:No description available
ProdDate
datetime2Order Date-
Description:No description available
ProductManagerIDDefault Navigation
intProduct ManagerContact
Description:No description available
ProductOrderTypeDefault Navigation
char(2)Product Order TypeAMOrderType
Description:No description available
ProductOrdIDDefault Navigation
nvarchar(19)Product Production Nbr.AMProdItem
Description:No description available
ProductWorkgroupIDDefault Navigation
intProduct WorkgroupEPCompanyTree
Description:No description available
ProjectIDDefault Navigation
intProjectPMProject
Description:No description available
QtyComplete
decimalQty. Complete-
Description:No description available
QtyReadyToProdNonexistent in DB
decimalQty. Ready to Produce-
Description:No description available
QtyRemainingNonexistent in DB
decimalQty. Remaining-
Description:No description available
QtyScrapped
decimalQty. Scrapped-
Description:No description available
QtytoProd
decimalQty. to Produce-
Description:No description available
ReadinessToProd
nvarchar(1)Readiness to Produce-
Description:No description available
RelDate
datetime2Release Date-
Description:No description available
Released
bitReleased-
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
smallintDispatch Priority-
Description:No description available
ScrapLocationIDDefault Navigation
intScrap LocationINLocation
Description:No description available
ScrapOverride
bitScrap Override-
Description:No description available
ScrapSiteIDDefault Navigation
intScrap WarehouseINSite
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:No description available
SiteIDDefault Navigation
intWarehouseINLocation
Description:No description available
SourceOrderTypeDefault Navigation
char(2)Source Order TypeAMOrderType
Description:No description available
SourceProductionNbrDefault Navigation
nvarchar(19)Source Production NbrAMProdItem
Description:No description available
SplitLineCntr
int-
Description:No description available
StartDate
datetime2Start Date-
Description:No description available
StatusID
char(1)Status-
Description:No description available
SubItemIDDefault Navigation
intSubitemAMBomItem
Description:No description available
SupplyType
intSupply Type-
Description:No description available
TaskIDDefault Navigation
intProject TaskPMTask
Description:No description available
TranDateNonexistent in DB
datetimeTran. Date-
Description:No description available
TranType
nchar(3)Tran. Type-
Description:No description available
tstamp
timestamp-
Description:No description available
UnassignedQty
decimal-
Description:No description available
UOMDefault Navigation
nvarchar(6)UOMINUnit
Description:No description available
UpdateProject
bitUpdate Project-
Description:No description available
WIPAcctIDDefault Navigation
intWIP AccountAccount
Description:No description available
WIPBalanceNonexistent in DB
decimalWIP Balance-
Description:No description available
WIPComp
decimalMFG to Inventory-
Description:No description available
WIPSubIDDefault Navigation
intWIP SubaccountSub
Description:No description available
WIPTotal
decimalWIP Total-
Description:No description available
WIPVarianceAcctIDDefault Navigation
intWIP Variance AccountAccount
Description:No description available
WIPVarianceSubIDDefault Navigation
intWIP Variance SubaccountSub
Description:No description available