| PRIMARY KEY |
|
I_Product_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) |
| |
|
Created
DATE default: SYSDATE |
| |
|
CreatedBy
NUMBER (10, 0) |
| |
|
Updated
DATE default: SYSDATE |
| |
|
UpdatedBy
NUMBER (10, 0) |
| |
|
I_IsImported
CHAR (1) default: 'N' NOT NULL |
| |
|
I_ErrorMsg
NVARCHAR2 (2000) |
| |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
Value
NVARCHAR2 (40) |
| |
|
Name
NVARCHAR2 (60) |
| |
|
Description
NVARCHAR2 (255) |
| |
|
DocumentNote
NVARCHAR2 (2000) |
Order/Invoice/.. additional note
| |
|
Help
NVARCHAR2 (2000) |
| |
|
UPC
VARCHAR2 (30) |
| |
|
SKU
VARCHAR2 (30) |
| |
|
X12DE355
CHAR (2) |
| |
|
C_UOM_ID
NUMBER (10, 0) |
| C_UOM |
|
ProductCategory_Value
NVARCHAR2 (40) |
| |
|
M_Product_Category_ID
NUMBER (10, 0) |
| M_Product_Category |
|
ProductType
CHAR (1) default: 'I' |
I_tem, S_ervice, R_esource, E_xpense, O_nline
| |
|
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) |
| |
|
Discontinued
CHAR (1) default: 'N' CHECK ( Discontinued in ( 'Y' , 'N' )) |
| |
|
DiscontinuedBy
DATE |
| |
|
ImageURL
NVARCHAR2 (120) |
| |
|
DescriptionURL
NVARCHAR2 (120) |
| |
|
BPartner_Value
NVARCHAR2 (40) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
ISO_Code
CHAR (3) |
| |
|
C_Currency_ID
NUMBER (10, 0) |
| C_Currency |
|
PriceList
NUMBER default: 0 |
| |
|
PricePO
NUMBER default: 0 |
| |
|
RoyaltyAmt
NUMBER default: 0 |
| |
|
PriceEffective
DATE |
| |
|
VendorProductNo
NVARCHAR2 (30) |
| |
|
VendorCategory
NVARCHAR2 (30) |
| |
|
Manufacturer
NVARCHAR2 (30) |
| |
|
Order_Min
NUMBER default: 0 |
| |
|
Order_Pack
NUMBER default: 0 |
| |
|
CostPerOrder
NUMBER default: 0 |
| |
|
DeliveryTime_Promised
NUMBER (10, 0) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) |
| |
FOREIGN KEY
CBPartner_IProduct: C_BPartner_ID => C_BPartner
CCurrency_IProduct: C_Currency_ID => C_Currency
CUOM_IProduct: C_UOM_ID => C_UOM
MProduct_IProduct: M_Product_ID => M_Product
MProductCategory_IProduct: M_Product_Category_ID => M_Product_Category
|