Table M_LotCtl
PRIMARY KEY
M_LotCtl_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)
StartNo
NUMBER (10, 0)
NOT NULL
IncrementNo
NUMBER (10, 0)
NOT NULL
CurrentNext
NUMBER (10, 0)
NOT NULL
Prefix
NVARCHAR2 (10)
Suffix
NVARCHAR2 (10)
REFERENCED BY
M_AttributeSet
,
M_Lot