| PRIMARY KEY |
|
M_Product_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| AD_Client |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| AD_Org |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Value
NVARCHAR2 (40) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Help
NVARCHAR2 (2000) |
| |
|
DocumentNote
NVARCHAR2 (2000) |
Order/Invoice/.. additional note
| |
|
UPC
VARCHAR2 (30) |
| |
|
SKU
VARCHAR2 (30) |
| |
|
C_UOM_ID
NUMBER (10, 0) NOT NULL |
| C_UOM |
|
SalesRep_ID
NUMBER (10, 0) |
| |
|
IsSummary
CHAR (1) default: 'N' NOT NULL |
| |
|
ProductType
CHAR (1) default: 'I' NOT NULL |
I_tem, S_ervice, R_esource, E_xpense, O_nline
| |
|
IsStocked
CHAR (1) default: 'Y' CHECK ( IsStocked in ( 'Y' , 'N' )) NOT NULL |
| |
|
M_Locator_ID
NUMBER (10, 0) |
| M_Locator |
|
IsPurchased
CHAR (1) default: 'Y' CHECK ( IsPurchased in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSold
CHAR (1) default: 'Y' CHECK ( IsSold in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsBOM
CHAR (1) default: 'N' CHECK ( IsBOM in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsInvoicePrintDetails
CHAR (1) default: 'N' CHECK ( IsInvoicePrintDetails in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPickListPrintDetails
CHAR (1) default: 'N' CHECK ( IsPickListPrintDetails in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsVerified
CHAR (1) default: 'N' CHECK ( IsVerified in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_RevenueRecognition_ID
NUMBER (10, 0) |
| C_RevenueRecognition |
|
M_Product_Category_ID
NUMBER (10, 0) NOT NULL |
| M_Product_Category |
|
Classification
CHAR (1) |
ABC Classification
| |
|
Volume
NUMBER default: 0 |
| |
|
Weight
NUMBER default: 0 |
| |
|
ShelfWidth
NUMBER (10, 0) |
| |
|
ShelfHeight
NUMBER (10, 0) |
| |
|
ShelfDepth
NUMBER (10, 0) |
| |
|
UnitsPerPallet
NUMBER (10, 0) |
| |
|
C_TaxCategory_ID
NUMBER (10, 0) NOT NULL |
| C_TaxCategory |
|
S_Resource_ID
NUMBER (10, 0) |
| S_Resource |
|
S_ExpenseType_ID
NUMBER (10, 0) |
| S_ExpenseType |
|
Discontinued
CHAR (1) default: 'N' CHECK ( Discontinued in ( 'Y' , 'N' )) |
| |
|
DiscontinuedBy
DATE |
| |
|
ImageURL
NVARCHAR2 (120) |
| |
|
DescriptionURL
NVARCHAR2 (120) |
| |
|
DownloadURL
NVARCHAR2 (120) |
| |
|
R_MailText_ID
NUMBER (10, 0) |
| R_MailText |
|
VersionNo
NVARCHAR2 (20) |
| |
|
GuaranteeDays
NUMBER (10, 0) |
Days granted for Guarantee
| |
|
GuaranteeDaysMin
NUMBER (10, 0) |
| |
|
M_AttributeSet_ID
NUMBER (10, 0) |
| M_AttributeSet |
|
M_AttributeSetInstance_ID
NUMBER (10, 0) |
Default Attributes
| M_AttributeSetInstance |
|
M_FreightCategory_ID
NUMBER (10, 0) |
| M_FreightCategory |
|
IsSelfService
CHAR (1) default: 'Y' CHECK ( IsSelfService in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsWebStoreFeatured
CHAR (1) default: 'N' CHECK ( IsWebStoreFeatured in ( 'Y' , 'N' )) NOT NULL |
| |
|
Processing
CHAR (1) |
| |
|
C_SubscriptionType_ID
NUMBER (10, 0) |
| C_SubscriptionType |
FOREIGN KEY
AD_Org_MProduct: AD_Org_ID => AD_Org
ADClient_MProduct: AD_Client_ID => AD_Client
CRevRecognition_MProduct: C_RevenueRecognition_ID => C_RevenueRecognition
CSubscriptionType_MProduct: C_SubscriptionType_ID => C_SubscriptionType
CTaxCategory_MProduct: C_TaxCategory_ID => C_TaxCategory
CUOM_MProduct: C_UOM_ID => C_UOM
MAttributeSet_MProduct: M_AttributeSet_ID => M_AttributeSet
MAttrSetInst_MProduct: M_AttributeSetInstance_ID => M_AttributeSetInstance
MFreightCategory_MProduct: M_FreightCategory_ID => M_FreightCategory
MLocator_MProduct: M_Locator_ID => M_Locator
MProduct_MProductCategory: M_Product_Category_ID => M_Product_Category
RMailText_MProduct: R_MailText_ID => R_MailText
SExpenseType_MProduct: S_ExpenseType_ID => S_ExpenseType
SResource_MProduct: S_Resource_ID => S_Resource
|
REFERENCED BY
A_Asset,
A_Registration,
B_TopicType,
B_TopicType,
C_AcctSchema_Element,
C_BPartner_Product,
C_CommissionLine,
C_InvoiceLine,
C_OrderLine,
C_Phase,
C_ProjectIssue,
C_ProjectLine,
C_ProjectPhase,
C_ProjectTask,
C_RfQLine,
C_ServiceLevel,
C_Subscription,
C_Task,
C_ValidCombination,
Fact_Acct,
Fact_Acct_Balance,
I_GLJournal,
I_Inventory,
I_Invoice,
I_Order,
I_Product,
M_DiscountSchemaBreak,
M_DiscountSchemaLine,
M_EDI,
M_InOutLine,
M_InventoryLine,
M_Lot,
M_MatchInv,
M_MatchPO,
M_MovementLine,
M_Product_Acct,
M_Product_BOM,
M_Product_BOM,
M_Product_Costing,
M_Product_PO,
M_Product_Trl,
M_ProductionLine,
M_ProductionPlan,
M_ProductPrice,
M_RelatedProduct,
M_RelatedProduct,
M_Replenish,
M_Storage,
M_Substitute,
M_Substitute,
M_Transaction,
M_TransactionAllocation,
PA_Measure,
PA_ReportColumn,
PA_ReportSource,
R_Request,
R_RequestAction,
S_TimeExpenseLine,
S_Training_Class,
T_InventoryValue,
T_Replenish,
W_BasketLine |
|