Skip to main content
PO

POFixedDemand

PX.Objects.PO
Field NameTypeDisplay NameForeign Key
PlanID
bigintINItemPlan
Description:No description available
ActiveNonexistent in DB
bitActive-
Description:No description available
AddLeadTimeDaysNonexistent in DB
smallintAdd. Lead Time (Days)-
Description:No description available
BAccountID
intBAccount
Description:No description available
CostCenterID
intINLotSerialStatusByCostCenter
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
CuryIDDefault NavigationNonexistent in DB
nvarchar(5)CurrencyCurrency
Description:No description available
DemandPlanIDDefault Navigation
bigint-
Description:No description available
DemandProjectIDNonexistent in DB
int-
Description:No description available
DemandUOM
varchar(MAX)UOM-
Description:No description available
EffPriceNonexistent in DB
decimalVendor Price-
Description:No description available
ExcludePlanLevel
int-
Description:No description available
ExtCostNonexistent in DB
decimalExtended Amt.-
Description:No description available
ExtVolumeNonexistent in DB
decimalVolume-
Description:No description available
ExtWeightNonexistent in DB
decimalWeight-
Description:No description available
FixedSource
char(1)Fixed Source-
Description:No description available
Hold
bitOn Hold-
Description:No description available
IgnoreOrigPlan
bit-
Description:No description available
InventoryIDDefault Navigation
intInventory IDInventoryItem
Description:No description available
IsSkippedWhenBackOrderedNonexistent in DB
bit-
Description:No description available
IsSpecialOrderNonexistent in DB
bit-
Description:No description available
IsTempLotSerialNonexistent in DB
bit-
Description:No description available
IsTemporaryNonexistent in DB
bit-
Description:No description available
ItemClassCDDefault Navigation
nvarchar(30)Class IDINItemClass
Description:No description available
KitInventoryIDDefault Navigation
intInventory IDInventoryItem
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
LocalizedPlanDescrNonexistent in DB
nvarchar(60)Plan Type-
Description:No description available
LocationIDDefault Navigation
intLocationINLocation
Description:No description available
LotSerialNbr
nvarchar(100)Lot/Serial Nbr.-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OrderQtyNonexistent in DB
decimalQuantity-
Description:No description available
OrigNoteID
uniqueidentifier-
Description:No description available
OrigPlanID
bigint-
Description:No description available
OrigPlanLevel
int-
Description:No description available
OrigPlanTypeDefault Navigation
char(2)Orig. Plan TypeINPlanType
Description:No description available
OrigUOM
nvarchar(6)-
Description:No description available
PlanDate
datetime2Planned On-
Description:No description available
PlanDescr
nvarchar(60)-
Description:No description available
PlanQty
decimal(25, 6)Requested Qty.-
Description:No description available
PlanTypeDefault Navigation
char(2)INPlanType
Description:No description available
PlanUnitQty
decimal-
Description:No description available
POSiteIDDefault Navigation
intWarehouseINSite
Description:No description available
PriceRecordID
int-
Description:No description available
ProjectID
int-
Description:No description available
RefEntityType
varchar(255)-
Description:No description available
RefNoteID
uniqueidentifierReference Nbr.-
Description:No description available
RequestedDate
datetime2Requested On-
Description:No description available
Reverse
bitReverse-
Description:No description available
SalesBranchIDNonexistent in DB
int-
Description:No description available
SalesCustomerIDDefault NavigationNonexistent in DB
intCustomerBAccount
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:No description available
SiteIDDefault Navigation
intWarehouseINSite
Description:No description available
SorterStringNonexistent in DB
nvarchar(MAX)-
Description:No description available
SourceSiteDescrNonexistent in DB
nvarchar(60)Demand Warehouse Description-
Description:No description available
SourceSiteIDDefault Navigation
intDemand WarehouseINSite
Description:No description available
SubItemIDDefault Navigation
intSubitemINSubItem
Description:No description available
SupplyPlanIDDefault Navigation
bigintINItemPlan
Description:No description available
TaskID
int-
Description:No description available
tstamp
timestamp-
Description:No description available
UnitMultDiv
char(1)-
Description:No description available
UnitRate
decimal-
Description:No description available
UOM
nvarchar(6)-
Description:No description available
VendorIDDefault Navigation
intVendorBAccount
Description:No description available
VendorLocationIDDefault Navigation
intLocation-
Description:No description available