IN
INReplenishmentItem
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ABCCodeID | char(1) | ABC Code | INABCCode | |
Description:No description available | ||||
ABCCodeIsFixed | bit | Fixed ABC Code | - | |
Description:No description available | ||||
BasePrice | decimal | Current Price | - | |
Description:No description available | ||||
BasePriceDate | datetime | Effective Date | - | |
Description:No description available | ||||
BasePriceOverride | bit | Price Override | - | |
Description:No description available | ||||
BaseUnit | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
Commissionable | bit | Subject to Commission | - | |
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 | ||||
DecimalBaseUnit | bit | - | ||
Description:No description available | ||||
DefaultSubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
DefaultVendorLocationID | int | Default Location | - | |
Description:No description available | ||||
DemandCalculationNonexistent in DB | string | Demand Calculation | - | |
Description:No description available | ||||
Descr | nvarchar(255) | Description | - | |
Description:No description available | ||||
DfltPurchaseUnit | nvarchar(6) | Purchase Unit | INUnit | |
Description:No description available | ||||
DfltReceiptLocationID | int | Default Receipt To | INLocation | |
Description:No description available | ||||
DfltSalesUnit | nvarchar(6) | Sales Unit | INUnit | |
Description:No description available | ||||
DfltShipLocationID | int | Default Issue From | INLocation | |
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 | ||||
InventoryCD | nvarchar | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtAcctID | int | Inventory Account | Account | |
Description:No description available | ||||
InvtSubID | int | Inventory Sub. | Sub | |
Description:No description available | ||||
IsDefaultNonexistent in DB | bool? | 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 | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(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 | 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 | Reorder Point | - | |
Description:No description available | ||||
MinQtyOverride | bit | Override | - | |
Description:No description available | ||||
MovementClassID | nvarchar(1) | Movement Class | INMovementClass | |
Description:No description available | ||||
MovementClassIsFixed | bit | Fixed Movement Class | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
POCreateNonexistent in DB | bool? | - | ||
Description:No description available | ||||
PendingBasePrice | decimal | Pending Price | - | |
Description:No description available | ||||
PendingBasePriceDate | datetime | Pending Price Date | - | |
Description:No description available | ||||
PendingStdCost | decimal | Pending Cost | - | |
Description:No description available | ||||
PendingStdCostDate | datetime | Pending Cost Date | - | |
Description:No description available | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:Planning method | ||||
PreferredVendorID | int | Preferred Vendor ID | Vendor | |
Description:No description available | ||||
PreferredVendorLocationID | int | Preferred Location | 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 | Contact | |
Description:No description available | ||||
PriceWorkgroupID | int | Price Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | EPEmployee | |
Description:No description available | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
PurchaseERQNonexistent in DB | decimal? | Purchase ERQ | - | |
Description:No description available | ||||
PurchaseUnit | nvarchar(6) | Purchase UOM | INUnit | |
Description:No description available | ||||
QtyDemandNonexistent in DB | decimal? | Qty. on Demand | - | |
Description:No description available | ||||
QtyFSSrvOrdAllocatedNonexistent in DB | decimal? | Qty. FS Allocated | - | |
Description:No description available | ||||
QtyFSSrvOrdBookedNonexistent in DB | decimal? | Qty. FS Booked | - | |
Description:No description available | ||||
QtyFSSrvOrdPreparedNonexistent in DB | decimal? | Qty. FS Prepared | - | |
Description:No description available | ||||
QtyFixedSOPODiffNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
QtyHardDemandNonexistent in DB | decimal? | Qty. on Hard Demand | - | |
Description:No description available | ||||
QtyINAssemblyDemandNonexistent in DB | decimal? | Qty. IN Assembly Demand | - | |
Description:No description available | ||||
QtyINAssemblySupplyNonexistent in DB | decimal? | Qty. IN Assembly Supply | - | |
Description:No description available | ||||
QtyINIssuesNonexistent in DB | decimal? | Qty. IN Issues | - | |
Description:No description available | ||||
QtyINReceiptsNonexistent in DB | decimal? | Qty. IN Receipts | - | |
Description:No description available | ||||
QtyINReplanedNonexistent in DB | decimal? | Replenishment Qty. | - | |
Description:No description available | ||||
QtyInTransitNonexistent in DB | decimal? | Qty. IN Transit | - | |
Description:No description available | ||||
QtyInTransitToProductionNonexistent in DB | decimal? | Qty In Transit to Production | - | |
Description:No description available | ||||
QtyNotAvailNonexistent in DB | decimal? | Qty. Not Available | - | |
Description:No description available | ||||
QtyOnHandNonexistent in DB | decimal? | Qty. on Hand | - | |
Description:No description available | ||||
QtyPOFixedProductionOrdersNonexistent in DB | decimal? | Qty on Purchase for Production | - | |
Description:No description available | ||||
QtyPOFixedProductionPreparedNonexistent in DB | decimal? | Qty on Purchase for Prod. Prepared | - | |
Description:No description available | ||||
QtyPOOrdersNonexistent in DB | decimal? | Qty. PO Orders | - | |
Description:No description available | ||||
QtyPOPreparedNonexistent in DB | decimal? | Qty. PO Prepared | - | |
Description:No description available | ||||
QtyPOReceiptsNonexistent in DB | decimal? | Qty. PO Receipts | - | |
Description:No description available | ||||
QtyProcessNonexistent in DB | decimal? | Qty. To Process | - | |
Description:No description available | ||||
QtyProcessIntNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
QtyProcessRoundedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
QtyProdFixedProdOrdersNonexistent in DB | decimal? | Qty on Production for Production | - | |
Description:No description available | ||||
QtyProdFixedProdOrdersPreparedNonexistent in DB | decimal? | Qty on Production for Prod. Prepared | - | |
Description:No description available | ||||
QtyProdFixedProductionNonexistent in DB | decimal? | Qty on Production to Production | - | |
Description:No description available | ||||
QtyProdFixedPurchaseNonexistent in DB | decimal? | Qty on Production to Purchase | - | |
Description:No description available | ||||
QtyProdFixedSalesOrdersNonexistent in DB | decimal? | Qty on Production for SO | - | |
Description:No description available | ||||
QtyProdFixedSalesOrdersPreparedNonexistent in DB | decimal? | Qty on Production for SO Prepared | - | |
Description:No description available | ||||
QtyProductionAllocatedNonexistent in DB | decimal? | Qty on Production Allocated | - | |
Description:No description available | ||||
QtyProductionDemandNonexistent in DB | decimal? | Qty on Production Demand | - | |
Description:No description available | ||||
QtyProductionDemandPreparedNonexistent in DB | decimal? | Qty on Production Demand Prepared | - | |
Description:No description available | ||||
QtyProductionSupplyNonexistent in DB | decimal? | Qty on Production Supply | - | |
Description:No description available | ||||
QtyProductionSupplyPreparedNonexistent in DB | decimal? | Qty Production Supply Prepared | - | |
Description:No description available | ||||
QtyReplenishmentNonexistent in DB | decimal? | Qty. on Supply | - | |
Description:No description available | ||||
QtySOBackOrderedNonexistent in DB | decimal? | Qty. SO Back Ordered | - | |
Description:No description available | ||||
QtySOBookedNonexistent in DB | decimal? | Qty. SO Booked | - | |
Description:No description available | ||||
QtySOFixedProductionNonexistent in DB | decimal? | Qty on SO to Production | - | |
Description:No description available | ||||
QtySOPreparedNonexistent in DB | decimal? | Qty. SO Prepared | - | |
Description:No description available | ||||
QtySOShippedNonexistent in DB | decimal? | Qty. SO Shipped | - | |
Description:No description available | ||||
QtySOShippingNonexistent in DB | 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 | INSite | |
Description:No description available | ||||
SafetyStock | decimal | Safety Stock | - | |
Description:No description available | ||||
SafetyStockOverride | bit | Override | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteCD | nvarchar(30) | Warehouse ID | INSite | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SiteStatus | char(2) | Status | - | |
Description:No description available | ||||
StdCost | decimal | Current Cost | - | |
Description:No description available | ||||
StdCostDate | datetime | Effective Date | - | |
Description:No description available | ||||
StdCostOverride | bit | Std. Cost Override | - | |
Description:No description available | ||||
SubItemCD | nvarchar(30) | Subitem ID | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
TerminationDateOverride | bit | Override | - | |
Description:No description available | ||||
TransferERQ | decimal | Transfer ERQ | - | |
Description:No description available | ||||
TransferERQOverride | bit | Override | - | |
Description:No description available | ||||
ValMethod | char(1) | - | ||
Description:No description available | ||||
VendorClassID | nvarchar(10) | Vendor Class | VendorClass | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||