mes
Tables (49)
DIV_WORK_ORDER_DETAILWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — VARCHAR(20)
- WRITNG_SEQ — INTEGER
- WORK_DT — VARCHAR(10)
- WORK_ORDER_NO — VARCHAR(20)
- ORG_MATR_LOT_NO — VARCHAR(20)
- ORG_MATR_CD — VARCHAR(20)
- MATR_CD — VARCHAR(20)
- WORK_QY — INTEGER
- REMARK — VARCHAR(100)
- PROCK — INTEGER
DIV_WORK_ORDER_LOTWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — VARCHAR(20)
- WRITNG_SEQ — INTEGER
- SEQ — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- ORG_MATR_LOT_NO — VARCHAR(20)
- ORG_MATR_CD — VARCHAR(20)
- WORK_DT — VARCHAR(10)
- MATR_LOT_NO — VARCHAR(20)
- MATR_CD — VARCHAR(20)
- WORK_QY — INTEGER
- ORG_YN — INTEGER
- REMARK — VARCHAR(100)
DIV_WORK_ORDER_MSTWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — INTEGER
- WORK_ORDER_NM — VARCHAR(50)
- REMARK — VARCHAR(100)
TBL_BADN_DTLSDTLS_ID
- DTLS_ID — VARCHAR(50) — NOT NULL
- BADN_CD — VARCHAR(20)
- BADN_NM — VARCHAR(100)
- DIS_NO — INT
- DTLS — VARCHAR(100)
- PROCS_CD — VARCHAR(20)
- REMARK — VARCHAR(50)
TBL_MATR_DTA_INVNMATR_CD
- MATR_CD — VARCHAR(20)
- YEAR — VARCHAR(20)
- MONTH — VARCHAR(20)
- WRHOUSNG_QY — INT
- WRHOUSNG_RTNGUD — INT
- EXCCLC_WRHOUSNG — INT
- DLIVY_QY — INT
- DLIVY_RTNGUD — INT
- EXCCLC_DLIVY — INT
TBL_MATR_PLANWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — VARCHAR(20)
- SEQ — INTEGER
- MATR_PLAN_NO — VARCHAR(20)
- WORK_QY — INTEGER
- MATR_CD — VARCHAR(20)
- MATR_ORDER_QY — INTEGER
- REMARK — VARCHAR(100)
TBL_MATR_WRH_DD_DATE
- D_DATE — VARCHAR(20)
- D_NUM — INTEGER
- D_SEQ — INTEGER
- D_STATUS — INTEGER
- D_DIV — INTEGER
- D_OUTDIV — INTEGER
- D_MAGNO — VARCHAR(20)
- D_PONB — VARCHAR(20)
- D_PO_SEQ — INTEGER
- D_COMPANY — INTEGER
- D_PROJECT — VARCHAR(20)
- D_ITEMCODE — VARCHAR(20)
- D_QTY — INTEGER
- D_PRICE — number
- D_AMOUNT — number
- D_LOTNO — VARCHAR(20)
- D_PRORDERNO — VARCHAR(20)
- D_RRNUM — VARCHAR(20)
- D_INNUM — VARCHAR(20)
- D_REMARK — VARCHAR(100)
- D_INBAKQTY — number
- D_INCALQTY — number
- D_OUTQTY — number
- D_OUTBAKQTY — number
- D_OUTCALQTY — number
- D_PROCK — INTEGER
TBL_MATR_WRH_LL_DATE
- L_DATE — VARCHAR2(10)
- L_NUM — VARCHAR2(30)
- L_SEQ — INTEGER
- L_DIV — INTEGER
- L_COMPANY — VARCHAR(20)
- L_ITEMCODE — VARCHAR(20)
- L_MLOTNO — VARCHAR(30)
- L_REMARKS — VARCHAR(100)
- L_INQTY — number
- L_INBAKQTY — number
- L_INCALQTY — number
- L_OUTQTY — number
- L_OUTBAKQTY — number
- L_OUTCALQTY — number
- L_COUNT — INTEGER
- L_HOLDCK — INTEGER
- L_HOLDQTY — INTEGER
- L_HOLDREMARK — VARCHAR(100)
- L_PROCK — INTEGER
- L_PROGB — INTEGER
TBL_MATR_WRH_MM_DATE
- M_DATE — VARCHAR(20) — NOT NULL
- M_NUM — VARCHAR(20) — NOT NULL
- M_COMPANY — VARCHAR(20)
- M_DIV — CHAR(1)
- M_OUTDIV — CHAR(1)
- M_REMARK — VARCHAR(100)
TBL_PRDCTN_PLAN_DETAILPLAN_DT
- PLAN_DT — VARCHAR(20)
- PLAN_NO — VARCHAR(20)
- SEQ — INTEGER
- PRDCTN_PLAN_NO — VARCHAR(20)
- CSTMR_ORDER_NO — VARCHAR(20)
- CSTMR_SEQ — INTEGER
- PRDUCT_CD — VARCHAR(20)
- PLAN_QY — INTEGER
- WORK_DT — VARCHAR(10)
- WORK_SEQ — INTEGER
- PRDCTN_REQEST_QY — INTEGER
- CLOS_YN — INTEGER
- REMARK — VARCHAR(100)
TBL_PRDCTN_PLAN_MSTPLAN_DT
- PLAN_DT — VARCHAR(10)
- PLAN_NO — VARCHAR(20)
- PLAN_NM — VARCHAR(50)
- MANAGER — INTEGER
- REMARK — VARCHAR(100)
TBL_PRDCTN_PLAN_ORDERPLAN_DT
- PLAN_DT — VARCHAR(10)
- PLAN_NO — VARCHAR(20)
- SEQ — INTEGER
- WORK_PLAN_NO — VARCHAR(20)
- ORDER_MAG_NO — VARCHAR(20)
- WORK_QY — INTEGER
TBL_PRDCTN_SHIPMNT_DETAILDLIVY_DATE
- DLIVY_DATE — VARCHAR(20) — NOT NULL
- CHIT_NO — INTEGER — NOT NULL
- SEQ — INTEGER — NOT NULL
- DIV_CD — INTEGER
- COMPANY_CD — VARCHAR(50)
- ITEM_CD — VARCHAR(20)
- CSTMR_ORDER_NO — VARCHAR(20)
- LOT_NO — VARCHAR(20)
- QTY — INTEGER
- UNTPC — INTEGER
- AMOUNT — INTEGER
- REMARK — VARCHAR(100)
TBL_PRDCTN_SHIPMNT_LOTDLIVY_DATE
- DLIVY_DATE — VARCHAR(20) — NOT NULL
- CHIT_NO — VARCHAR(20) — NOT NULL
- SEQ — INTEGER — NOT NULL
- DIV_CD — INTEGER
- ITEM_CD — VARCHAR(20)
- PRDUCT_LOT_NO — VARCHAR(20)
- MATR_LOT_NO — VARCHAR(20)
- QTY — INTEGER
TBL_PRDCTN_SHIPMNT_MSTDLIVY_DATE
- DLIVY_DATE — VARCHAR(20) — NOT NULL
- CHIT_NO — INTEGER — NOT NULL
- DIV_CD — INTEGER — NOT NULL
- COMPANY_CD — VARCHAR(20)
- ROUT_NO — VARCHAR(20)
- REMARK — VARCHAR(100)
- PRO_DIV — INTEGER
TBL_PRDUCT_DTAPRDUCT_CD
- PRDUCT_CD — VARCHAR(20) — NOT NULL
- MNGR_EMPNO — VARCHAR(20)
- LOG_COMPANY — VARCHAR(20)
- TYPE_CD — VARCHAR(20)
- PRDUCT_DIV — VARCHAR(20)
- PRDCTN_DIV — VARCHAR(20)
- WRH_DIV — INTEGER
- USE_YN — CHAR(1)
- ASSY_YN — INTEGER
- SFINVC — INT
- SAFE_DAYCNT — INT
- MIN_INVNTRY — INT
- MAX_INVNTRY — INT
- PRDCTND_REQRE_DAYCNT — INT
- MNTHNG_REQRE_QY — INT
- HT_REQRE_QY — INT
TBL_PRDUCT_INVN_MNGPRDUCT_CD
- PRDUCT_CD — VARCHAR(20)
- YEAR — VARCHAR(4)
- MONTH — VARCHAR(2)
- PRDUCT_WRH_QY — int
- PRDUCT_RTNGUD_QY — int
- EXCCLC_WRH_QY — int
- DLIVY_QY — int
- DLIVY_RTNGUD_QY — int
- EXCCLC_DLIVY_QY — int
TBL_PRDUCT_PROCSPRDUCT_CD
- PRDUCT_CD — VARCHAR(20) — NOT NULL
- SEQ — INTEGER
- PROCS_CD — VARCHAR(20)
- OUTORD_YN — INTEGER
- OUTORD_CMPNY — VARCHAR(50)
- CONTENT — VARCHAR(50)
- QC_YN — INTEGER
- UNIT — VARCHAR(20)
- PRICE — DECIMAL(10,2)
- LEADTIME — INTEGER
TBL_PRDUCT_TOOLPRDUCT_CD
- PRDUCT_CD — VARCHAR(20) — NOT NULL
- MATR_CD — VARCHAR(20) — NOT NULL
- USE_WEIGHT — number
- USE_COUNT — INTEGER
- PROCS_CD — INTEGER
- REMARK — VARCHAR(100)
TBL_PROCS_ACMSLTWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- PROCS_SEQ — INTEGER
- LOT_NO — VARCHAR(20)
- MOVING_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- EQP_CD — VARCHAR(20)
- LINE_NO — INTEGER
- WORK_QY — INTEGER
- BADN_QY — INTEGER
- MATR_LOT_NO — VARCHAR(20)
- WORK_STTM_H — INTEGER
- WORK_STTM_M — INTEGER
- WORK_ENTM_H — INTEGER
- WORK_ENTM_M — INTEGER
- WRIT_TM — VARCHAR(10)
- REMARK — VARCHAR(100)
TBL_PROCS_ACMSLT_BADNWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — INTEGER
- WORK_SEQ — INTEGER
- PROCS_CD — INTEGER
- LOT_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- BADN_CD — INTEGER
- BADN_QY — INTEGER
- REMARK — VARCHAR(100)
TBL_PROCS_ACMSLT_MATR_USEWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — INTEGER
- PROCS_CD — INTEGER
- LOT_NO — VARCHAR(20)
- MATR_LOT_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- MATR_CD — VARCHAR(20)
- TOT_LOT_NO — VARCHAR(20)
- INPT_QY — DECIMAL(10,2)
TBL_PROCS_ACMSLT_WORKERWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- WORKER — INTEGER
TBL_PROCS_DTAPROCS_ID
- PROCS_ID — VARCHAR(20) — NOT NULL
- PRODC_CD — VARCHAR(20) — NOT NULL
- PROCS_NM — VARCHAR(100)
- RANK — INT
- UNIT — VARCHAR(20)
- OUTORD_PROCS — INT
- OUTORD_CMPNY — VARCHAR(20)
- LEAD_DAY — INT
- PROCS_DIV — VARCHAR(20)
- AUTO_MOVE — INT
- REMARK — VARCHAR(300)
TBL_PROCS_TOOL_MNGDLVR_DT
- DLVR_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- LOT_NO — VARCHAR(20)
- MOVING_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- EPQ_CD — VARCHAR(20)
- WORKER — INTEGER
- MATR_CD — VARCHAR(20)
- USE_QTY — INTEGER
- MATR_LOT_NO — VARCHAR(20)
- REMARK — VARCHAR(100)
- WRIT_TM — VARCHAR(20)
- PROCK — INTEGER
TBL_WORK_ORDER_DETAILWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — INTEGER
- WRITNG_SEQ — INTEGER
- WORK_DT — VARCHAR(20)
- CSTMR_ORDER_NO — VARCHAR(20)
- CSTMR_SEQ — INTEGER
- WORK_DIV — INTEGER
- PRDUCTN_PLAN_NO — VARCHAR(20)
- WORK_ORDER_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- TOT_WORK_QY — INTEGER
- WORK_SEQ — INTEGER
- REMARK — VARCHAR(100)
TBL_WORK_ORDER_LOT_DETAILWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — INTEGER
- WRITNG_SEQ — INTEGER
- WRITNG_SUB_NO — INTEGER
- WORK_DT — VARCHAR(20)
- CSTMR_ORDER_NO — VARCHAR(20)
- CSTMR_SEQ — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- MOVING_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- TOT_WORK_QY — INTEGER
- MATR_CD — VARCHAR(20)
- MATR_QY — INTEGER
- MATR_LOT_NO — VARCHAR(20)
- WORK_SEQ — INTEGER
- REMARK — VARCHAR(20)
TBL_WORK_ORDER_MNGWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — INTEGER
- SEQ — INTEGER
- PRDCTN_PLAN_NO — VARCHAR(20)
- WORK_ORDER_NO — VARCHAR(20)
- CSTMR_ORDER_MNG_NO — VARCHAR(20)
- WORK_QY — INTEGER
TBL_WORK_ORDER_MSTWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — INTEGER
- WORK_ORDER_NM — VARCHAR(50)
- EMPL_NO — INTEGER
- PRDCTN_PLAN_NO — VARCHAR(20)
- REMARK — VARCHAR(100)
TBL_WORK_PROCS_ACMSLTWRITNG_DT
- WRITNG_DT — VARCHAR(20)
- WRITNG_NO — INTEGER
- PROCS_SEQ — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- WORK_DT — VARCHAR(10)
- PRDUCT_CD — VARCHAR(20)
- PROCS_CD — INTEGER
- PROCS_PLAN_QY — INTEGER
- PROCS_WRH_QY — INTEGER
- PROCS_WRH_INSPCT_PSEXAM_QY — INTEGER
- PROCS_WRH_INSPCT_BADN_QY — INTEGER
- PRDCTN_QY — INTEGER
- PRDCTN_INSPCT_PSEXAM_QY — INTEGER
- PRDCTN_INSPCT_BADN_QY — INTEGER
- PROCS_DLIVY_QY — INTEGER
- OUTORD_WRH_WAIT_QY — INTEGER
- OUTORD_INSPCT_PSEXAM_QY — INTEGER
- OUTORD_INSPCT_BADN_QY — INTEGER
- OUTORD_WRH_QY — INTEGER
- DTA_PROCS_DIV — VARCHAR(1)
- CLOS_YN — VARCHAR(1)
- WORK_SEQ — INTEGER
lettnemplyrinfoESNTL_ID
- ESNTL_ID — VARCHAR2(20)
- EMPL_NO — VARCHAR(20)
- USER_NM2 — CHAR(20)
- ORGZT_ID — CHAR(20)
- USER_NM — VARCHAR(60)
- PASSWORD — VARCHAR(200)
- PASSWORD_HINT — VARCHAR(100)
- PASSWORD_CNSR — VARCHAR(100)
- IHIDNUM — VARCHAR(200)
- SEXDSTN_CODE — CHAR(1)
- BRTHDY — CHAR(20)
- FXNUM — VARCHAR(20)
- HOUSE_ADRES — VARCHAR(100)
- DETAIL_ADRES — VARCHAR(100)
- HOUSE_MIDDLE_TELNO — VARCHAR(4)
- HOUSE_END_TELNO — VARCHAR(4)
- AREA_NO — VARCHAR(4)
- ZIP — VARCHAR(6)
- OFFM_TELNO — VARCHAR(20)
- MBTLNUM — VARCHAR(20)
- EMAIL_ADRES — VARCHAR(50)
- OFCPS_NM — VARCHAR(60)
- GROUP_ID — CHAR(20)
- PSTINST_CODE — CHAR(8)
- EMPLYR_STTUS_CODE — VARCHAR(15)
- CRTFC_DN_VALUE — VARCHAR(20)
- SBSCRB_DE — date
- ENTERING_DATE — date
- JOB — VARCHAR(20)
- DEPT_CD — VARCHAR(20)
- TEAM_CD — VARCHAR(20)
- GROUP_CD — VARCHAR(20)
- DIVISION — CHAR(1)
- OUTORD_ENTRPS_ID — VARCHAR(20)
- PROCS_CD — VARCHAR(20)
- ENCY_DT — DATE
- REAL_BRTHDY — DATE
- ANSLRY — INTEGER
- MNTSLR — INTEGER
- PYMHR — INTEGER
- RSPOFC — VARCHAR(20)
- HOME_ZIP — VARCHAR(10)
- HOME_ADRES — VARCHAR(100)
- HOME_DETAIL_ADRES — VARCHAR(100)
- HOME_TELNO — VARCHAR(20)
- MOBLPHON — VARCHAR(20)
- EMAIL — VARCHAR(20)
- REMARK — VARCHAR(100)
tbl_assmbl_work_badnWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- LINE_NO — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- MATR_CD — VARCHAR(20)
- BADN_CD — INTEGER
- BADN_QY — INTEGER
- REMARK — VARCHAR(100)
tbl_assmbl_work_matr_useWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- SUB_MATR_CD — VARCHAR(20)
- MATR_CD — VARCHAR(20)
- MF_NO — VARCHAR(20)
- LOT_NO — VARCHAR(20)
- INPT_QY — INTEGER
tbl_box_dtaPRDUCT_CD
- PRDUCT_CD — VARCHAR(20) — NOT NULL
- PRIOR_YN — INTEGER
- BOX_CD — INTEGER
- USE_QY — INTEGER
- REMARK — VARCHAR(50)
tbl_box_invnBOX_NO
- BOX_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- WRH_DT — VARCHAR(10)
- BOX_TYPE — INTEGER
- WRH_QY — number
- MV_WRH_QY — number
- DLVR_QY — number
- MV_DLVR_QY — number
- EXCCLC_WRH_QY — number
- EXCCLC_DLVR_QY — number
- CLOS_YN — INTEGER
tbl_box_prduct_listBOX_NO
- BOX_NO — VARCHAR(20)
- WRH_DT — VARCHAR(10)
- WORK_ORDER_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- WRH_QY — INTEGER
- REMARK — VARCHAR(100)
tbl_div_work_procs_acmslt_mstWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- LOT_NO — INTEGER
- ORG_MATR_CD — VARCHAR(20)
- EQP_CD — VARCHAR(20)
- PRDCTN_QY — INTEGER
- BADN_QY — INTEGER
- MATR_USE_LOT_NO — INTEGER
- WORK_STTM_H — INTEGER
- WORK_STTM_M — INTEGER
- WORK_ENTM_H — INTEGER
- WORK_ENTM_M — INTEGER
- WRIT_TM — VARCHAR(20)
- MATR_BADN — VARCHAR(20)
- REMARK — VARCHAR(100)
tbl_matr_assmbl_workWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- LINE_NO — INTEGER
- MATR_CD — VARCHAR(20)
- WORKER — INTEGER
- WORK_QY — INTEGER
- BADN_QY — INTEGER
- WORK_STTM_H — INTEGER
- WORK_STTM_M — INTEGER
- WORK_ENTM_H — INTEGER
- WORK_ENTM_M — INTEGER
- WRIT_TM — VARCHAR(10)
- REMARK — VARCHAR(100)
tbl_matr_dtaMATR_CD
- MATR_CD — VARCHAR(20) — NOT NULL
- MATR_NM — VARCHAR(100)
- BARCODE — VARCHAR(20)
- PCODE — VARCHAR(20)
- WRHOUSNG_ENTRPS — INTEGER
- MATR_ACNT — INTEGER
- MATR_DIV — INTEGER
- MATR_MPDIV — INTEGER
- NOT_USE_YN — INTEGER
- INSP_TRGET_YN — INTEGER
- LOT_TRGET_YN — INTEGER
- SFINVC_MAG — INTEGER
- SFINVC — INTEGER
- SAFE_DAYCNT — INTEGER
- MIN_INVNTRY — INTEGER
- MAX_INVNTRY — INTEGER
- PRDCTND_REQRE_DAYCNT — INTEGER
- MNTHNG_REQRE_QY — INTEGER
- HT_REQRE_QY — INTEGER
- MAT_MA_ITEMCODE — VARCHAR(20) — NOT NULL
- MAT_MA_MITEMCODE — VARCHAR(20) — NOT NULL
- MAT_MA_ORDERCK — INTEGER
- MAT_MA_MATDCK — INTEGER
- MAT_MA_QTY — number
- MAT_MA_PROCESS — INTEGER
- MAT_MA_REMARK — VARCHAR(100)
tbl_matr_replaceMatrMAT_RE_MITEMCODE
- MAT_RE_MITEMCODE — VARCHAR(20) — NOT NULL
- MAT_RE_SITEMCODE — VARCHAR(20) — NOT NULL
- MAT_RE_REMARK — VARCHAR(100)
tbl_noprocCODE
- CODE — INTEGER
- CONTENTNAME — VARCHAR(100)
- EXPLANATION — VARCHAR(100)
- PROCESS_CODE — INTEGER
- DISNO — INTEGER
- REMARK — VARCHAR(100)
tbl_pack_mng_boxWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- PROCS_CD — INTEGER
- BOX_NO — VARCHAR(20)
- BOX_TYPE — INTEGER
- WORK_ORDER_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- QTY — INTEGER
tbl_prduct_lot_invnWORK_ORDER_NO
- WORK_ORDER_NO — VARCHAR(20)
- MATR_LOT_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- WRH_DT — VARCHAR(10)
- DLVR_DT — VARCHAR(10)
- WRH_QY — INTEGER
- MV_WRH_QY — INTEGER
- DLVR_QY — INTEGER
- MV_DLVR_QY — INTEGER
- EXCCLC_WRH_QY — INTEGER
- EXCCLC_DLVR_QY — INTEGER
- CLOS_YN — INTEGER
tbl_prduct_matrPRDUCT_CD
- PRDUCT_CD — VARCHAR(20) — NOT NULL
- MATR_CD — VARCHAR(20) — NOT NULL
- ORDER_YN — INTEGER
- PRDCTN_YN — INTEGER
- USE_WEIGHT — number
- USE_PROCS — INTEGER — NOT NULL
- REMARK — VARCHAR(100)
tbl_prduct_noWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- LOT_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- LINE_NO — INTEGER
- QTY — INTEGER
- REMARK — VARCHAR(100)
tbl_prduct_no_detailWORK_DT
- WORK_DT — VARCHAR(20)
- WORK_NO — VARCHAR(20)
- SEQ — INTEGER
- LOT_NO — VARCHAR(20)
- PRDUCT_CD — VARCHAR(20)
- PRDUCT_NO — VARCHAR(20)
tbl_product_uphMA_LUPH_LINECODE
- MA_LUPH_LINECODE — INTEGER — NOT NULL
- MA_LUPH_ITEMDIV — INTEGER
- MA_LUPH__ITEMCODE — VARCHAR(20) — NOT NULL
- MA_LUPH__PROCESS — INTEGER
- MA_LUPH_HQTY — INTEGER
- MA_LUPH_PRIMARY — INTEGER
- MA_LUPH_REMARK — VARCHAR(100)
tbl_work_line_manageLINE_CODE
- LINE_CODE — varchar(20) — NOT NULL
- LINE_NAME — varchar(50)
- PROCESS_CODE — int
- MACH_CODE — varchar(20)
- RANK — int
- REMARK — varchar(100)
tbl_workgrpLI_D_PROCESS
- LI_D_PROCESS — INTEGER — NOT NULL
- LI_D_LINECODE — INTEGER — NOT NULL
- LI_D_WORKER — INTEGER
- LI_D__REMARK — VARCHAR(100)