SETOS_PC
Tables (12)
tb_mes_pc100
- COMPANY — varchar(20) — Primary key — NOT NULL
- PR_CD — varchar(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- PR_DT — varchar(10)
- REMARK — varchar(400)
- USER_CD — varchar(255)
tb_mes_pc110
- COMPANY — varchar(20) — Primary key — NOT NULL
- PR_CD — varchar(20) — Primary key — NOT NULL
- PR_SEQ — bigint(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- CUST_CD — varchar(20)
- DEV_DT — varchar(10)
- DUE_DT — varchar(10)
- END_DT — varchar(10)
- END_QTY — decimal(20,5)
- END_REMARK — decimal(19,2)
- ITEM_CD — varchar(20)
- ITEM_QTY — decimal(20,5)
- ITEM_REMARK — varchar(400)
- REQ_QTY — decimal(20,5)
- PO_QTY — decimal(20,5)
- REQ_DT — varchar(10)
tb_mes_pc200
- COMPANY — varchar(20) — Primary key — NOT NULL
- PO_CD — varchar(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- CURRENCY_CD — varchar(20)
- CUST_CD — varchar(20)
- EXCHANGE_RATE — decimal(20,5)
- PO_DT — varchar(10)
- REMARK — varchar(400)
- SURTAX_YN — varchar(20)
- USER_CD — varchar(255)
tb_mes_pc210
- COMPANY — varchar(20) — Primary key — NOT NULL
- PO_CD — varchar(20) — Primary key — NOT NULL
- PO_SEQ — bigint(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- DEV_DT — varchar(10)
- DUE_DT — varchar(10)
- END_DT — varchar(10)
- END_QTY — decimal(20,5)
- END_REMARK — decimal(19,2)
- ITEM_CD — varchar(20)
- ITEM_QTY — decimal(20,5)
- ITEM_REMARK — varchar(400)
- MM_QC_YN — varchar(20)
- PR_CD — varchar(20)
- PR_SEQ — bigint(20)
- SUPPLY_AMT — decimal(20,5)
- SURTAX_AMT — decimal(20,5)
- TOTAL_AMT — decimal(20,5)
- UNIT_AMT — decimal(20,5)
- WH_CD — varchar(20)
- RV_QTY — decimal(20,5)
- SR_QTY — decimal(20,5)
- PC_QTY — decimal(20,5)
- RR_QTY — decimal(20,5)
tb_mes_pc300
- COMPANY — varchar(20) — Primary key — NOT NULL
- SR_CD — varchar(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- CURRENCY_CD — varchar(20)
- CUST_CD — varchar(20)
- EXCHANGE_RATE — decimal(20,5)
- REMARK — varchar(400)
- SR_DT — varchar(10)
- SURTAX_YN — varchar(20)
- USER_CD — varchar(255)
tb_mes_pc310
- COMPANY — varchar(20) — Primary key — NOT NULL
- SR_CD — varchar(20) — Primary key — NOT NULL
- SR_SEQ — bigint(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- DEV_DT — varchar(10)
- DUE_DT — varchar(10)
- ITEM_CD — varchar(20)
- ITEM_QTY — decimal(20,5)
- ITEM_REMARK — varchar(400)
- MM_QC_YN — varchar(20)
- PO_CD — varchar(20)
- PO_SEQ — bigint(20)
- SUPPLY_AMT — decimal(20,5)
- SURTAX_AMT — decimal(20,5)
- TOTAL_AMT — decimal(20,5)
- UNIT_AMT — decimal(20,5)
- WH_CD — varchar(20)
- QM_QTY — decimal(20,5)
- RV_QTY — decimal(20,5)
tb_mes_pc400
- COMPANY — varchar(20) — Primary key — NOT NULL
- RV_CD — varchar(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- CURRENCY_CD — varchar(20)
- CUST_CD — varchar(20)
- EXCHANGE_RATE — decimal(20,5)
- PC_RV_TYPE — varchar(20)
- REMARK — varchar(400)
- RV_DT — varchar(10)
- SURTAX_YN — varchar(20)
- USER_CD — varchar(255)
tb_mes_pc410
- COMPANY — varchar(20) — Primary key — NOT NULL
- RV_CD — varchar(20) — Primary key — NOT NULL
- RV_SEQ — bigint(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- ITEM_CD — varchar(20)
- ITEM_QTY — decimal(20,5)
- ITEM_REMARK — varchar(400)
- LAST_ST_QTY — decimal(20,5)
- LOT_NO — varchar(20)
- PO_CD — varchar(20)
- PO_SEQ — bigint(20)
- QM_CD — varchar(20)
- QM_SEQ — bigint(20)
- SR_CD — varchar(20)
- SR_SEQ — bigint(20)
- ST_QTY — decimal(20,5)
- STOCK_CD — varchar(20)
- SUPPLY_AMT — decimal(20,5)
- SURTAX_AMT — decimal(20,5)
- TOTAL_AMT — decimal(20,5)
- UNIT_AMT — decimal(20,5)
- WH_CD — varchar(20)
- PC_QTY — decimal(20,5)
- RR_QTY — decimal(20,5)
tb_mes_pc500
- COMPANY — varchar(20) — Primary key — NOT NULL
- RR_CD — varchar(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- CURRENCY_CD — varchar(20)
- CUST_CD — varchar(20)
- EXCHANGE_RATE — decimal(20,5)
- REMARK — varchar(400)
- RR_DT — varchar(10)
- SURTAX_YN — varchar(20)
- USER_CD — varchar(255)
- PC_RV_TYPE — varchar(20)
tb_mes_pc510
- COMPANY — varchar(20) — Primary key — NOT NULL
- RR_CD — varchar(20) — Primary key — NOT NULL
- RR_SEQ — bigint(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- ITEM_CD — varchar(20)
- ITEM_QTY — decimal(20,5)
- ITEM_REMARK — varchar(400)
- LAST_ST_QTY — decimal(20,5)
- LOT_NO — varchar(20)
- PO_CD — varchar(20)
- PO_SEQ — bigint(20)
- RV_CD — varchar(20)
- RV_SEQ — bigint(20)
- ST_QTY — decimal(20,5)
- STOCK_CD — varchar(20)
- SUPPLY_AMT — decimal(20,5)
- SURTAX_AMT — decimal(20,5)
- TOTAL_AMT — decimal(20,5)
- UNIT_AMT — decimal(20,5)
- WH_CD — varchar(20)
- SLIP_CD — varchar(20) — NOT NULL
- SLIP_SEQ — bigint(20) — NOT NULL
- ITEM_ABS_QTY — decimal(20,5)
- LAST_PC_QTY — decimal(20,5)
- PC_QTY — decimal(20,5)
- PC_SLIP_CD — varchar(20)
- PC_SLIP_SEQ — bigint(20)
- REF_SLIP_CD — varchar(20)
- REF_SLIP_SEQ — bigint(20)
- REMAIN_QTY — decimal(20,5)
- USE_QTY — decimal(20,5)
tb_mes_pc600
- COMPANY — varchar(20) — Primary key — NOT NULL
- PC_CD — varchar(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- CURRENCY_CD — varchar(20)
- CUST_CD — varchar(20)
- EXCHANGE_RATE — decimal(20,5)
- PC_DT — varchar(10)
- REMARK — varchar(400)
- SURTAX_YN — varchar(20)
- USER_CD — varchar(255)
tb_mes_pc610
- COMPANY — varchar(20) — Primary key — NOT NULL
- PC_CD — varchar(20) — Primary key — NOT NULL
- PC_SEQ — bigint(20) — Primary key — NOT NULL
- CREATED_AT — datetime
- CREATED_BY — varchar(255)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(255)
- ITEM_CD — varchar(50)
- ITEM_QTY — decimal(20,5)
- ITEM_REMARK — varchar(400)
- PO_CD — varchar(20)
- PO_SEQ — bigint(20)
- RV_CD — varchar(20)
- RV_SEQ — bigint(20)
- SUPPLY_AMT — decimal(20,5)
- SURTAX_AMT — decimal(20,5)
- TOTAL_AMT — decimal(20,5)
- UNIT_AMT — decimal(20,5)
- RR_CD — varchar(20)
- RR_SEQ — bigint(20)