Table M_PriceList

Diagram AD  Diagram B  Diagram C  Diagram I  Diagram S  Diagram W 

PRIMARY KEY
M_PriceList_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)
BasePriceList_ID NUMBER (10, 0)		M_PriceList
IsTaxIncluded CHAR (1) default: 'N' CHECK ( IsTaxIncluded in ( 'Y' , 'N' )) NOT NULL
IsSOPriceList CHAR (1) default: 'Y' CHECK ( IsSOPriceList in ( 'Y' , 'N' )) NOT NULL
IsDefault CHAR (1) default: 'N' CHECK ( IsDefault in ( 'Y' , 'N' )) NOT NULL
C_Currency_ID NUMBER (10, 0) NOT NULL		C_Currency
EnforcePriceLimit CHAR (1) default: 'N' CHECK ( EnforcePriceLimit in ( 'Y' , 'N' )) NOT NULL
FOREIGN KEY BasePriceList: BasePriceList_ID => M_PriceList CCurrency_MPriceList: C_Currency_ID => C_Currency
REFERENCED BY AD_ClientInfo, B_TopicType, C_BPartner, C_BPartner, C_Invoice, C_Order, I_Invoice, I_Order, M_PriceList, M_PriceList_Version, S_TimeExpense, W_Basket