| PRIMARY KEY |
|
M_AttributeSet_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) |
| |
|
IsSerNo
CHAR (1) default: 'Y' CHECK ( IsSerNo in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSerNoMandatory
CHAR (1) default: 'N' CHECK ( IsSerNoMandatory in ( 'Y' , 'N' )) NOT NULL |
| |
|
M_SerNoCtl_ID
NUMBER (10, 0) |
| M_SerNoCtl |
|
IsLot
CHAR (1) default: 'Y' CHECK ( IsLot in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsLotMandatory
CHAR (1) default: 'N' CHECK ( IsLotMandatory in ( 'Y' , 'N' )) NOT NULL |
| |
|
M_LotCtl_ID
NUMBER (10, 0) |
| M_LotCtl |
|
IsGuaranteeDate
CHAR (1) default: 'N' CHECK ( IsGuaranteeDate in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsGuaranteeDateMandatory
CHAR (1) default: 'N' CHECK ( IsGuaranteeDateMandatory in ( 'Y' , 'N' )) NOT NULL |
| |
|
GuaranteeDays
NUMBER (10, 0) |
| |
|
IsInstanceAttribute
CHAR (1) default: 'N' CHECK ( IsInstanceAttribute in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsMandatory
CHAR (1) default: 'N' CHECK ( IsMandatory in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
MLotCtl_MAttributeSet: M_LotCtl_ID => M_LotCtl
MSerNoCtl_AttributeSet: M_SerNoCtl_ID => M_SerNoCtl
|
REFERENCED BY
M_AttributeSetInstance,
M_AttributeUse,
M_Product |
|