/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\LCS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_LCS_COSTSTRUDEFDETAIL') 
 CREATE TABLE T_LCS_COSTSTRUDEFDETAIL (
FDETAILID BIGINT DEFAULT 0 NOT NULL,
FENTRYID BIGINT DEFAULT 0 NOT NULL,
FSEQ BIGINT DEFAULT 0 NOT NULL,
FCOSTBIZOBJID BIGINT DEFAULT 0 NOT NULL,
FDEFAULTRULE NCLOB
);


 EXEC p_AlterColumn 'T_LCS_COSTSTRUDETAIL', 'FADAPTATIONRULE', 'NCLOB', 'NULL', '1111', 'NULL';

 EXEC p_AlterColumn 'T_LCS_COSTSTRUDETAIL', 'FADAPTATIONRULE_TAG', 'NCLOB', 'NULL', '0001', 'NULL';


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\LCS_table.sql **/
