ALTER TABLE HT_BOOKING_DETAIL ADD DISCOUNT MONEY DEFAULT 0 NOT NULL GO ALTER TABLE HT_BOOKING_DETAIL ADD COMMISSION MONEY DEFAULT 0 NOT NULL GO ALTER TABLE HT_BOOKING_DETAIL ADD SERVICE_RATE MONEY DEFAULT 0 NOT NULL GO ALTER TABLE HT_BOOKING_DETAIL ADD VAT_TAX_RATE MONEY DEFAULT 0 NOT NULL GO CREATE TABLE [dbo].[CONTRACT_RATE]( [PR_KEY] [uniqueidentifier] NOT NULL, [CONTRACT_NO] [nvarchar](20) NOT NULL, [CONTRACT_TYPE] [nvarchar](20) NOT NULL, [ACCOUNT_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [CURRENCY_ID] [nvarchar](20) NOT NULL, [INTEREST_RATE] [money] NOT NULL, [RATE_TYPE] [nvarchar](20) NOT NULL, [VALID_DATE] [smalldatetime] NOT NULL, CONSTRAINT [PK_CONTRACT_RATE] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE CA_BUDGET ADD ORIGINAL_AMOUNT MONEY DEFAULT 0 NOT NULL GO ALTER TABLE CA_BUDGET ADD ORIGINAL_AMOUNT_EXTRA MONEY DEFAULT 0 NOT NULL GO ALTER TABLE WAREHOUSE_BALANCE ADD JOB_ID NVARCHAR(20) default '' not null GO CREATE TABLE [dbo].[ASSET_LOCATION]( [PR_KEY] [uniqueidentifier] NOT NULL, [FR_KEY] [uniqueidentifier] NOT NULL, [DAY_START] [smalldatetime] NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_ID_ORIG] [nvarchar](20) NOT NULL, [JOB_ID] [nvarchar](20) NOT NULL, [COMMENTS] [nvarchar](100) NOT NULL, CONSTRAINT [PK_ASSET_LOCATION] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE DM_PR_DETAIL ADD PR_ACCOUNT_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_PR_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO INSERT INTO SYS_SYSTEMVAR VALUES('SALE_PRICE_BY_ORGANIZATION','0','SALE_PRICE_BY_ORGANIZATION','BOOLEAN','COMMON') GO ALTER TABLE SALE_DETAIL ADD QUANTITY_EXPECTED MONEY DEFAULT 0 NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD QUANTITY_EXPECTED MONEY DEFAULT 0 NOT NULL GO ALTER TABLE SALE_DETAIL ADD ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_ITEM_OP ADD IS_TRANSFER SMALLINT DEFAULT 0 NOT NULL GO ALTER TABLE DM_ITEM_OP ADD TRANSFER_ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD WAREHOUSE_ID NVARCHAR(20) DEFAULT '' NULL GO ALTER TABLE SALE_DETAIL ADD WAREHOUSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[DM_PAYMENT_METHOD]( [PAYMENT_METHOD_ID] [nvarchar](20) NOT NULL, [PAYMENT_METHOD_NAME] [nvarchar](50) NOT NULL, [PAYMENT_ACCOUNT_ID] [nvarchar](20) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_PAYMENT_METHOD] PRIMARY KEY CLUSTERED ( [PAYMENT_METHOD_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DM_PAYMENT_METHOD] ADD CONSTRAINT [DF_DM_PAYMENT_METHOD_PAYMENT_ACCOUNT_ID] DEFAULT ('') FOR [PAYMENT_ACCOUNT_ID] GO CREATE TABLE [dbo].[DM_PAYMENT_TERM]( [PAYMENT_TERM_ID] [nvarchar](20) NOT NULL, [PAYMENT_TERM_NAME] [nvarchar](50) NOT NULL, [DUE_DATE_TYPE] [nvarchar](20) NOT NULL, [DUE_DAYS] [int] NOT NULL, [DISCOUNT_RATE] [money] NOT NULL, [DISCOUNT_DATE_TYPE] [nvarchar](20) NOT NULL, [DISCOUNT_DAYS] [int] NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_PAYMENT_TERM] PRIMARY KEY CLUSTERED ( [PAYMENT_TERM_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_SHIPPING_METHOD]( [SHIPPING_METHOD_ID] [nvarchar](20) NOT NULL, [SHIPPING_METHOD_NAME] [nvarchar](50) NOT NULL, [SHIPPING_METHOD_TYPE] [nvarchar](20) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_SHIPPING_METHOD] PRIMARY KEY CLUSTERED ( [SHIPPING_METHOD_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_PR_DETAIL_CREDIT_LIMIT]( [PR_KEY] [uniqueidentifier] NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [CREDIT_LIMIT] [money] NOT NULL, [VALID_START_DATE] [smalldatetime] NOT NULL, [VALID_END_DATE] [smalldatetime] NOT NULL, [ACTIVE] [smallint] NOT NULL, CONSTRAINT [PK_DM_PR_DETAIL_CREDIT_LIMIT] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DM_PR_DETAIL_CREDIT_LIMIT] UNIQUE NONCLUSTERED ( [PR_DETAIL_ID] ASC, [VALID_START_DATE] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_ITEM_WAREHOUSE_LIMIT]( [PR_KEY] [uniqueidentifier] NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, [ITEM_ID] [nvarchar](20) NOT NULL, [ITEM_CLASS_ID] [nvarchar](20) NOT NULL, [VALID_DAY_START] [smalldatetime] NOT NULL, [VALID_DAY_END] [smalldatetime] NOT NULL, [ACTIVE] [smallint] NOT NULL, CONSTRAINT [PK_DM_ITEM_WAREHOUSE_LIMIT] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DM_ITEM_WAREHOUSE_LIMIT] UNIQUE NONCLUSTERED ( [ITEM_CLASS_ID] ASC, [ITEM_ID] ASC, [WAREHOUSE_ID] ASC, [VALID_DAY_START] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[SYS_LOCK]( [PR_KEY] [uniqueidentifier] NOT NULL, [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [MODULE_ID] [nvarchar](20) NOT NULL, [TO_DATE] [smalldatetime] NOT NULL, CONSTRAINT [PK_SYS_LOCK_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SYS_LOCK] UNIQUE NONCLUSTERED ( [ORGANIZATION_ID] ASC, [MODULE_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO GO CREATE TABLE [dbo].[SYS_MENU_MAPPING]( [PR_KEY] [money] NOT NULL, [FUNCTION_ID] [nvarchar](50) NOT NULL, [MENU_ID] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SYS_MENU_MAPPING] PRIMARY KEY CLUSTERED ( [FUNCTION_ID] ASC, [MENU_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERT INTO SYS_TRAN_CLASS VALUES('SD','Sale Discount',1,'ADMIN') GO INSERT INTO SYS_TRAN_CLASS VALUES('SBP','Sale Base Price',1,'ADMIN') GO INSERT INTO SYS_TRAN (TRAN_ID,TRAN_NAME,TRAN_CLASS,TRAN_SUB_CLASS,LIST_ORDER,OUTPUT_FORM, POSTED,MODULE_ID,PROJECT_ID,USER_ID,ACTIVE,SHOW_IN_MENU) VALUES('SD','Sale Discount','SD','SD',1,'FRMSALE_DISCOUNT',1,'','FIN','ADMIN',1,1) GO INSERT INTO SYS_TRAN (TRAN_ID,TRAN_NAME,TRAN_CLASS,TRAN_SUB_CLASS,LIST_ORDER,OUTPUT_FORM, POSTED,MODULE_ID,PROJECT_ID,USER_ID,ACTIVE,SHOW_IN_MENU) VALUES('SBP','Sale Base Price','SBP','SBP',1,'FRMSALE_BASE_PRICE',1,'','FIN','ADMIN',1,1) GO ALTER TABLE ADJUSTMENT ADD ITEM_SOURCE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE TRANSACTION_REGISTER ADD ORGANIZATION_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE CONTRACT_JOB ADD EXPENSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO INSERT INTO SYS_SYSTEMVAR VALUES('ALLOW_SO_OVER_CREDIT_LIMIT','1','ALLOW_SO_OVER_CREDIT_LIMIT','BOOLEAN','COMMON') Go ALTER TABLE TRANSACTION_REGISTER_detail ADD ORGANIZATION_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE VOUCHER_DETAIL ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SALE ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE VAT_TRANSACTION ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SALE_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SO_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO INSERT INTO SYS_SYSTEMVAR VALUES('CACHE_VERSION','1','CACHE_VERSION','STRING','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('DM_POSTING_BY_ORGANIZATION','0','DM_POSTING_BY_ORGANIZATION','BOOLEAN','COMMON') GO CREATE TABLE [dbo].[DM_POSTING]( [PR_KEY] [uniqueidentifier] NOT NULL, [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [TRAN_ID] [nvarchar](20) NOT NULL, [DAY_START] [smalldatetime] NOT NULL, [DAY_END] [smalldatetime] NOT NULL, [TRAN_NO] [nvarchar](20) NOT NULL, [ITEM_SOURCE_ID] [nvarchar](20) NOT NULL, [ITEM_OP_ID] [nvarchar](100) NOT NULL, [ITEM_CLASS_ID] [nvarchar](100) NOT NULL, [PR_DETAIL_CLASS_ID] [nvarchar](100) NOT NULL, [WAREHOUSE_ID] [nvarchar](100) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_POSTING] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC ) ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_POSTING_DETAIL]( [PR_KEY] [uniqueidentifier] NOT NULL, [FR_KEY] [uniqueidentifier] NOT NULL, [LIST_ORDER] [int] NOT NULL, [ACCOUNT_ID_DEBIT] [nvarchar](20) NOT NULL, [ACCOUNT_ID_CREDIT] [nvarchar](20) NOT NULL, [POSTING_FORMULA] [nvarchar](100) NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [JOB_ID] [nvarchar](20) NOT NULL, [EXPENSE_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_POSTING_DETAIL] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC ) ) ON [PRIMARY] GO INSERT INTO SYS_SYSTEMVAR VALUES('ALLOW_SO_NEGATIVE_INVENTORY_BALANCE','0','ALLOW_SO_NEGATIVE_INVENTORY_BALANCE','BOOLEAN','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('ALLOW_SO_OVER_DUE_CREDIT','0','ALLOW_SO_OVER_DUE_CREDIT','BOOLEAN','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('IS_CHECK_OVER_CREDIT_APPROVED','1','IS_CHECK_OVER_CREDIT_APPROVED','BOOLEAN','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('TRAN_ID_EXPORT_FROM_SO','BH','TRAN_ID_EXPORT_FROM_SO','STRING','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('TRAN_ID_INVOICE_EXPORT_FROM_SO','PTHU','TRAN_ID_INVOICE_EXPORT_FROM_SO','STRING','COMMON') GO CREATE TABLE [dbo].[PO]( [PR_KEY] [uniqueidentifier] NOT NULL, [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [TRAN_ID] [nvarchar](20) NOT NULL, [TRAN_NO] [nvarchar](30) NOT NULL, [TRAN_DATE] [smalldatetime] NOT NULL, [RELEASE_DATE] [smalldatetime] NOT NULL, [ITEM_SOURCE_ID] [nvarchar](20) NOT NULL, [ITEM_OP_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, [EMPLOYEE_ID] [nvarchar](20) NOT NULL, [MARKET_ID] [nvarchar](20) NOT NULL, [CURRENCY_ID] [nvarchar](20) NOT NULL, [EXCHANGE_RATE] [money] NOT NULL, [EXCHANGE_RATE_EXTRA] [money] NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_NAME] [nvarchar](100) NOT NULL, [CONTACT_PERSON] [nvarchar](50) NOT NULL, [ADDRESS] [nvarchar](200) NOT NULL, [TAX_FILE_NUMBER] [nvarchar](30) NOT NULL, [PAYMENT_METHOD_ID] [nvarchar](20) NOT NULL, [PAYMENT_TERM_ID] [nvarchar](20) NOT NULL, [COMMENTS] [nvarchar](300) NOT NULL, [STATUS] [nvarchar](20) NOT NULL, CONSTRAINT [PK_PO] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PO] WITH NOCHECK ADD CONSTRAINT [FK_PO_DM_CURRENCY] FOREIGN KEY([CURRENCY_ID]) REFERENCES [dbo].[DM_CURRENCY] ([CURRENCY_ID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[PO] CHECK CONSTRAINT [FK_PO_DM_CURRENCY] GO ALTER TABLE [dbo].[PO] WITH CHECK ADD CONSTRAINT [FK_PO_SYS_TRAN] FOREIGN KEY([TRAN_ID]) REFERENCES [dbo].[SYS_TRAN] ([TRAN_ID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[PO] CHECK CONSTRAINT [FK_PO_SYS_TRAN] GO ALTER TABLE [dbo].[PO] ADD CONSTRAINT [DF__PO__BRANCH__473C8FC7] DEFAULT ('') FOR [ORGANIZATION_ID] GO ALTER TABLE [dbo].[PO] ADD CONSTRAINT [DF__PO__ITEM_S__71B5E533] DEFAULT ('') FOR [ITEM_SOURCE_ID] GO ALTER TABLE [dbo].[PO] ADD CONSTRAINT [DF__PO__ITEM_O__72AA096C] DEFAULT ('') FOR [ITEM_OP_ID] GO CREATE TABLE [dbo].[PO_DETAIL]( [PR_KEY] [uniqueidentifier] NOT NULL, [FR_KEY] [uniqueidentifier] NOT NULL, [LIST_ORDER] [int] NOT NULL, [ITEM_OP_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NULL, [JOB_ID] [nvarchar](20) NOT NULL, [EMPLOYEE_ID] [nvarchar](20) NOT NULL, [ITEM_ID] [nvarchar](20) NOT NULL, [DESCRIPTION] [nvarchar](200) NOT NULL, [DESCRIPTION_ULS] [nvarchar](200) NOT NULL, [UNIT_ID] [nvarchar](20) NOT NULL, [QUANTITY] [money] NOT NULL, [QUANTITY_EXTRA] [money] NOT NULL, [QUANTITY_WH] [money] NOT NULL, [UNIT_PRICE_ORIG] [decimal](18, 6) NULL, [UNIT_PRICE] [money] NOT NULL, [UNIT_PRICE_WH] [money] NOT NULL, [AMOUNT_ORIG] [money] NOT NULL, [AMOUNT] [money] NOT NULL, [VAT_INCOME_AMOUNT_ORIG] [money] NOT NULL, [VAT_INCOME_AMOUNT] [money] NOT NULL, [VAT_TAX_ID] [nvarchar](20) NOT NULL, [VAT_TAX_RATE] [money] NOT NULL, [VAT_TAX_AMOUNT] [money] NOT NULL, [VAT_TAX_AMOUNT_ORIG] [money] NOT NULL, [IMPORT_TAX_RATE] [money] NOT NULL, [IMPORT_TAX_AMOUNT] [money] NOT NULL, [IMPORT_TAX_AMOUNT_ORIG] [money] NOT NULL, [PURCHASE_COST] [money] NOT NULL, [PURCHASE_COST_ORIG] [money] NOT NULL, [DISCOUNT_RATE] [money] NOT NULL, [DISCOUNT_AMOUNT] [money] NOT NULL, [DISCOUNT_AMOUNT_ORIG] [money] NOT NULL, [TOTAL_AMOUNT] [money] NOT NULL, [TOTAL_AMOUNT_ORIG] [money] NOT NULL, [AMOUNT_EXTRA] [money] NOT NULL, [VAT_INCOME_AMOUNT_EXTRA] [money] NOT NULL, [VAT_TAX_AMOUNT_EXTRA] [money] NOT NULL, [DISCOUNT_AMOUNT_EXTRA] [money] NOT NULL, [IMPORT_TAX_AMOUNT_EXTRA] [money] NOT NULL, [PURCHASE_COST_EXTRA] [money] NOT NULL, [TOTAL_AMOUNT_EXTRA] [money] NOT NULL, [LUX_TAX_RATE] [money] NOT NULL, [LUX_TAX_AMOUNT] [money] NOT NULL, [LUX_TAX_AMOUNT_ORIG] [money] NOT NULL, [LUX_TAX_AMOUNT_EXTRA] [money] NOT NULL, CONSTRAINT [PK_PO_DETAIL_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO_DETAIL__ITEM___04898DDC] DEFAULT ('') FOR [ITEM_OP_ID] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO_DETAIL__WAREH__057DB215] DEFAULT ('') FOR [WAREHOUSE_ID] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___EMPLO__1486F2C8] DEFAULT ('') FOR [EMPLOYEE_ID] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF_PO_DETAIL_VAT_INCOME_AMOUNT_ORIG] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT_ORIG] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF_PO_DETAIL_VAT_INCOME_AMOUNT] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___AMOUN__2FBA0BF1] DEFAULT ((0)) FOR [AMOUNT_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___VAT_I__30AE302A] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___VAT_T__31A25463] DEFAULT ((0)) FOR [VAT_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___DISCO__3296789C] DEFAULT ((0)) FOR [DISCOUNT_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___IMPOR__338A9CD5] DEFAULT ((0)) FOR [IMPORT_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___PURCH__3572E547] DEFAULT ((0)) FOR [PURCHASE_COST_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___TOTAL__36670980] DEFAULT ((0)) FOR [TOTAL_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___LUX_T__0C3BC58A] DEFAULT ((0)) FOR [LUX_TAX_RATE] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___LUX_T__0D2FE9C3] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___LUX_T__0E240DFC] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT_ORIG] GO ALTER TABLE [dbo].[PO_DETAIL] ADD CONSTRAINT [DF__PO___LUX_T__0F183235] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT_EXTRA] GO CREATE TABLE [dbo].[SBO]( [PR_KEY] [uniqueidentifier] NOT NULL, [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [TRAN_ID] [nvarchar](20) NOT NULL, [TRAN_NO] [nvarchar](30) NOT NULL, [TRAN_DATE] [smalldatetime] NOT NULL, [APPROVE_DATE] [smalldatetime] NOT NULL, [RELEASE_DATE] [smalldatetime] NOT NULL, [EMPLOYEE_ID] [nvarchar](20) NOT NULL, [MARKET_ID] [nvarchar](20) NOT NULL, [CURRENCY_ID] [nvarchar](20) NOT NULL, [EXCHANGE_RATE] [money] NOT NULL, [EXCHANGE_RATE_EXTRA] [money] NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_NAME] [nvarchar](100) NOT NULL, [CONTACT_PERSON] [nvarchar](50) NOT NULL, [ADDRESS] [nvarchar](200) NOT NULL, [TAX_FILE_NUMBER] [nvarchar](30) NOT NULL, [PAYMENT_METHOD_ID] [nvarchar](20) NOT NULL, [PAYMENT_TERM_ID] [nvarchar](20) NOT NULL, [CREDIT_LIMIT] [money] NOT NULL, [COMMENTS] [nvarchar](300) NOT NULL, [STATUS] [nvarchar](20) NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, [APPROVER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_SBO_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SBO] WITH CHECK ADD CONSTRAINT [FK_SBO_DM_CURRENCY] FOREIGN KEY([CURRENCY_ID]) REFERENCES [dbo].[DM_CURRENCY] ([CURRENCY_ID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[SBO] CHECK CONSTRAINT [FK_SBO_DM_CURRENCY] GO ALTER TABLE [dbo].[SBO] WITH CHECK ADD CONSTRAINT [FK_SBO_SYS_TRAN] FOREIGN KEY([TRAN_ID]) REFERENCES [dbo].[SYS_TRAN] ([TRAN_ID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[SBO] CHECK CONSTRAINT [FK_SBO_SYS_TRAN] GO ALTER TABLE [dbo].[SBO] ADD CONSTRAINT [DF__SBO__BRANCH_ID__4830B400] DEFAULT ('') FOR [ORGANIZATION_ID] GO ALTER TABLE [dbo].[SBO] ADD CONSTRAINT [DF_SBO_PR_DETAIL_NAME] DEFAULT ('') FOR [PR_DETAIL_NAME] GO ALTER TABLE [dbo].[SBO] ADD CONSTRAINT [DF_SBO_CREDIT_LIMIT] DEFAULT ((0)) FOR [CREDIT_LIMIT] GO CREATE TABLE [dbo].[SBO_DETAIL]( [PR_KEY] [uniqueidentifier] NOT NULL, [FR_KEY] [uniqueidentifier] NOT NULL, [LIST_ORDER] [int] NOT NULL, [ITEM_SOURCE_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, [JOB_ID] [nvarchar](20) NOT NULL, [ITEM_ID] [nvarchar](20) NOT NULL, [DESCRIPTION] [nvarchar](200) NOT NULL, [DESCRIPTION_ULS] [nvarchar](200) NOT NULL, [UNIT_ID] [nvarchar](20) NOT NULL, [QUANTITY] [money] NOT NULL, [QUANTITY_EXTRA] [money] NOT NULL, [QUANTITY_WH] [money] NOT NULL, [UNIT_PRICE_ORIG] [decimal](18, 6) NOT NULL, [UNIT_PRICE] [money] NOT NULL, [UNIT_PRICE_WH] [money] NOT NULL, [AMOUNT_ORIG] [money] NOT NULL, [AMOUNT] [money] NOT NULL, [AMOUNT_EXTRA] [money] NOT NULL, [VAT_INCOME_AMOUNT_ORIG] [money] NOT NULL, [VAT_INCOME_AMOUNT] [money] NOT NULL, [VAT_INCOME_AMOUNT_EXTRA] [money] NOT NULL, [VAT_TAX_ID] [nvarchar](20) NOT NULL, [VAT_TAX_RATE] [money] NOT NULL, [VAT_TAX_AMOUNT] [money] NOT NULL, [VAT_TAX_AMOUNT_ORIG] [money] NOT NULL, [VAT_TAX_AMOUNT_EXTRA] [money] NOT NULL, [EXPORT_TAX_RATE] [money] NOT NULL, [EXPORT_TAX_AMOUNT] [money] NOT NULL, [EXPORT_TAX_AMOUNT_ORIG] [money] NOT NULL, [EXPORT_TAX_AMOUNT_EXTRA] [money] NOT NULL, [DISCOUNT_RATE] [money] NOT NULL, [DISCOUNT_AMOUNT] [money] NOT NULL, [DISCOUNT_AMOUNT_ORIG] [money] NOT NULL, [DISCOUNT_AMOUNT_EXTRA] [money] NOT NULL, [LUX_TAX_RATE] [money] NOT NULL, [LUX_TAX_AMOUNT] [money] NOT NULL, [LUX_TAX_AMOUNT_ORIG] [money] NOT NULL, [LUX_TAX_AMOUNT_EXTRA] [money] NOT NULL, [TOTAL_AMOUNT] [money] NOT NULL, [TOTAL_AMOUNT_ORIG] [money] NOT NULL, [TOTAL_AMOUNT_EXTRA] [money] NOT NULL, CONSTRAINT [PK_SBO_DETAIL_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__AMOUN__2818EA29] DEFAULT ((0)) FOR [AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF_SBO_DETAIL_VAT_INCOME_AMOUNT_ORIG] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT_ORIG] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF_SBO_DETAIL_VAT_INCOME_AMOUNT] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__VAT_I__290D0E62] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__VAT_T__2A01329B] DEFAULT ((0)) FOR [VAT_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__EXPOR__2BE97B0D] DEFAULT ((0)) FOR [EXPORT_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__DISCO__2AF556D4] DEFAULT ((0)) FOR [DISCOUNT_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__LUX_T__100C566E] DEFAULT ((0)) FOR [LUX_TAX_RATE] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__LUX_T__11007AA7] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__LUX_T__11F49EE0] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT_ORIG] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__LUX_T__12E8C319] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SBO_DETAIL] ADD CONSTRAINT [DF__SBO_DETA__TOTAL__2EC5E7B8] DEFAULT ((0)) FOR [TOTAL_AMOUNT_EXTRA] GO CREATE TABLE [dbo].[SBO_RATE]( [PR_KEY] [uniqueidentifier] NOT NULL, [FR_KEY] [uniqueidentifier] NOT NULL, [RATE_TYPE] [nvarchar](20) NOT NULL, [INTEREST_RATE] [money] NOT NULL, [VALID_DATE] [smalldatetime] NOT NULL, CONSTRAINT [PK_SBO_RATE] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[SO]( [PR_KEY] [uniqueidentifier] NOT NULL, [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [TRAN_ID] [nvarchar](20) NOT NULL, [TRAN_NO] [nvarchar](30) NOT NULL, [TRAN_DATE] [smalldatetime] NOT NULL, [SBO_TRAN_ID] [nvarchar](20) NOT NULL, [SBO_TRAN_NO] [nvarchar](30) NOT NULL, [IS_OVER_CREDIT_LIMIT] [smallint] NOT NULL, [APPROVE_DATE] [smalldatetime] NOT NULL, [RELEASE_DATE] [smalldatetime] NOT NULL, [DELIVERY_DATE] [smalldatetime] NULL, [EMPLOYEE_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, [ITEM_SOURCE_ID] [nvarchar](20) NOT NULL, [ITEM_OP_ID] [nvarchar](20) NOT NULL, [MARKET_ID] [nvarchar](20) NOT NULL, [SHIPPING_METHOD_ID] [nvarchar](20) NOT NULL, [VEHICLE_ID] [nvarchar](20) NOT NULL, [CURRENCY_ID] [nvarchar](20) NOT NULL, [EXCHANGE_RATE] [money] NOT NULL, [EXCHANGE_RATE_EXTRA] [money] NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_NAME] [nvarchar](100) NOT NULL, [CONTACT_PERSON] [nvarchar](50) NOT NULL, [ADDRESS] [nvarchar](200) NOT NULL, [TAX_FILE_NUMBER] [nvarchar](30) NOT NULL, [PAYMENT_METHOD_ID] [nvarchar](20) NOT NULL, [PAYMENT_TERM_ID] [nvarchar](20) NOT NULL, [COMMENTS] [nvarchar](300) NOT NULL, [STATUS] [nvarchar](20) NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, [APPROVER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_SO_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SO] WITH CHECK ADD CONSTRAINT [FK_SO_DM_CURRENCY] FOREIGN KEY([CURRENCY_ID]) REFERENCES [dbo].[DM_CURRENCY] ([CURRENCY_ID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[SO] CHECK CONSTRAINT [FK_SO_DM_CURRENCY] GO ALTER TABLE [dbo].[SO] WITH CHECK ADD CONSTRAINT [FK_SO_SYS_TRAN] FOREIGN KEY([TRAN_ID]) REFERENCES [dbo].[SYS_TRAN] ([TRAN_ID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[SO] CHECK CONSTRAINT [FK_SO_SYS_TRAN] GO ALTER TABLE [dbo].[SO] ADD CONSTRAINT [DF__SO__BRANCH_ID__4830B400] DEFAULT ('') FOR [ORGANIZATION_ID] GO ALTER TABLE [dbo].[SO] ADD CONSTRAINT [DF_SO_PR_DETAIL_NAME] DEFAULT ('') FOR [PR_DETAIL_NAME] GO CREATE TABLE [dbo].[SO_DETAIL]( [PR_KEY] [uniqueidentifier] NOT NULL, [FR_KEY] [uniqueidentifier] NOT NULL, [LIST_ORDER] [int] NOT NULL, [ITEM_SOURCE_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [JOB_ID] [nvarchar](20) NOT NULL, [ITEM_ID] [nvarchar](20) NOT NULL, [DESCRIPTION] [nvarchar](200) NOT NULL, [DESCRIPTION_ULS] [nvarchar](200) NOT NULL, [UNIT_ID] [nvarchar](20) NOT NULL, [QUANTITY] [money] NOT NULL, [QUANTITY_EXTRA] [money] NOT NULL, [QUANTITY_WH] [money] NOT NULL, [UNIT_PRICE_ORIG] [decimal](18, 6) NOT NULL, [UNIT_PRICE] [money] NOT NULL, [UNIT_PRICE_WH] [money] NOT NULL, [AMOUNT_ORIG] [money] NOT NULL, [AMOUNT] [money] NOT NULL, [AMOUNT_EXTRA] [money] NOT NULL, [VAT_INCOME_AMOUNT_ORIG] [money] NOT NULL, [VAT_INCOME_AMOUNT] [money] NOT NULL, [VAT_INCOME_AMOUNT_EXTRA] [money] NOT NULL, [VAT_TAX_ID] [nvarchar](20) NOT NULL, [VAT_TAX_RATE] [money] NOT NULL, [VAT_TAX_AMOUNT] [money] NOT NULL, [VAT_TAX_AMOUNT_ORIG] [money] NOT NULL, [VAT_TAX_AMOUNT_EXTRA] [money] NOT NULL, [EXPORT_TAX_RATE] [money] NOT NULL, [EXPORT_TAX_AMOUNT] [money] NOT NULL, [EXPORT_TAX_AMOUNT_ORIG] [money] NOT NULL, [EXPORT_TAX_AMOUNT_EXTRA] [money] NOT NULL, [DISCOUNT_RATE] [money] NOT NULL, [DISCOUNT_AMOUNT] [money] NOT NULL, [DISCOUNT_AMOUNT_ORIG] [money] NOT NULL, [DISCOUNT_AMOUNT_EXTRA] [money] NOT NULL, [LUX_TAX_RATE] [money] NOT NULL, [LUX_TAX_AMOUNT] [money] NOT NULL, [LUX_TAX_AMOUNT_ORIG] [money] NOT NULL, [LUX_TAX_AMOUNT_EXTRA] [money] NOT NULL, [TOTAL_AMOUNT] [money] NOT NULL, [TOTAL_AMOUNT_ORIG] [money] NOT NULL, [TOTAL_AMOUNT_EXTRA] [money] NOT NULL, [PRICE_LEVEL_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_SO_DETAIL_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__AMOUN__2818EA29] DEFAULT ((0)) FOR [AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF_SO_DETAIL_VAT_INCOME_AMOUNT_ORIG] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT_ORIG] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF_SO_DETAIL_VAT_INCOME_AMOUNT] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__VAT_I__290D0E62] DEFAULT ((0)) FOR [VAT_INCOME_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__VAT_T__2A01329B] DEFAULT ((0)) FOR [VAT_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__EXPOR__2BE97B0D] DEFAULT ((0)) FOR [EXPORT_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__DISCO__2AF556D4] DEFAULT ((0)) FOR [DISCOUNT_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__LUX_T__100C566E] DEFAULT ((0)) FOR [LUX_TAX_RATE] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__LUX_T__11007AA7] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__LUX_T__11F49EE0] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT_ORIG] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__LUX_T__12E8C319] DEFAULT ((0)) FOR [LUX_TAX_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD CONSTRAINT [DF__SO_DETA__TOTAL__2EC5E7B8] DEFAULT ((0)) FOR [TOTAL_AMOUNT_EXTRA] GO ALTER TABLE [dbo].[SO_DETAIL] ADD DEFAULT ('') FOR [PRICE_LEVEL_ID] GO CREATE TABLE [dbo].[DM_PR_DETAIL_CREDIT_LIMIT]( [PR_KEY] [uniqueidentifier] NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [CREDIT_LIMIT] [money] NOT NULL, [VALID_START_DATE] [smalldatetime] NOT NULL, [VALID_END_DATE] [smalldatetime] NOT NULL, [ACTIVE] [smallint] NOT NULL, CONSTRAINT [PK_DM_PR_DETAIL_CREDIT_LIMIT] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DM_PR_DETAIL_CREDIT_LIMIT] UNIQUE NONCLUSTERED ( [PR_DETAIL_ID] ASC, [VALID_START_DATE] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_ITEM_WAREHOUSE_LIMIT]( [PR_KEY] [uniqueidentifier] NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, [ITEM_ID] [nvarchar](20) NOT NULL, [ITEM_CLASS_ID] [nvarchar](20) NOT NULL, [VALID_DAY_START] [smalldatetime] NOT NULL, [VALID_DAY_END] [smalldatetime] NOT NULL, [ACTIVE] [smallint] NOT NULL, CONSTRAINT [PK_DM_ITEM_WAREHOUSE_LIMIT] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DM_ITEM_WAREHOUSE_LIMIT] UNIQUE NONCLUSTERED ( [ITEM_CLASS_ID] ASC, [ITEM_ID] ASC, [WAREHOUSE_ID] ASC, [VALID_DAY_START] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO alter table CONTRACT_JOB ADD EXPENSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[SYS_MENU_MAPPING]( [PR_KEY] [money] NOT NULL, [FUNCTION_ID] [nvarchar](50) NOT NULL, [MENU_ID] [nvarchar](50) NOT NULL, CONSTRAINT [PK_SYS_MENU_MAPPING] PRIMARY KEY CLUSTERED ( [FUNCTION_ID] ASC, [MENU_ID] ASC ) ) ON [PRIMARY] GO ALTER TABLE DM_WAREHOUSE ADD ROOM_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_WAREHOUSE ADD ORGANIZATION_ID NVARCHAR(20) DEFAULT '' NOT NULL GO alter tabLE DM_POSTING_DETAIL ADD IS_VAT SMALLINT DEFAULT 0 NOT NULL GO ALTER TABLE SO_DETAIL ADD ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD QUANTITY_BILL MONEY DEFAULT 0 NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD QUANTITY_MEASURE MONEY DEFAULT 0 NOT NULL GO ALTER TABLE VOUCHER ADD BANK_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE VOUCHER ADD BANK_ID_CONTRA NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE LEDGER ADD BANK_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SALE ADD SHIPPING_METHOD_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SALE ADD VEHICLE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_WAREHOUSE ADD WAREHOUSE_CLASS_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[DM_WAREHOUSE_CLASS]( [WAREHOUSE_CLASS_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_CLASS_NAME] [nvarchar](50) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_WAREHOUSE_CLASS] PRIMARY KEY CLUSTERED ( [WAREHOUSE_CLASS_ID] ASC ) ) ON [PRIMARY] GO ALTER TABLE SALE ADD ORIG_TRAN_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SALE ADD ORIG_TRAN_NO NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SBO ADD PAYMENT_DAY_OF_MONTH INT DEFAULT 0 NOT NULL GO ALTER TABLE SO ADD DRIVER_NAME NVARCHAR(50) DEFAULT '' NOT NULL GO ALTER TABLE SALE ADD DRIVER_NAME NVARCHAR(50) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD FIXED_UNIT_PRICE MONEY DEFAULT 0 NOT NULL GO ALTER TABLE PURCHASE_DETAIL ADD FIXED_AMOUNT MONEY DEFAULT 0 NOT NULL GO ALTER TABLE SALE_DETAIL ADD FIXED_UNIT_PRICE MONEY DEFAULT 0 NOT NULL GO ALTER TABLE SALE_DETAIL ADD FIXED_AMOUNT MONEY DEFAULT 0 NOT NULL GO INSERT INTO SYS_SYSTEMVAR VALUES('FIXED_PRICE_LEVEL_ID','99','FIXED_PRICE_LEVEL_ID','STRING','COMMON') GO alter table SYS_TRAN_DEFAULT ADD ORGANIZATION_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[DM_BANK]( [BANK_ID] [nvarchar](20) NOT NULL, [BANK_NAME] [nvarchar](50) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_BANK] PRIMARY KEY CLUSTERED ( [BANK_ID] ASC ) ) ON [PRIMARY] GO ALTER TABLE SBO ADD CREDIT_LIMIT1 MONEY DEFAULT 0 NOT NULL GO EXEC DROPCOLUMN 'SBO','PAYMENT_DAY_OF_MONTH' GO ALTER TABLE DM_PR_DETAIL ADD PR_ACCOUNT_ID1 NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_SALE_DETAIL ADD FIXED_UNIT_PRICE MONEY DEFAULT 0 NOT NULL GO ALTER TABLE POS_SALE_DETAIL ADD FIXED_AMOUNT MONEY DEFAULT 0 NOT NULL GO ALTER TABLE POS_SALE_DETAIL ADD ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO EXEC DropColumn 'DM_POSTING','WAREHOUSE_ID' GO ALTER TABLE DM_POSTING ADD WAREHOUSE_CLASS_ID NVARCHAR(200) DEFAULT '' NOT NULL GO ALTER TABLE DM_POSTING ADD ISSUE_RECEIVE NVARCHAR(1) DEFAULT 'X' NOT NULL GO ALTER TABLE SO_DETAIL ADD DELIVERY_TIME NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SALE ADD DRIVER_NAME NVARCHAR(50) DEFAULT '' NOT NULL GO DROP TABLE SYS_LOCK GO CREATE TABLE [dbo].[SYS_LOCK]( [PR_KEY] [uniqueidentifier] NOT NULL, [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [MODULE_ID] [nvarchar](20) NOT NULL, [TO_DATE] [smalldatetime] NOT NULL, CONSTRAINT [PK_SYS_LOCK_1] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_SYS_LOCK] UNIQUE NONCLUSTERED ( [ORGANIZATION_ID] ASC, [MODULE_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO UPDATE SYS_TRAN SET MODULE_ID='FIN_CASHBANK' WHERE TRAN_ID='JN' GO INSERT INTO SYS_SYSTEMVAR VALUES('FORCE_UNIT_EXTRA_AS_UNIT','1','FORCE_UNIT_EXTRA_AS_UNIT','BOOLEAN','COMMON') GO ALTER TABLE WAREHOUSE ADD UNIT_ID_ACTUAL NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE WAREHOUSE_BALANCE ADD UNIT_ID_ACTUAL NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SO ADD DELIVER_ORGANIZATION_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SO_DETAIL ADD IS_SII SMALLINT DEFAULT 0 NOT NULL GO ALTER TABLE SO_DETAIL ADD IS_DELIVERED SMALLINT DEFAULT 0 NOT NULL GO ALTER TABLE SO_DETAIL ADD IS_INVOICED SMALLINT DEFAULT 0 NOT NULL GO UPDATE SYS_TABLE SET ID_FIELD='PR_KEY', NAME_FIELD='PR_KEY' WHERE TABLE_NAME = 'SYS_TRAN_NO' GO ALTER TABLE PO ADD PO_CLASS_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[DM_PO_CLASS]( [PO_CLASS_ID] [nvarchar](20) NOT NULL, [PO_CLASS_NAME] [nvarchar](50) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_PO_CLASS] PRIMARY KEY CLUSTERED ( [PO_CLASS_ID] ASC ) ) ON [PRIMARY] GO alter table DM_PR_DETAIL ADD PROVINCE_ID NVARCHAR(20) DEFAULTL '' NOT NULL GO ALTER TABLE DM_POSTING ADD ITEM_ID NVARCHAR(100) DEFAULT '' NOT NULL GO ALTER TABLE SYS_TRAN ADD IS_SALE SMALLINT DEFAULT 0 NOT NULL GO ALTER TABLE SBO_DETAIL ADD PAYMENT_TERM_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE SBO_DETAIL ADD CREDIT_LIMIT MONEY DEFAULT(0) NOT NULL GO INSERT INTO SYS_SYSTEMVAR VALUES('INTERNAL_PR_DETAIL_CLASS','10','INTERNAL_PR_DETAIL_CLASS','STRING','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('FORCE_SALE_ORDER','1','FORCE_SALE_ORDER','BOOLEAN','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('MAIN_ITEM_CLASS','01','MAIN_ITEM_CLASS','STRING','COMMON') GO ALTER TABLE POS_SO_DETAIL ADD FIXED_UNIT_PRICE MONEY DEFAULT 0 NOT NULL GO ALTER TABLE POS_SO_DETAIL ADD FIXED_AMOUNT MONEY DEFAULT 0 NOT NULL GO ALTER TABLE POS_SO_DETAIL ADD ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_SO_DETAIL ADD WAREHOUSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_SO_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE BALANCE_DETAIL ADD BANK_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_ACCOUNT ADD IS_BANK SMALLINT DEFAULT 0 NOT NULL GO GO ALTER TABLE POS_PAYMENT ADD AMOUNT_ORIG MONEY DEFAULT 0 NOT NULL GO EXEC DropColumn 'POS_SO_DETAIL','COG_UNIT_PRICE' GO EXEC DropColumn 'POS_SO_DETAIL','COG_UNIT_PRICE_ORIG' GO EXEC DropColumn 'POS_SO_DETAIL','COG_AMOUNT' GO EXEC DropColumn 'POS_SO_DETAIL','COG_AMOUNT_ORIG' GO GO ALTER TABLE HT_FOLIO_PAYMENT ADD USER_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE HT_FOLIO_PAYMENT ADD TRAN_DATE SMALLDATETIME DEFAULT '01-01-2012' NOT NULL GO ALTER TABLE SALE_DETAIL ADD ROOM_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_PR_DETAIL ADD PROVINCE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[DM_PROVINCES]( [PROVINCE_ID] [nvarchar](20) NOT NULL, [PROVINCE_NAME] [nvarchar](50) NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, [ACTIVE] [smallint] NOT NULL, CONSTRAINT [PK_DM_PROVINCES] PRIMARY KEY CLUSTERED ( [PROVINCE_ID] ASC ) ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_ITEM_COMBO]( [ITEM_COMBO_ID] [nvarchar](20) NOT NULL, [ITEM_COMBO_NAME] [nvarchar](50) NOT NULL, [ITEM_ID] [nvarchar](20) NOT NULL, [UNIT_ID] [nvarchar](20) NOT NULL, [ACTIVE] [smallint] NOT NULL, [USER_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_ITEM_COMBO] PRIMARY KEY CLUSTERED ( [ITEM_COMBO_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_DM_ITEM_COMBO] UNIQUE NONCLUSTERED ( [ITEM_ID] ASC, [UNIT_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE POS_SALE ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO CREATE TABLE [dbo].[DM_ITEM_VB]( [PR_KEY] [uniqueidentifier] NOT NULL, [ITEM_ID] [nvarchar](20) NULL, [UNIT_ID] [nvarchar](20) NULL, [VB_ID] [nvarchar](20) NULL, [ACTIVE] [smallint] NULL, [USER_ID] [nvarchar](20) NULL, CONSTRAINT [PK_DM_ITEM_VB] PRIMARY KEY CLUSTERED ( [PR_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[DM_ORGANIZATION_MAPPING]( [ORGANIZATION_ID] [nvarchar](20) NOT NULL, [PR_DETAIL_ID] [nvarchar](20) NOT NULL, [WAREHOUSE_ID] [nvarchar](20) NOT NULL, CONSTRAINT [PK_DM_ORGANIZATION_MAPPING] PRIMARY KEY CLUSTERED ( [ORGANIZATION_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE DM_BANK ADD BANK_ACCOUNT NVARCHAR(50) DEFAULT '' NOT NULL GO ALTER TABLE DM_BANK ADD BANK_BRANCH NVARCHAR(50) DEFAULT '' NOT NULL GO EXEC DROPCOLUMN 'DM_ITEM_OP','ITEM_OP_CLASS_ID' GO ALTER TABLE DM_ORGANIZATION ADD IS_POS SMALLINT DEFAULT 0 NOT NULL GO ALTER TABLE POS_PURCHASE ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_SALE_DETAIL ADD WAREHOUSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_SALE_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_PURCHASE_DETAIL ADD WAREHOUSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_PURCHASE_DETAIL ADD PRICE_LEVEL_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE POS_PURCHASE_DETAIL ADD FIXED_UNIT_PRICE MONEY DEFAULT (0) NOT NULL GO ALTER TABLE POS_PURCHASE_DETAIL ADD FIXED_AMOUNT MONEY DEFAULT (0) NOT NULL GO ALTER TABLE POS_PURCHASE_DETAIL ADD ITEM_OP_ID NVARCHAR(20) DEFAULT '' NOT NULL GO EXEC DROPCOLUMN 'DM_CURRENCY','EXCHANGE_RATE' GO ALTER TABLE BUDGET ADD EXPENSE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE ADD SALE_PR_KEY UNIQUEIDENTIFIER DEFAULT '00000000-0000-0000-0000-000000000000' NOT NULL GO ALTER TABLE PURCHASE ADD ORIG_TRAN_NO NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE ADD ORIG_TRAN_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE PURCHASE ADD VEHICLE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_ORGANIZATION_MAPPING ADD TAX_OFFICE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_ORGANIZATION_MAPPING ADD ITEM_SOURCE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO INSERT INTO SYS_SYSTEMVAR VALUES('VB_ITEM_CLASS','02','VB_ITEM_CLASS','STRING','COMMON') GO INSERT INTO SYS_SYSTEMVAR VALUES('ITEM_OP_ID_SHELL_DEPOSIT','13018888','ITEM_OP_ID_SHELL_DEPOSIT','STRING','COMMON') GO ALTER TABLE POS_SHIFT_ITEM ADD UNIT_ID NVARCHAR(20) DEFAULT '' NOT NULL GO ALTER TABLE DM_ACCOUNT ADD IS_POS SMALLINT DEFAULT 0 NOT NULL GO delete from pos_sale where not exists(select 'true' from dm_item where item_id like '12%') go delete from pos_sale_detail where not exists(select 'true' from dm_item where item_id like '12%') go delete from pos_PURCHASE where not exists(select 'true' from dm_item where item_id like '12%') go delete from pos_purchase_detail where not exists(select 'true' from dm_item where item_id like '12%') go delete from warehouse where not exists(select 'true' from dm_item where item_id like '12%') go delete from WAREHOUSE_BALANCE where not exists(select 'true' from dm_item where item_id like '12%') go delete from SALE_BASE_PRICE where not exists(select 'true' from dm_item where item_id like '12%') go delete from SALE_BASE_PRICE_DETAIL where not exists(select 'true' from dm_item where item_id like '12%') go delete from VOUCHER where not exists(select 'true' from dm_item where item_id like '12%') go delete from VOUCHER_DETAIL where not exists(select 'true' from dm_item where item_id like '12%') go delete from VAT_TRANSACTION where not exists(select 'true' from dm_item where item_id like '12%') go delete from LEDGER where not exists(select 'true' from dm_item where item_id like '12%') go delete from SALE where not exists(select 'true' from dm_item where item_id like '12%') go delete from SALE_DETAIL where not exists(select 'true' from dm_item where item_id like '12%') go delete from PURCHASE where not exists(select 'true' from dm_item where item_id like '12%') go delete from PURCHASE_DETAIL where not exists(select 'true' from dm_item where item_id like '12%') go delete from data_log where table_name in ('SALE_BASE_PRICE','SALE_BASE_PRICE_DETAIL','VOUCHER','VOUCHER_DETAIL','VAT_TRANSACTION','LEDGER','POS_SALE','POS_SALE_DETAIL','POS_PURCHASE','POS_PURCHASE_DETAIL','WAREHOUSE','WAREHOUSE_BALANCE','DM_ITEM') where not exists(select 'true' from dm_item where item_id like '12%') GO update dm_item set ITEM_ID = '19' + SUBSTRING(ITEM_ID,3,8) where ITEM_ID like '02%' go update dm_item set ITEM_ID = '12' + SUBSTRING(ITEM_ID,3,8) where ITEM_ID like '01%' go update dm_item set ITEM_ID = '20' + SUBSTRING(ITEM_ID,3,10) where ITEM_ID like '03%' go update dm_item set ITEM_ID = '22' + SUBSTRING(ITEM_ID,3,8) where ITEM_ID like '04%' go update dm_item set ITEM_ID = '20' + SUBSTRING(ITEM_ID,5,8) where ITEM_ID like '20%' AND LEN(ITEM_ID)=12 go update dm_item set item_id=substring(item_id,1,6) + SUBSTRING(item_id,9,2) where (ITEM_ID like '12%' or ITEM_ID like '20%') and len(item_id) = 10 go update dm_item set item_id=substring(item_id,1,4) + SUBSTRING(item_id,7,4) where ITEM_ID like '22%' and len(item_id) = 10 go update dm_item set item_id=substring(item_id,1,6) + SUBSTRING(item_id,9,2) where ITEM_ID like '99%' and len(item_id) = 10 go delete from dm_item where substring(item_id,7,1) <> '1' and item_id like '19%' and len(item_id) = 10 go update dm_item set item_id = substring(item_id,1,2) + substring(item_id,5,6) where ITEM_ID like '19%' and len(item_id) = 10 go update DM_ITEM set ITEM_NAME = REPLACE(item_name,N'Hà Nội ','') where ITEM_ID like '19%' go ALTER TABLE SYS_FORMINFO DROP CONSTRAINT FK_DM_FORMINFO_DM_FORM GO ALTER TABLE SYS_GRIDINFO DROP CONSTRAINT FK_DM_GRIDINFO_DM_FORM GO ALTER TABLE SYS_REPORT DROP CONSTRAINT FK_SYS_REPORT_SYS_REPORT_GROUP GO ALTER TABLE SYS_REPORTFIELD DROP CONSTRAINT FK_SYS_REPORTFIELD_SYS_REPORT GO ALTER TABLE SYS_REPORT_CONFIG DROP CONSTRAINT FK_SYS_REPORT_CONFIG_SYS_REPORT GO ALTER TABLE SYS_REPORT_FORMULA DROP CONSTRAINT FK_SYS_REPORT_FORMULA_SYS_REPORT GO delete from dm_item_op where item_op_id='02010004' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id='01210001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id='01220001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id='01110001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id in ('03024001','03024002','03024003','03024004','03024007') and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id in ('11111101','11111201','11112201','11113201') and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id in ('11211201') and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id in ('12010001','12010002','12010003') and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id like '13014%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id like '13024%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go delete from dm_item_op where item_op_id in ('03014001','03014002','03014003','03014004','03014007') and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0110001' where item_op_id='01100001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0120001',item_op_name=N'Nhập khẩu' where item_op_id='01200001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0200010',item_op_name=N'Nhập công trình' where item_op_id='02000010' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0200001',item_op_name=N'Nhập mua nội bộ Cty và Cty TNHH' where item_op_id='02010001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0200002',item_op_name=N'Nhập mua nội bộ Công ty' where item_op_id='02010002' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0200003',item_op_name=N'Nhập di chuyển nội bộ' where item_op_id='02010003' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'0300000','030000') where item_op_id like '0300000%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'0300001','030001') where item_op_id like '0300001%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'03004','0304') where item_op_id like '03004%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='0308888',item_op_name=N'Nhập lại vỏ bình' where item_op_id='03008888' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1111101',item_op_name=N'Xuất bán lẻ cá nhân và các hộ tiêu dùng' where item_op_id='11101101' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1111201',item_op_name=N'Xuất bán buôn' where item_op_id='11101201' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1112201',item_op_name=N'Xuất bán TĐL,ĐL thành viên' where item_op_id='11102201' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1113201',item_op_name=N'Xuất bán TĐL,ĐL Ng.ngành' where item_op_id='11103201' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1121201',item_op_name=N'Xuất khẩu' where item_op_id='11201201' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1200001',item_op_name=N'Xuất bán nội bộ Cty và Cty TNHH' where item_op_id='12000001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1200002',item_op_name=N'Xuất bán nội bộ Công ty' where item_op_id='12000002' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1200003',item_op_name=N'Xuất di chuyển nội bộ' where item_op_id='12000003' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'1200000','120000') where item_op_id like '1200000%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1200010' where item_op_id='12000010' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'1300001','130001') where item_op_id like '1300001%' and len(item_op_id)=8 and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'1300000','130000') where item_op_id like '1300000%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = replace(item_op_id,'13004','1304') where item_op_id like '13004%' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='1308888',item_op_name=N'Xuất ký cược vỏ bình' where item_op_id='13018888' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go insert into dm_item_op values('1111102',N'Xuất bán lẻ các hộ kinh doanh','X',0,'',1,'ADMIN') GO DELETE FROM DM_ITEM_OP WHERE ITEM_OP_ID IN ('03000020','03009999','13000020','13019999') and not exists(select 'true' from dm_item_op where item_op_id='11130201') GO update DM_ITEM_OP set TRANSFER_ITEM_OP_ID='' where ITEM_OP_ID='1300014' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update DM_ITEM_OP set TRANSFER_ITEM_OP_ID='' where ITEM_OP_ID='0110001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update DM_ITEM_OP set TRANSFER_ITEM_OP_ID='0200001' where ITEM_OP_ID='1200001' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update DM_ITEM_OP set TRANSFER_ITEM_OP_ID='0200002' where ITEM_OP_ID='1200002' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update DM_ITEM_OP set TRANSFER_ITEM_OP_ID='0200003' where ITEM_OP_ID='1200003' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id = substring(item_op_id,1,4) + '0' + substring(item_op_id,5,3) where len(item_op_id)=7 and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='11121201' where item_op_id='11120201' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set item_op_id='11122201' where item_op_id='11130201' and not exists(select 'true' from dm_item_op where item_op_id='11130201') go update dm_item_op set TRANSFER_ITEM_OP_ID = substring(TRANSFER_ITEM_OP_ID,1,4) + '0' + substring(TRANSFER_ITEM_OP_ID,5,3) where len(TRANSFER_ITEM_OP_ID)=7 and not exists(select 'true' from dm_item_op where item_op_id='11130201') go insert into dm_item_op values('11130201',N'Xuất bán qua hãng khác','X',0,'',1,'ADMIN') GO UPDATE SEC_USER SET ORGANIZATION_ID='301000' WHERE USER_ID LIKE 'HP%' AND ORGANIZATION_ID='101000' GO update sec_user set ORGANIZATION_ID='301001',USER_GROUP_ID='12' WHERE USER_ID IN ('HP_LONG','HP_MinhNT','HP_ToanND') GO update sec_user set ORGANIZATION_ID='301002',USER_GROUP_ID='12' WHERE USER_ID IN ('HP_TuHA','HP_XuanTT') GO update sec_user set ORGANIZATION_ID='301003',USER_GROUP_ID='12' WHERE USER_ID IN ('HP_YenVH','HP_ThanhLV') GO update sec_user set ORGANIZATION_ID='301101' WHERE USER_ID IN ('HP_DongTV') GO update sec_user set ORGANIZATION_ID='301102' WHERE USER_ID IN ('HP_NghiaDV') GO update sec_user set ORGANIZATION_ID='301103' WHERE USER_ID IN ('HP_HuyenPT') GO update sec_user set ORGANIZATION_ID='301104' WHERE USER_ID IN ('HP_HuyenHT') GO update sec_user set ORGANIZATION_ID='301105' WHERE USER_ID IN ('HP_TuyetDT') GO update sec_user set ORGANIZATION_ID='301106' WHERE USER_ID IN ('HP_QuyenDB') GO update sec_user set ORGANIZATION_ID='301107' WHERE USER_ID IN ('HP_VinhNK') GO UPDATE SEC_USER SET USER_GROUP_ID='31' WHERE USER_ID LIKE 'HP%' AND EXISTS(SELECT 'TREU' FROM DM_ORGANIZATION WHERE SEC_USER.ORGANIZATION_ID=DM_ORGANIZATION.ORGANIZATION_ID AND ORGANIZATION_NAME LIKE N'%cửa hàng%') go UPDATE SEC_USER SET USER_GROUP_ID ='03' WHERE USER_GROUP_ID='01' AND USER_ID LIKE 'HP%' GO UPDATE SEC_USER SET USER_GROUP_ID='04' WHERE USER_ID='HP_DungTT' GO UPDATE SEC_USER SET USER_GROUP_ID='12' WHERE USER_ID IN ('HP_THANGPB','HP_NGUYET','HP_NGOCMANH','HP_BINHNV','HP_MINHHOA','HP_UT','HP_CUONGNX','HP_PHAMHUNG','HP_THANHHC','HP_MANHLINH') GO UPDATE SYS_ID_FILTER SET REGULAR_EXPRESSION = REPLACE(REGULAR_EXPRESSION,'PR_DETAIL_ID','EMPLOYEE_ID') WHERE TABLE_NAME='HR_EMPLOYEE_INFO' GO UPDATE DM_ITEM SET VAT_TAX_ID='10' WHERE ITEM_ID NOT LIKE '19%' GO alter table WAREHOUSE_BALANCE DROP CONSTRAINT PK_WAREHOUSE_BALANCE_1 GO UPDATE DM_POSTING_DETAIL SET JOB_ID='000000000000' WHERE JOB_ID <> '' GO UPDATE DM_COMMUNICATE_CONFIG SET IS_NEW=0,IS_EDIT=0,IS_DELETE=0,IS_PUBLIC=0 WHERE TABLE_NAME LIKE 'SYS_ID%' GO alter table SALE_BASE_PRICE_DETAIL ADD PR_DETAIL_ID NVARCHAR(20) DEFAULT '' GO delete from data_log where table_name like 'SYS_ID%' GO alter table SALE_DETAIL ADD ITEM_SOURCE_ID NVARCHAR(20) DEFAULT '' NOT NULL GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'01110001','01100001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'01210001','01200001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'01220001','01200001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'02010001','02000001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03004001','03040001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03004002','03040002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03004003','03040003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03004004','03040004') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03004007','03040007') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03008888','03080888') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03014001','03040001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03014002','03040002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03014003','03040003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03014004','03040004') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03014007','03040007') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03024001','03040001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03024002','03040002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03024003','03040003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03024004','03040004') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03024007','03040007') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11101101','11110101,11110102') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11101201','11110201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11102201','11120201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11103201','11130201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11111101','11110101') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11111201','11110201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11112201','11120201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11113201','11130201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11201201','11210201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'11211201','11210201') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'12010001','12000001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'12010002','12000002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'12010003','12000003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13004001','13040001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13004002','13040002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13004003','13040003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13004004','13040004') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13014001','13040001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13014002','13040002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13014003','13040003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13014004','13040004') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13018888','13080888') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13024001','13040001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13024002','13040002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13024003','13040003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13024004','13040004') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'02010001','02000001') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'02010002','02000002') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'02010003','02000003') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03000015','03080888') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'13019999','13080888') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'03009999','03080888') GO update dm_posting set ITEM_OP_ID=REPLACE(ITEM_OP_ID,'02010004','03080888') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0100000001','12000001') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0100000002','12000002') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201031101','19031101') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201031102','19031102') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201031203','19031203') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201031300','19031300') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201031301','19031301') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201031600','19031600') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201032101','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201032102','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201032203','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201032300','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201032301','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201033101','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201033102','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201033203','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201033300','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201033301','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201033600','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201034101','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201034102','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201034203','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201034300','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201034301','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201035101','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201035102','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201035203','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201035300','') GO update dm_posting set ITEM_ID=REPLACE(ITEM_ID,'0201035301','') GO UPDATE DM_POSTING SET ITEM_ID=REPLACE(ITEM_ID,',','') WHERE ITEM_ID <> '12000001,12000002' GO update DM_POSTING_DETAIL set POSTING_FORMULA='.AMOUNT.-.DISCOUNT_AMOUNT.' where POSTING_FORMULA = ' .AMOUNT.-.DISCOUNT_AMOUNT' go update DM_POSTING_DETAIL set POSTING_FORMULA='.AMOUNT.-.DISCOUNT_AMOUNT.' where POSTING_FORMULA = '.AMOUNT.-.DISCOUNT_AMOUNT' go update DM_POSTING_DETAIL set JOB_ID='000000000000' where exists(select 'true' from DM_ACCOUNT where DM_POSTING_DETAIL.ACCOUNT_ID_CREDIT=DM_ACCOUNT.ACCOUNT_ID and IS_JOB=1) and not exists(select 'true' from DM_JOB where DM_POSTING_DETAIL.JOB_ID=DM_JOB.JOB_ID) go UPDATE DM_POSTING_DETAIL SET EXPENSE_ID='000000' where exists(select 'true' from DM_ACCOUNT where DM_POSTING_DETAIL.ACCOUNT_ID_DEBIT=DM_ACCOUNT.ACCOUNT_ID and IS_EXPENSE=1) and not exists(select 'true' from DM_EXPENSE where DM_POSTING_DETAIL.EXPENSE_ID=DM_EXPENSE.EXPENSE_ID) go UPDATE DM_POSTING_DETAIL SET JOB_ID='000000000000' where exists(select 'true' from DM_ACCOUNT where DM_POSTING_DETAIL.ACCOUNT_ID_DEBIT=DM_ACCOUNT.ACCOUNT_ID and IS_JOB=1) and not exists(select 'true' from DM_JOB where DM_POSTING_DETAIL.JOB_ID=DM_JOB.JOB_ID) go update DM_POSTING_DETAIL set is_vat=1 where POSTING_FORMULA like '%vat%' go