GM OMS
Tables (8)
goods_items_mst
- goodsi_opt_title — nvarchar(80) — Primary key — NOT NULL
- goodsi_opt_value — nvarchar(80) — Primary key — NOT NULL
- goodsi_seq — int — Primary key — NOT NULL
- goods_sid — bigint — Foreign key → goods_mst.goods_sid — NOT NULL
- Field
- Field2
- Field3
goods_mst
- goods_partner_sid — bigint — Primary key — NOT NULL
- goods_brand_id — int — Primary key — NOT NULL
- goods_sid — bigint — Primary key — NOT NULL
- goods_status_cd — varchar(20)
- goods_save_status_cd — varchar(20)
- goods_sname — nvarchar(100)
- goods_fname — nvarchar(200)
- goods_category_cd — nvarchar(20)
- goods_sub_category_cd — nvarchar(20)
- goods_manufac_cd — nvarchar(20)
- goods_origin_cd — nvarchar(20)
- goods_org_price — numeric
- goods_price — numeric
- goods_org_cost — numeric
- goods_currency_cd — nvarchar(20)
- goods_type_cd — nvarchar(20)
- goods_remark — nvarchar(512)
- goods_launch_date — nvarchar(10)
- goods_ch_item_id — nvarchar(50)
- goods_old_yn — int
- create_date — nvarchar(10)
- create_time — nvarchar(8)
- create_user_sid — bigint
- update_date — nvarchar(10)
- update_time — nvarchar(8)
- update_user_sid — bigint
items_mst
- item_partner_sid — bigint — Primary key — NOT NULL
- item_partner_sub_id — int — Primary key — NOT NULL
- item_cd — nvarchar(20) — Primary key — NOT NULL
- item_alu — nvarchar(20)
- item_ean — nvarchar(20)
- item_sname_kor — nvarchar(40)
- Field
order_ext_hst
- ord_sid (ordx_sid) — bigint — Foreign key → order_hst.ord_sid — NOT NULL
- ordx_gather_IF — bigint
- ordx_gather_date — nvarchar(10)
- ordx_gather_time — nvarchar(8)
- ordx_deposit_erp_IF — bigint
- ordx_deposit_erp_date — nvarchar(10)
- ordx_deposit_erp_time — nvarchar(8)
- ordx_picking_wms_IF — bigint
- ordx_picking_wms_date — nvarchar(10)
- ordx_picking_wms_time — nvarchar(8)
- ordx_picking_ch_IF — bigint
- ordx_picking_ch_date — nvarchar(10)
- ordx_picking_ch_time — nvarchar(8)
- ordx_packed_wms_IF — bigint
- ordx_packed_wms_date — nvarchar(10)
- ordx_packed_wms_time — nvarchar(8)
- ordx_packed_ch_IF — bigint
- ordx_packed_ch_date — nvarchar(10)
- ordx_packed_ch_time — nvarchar(8)
- ordx_invoice_ch_IF — bigint
- ordx_invoice_ch_date — nvarchar(10)
- ordx_invoice_ch_time — nvarchar(8)
- ordx_invoice_wms_IF — bigint
- ordx_invoice_wms_date — nvarchar(10)
- ordx_invoice_wms_time — nvarchar(8)
- ordx_shipped_wms_IF — bigint
- ordx_shipped_wms_date — nvarchar(10)
- ordx_shipped_wms_time — nvarchar(8)
- ordx_shipped_ch_IF — bigint
- ordx_shipped_ch_date — nvarchar(10)
- ordx_shipped_ch_time — nvarchar(8)
- ordx_outbound_wms_IF — bigint
- ordx_outbound_wms_date — nvarchar(10)
- ordx_outbound_wms_time — nvarchar(8)
- ordx_outbound_ch_IF — bigint
- ordx_outbound_ch_date — nvarchar(10)
- ordx_outbound_ch_time — nvarchar(8)
- ordx_outbound_ch_remark — nvarchar(50)
- ordx_sales_erp_IF — bigint
- ordx_sales_erp_date — nvarchar(10)
- ordx_sales_erp_time — nvarchar(8)
- ordx_delivery_ch_IF — bigint
- ordx_delivery_ch_date — nvarchar(10)
- ordx_delivery_ch_time — nvarchar(8)
- ordx_cancel_erp_IF — bigint
- ordx_cancel_erp_date — nvarchar(10)
- ordx_cancel_erp_time — nvarchar(8)
- ordx_cancel_ch_IF — bigint
- ordx_cancel_ch_date — nvarchar(10)
- ordx_cancel_ch_time — nvarchar(8)
- ordx_vas_IF — bigint
- ordx_vas_date — nvarchar(10)
- ordx_vas_time — nvarchar(8)
order_goods_dtl
- ordg_goods_seq — int — Primary key — NOT NULL
- ord_sid (ordg_sid) — bigint — Foreign key → order_hst.ord_sid — NOT NULL
- goods_sid (ordg_good_sid) — bigint — Foreign key → goods_mst.goods_sid
- ordg_good_opt_title — nvarchar(80)
- ordg_goods_opt_value — nvarchar(80)
- ordg_unit_price — numeric
- ordg_unit_dc — numeric
- ordg_unit_net — numeric
- ordg_unit_vat — numeric
- ordg_unit_tax1 — numeric
- ordg_unit_tax2 — numeric
- ordg_qty — numeric
- ordg_item_id — nvarchar(80)
- ordg_option_code — nvarchar(50)
- ordg_option_name — nvarchar(100)
- ordg_ext_fld01 — nvarchar(50)
- ordg_ext_fld02 — nvarchar(50)
- ordg_ext_fld03 — nvarchar(50)
- ordg_ext_fld04 — nvarchar(50)
- ordg_ext_fld05 — nvarchar(50)
- ordg_ext_fld06 — nvarchar(50)
- ordg_ext_fld07 — nvarchar(50)
- ordg_ext_fld08 — nvarchar(50)
- ordg_ext_fld09 — nvarchar(50)
- ordg_ext_fld10 — nvarchar(MAX)
- ordg_retqty — numeric
order_hst
- ord_partner_sid — bigint — Primary key — NOT NULL
- ord_sid — bigint — Primary key — NOT NULL
- ord_ch_id — nvarchar(50)
- ord_id — nvarchar(50)
- ord_seq — int
- ord_dlv_id — nvarchar(30)
- ord_type — nvarchar(1)
- ord_status_cd — nvarchar(10)
- ord_substatus_cd — nvarchar(10)
- ord_date — nvarchar(10)
- ord_time — nvarchar(8)
- ord_confirm_date — nvarchar(10)
- ord_request_date — nvarchar(10)
- ord_collect_date — nvarchar(10)
- ord_currency_cd — nvarchar(10)
- ord_sales_price — numeric
- ord_dc_amt — numeric
- ord_gross_amt — numeric
- ord_net_amt — numeric
- ord_vat_amt — numeric
- ord_tax1_amt — numeric
- ord_tax2_amt — numeric
- ord_dlv_cost_gross_amt — numeric
- ord_dlv_cost_net_amt — numeric
- ord_dlv_cost_vat_amt — numeric
- ord_dlv_cost_tax1_amt — numeric
- ord_dlv_cost_tax2_amt — numeric
- ord_cust_cd — nvarchar(200)
- ord_cust_first_name — nvarchar(2048)
- ord_cust_first_name_E — nvarchar(2048)
- ord_cust_last_name — nvarchar(2048)
- ord_cust_last_name_E — nvarchar(2048)
- ord_cust_full_name — nvarchar(2048)
- ord_cust_full_name_E — nvarchar(2048)
- ord_cust_gender_cd — nvarchar(20)
- ord_cust_birth_date — nvarchar(10)
- ord_cust_email — nvarchar(500)
- ord_cust_email_E — nvarchar(2048)
- ord_cust_tel — nvarchar(50)
- ord_cust_tel_E — nvarchar(2048)
- ord_cust_mobile — nvarchar(50)
- ord_cust_mobile_E — nvarchar(2048)
- ord_cust_country_cd — nvarchar(50)
- ord_cust_state — nvarchar(200)
- ord_cust_city — nvarchar(4000)
- ord_cust_addr1 — nvarchar(4000)
- ord_cust_addr2 — nvarchar(4000)
- ord_cust_addr2_E — nvarchar(4000)
- ord_send_snm — nvarchar(50)
- ord_send_fnm — nvarchar(50)
- ord_send_zip_code1 — nvarchar(10)
- ord_send_zip_code2 — nvarchar(10)
- ord_send_tel — nvarchar(10)
- ord_send_addr1 — nvarchar(4000)
- ord_send_addr2 — nvarchar(4000)
- ord_send_addr3 — nvarchar(2048)
- ord_ship_first_name — nvarchar(2048)
- ord_ship_first_name_E — nvarchar(2048)
- ord_ship_last_name — nvarchar(2048)
- ord_ship_last_name_E — nvarchar(2048)
- … +58
order_items_dtl
- ordi_no — int — Primary key — NOT NULL
- ord_sid (ordi_sid) — bigint — Foreign key → order_goods_dtl.ord_sid — NOT NULL
- ordi_good_seq — int
- ordi_good_sid — bigint
- ordi_item_cd — nvarchar(50)
- ordi_item_seq — int
- ordi_item_nm — numeric
- ordi_gubun — numeric
- ordi_item_qty — int
- ordi_item_outqty — int
- ordi_item_price — numeric
- ordi_item_gross — numeric
- ordi_item_dc — numeric
- ordi_item_net — numeric
- ordi_item_vat — numeric
- ordi_item_tax1 — numeric
- ordi_item_tax2 — numeric
- ordi_commition — int
- ordi_remark — nvarchar(250)
- ordi_item_retqty — int
- ordi_vas_sid — bigint
order_payment_dtl
- ordp_seq — int — Primary key — NOT NULL
- ord_sid (ordp_sid) — bigint — Foreign key → order_hst.ord_sid — NOT NULL
- ordp_method_cd — nvarchar(50)
- ordp_currency_cd — nvarchar(20)
- ordp_amt — numeric
- ordp_card_cd — nvarchar(50)
- ordp_card_cd_E — nvarchar(1024)
- ordp_card_app1_cd — nvarchar(50)
- ordp_card_app2_cd — nvarchar(50)
- ordp_extra_info1 — nvarchar(50)
- ordp_extra_info2 — nvarchar(50)
- ordp_extra_info3 — nvarchar(50)
- ordp_extra_info4 — nvarchar(50)
- ordp_extra_info5 — nvarchar(50)
- ordp_refund_num_E — nvarchar(1024)