| PRIMARY KEY |
|
M_PriceList_Version_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
M_PriceList_ID
NUMBER (10, 0) NOT NULL |
| M_PriceList |
|
M_DiscountSchema_ID
NUMBER (10, 0) NOT NULL |
| M_DiscountSchema |
|
ValidFrom
DATE NOT NULL |
| |
|
ProcCreate
CHAR (1) |
| |
|
M_Pricelist_Version_Base_ID
NUMBER (10, 0) |
| |
FOREIGN KEY
MDiscountS_MPLVersion: M_DiscountSchema_ID => M_DiscountSchema
MPriceList_MPriceListVersion: M_PriceList_ID => M_PriceList
|
REFERENCED BY
C_Project,
M_ProductPrice,
T_InventoryValue |
|