Table C_BPartner_Product
PRIMARY KEY
C_BPartner_ID
NUMBER (10, 0)
NOT NULL
C_BPartner
M_Product_ID
NUMBER (10, 0)
NOT NULL
M_Product
AD_Client_ID
NUMBER (10, 0)
NOT NULL
AD_Org_ID
NUMBER (10, 0)
NOT NULL
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
Description
NVARCHAR2 (255)
VendorProductNo
NVARCHAR2 (30)
VendorCategory
NVARCHAR2 (30)
Manufacturer
NVARCHAR2 (30)
QualityRating
NUMBER
ShelfLifeMinPct
NUMBER (10, 0)
NOT NULL
ShelfLifeMinDays
NUMBER (10, 0)
NOT NULL
FOREIGN KEY
CBPartner_CBPProduct: C_BPartner_ID =>
C_BPartner
MProduct_CBPProduct: M_Product_ID =>
M_Product