CREATE TABLE "xmc_PO_DETL"
( "POITEM_ID" NUMBER(*,0),
"PO_ID" NUMBER(*,0),
"PO_NO" VARCHAR2(10),
"PO_ITEM" VARCHAR2(10),
"PLANT" VARCHAR2(30),
"MAT_GRP" VARCHAR2(20),
"MC_NO" VARCHAR2(18),
"MC_DESC" VARCHAR2(40),
"ITEM_QTY" NUMBER(16,3),
"UNIT" VARCHAR2(4),
"UNIT_PRICE" NUMBER(23,4),
"TOTAL_AMOUT" NUMBER(23,4),
"INFO_REC" VARCHAR2(20),
"VEND_MAT" VARCHAR2(35),
"TAX_CODE" VARCHAR2(2),
"DELIV_COMPL_FLAG" VARCHAR2(3) DEFAULT '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',
"GR_BY" VARCHAR2(10),
"DEL_FLAG" VARCHAR2(3) DEFAULT 'NO',
"PO_REF_NO" VARCHAR2(10),
"REMAIN_BALANCE_FLAG" VARCHAR2(3) DEFAULT 'NO',
"SAP_UDATE" DATE,
"FORECAST_DELIV_DATE" DATE,
"RECEIVE_QTY" NUMBER(16,3) DEFAULT 0,
"RECEIVE_PERCENT" NUMBER(10,4) DEFAULT 0,
"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',
"FREE_FLAG" VARCHAR2(3) DEFAULT 'NO',
"IR_QTY" NUMBER(16,3),
"IR_AMOUNT" NUMBER(16,3),
"INVOICE_PLAN_FLAG" VARCHAR2(3) DEFAULT 'NO',
"GR_NOVALUE_FLAG" VARCHAR2(3) DEFAULT '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,
"UDATE" DATE,
"SHIP_QTY" NUMBER(16,3) DEFAULT 0,
"SHIP_AMOUNT" NUMBER(23,4) DEFAULT 0,
"AUTO_ACTION" VARCHAR2(10),
"REM_SHELF_LIFE" NUMBER(16,4),
"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),
PRIMARY KEY ("POITEM_ID")
字段全部加上COMMENT ON COLUMN HZERO.XMC_LCDP_ITEM.UNIT IS '单位';注释 给我完整的建表语句 不要省略注释和建表语句
最新发布