掌握GTD方法，实现生活平衡的艺术

掌握健康生活艺术，享受平衡的生活方式 #生活乐趣# #生活艺术# #健康生活艺术# #身心平衡艺术#

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"); 只要单纯的字段 视图校验全部去掉

网址：掌握GTD方法，实现生活平衡的艺术 https://www.yuejiaxmz.com/news/view/1361886

相关内容

平衡工作与生活的艺术——GTD简单介绍
养生之道：掌握生活的平衡艺术
搞定Ⅲ：平衡工作与生活的艺术
搞定3：平衡工作与生活的艺术
情绪调节的艺术，掌握自我，享受平衡生活
时间管理的艺术：掌握生活与工作的平衡
情绪调节，掌握心理平衡的艺术
搞定：无压工作的艺术+提升工作与生活效率+平衡工作与生活的艺术(共三册)【全本
养生之道：掌握生活中的平衡艺术
掌握时间管理、实现平衡生活的 7 个行之有效的技巧

随便看看