- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
CREATE TABLE [dbo].[TBL_JOUR_PRODUCTION_PLAN_KK_BH](
[JPPKKBH_ID] [uniqueidentifier] NOT NULL,
[JPPKKBH_JPKKBH_ID] [uniqueidentifier] NOT NULL,
[JPPKKBH_WC_ID] [int] NOT NULL,
[JPPKKBH_DATE] [datetime] NOT NULL,
[JPPKKBH_QTY] [numeric](30, 5) NOT NULL,
[JPPKKBH_QTYF] [numeric](30, 5) NOT NULL,
[JPPKKBH_COMENT] [varchar](8000) NULL,
[JPPKKBH_DESCRIPTION] [varchar](8000) NOT NULL,
[JPPKKBH_WHO] [varchar](150) NOT NULL,
[JPPKKBH_WHO_ID] [uniqueidentifier] NOT NULL,
[JPPKKBH_WHEN] [datetime] NOT NULL,
(
CREATE TABLE [dbo].[TBL_JOUR_PRODUCTION_PLAN_KK_BH_HISTORY](
[JPPKKBHH_ID] [uniqueidentifier] NOT NULL,
[JPPKKBHH_JPPKKBH_ID] [uniqueidentifier] NOT NULL,
[JPPKKBHH_JPPKKBH_JPKKBH_ID] [uniqueidentifier] NOT NULL,
[JPPKKBHH_JPPKKBH_WC_ID] [int] NOT NULL,
[JPPKKBHH_JPPKKBH_DATE] [datetime] NOT NULL,
[JPPKKBHH_JPPKKBH_QTY] [numeric](30, 5) NOT NULL,
[JPPKKBHH_JPPKKBH_QTYF] [numeric](30, 5) NOT NULL,
[JPPKKBHH_JPPKKBH_COMENT] [varchar](8000) NULL,
[JPPKKBHH_JPPKKBH_DESCRIPTION] [varchar](8000) NOT NULL,
[JPPKKBHH_JPPKKBH_WHO_ID] [uniqueidentifier] NULL,
[JPPKKBHH_JPPKKBH_WHEN] [datetime] NOT NULL,
[JPPKKBHH_OPER] [int] NOT NULL,
[JPPKKBHH_WHO_ID] [uniqueidentifier] NOT NULL,
[JPPKKBHH_WHEN] [datetime] NOT NULL,
(