-- 创建采购订单主表 XMC_PO_MAST
CREATE TABLE "XINSPADM"."SP_PO_MAST"
(
"PO_ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY, -- 主键，自增
"PO_NO" VARCHAR2(10), -- 采购订单编号
"PO_CAT" VARCHAR2(1), -- 采购订单类别
"PO_TYPE" VARCHAR2(10), -- 采购订单类型
"PMNT_TERM" VARCHAR2(20), -- 付款条件
"VENDOR_CODE" VARCHAR2(10), -- 供应商代码
"CURRENCY" VARCHAR2(5), -- 货币代码
"INCO_TERMS1" VARCHAR2(3), -- 贸易术语1
"INCO_TERMS2" VARCHAR2(30), -- 贸易术语2
"CONTRACT_START_DATE" DATE, -- 合同开始日期
"CONTRACT_END_DATE" DATE, -- 合同结束日期
"TARGET_VAL" NUMBER(23,4), -- 目标金额
"REL_GROUP" VARCHAR2(2), -- 关联组
"REL_FLAG" VARCHAR2(3) DEFAULT 'NO', -- 关联标志，默认NO
"REL_DATE" DATE, -- 关联日期
"DEL_FLAG" VARCHAR2(3) DEFAULT 'NO', -- 删除标志，默认NO
"COMPANY_CODE" VARCHAR2(10), -- 公司代码
"PUR_GROUP" VARCHAR2(5), -- 采购组
"PURCH_ORG" VARCHAR2(10), -- 采购组织
"EPO_FLAG" VARCHAR2(3) DEFAULT 'NO', -- EPO标志，默认NO
"MATN_MAN" VARCHAR2(20), -- 物料管理
"SAP_CDATE" DATE, -- SAP创建日期
"BUYER" VARCHAR2(20), -- 采购员
"CUR_REL_CODE" VARCHAR2(2), -- 当前关联代码
"SALES_PERSON" VARCHAR2(30), -- 销售人员
"PUR_GROUP_CONTACT" VARCHAR2(50), -- 采购组联系人
"PUR_GROUP_TEL" VARCHAR2(30), -- 采购组电话
"PR_NO" VARCHAR2(20), -- 采购申请编号
"USERID" VARCHAR2(20), -- 用户ID
"VALIDITY_START" DATE, -- 有效期开始
"VALIDITY_END" DATE, -- 有效期结束
"MODIFIER" VARCHAR2(20), -- 修改者
"WORKFLOW_STATUS" VARCHAR2(255), -- 工作流状态
"STREET" VARCHAR2(100), -- 街道地址
"HOUSE_NUMBER" VARCHAR2(50), -- 门牌号
"POST_CODE" VARCHAR2(20), -- 邮政编码
"CITY" VARCHAR2(200), -- 城市
"COUNTRY_CODE" VARCHAR2(100), -- 国家代码
"TEL" VARCHAR2(30), -- 电话
"TEL_EXT" VARCHAR2(30), -- 电话分机
"FAX" VARCHAR2(30), -- 传真
"FAX_EXT" VARCHAR2(30), -- 传真分机
"STOCK_TYPE" VARCHAR2(10), -- 库存类型
"CDATE" DATE, -- 创建日期
"UDATE" DATE, -- 更新日期
"WORKFLOW_ID" NUMBER(19,0), -- 工作流ID
"FLOW_TYPE" VARCHAR2(255), -- 流程类型
"WORKFLOW_START_DATE" DATE, -- 工作流开始日期
"WORKFLOW_FINISH_DATE" DATE, -- 工作流结束日期
"WARRANTY_PERIOD" NUMBER(*,0), -- 保修期
"WARRANTY_METHOD" VARCHAR2(20), -- 保修方式
"HEAD_CAT" VARCHAR2(1), -- 头类别
"HEAD_TAX" VARCHAR2(2), -- 头税码
"CATEGORY" VARCHAR2(1), -- 类别
"MAX_ORG_LEVEL" VARCHAR2(20), -- 最大组织级别
"MAX_ORG_GRADE" NUMBER(18,0), -- 最大组织等级
"MAX_SIGN_PERSON" VARCHAR2(20), -- 最大签字人
"CREATE_TYPE" VARCHAR2(20), -- 创建类型
"BIDDING" VARCHAR2(3), -- 招标标志
"BIDDING_NO" VARCHAR2(20), -- 招标编号
"BACK_OFFICE" VARCHAR2(10), -- 后台
"FINAL_VENDOR_CODE" VARCHAR2(6), -- 最终供应商代码
"VENDOR_MAIL_ADDRESS" VARCHAR2(60), -- 供应商邮箱地址
"CONTRACT_NUMBER" VARCHAR2(200), -- 合同编号
"NEED_CONTRACT" VARCHAR2(20), -- 是否需要合同
"WITHOUT_CONTRACT_REASON" VARCHAR2(255), -- 无合同原因
"HC_WEB_SITE" VARCHAR2(10), -- HC网站
"IS_HC_PO" VARCHAR2(5), -- 是否HC采购订单
"HC_ORDER_ID" VARCHAR2(25), -- HC订单ID
"ELE_SEAL_STATUS" VARCHAR2(150), -- 电子印章状态
"ELE_SEAL_CONTRACT_ID" VARCHAR2(40), -- 电子印章合同ID
"PURCHASE_WAY" VARCHAR2(100 CHAR), -- 采购方式
"URGENT_REASON" VARCHAR2(250), -- 紧急原因
"SINGLE_CONTRACT" VARCHAR2(10), -- 单一合同
"SRM_PO_PAGE_URL" VARCHAR2(255), -- SRM采购订单页面URL
"CURRENCY_FLAG" VARCHAR2(2), -- 货币标志
"CLEAR_FLAG" VARCHAR2(2), -- 清除标志
CONSTRAINT "UQ_PO_MAST_PONO" UNIQUE ("PO_NO") DISABLE, -- PO_NO唯一约束，禁用状态
PRIMARY KEY ("PO_ID") -- 主键约束，PO_ID自增
)
SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(
INITIAL 65536 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "SUPPLY_DATA";
-- 创建索引，提升查询性能
CREATE INDEX "XINSPADM"."INX_SP_PO_MAST_PONO" ON "XINSPADM"."SP_PO_MAST" ("PO_NO")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "SUPPLY_DATA";
CREATE INDEX "XINSPADM"."INX_SP_PO_MAST_PRNO" ON "XINSPADM"."SP_PO_MAST" ("PR_NO")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "SUPPLY_DATA";
CREATE INDEX "XINSPADM"."INX_SP_PO_MAST_VCODE" ON "XINSPADM"."SP_PO_MAST" ("VENDOR_CODE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "SUPPLY_DATA";
CREATE INDEX "XINSPADM"."SP_PO_MAST_IDX1" ON "XINSPADM"."SP_PO_MAST" ("PMNT_TERM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "SUPPLY_DATA";
CREATE UNIQUE INDEX "XINSPADM"."SYS_C0012217" ON "XINSPADM"."SP_PO_MAST" ("PO_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PO_ID IS '采购订单主键，自增';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PO_NO IS '采购订单编号';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PO_CAT IS '采购订单类别';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PO_TYPE IS '采购订单类型';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PMNT_TERM IS '付款条件';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.VENDOR_CODE IS '供应商代码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CURRENCY IS '货币代码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.INCO_TERMS1 IS '贸易术语1';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.INCO_TERMS2 IS '贸易术语2';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CONTRACT_START_DATE IS '合同开始日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CONTRACT_END_DATE IS '合同结束日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.TARGET_VAL IS '目标金额';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.REL_GROUP IS '关联组';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.REL_FLAG IS '关联标志，默认NO';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.REL_DATE IS '关联日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.DEL_FLAG IS '删除标志，默认NO';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.COMPANY_CODE IS '公司代码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PUR_GROUP IS '采购组';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PURCH_ORG IS '采购组织';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.EPO_FLAG IS 'EPO标志，默认NO';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.MATN_MAN IS '物料管理';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.SAP_CDATE IS 'SAP创建日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.BUYER IS '采购员';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CUR_REL_CODE IS '当前关联代码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.SALES_PERSON IS '销售人员';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PUR_GROUP_CONTACT IS '采购组联系人';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PUR_GROUP_TEL IS '采购组电话';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PR_NO IS '采购申请编号';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.USERID IS '用户ID';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.VALIDITY_START IS '有效期开始';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.VALIDITY_END IS '有效期结束';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.MODIFIER IS '修改者';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WORKFLOW_STATUS IS '工作流状态';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.STREET IS '街道地址';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.HOUSE_NUMBER IS '门牌号';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.POST_CODE IS '邮政编码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CITY IS '城市';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.COUNTRY_CODE IS '国家代码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.TEL IS '电话';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.TEL_EXT IS '电话分机';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.FAX IS '传真';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.FAX_EXT IS '传真分机';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.STOCK_TYPE IS '库存类型';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CDATE IS '创建日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.UDATE IS '更新日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WORKFLOW_ID IS '工作流ID';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.FLOW_TYPE IS '流程类型';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WORKFLOW_START_DATE IS '工作流开始日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WORKFLOW_FINISH_DATE IS '工作流结束日期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WARRANTY_PERIOD IS '保修期';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WARRANTY_METHOD IS '保修方式';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.HEAD_CAT IS '头类别';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.HEAD_TAX IS '头税码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CATEGORY IS '类别';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.MAX_ORG_LEVEL IS '最大组织级别';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.MAX_ORG_GRADE IS '最大组织等级';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.MAX_SIGN_PERSON IS '最大签字人';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CREATE_TYPE IS '创建类型';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.BIDDING IS '招标标志';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.BIDDING_NO IS '招标编号';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.BACK_OFFICE IS '后台';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.FINAL_VENDOR_CODE IS '最终供应商代码';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.VENDOR_MAIL_ADDRESS IS '供应商邮箱地址';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.CONTRACT_NUMBER IS '合同编号';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.NEED_CONTRACT IS '是否需要合同';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.WITHOUT_CONTRACT_REASON IS '无合同原因';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.HC_WEB_SITE IS 'HC网站';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.IS_HC_PO IS '是否HC采购订单';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.HC_ORDER_ID IS 'HC订单ID';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.ELE_SEAL_STATUS IS '电子印章状态';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.ELE_SEAL_CONTRACT_ID IS '电子印章合同ID';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.PURCHASE_WAY IS '采购方式';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.URGENT_REASON IS '紧急原因';
COMMENT ON COLUMN XINSPADM.SP_PO_MAST.SINGLE_CONTRACT IS 索引优化下 不需要这么多
常用Linux命令与技巧
扫一扫
859
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
