Level 2 報表設計

CREATE TABLE JN_JNRef
(
AD_Client_ID NUMBER(10,0) NOT NULL,
AD_Org_ID NUMBER(10,0) NOT NULL,
JN_JNRef_ID NUMBER(10,0) NOT NULL,

Name NVARCHAR2(60) NOT NULL,
Value NVARCHAR2(60) NOT NULL,
Description NVARCHAR2(255),
ValidFrom DATE,
ValidTo DATE,
IsActive CHAR(1) DEFAULT 'Y' NOT NULL,
Created DATE DEFAULT SYSDATE NOT NULL,
CreatedBy NUMBER(10,0) DEFAULT 0 NOT NULL,
Updated DATE DEFAULT SYSDATE NOT NULL,
UpdatedBy NUMBER(10,0) DEFAULT 0 NOT NULL
)

CREATE TABLE JN_JNRefList
(
AD_Client_ID NUMBER(10,0) NOT NULL,
AD_Org_ID NUMBER(10,0) NOT NULL,
JN_JNRef_ID NUMBER(10,0) NOT NULL,
JN_JNRefList_ID NUMBER(10,0) NOT NULL,


Name NVARCHAR2(60) NOT NULL,
Value NVARCHAR2(60) NOT NULL,
Description NVARCHAR2(255),
ValidFrom DATE,
ValidTo DATE,

IsActive CHAR(1) DEFAULT 'Y' NOT NULL,
Created DATE DEFAULT SYSDATE NOT NULL,
CreatedBy NUMBER(10,0) DEFAULT 0 NOT NULL,
Updated DATE DEFAULT SYSDATE NOT NULL,
UpdatedBy NUMBER(10,0) DEFAULT 0 NOT NULL
)