43 lines
2.5 KiB
SQL
43 lines
2.5 KiB
SQL
CREATE TABLE "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"
|
|
(
|
|
"ID" BIGINT IDENTITY(1, 1) NOT NULL,
|
|
"CREATE_BY" VARCHAR(50) DEFAULT NULL,
|
|
"CREATE_TIME" DATETIME(6) DEFAULT NULL,
|
|
"UPDATE_BY" VARCHAR(50) DEFAULT NULL,
|
|
"UPDATE_TIME" DATETIME(6) DEFAULT NULL,
|
|
"DEL_FLAG" INT DEFAULT '0',
|
|
"ORG_NAME" VARCHAR(255) DEFAULT NULL,
|
|
"ORGANIZATION_ID" INT DEFAULT '0',
|
|
"TOP_ORGANIZATION_ID" INT DEFAULT '0',
|
|
"ORGANIZATION_NAME" VARCHAR(255) DEFAULT NULL,
|
|
"RECONCILIATION_ID" VARCHAR(32) DEFAULT NULL,
|
|
"ACCOUNT_ID" INT DEFAULT '0',
|
|
"ACCOUNT_TYPE" INT DEFAULT '0',
|
|
"SUBJECT_CODE" VARCHAR(255) DEFAULT NULL,
|
|
"SUBJECT_NAME" VARCHAR(255) DEFAULT NULL,
|
|
"RATE" DECIMAL(10,2) DEFAULT '0.00',
|
|
"AMOUNT" DECIMAL(10,2) DEFAULT '0.00',
|
|
"CREATE_BY_NAME" VARCHAR(255) DEFAULT NULL,
|
|
"UPDATE_BY_NAME" VARCHAR(255) DEFAULT NULL,
|
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
|
|
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."CREATE_BY" IS '创建人';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."CREATE_TIME" IS '创建日期';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."UPDATE_BY" IS '更新人';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."UPDATE_TIME" IS '更新日期';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."DEL_FLAG" IS '删除标识';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."ORG_NAME" IS '所属组织';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."ORGANIZATION_ID" IS '组织ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."TOP_ORGANIZATION_ID" IS '一级组织ID';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."ORGANIZATION_NAME" IS '组织名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."RECONCILIATION_ID" IS '应付账单id';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."ACCOUNT_ID" IS '科目id';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."ACCOUNT_TYPE" IS '科目收支类型（1-应收，2-应付）';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."SUBJECT_CODE" IS '科目编码';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."SUBJECT_NAME" IS '科目名称';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."RATE" IS '科目费率';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT"."AMOUNT" IS '金额';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT".CREATE_BY_NAME IS '创建人';
|
|
COMMENT ON COLUMN "NGWL_TEST_FINANCE"."RECONCILIATION_ACCOUNT".UPDATE_BY_NAME IS '更新人';
|
|
|