CREATE TABLE "XMC_PO_DETL" (
"POITEM_ID" NUMBER(*,0) PRIMARY KEY USING INDEX (
CREATE INDEX "IDX_POITEM_PK" ON "XMC_PO_DETL"("POITEM_ID")
),
"PO_ID" NUMBER(*,0) NOT NULL,
"PO_NO" VARCHAR2(10) NOT NULL,
"PO_ITEM" VARCHAR2(10) NOT NULL,
"PLANT" VARCHAR2(30),
"MAT_GRP" VARCHAR2(20),
"MC_NO" VARCHAR2(18),
"MC_DESC" VARCHAR2(40),
"ITEM_QTY" NUMBER(16,3) CHECK ("ITEM_QTY" > 0),
"UNIT" VARCHAR2(4),
"UNIT_PRICE" NUMBER(23,4) CHECK ("UNIT_PRICE" >= 0),
"TOTAL_AMOUT" NUMBER(23,4) CHECK ("TOTAL_AMOUT" >= 0),
"INFO_REC" VARCHAR2(20),
"VEND_MAT" VARCHAR2(35),
"TAX_CODE" VARCHAR2(2) NOT NULL,
"DELIV_COMPL_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("DELIV_COMPL_FLAG" IN ('YES','NO')),
"DELIV_DATE" DATE,
"ITEM_CAT" VARCHAR2(1),
"PR_NO" VARCHAR2(10),
"PR_ITEM" VARCHAR2(10),
"ACCT_ASSCAT" VARCHAR2(1),
"GR_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("GR_FLAG" IN ('YES','NO')),
"GR_BY" VARCHAR2(10),
"DEL_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("DEL_FLAG" IN ('YES','NO')),
"PO_REF_NO" VARCHAR2(10),
"REMAIN_BALANCE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("REMAIN_BALANCE_FLAG" IN ('YES','NO')),
"SAP_UDATE" DATE,
"FORECAST_DELIV_DATE" DATE,
"RECEIVE_QTY" NUMBER(16,3) DEFAULT 0 CHECK ("RECEIVE_QTY" >= 0),
"RECEIVE_PERCENT" NUMBER(10,4) DEFAULT 0 CHECK ("RECEIVE_PERCENT" BETWEEN 0 AND 100),
"EQ_SEQ_ID" VARCHAR2(10),
"MANUFACTURER" VARCHAR2(60),
"EQ_MAKER_PART_NO" VARCHAR2(30),
"GL_ACCT" VARCHAR2(10),
"TAX_FREE_ENG" VARCHAR2(92),
"TAX_FREE_CHI" VARCHAR2(92),
"DRAW_DOC" VARCHAR2(22),
"DOC_VEND_MAT" VARCHAR2(60),
"ORIGINAL_MC_NO" VARCHAR2(20),
"PRICE_UNIT" NUMBER(*,0),
"REQUISITIONER" VARCHAR2(20),
"FINAL_INVOICE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("FINAL_INVOICE_FLAG" IN ('YES','NO')),
"FREE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("FREE_FLAG" IN ('YES','NO')),
"IR_QTY" NUMBER(16,3) CHECK ("IR_QTY" >= 0),
"IR_AMOUNT" NUMBER(16,3) CHECK ("IR_AMOUNT" >= 0),
"INVOICE_PLAN_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("INVOICE_PLAN_FLAG" IN ('YES','NO')),
"GR_NOVALUE_FLAG" VARCHAR2(3) DEFAULT 'NO' CHECK ("GR_NOVALUE_FLAG" IN ('YES','NO')),
"UNLOAD_POINT" VARCHAR2(20),
"ASSET_NO" VARCHAR2(50),
"ASSET_SUBNO" VARCHAR2(20),
"COST_CENTER" VARCHAR2(20),
"COAREA" VARCHAR2(30),
"COMMIT_ITEM" VARCHAR2(20),
"FUND_YEAR" VARCHAR2(10),
"FUND_CENTER" VARCHAR2(20),
"CDATE" DATE DEFAULT SYSDATE,
"UDATE" DATE DEFAULT SYSDATE,
"SHIP_QTY" NUMBER(16,3) DEFAULT 0 CHECK ("SHIP_QTY" >= 0),
"SHIP_AMOUNT" NUMBER(23,4) DEFAULT 0 CHECK ("SHIP_AMOUNT" >= 0),
"AUTO_ACTION" VARCHAR2(10),
"REM_SHELF_LIFE" NUMBER(16,4) CHECK ("REM_SHELF_LIFE" >= 0),
"RFQ_NO" VARCHAR2(10),
"RFQ_ITEM" VARCHAR2(6),
"INFOUPDATE_FLAG" VARCHAR2(3),
"FACILITY_PO_STATUS" VARCHAR2(20),
"TMP_DEL" VARCHAR2(3),
"PRICE_PRIORITY" VARCHAR2(255),
"BUDGET_CODE" VARCHAR2(20),
"COST_CATEGORY" VARCHAR2(30),
"ECCN" VARCHAR2(80),
"COSTDOWN_BASE" NUMBER(23,4),
CONSTRAINT "FK_PO_MAST" FOREIGN KEY ("PO_ID") REFERENCES "SP_PO_MAST"("PO_ID"),
CONSTRAINT "FK_TAX" FOREIGN KEY ("TAX_CODE") REFERENCES "SP_TAX"("TAX_CODE")
);
-- 创建常用查询索引
CREATE INDEX "IDX_PO_NO_ITEM" ON "XMC_PO_DETL"("PO_NO", "PO_ITEM");
CREATE INDEX "IDX_PR_NO" ON "XMC_PO_DETL"("PR_NO", "PR_ITEM");
CREATE INDEX "IDX_TAX_CODE" ON "XMC_PO_DETL"("TAX_CODE");
只要单纯的字段 视图校验全部去掉