DR
DRSingleProcess.ComponentINItem
PX.Objects.DR142 of 142 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
InventoryCD | nvarchar(MAX) | Inventory ID | - | |
Description:No description available | ||||
ABCCodeID | char(1) | ABC Code | INABCCode | |
Description:No description available | ||||
ABCCodeIsFixed | bit | Fixed ABC Code | - | |
Description:No description available | ||||
AttributeDescriptionGroupID | int | - | ||
Description:No description available | ||||
AttributesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
Availability | varchar(1) | Availability | - | |
Description:No description available | ||||
AvailabilityAdjustment | decimal | Availability Adjustment | - | |
Description:No description available | ||||
BaseItemVolume | decimal | Volume | - | |
Description:No description available | ||||
BaseItemWeight | decimal | Weight | - | |
Description:No description available | ||||
BasePriceObsolete | decimal | Default Price | - | |
Description:No description available | ||||
BaseUnit | nvarchar(6) | Base Unit | INUnit | |
Description:No description available | ||||
BaseVolume | decimal | Volume | - | |
Description:No description available | ||||
BaseWeight | decimal | - | ||
Description:No description available | ||||
Body | nvarchar(MAX) | Content | - | |
Description:No description available | ||||
COGSAcctID | int | COGS Account | Account | |
Description:No description available | ||||
COGSSubID | int | COGS Sub. | Sub | |
Description:No description available | ||||
ColumnAttributeValue | nvarchar(255) | - | ||
Description:No description available | ||||
Commisionable | bit | Subject to Commission | - | |
Description:No description available | ||||
CommodityCodeType | nvarchar(30) | Commodity Code Type | - | |
Description:No description available | ||||
CompletePOLine | char(1) | Close PO Line | - | |
Description:No description available | ||||
CostBasis | char(1) | Cost Based On | - | |
Description:No description available | ||||
CountryOfOrigin | nvarchar(100) | Country Of Origin | Country | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CycleID | nvarchar(10) | PI Cycle | INPICycle | |
Description:No description available | ||||
DecimalBaseUnit | bit | Divisible Unit | - | |
Description:No description available | ||||
DecimalPurchaseUnit | bit | Divisible Unit | - | |
Description:No description available | ||||
DecimalSalesUnit | bit | Divisible Unit | - | |
Description:No description available | ||||
DefaultColumnMatrixAttributeID | nvarchar(10) | Default Column Attribute ID | CSAnswers | |
Description:No description available | ||||
DefaultCostCodeID | int | Default Cost Code | PMCostCode | |
Description:No description available | ||||
DefaultInventorySourceForProjects | char(1) | Default Inventory Source for Projects | - | |
Description:No description available | ||||
DefaultRowMatrixAttributeID | nvarchar(10) | Default Row Attribute ID | CSAnswers | |
Description:No description available | ||||
DefaultSubItemID | int | Default Subitem | INSubItem | |
Description:No description available | ||||
DefaultSubItemOnEntry | bit | Use On Entry | - | |
Description:No description available | ||||
DefaultTerm | decimal | Default Term | - | |
Description:No description available | ||||
DefaultTermUOM | char(1) | Default Term UOM | - | |
Description:No description available | ||||
DeferralAcctID | int | Deferral Account | Account | |
Description:No description available | ||||
DeferralSubID | int | Deferral Sub. | Sub | |
Description:No description available | ||||
DeferredCode | nvarchar(10) | Deferral Code | DRDeferredCode | |
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DfltReceiptLocationIDObsolete | int | Default Receipt To | INLocation | |
Description:No description available | ||||
DfltShipLocationIDObsolete | int | Default Issue From | INLocation | |
Description:No description available | ||||
DfltSiteIDObsolete | int | Default Warehouse | INSite | |
Description:No description available | ||||
DiscAcctIDNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
DiscSubIDNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
ExpenseAccrualAcctIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ExpenseAccrualSubIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ExpenseAcctIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ExpenseSubIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ExportToExternal | bit | Export to External System | - | |
Description:No description available | ||||
GenerationRuleCntr | int | - | ||
Description:No description available | ||||
GroupMask | varbinary | - | ||
Description:No description available | ||||
HasChildNonexistent in DB | bit | - | ||
Description:No description available | ||||
HSTariffCode | nvarchar(30) | Commodity Code | - | |
Description:No description available | ||||
ImageUrl | nvarchar(255) | Image | - | |
Description:No description available | ||||
IncludedNonexistent in DB | bit | Included | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
InvtAcctID | int | Inventory Account | Account | |
Description:No description available | ||||
InvtSubID | int | Inventory Sub. | Sub | |
Description:No description available | ||||
IsConversionModeNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsConverted | bit | Is Converted | - | |
Description:No description available | ||||
IsSpecialOrderItem | bit | Special-Order Item | - | |
Description:No description available | ||||
IsSplitted | bit | Split into Components | - | |
Description:No description available | ||||
IsTemplate | bit | - | ||
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemStatus | char(2) | Item Status | - | |
Description:No description available | ||||
ItemType | char(1) | Type | - | |
Description:No description available | ||||
KitItem | bit | Is a Kit | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LastSiteID | int | INSite | ||
Description:No description available | ||||
LastStdCostObsolete | decimal | Last Cost | - | |
Description:No description available | ||||
LCVarianceAcctID | int | Landed Cost Variance Account | Account | |
Description:No description available | ||||
LCVarianceSubID | int | Landed Cost Variance Sub. | Sub | |
Description:No description available | ||||
LotSerClassID | nvarchar(10) | Lot/Serial Class | INLotSerClass | |
Description:No description available | ||||
MarkupPct | decimal | Markup % | - | |
Description:No description available | ||||
MinGrossProfitPct | decimal | Min. Markup % | - | |
Description:No description available | ||||
MovementClassID | varchar(1) | Movement Class | INMovementClass | |
Description:No description available | ||||
MovementClassIsFixed | bit | Fixed Movement Class | - | |
Description:No description available | ||||
NegQtyNonexistent in DB | bit | - | ||
Description:No description available | ||||
NonStockReceipt | bit | Require Receipt | - | |
Description:No description available | ||||
NonStockReceiptAsService | bit | Process Item via Receipt | - | |
Description:No description available | ||||
NonStockShip | bit | Require Shipment | - | |
Description:No description available | ||||
NotAvailMode | varchar(1) | When Qty Unavailable | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigLotSerClassID | nvarchar(MAX) | - | ||
Description:No description available | ||||
OvershipThreshold | decimal | Overship Threshold (%) | - | |
Description:No description available | ||||
PackageOption | char(1) | Packaging Option | - | |
Description:No description available | ||||
PackSeparately | bit | Pack Separately | - | |
Description:No description available | ||||
ParentItemClassID | int | - | ||
Description:No description available | ||||
PendingStdCostObsolete | decimal | Pending Cost | - | |
Description:No description available | ||||
PendingStdCostDateObsolete | datetime2 | Pending Cost Date | - | |
Description:No description available | ||||
PercentOfSalesPrice | decimal | Percent of Sales Price | - | |
Description:No description available | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:No description available | ||||
POAccrualAcctID | int | PO Accrual Account | Account | |
Description:No description available | ||||
POAccrualSubID | int | PO Accrual Sub. | Sub | |
Description:No description available | ||||
PostClassID | nvarchar(10) | Posting Class | INPostClass | |
Description:No description available | ||||
PostToExpenseAccount | varchar(MAX) | Post Cost to Expenses On | - | |
Description:No description available | ||||
PPVAcctID | int | Purchase Price Variance Account | Account | |
Description:No description available | ||||
PPVSubID | int | Purchase Price Variance Sub. | Sub | |
Description:No description available | ||||
PreferredItemClasses | char(1) | Preferred Item Classes | - | |
Description:No description available | ||||
PreferredVendorIDObsolete | int | Preferred Vendor | BAccount | |
Description:No description available | ||||
PreferredVendorLocationIDObsolete | int | Preferred Location | Location | |
Description:No description available | ||||
PriceClassID | nvarchar(10) | Price Class | INPriceClass | |
Description:No description available | ||||
PriceManagerID | int | Price Manager | Contact | |
Description:No description available | ||||
PriceOfSuggestedItems | char(1) | Price Of Suggested Items | - | |
Description:No description available | ||||
PriceWorkgroupID | int | Price Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | Contact | |
Description:No description available | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
PurchaseUnit | nvarchar(6) | Purchase Unit | INUnit | |
Description:No description available | ||||
ReasonCodeSubID | int | Reason Code Sub. | Sub | |
Description:No description available | ||||
RecPriceObsolete | decimal | MSRP | - | |
Description:No description available | ||||
ReplenishmentSource | char(1) | Source | - | |
Description:No description available | ||||
RowAttributeValue | nvarchar(255) | - | ||
Description:No description available | ||||
SalesAcctID | int | Sales Account | Account | |
Description:No description available | ||||
SalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
SalesUnit | nvarchar(6) | Sales Unit | INUnit | |
Description:No description available | ||||
SampleDescriptionNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
SampleIDNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
StdCostObsolete | decimal | Current Cost | - | |
Description:No description available | ||||
StdCostDateObsolete | datetime2 | Effective Date | - | |
Description:No description available | ||||
StdCstRevAcctID | int | Standard Cost Revaluation Account | Account | |
Description:No description available | ||||
StdCstRevSubID | int | Standard Cost Revaluation Sub. | Sub | |
Description:No description available | ||||
StdCstVarAcctID | int | Standard Cost Variance Account | Account | |
Description:No description available | ||||
StdCstVarSubID | int | Standard Cost Variance Sub. | Sub | |
Description:No description available | ||||
StkItem | bit | Stock Item | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TemplateItemID | int | Template ID | InventoryItem | |
Description:No description available | ||||
TotalPercentageNonexistent in DB | decimal | Total Percentage | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UndershipThreshold | decimal | Undership Threshold (%) | - | |
Description:No description available | ||||
UpdateOnlySelectedNonexistent in DB | bit | Update Only Selected Items with Template Changes | - | |
Description:No description available | ||||
UseParentSubID | bit | Use Component Subaccounts | - | |
Description:No description available | ||||
ValMethod | char(1) | Valuation Method | - | |
Description:No description available | ||||
Visibility | varchar(1) | Visibility | - | |
Description:No description available | ||||
VolumeUOM | nvarchar(6) | Volume UOM | INUnit | |
Description:No description available | ||||
WeightItem | bit | Weight Item | - | |
Description:No description available | ||||
WeightUOM | nvarchar(6) | Weight UOM | INUnit | |
Description:No description available | ||||