| PRIMARY KEY |
|
M_AttributeSetInstance_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 |
| |
|
M_AttributeSet_ID
NUMBER (10, 0) NOT NULL |
| M_AttributeSet |
|
SerNo
NVARCHAR2 (20) |
| |
|
Lot
NVARCHAR2 (20) |
| |
|
M_Lot_ID
NUMBER (10, 0) |
| M_Lot |
|
GuaranteeDate
DATE |
| |
|
Description
NVARCHAR2 (255) |
| |
FOREIGN KEY
MAttributeSet_MAttribSetInst: M_AttributeSet_ID => M_AttributeSet
MLot_MAttributeSetInstance: M_Lot_ID => M_Lot
|
REFERENCED BY
A_Asset,
C_InvoiceLine,
C_OrderLine,
C_ProjectIssue,
C_RfQLine,
M_AttributeInstance,
M_InOutLine,
M_InventoryLine,
M_MovementLine,
M_Product,
M_ProductionLine,
M_Storage,
M_Transaction,
M_TransactionAllocation |
|