Table M_DiscountSchema

Diagram C

Description:
Trade Discount

PRIMARY KEY
M_DiscountSchema_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)
ValidFrom DATE NOT NULL
DiscountType CHAR (1) NOT NULL
Script NVARCHAR2 (2000)
FlatDiscount NUMBER
IsQuantityBased CHAR (1) default: 'Y' CHECK ( IsQuantityBased in ( 'Y' , 'N' )) NOT NULL
CumulativeLevel CHAR (1)
Processing CHAR (1)
REFERENCED BY C_BPartner, C_BPartner, M_DiscountSchemaBreak, M_DiscountSchemaLine, M_PriceList_Version