IN
INReplenishmentItem
PX.Objects.IN140 of 140 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
InventoryCD | nvarchar(MAX) | - | ||
Description:No description available | ||||
SiteCD | nvarchar(30) | Warehouse ID | - | |
Description:No description available | ||||
SubItemCD | nvarchar(30) | Subitem ID | - | |
Description:No description available | ||||
ABCCodeID | char(1) | ABC Code | - | |
Description:No description available | ||||
ABCCodeIsFixed | bit | Fixed ABC Code | - | |
Description:No description available | ||||
BasePrice | decimal | Current Price | - | |
Description:No description available | ||||
BasePriceDate | datetime2 | Effective Date | - | |
Description:No description available | ||||
BasePriceOverride | bit | Price Override | - | |
Description:No description available | ||||
BaseUnit | nvarchar(6) | UOM | - | |
Description:No description available | ||||
Commissionable | bit | Subject to Commission | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DecimalBaseUnit | bit | - | ||
Description:No description available | ||||
DefaultSubItemID | int | Subitem | - | |
Description:No description available | ||||
DefaultVendorLocationID | int | Default Location | - | |
Description:No description available | ||||
DemandCalculation | nchar(1) | Demand Calculation | - | |
Description:No description available | ||||
Descr | nvarchar(255) | Description | - | |
Description:No description available | ||||
DfltPurchaseUnit | nvarchar(6) | Purchase Unit | - | |
Description:No description available | ||||
DfltReceiptLocationID | int | Default Receipt To | - | |
Description:No description available | ||||
DfltSalesUnit | nvarchar(6) | Sales Unit | - | |
Description:No description available | ||||
DfltShipLocationID | int | Default Issue From | - | |
Description:No description available | ||||
InclQtyFSSrvOrdAllocated | bit | Deduct Qty. SrvOrd Allocated | - | |
Description:No description available | ||||
InclQtyFSSrvOrdBooked | bit | Deduct Qty. on Customer Service Orders | - | |
Description:No description available | ||||
InclQtyFSSrvOrdPrepared | bit | Deduct Qty. SrvOrd Prepared | - | |
Description:No description available | ||||
InclQtyINAssemblyDemand | bit | Deduct Qty. of Kit Assembly Demand | - | |
Description:No description available | ||||
InclQtyINIssues | bit | Deduct Qty. on Issues | - | |
Description:No description available | ||||
InclQtyProductionAllocated | bit | Deduct Qty. on Production Allocated | - | |
Description:No description available | ||||
InclQtyProductionDemand | bit | Deduct Qty. on Production Demand | - | |
Description:No description available | ||||
InclQtyProductionDemandPrepared | bit | Deduct Qty. on Production Demand Prepared | - | |
Description:No description available | ||||
InclQtyProductionSupply | bit | Include Qty. of Production Supply | - | |
Description:No description available | ||||
InclQtyProductionSupplyPrepared | bit | Include Qty. of Production Supply Prepared | - | |
Description:No description available | ||||
InclQtySOBackOrdered | bit | Deduct Qty. on Back Orders | - | |
Description:No description available | ||||
InclQtySOBooked | bit | Deduct Qty. on Customer Orders | - | |
Description:No description available | ||||
InclQtySOPrepared | bit | Deduct Qty. on Sales Prepared | - | |
Description:No description available | ||||
InclQtySOShipped | bit | Deduct Qty. Shipped | - | |
Description:No description available | ||||
InclQtySOShipping | bit | Deduct Qty. Shipping | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
InvtAcctID | int | Inventory Account | - | |
Description:No description available | ||||
InvtSubID | int | Inventory Sub. | - | |
Description:No description available | ||||
IsDefaultNonexistent in DB | bit | Default | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
LastBasePrice | decimal | Last Price | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastStdCost | decimal | Last Cost | - | |
Description:No description available | ||||
LaunchDate | datetime | Launch Date | - | |
Description:No description available | ||||
LaunchDateOverride | bit | Override | - | |
Description:No description available | ||||
MarkupPct | decimal | Markup % | - | |
Description:No description available | ||||
MarkupPctOverride | bit | Markup % Override | - | |
Description:No description available | ||||
MaxQty | decimal(16, 9) | Max. Qty. | - | |
Description:No description available | ||||
MaxQtyOverride | bit | Override | - | |
Description:No description available | ||||
MaxShelfLife | int | Max. Shelf Life (Days) | - | |
Description:No description available | ||||
MaxShelfLifeOverride | bit | Override | - | |
Description:No description available | ||||
MinQty | decimal(16, 9) | Reorder Point | - | |
Description:No description available | ||||
MinQtyOverride | bit | Override | - | |
Description:No description available | ||||
MovementClassID | nvarchar(1) | Movement Class | - | |
Description:No description available | ||||
MovementClassIsFixed | bit | Fixed Movement Class | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PendingBasePrice | decimal | Pending Price | - | |
Description:No description available | ||||
PendingBasePriceDate | datetime2 | Pending Price Date | - | |
Description:No description available | ||||
PendingStdCost | decimal | Pending Cost | - | |
Description:No description available | ||||
PendingStdCostDate | datetime2 | Pending Cost Date | - | |
Description:No description available | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:No description available | ||||
POCreate | bit | - | ||
Description:No description available | ||||
PreferredVendorID | int | Preferred Vendor ID | - | |
Description:No description available | ||||
PreferredVendorLocationID | int | Preferred Location | - | |
Description:No description available | ||||
PreferredVendorName | nvarchar(60) | Preferred Vendor Name | - | |
Description:No description available | ||||
PreferredVendorOverride | bit | Preferred Vendor Override | - | |
Description:No description available | ||||
PriceManagerID | int | Price Manager | - | |
Description:No description available | ||||
PriceWorkgroupID | int | Price Workgroup | - | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | - | |
Description:No description available | ||||
ProductWorkgroupID | int | Product Workgroup | - | |
Description:No description available | ||||
PurchaseERQ | decimal | Purchase ERQ | - | |
Description:No description available | ||||
PurchaseUnit | nvarchar(6) | Purchase UOM | - | |
Description:No description available | ||||
QtyDemand | decimal | Qty. on Demand | - | |
Description:No description available | ||||
QtyFixedSOPODiff | decimal | - | ||
Description:No description available | ||||
QtyFSSrvOrdAllocated | decimal | Qty. FS Allocated | - | |
Description:No description available | ||||
QtyFSSrvOrdBooked | decimal | Qty. FS Booked | - | |
Description:No description available | ||||
QtyFSSrvOrdPrepared | decimal | Qty. FS Prepared | - | |
Description:No description available | ||||
QtyHardDemand | decimal | Qty. on Hard Demand | - | |
Description:No description available | ||||
QtyINAssemblyDemand | decimal | Qty. IN Assembly Demand | - | |
Description:No description available | ||||
QtyINAssemblySupply | decimal | Qty. IN Assembly Supply | - | |
Description:No description available | ||||
QtyINIssues | decimal | Qty. IN Issues | - | |
Description:No description available | ||||
QtyINReceipts | decimal | Qty. IN Receipts | - | |
Description:No description available | ||||
QtyINReplaned | decimal | Replenishment Qty. | - | |
Description:No description available | ||||
QtyInTransit | decimal | Qty. IN Transit | - | |
Description:No description available | ||||
QtyInTransitToProduction | decimal | Qty In Transit to Production | - | |
Description:No description available | ||||
QtyNotAvail | decimal | Qty. Not Available | - | |
Description:No description available | ||||
QtyOnHand | decimal | Qty. on Hand | - | |
Description:No description available | ||||
QtyPOFixedProductionOrders | decimal | Qty on Purchase for Production | - | |
Description:No description available | ||||
QtyPOFixedProductionPrepared | decimal | Qty on Purchase for Prod. Prepared | - | |
Description:No description available | ||||
QtyPOOrders | decimal | Qty. PO Orders | - | |
Description:No description available | ||||
QtyPOPrepared | decimal | Qty. PO Prepared | - | |
Description:No description available | ||||
QtyPOReceipts | decimal | Qty. PO Receipts | - | |
Description:No description available | ||||
QtyProcessNonexistent in DB | decimal | Qty. To Process | - | |
Description:No description available | ||||
QtyProcessInt | decimal | - | ||
Description:No description available | ||||
QtyProcessRoundedNonexistent in DB | bit | - | ||
Description:No description available | ||||
QtyProdFixedProdOrders | decimal | Qty on Production for Production | - | |
Description:No description available | ||||
QtyProdFixedProdOrdersPrepared | decimal | Qty on Production for Prod. Prepared | - | |
Description:No description available | ||||
QtyProdFixedProduction | decimal | Qty on Production to Production | - | |
Description:No description available | ||||
QtyProdFixedPurchase | decimal | Qty on Production to Purchase | - | |
Description:No description available | ||||
QtyProdFixedSalesOrders | decimal | Qty on Production for SO | - | |
Description:No description available | ||||
QtyProdFixedSalesOrdersPrepared | decimal | Qty on Production for SO Prepared | - | |
Description:No description available | ||||
QtyProductionAllocated | decimal | Qty on Production Allocated | - | |
Description:No description available | ||||
QtyProductionDemand | decimal | Qty on Production Demand | - | |
Description:No description available | ||||
QtyProductionDemandPrepared | decimal | Qty on Production Demand Prepared | - | |
Description:No description available | ||||
QtyProductionSupply | decimal | Qty on Production Supply | - | |
Description:No description available | ||||
QtyProductionSupplyPrepared | decimal | Qty Production Supply Prepared | - | |
Description:No description available | ||||
QtyReplenishment | decimal | Qty. on Supply | - | |
Description:No description available | ||||
QtySOBackOrdered | decimal | Qty. SO Back Ordered | - | |
Description:No description available | ||||
QtySOBooked | decimal | Qty. SO Booked | - | |
Description:No description available | ||||
QtySOFixedProduction | decimal | Qty on SO to Production | - | |
Description:No description available | ||||
QtySOPrepared | decimal | Qty. SO Prepared | - | |
Description:No description available | ||||
QtySOShipped | decimal | Qty. SO Shipped | - | |
Description:No description available | ||||
QtySOShipping | decimal | Qty. SO Allocated | - | |
Description:No description available | ||||
RecPrice | decimal | MSRP | - | |
Description:No description available | ||||
RecPriceOverride | bit | Price Override | - | |
Description:No description available | ||||
ReplenishmentMethod | char(1) | Replenishment Method | - | |
Description:No description available | ||||
ReplenishmentPolicyID | nvarchar(10) | Replenishment Policy ID | INReplenishmentPolicy | |
Description:No description available | ||||
ReplenishmentPolicyOverride | bit | Replenishment Policy Override | - | |
Description:No description available | ||||
ReplenishmentSource | char(1) | Replenishment Source | - | |
Description:No description available | ||||
ReplenishmentSourceSiteID | int | Source Warehouse | - | |
Description:No description available | ||||
SafetyStock | decimal(16, 9) | Safety Stock | - | |
Description:No description available | ||||
SafetyStockOverride | bit | Override | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SiteStatus | char(2) | Status | - | |
Description:No description available | ||||
StdCost | decimal | Current Cost | - | |
Description:No description available | ||||
StdCostDate | datetime2 | Effective Date | - | |
Description:No description available | ||||
StdCostOverride | bit | Std. Cost Override | - | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
TerminationDateOverride | bit | Override | - | |
Description:No description available | ||||
TransferERQ | decimal(16, 9) | Transfer ERQ | - | |
Description:No description available | ||||
TransferERQOverride | bit | Override | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
ValMethod | char(1) | - | ||
Description:No description available | ||||
VendorClassID | nvarchar(10) | Vendor Class | VendorClass | |
Description:No description available | ||||