[postgres@slpnmhudtkt-sns backup]$ pg_dump -d ccfdb -s -t dcg.brick_base_ebr -- -- PostgreSQL database dump -- -- Dumped from database version 10.3 -- Dumped by pg_dump version 10.3 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: brick_base_ebr; Type: TABLE; Schema: dcg; Owner: i_ds -- CREATE TABLE dcg.brick_base_ebr ( bill_num character(10) NOT NULL, bill_item numeric(6,0) NOT NULL, comp_code character(4) NOT NULL, ze2e_flg character(1) NOT NULL, fiscvarnt character(2) NOT NULL, zsourceid character(10) NOT NULL, fiscyear numeric(4,0) NOT NULL, sales_off character(4), profit_ctr character(10), doc_type character(4), doc_number character(10) NOT NULL, s_ord_item numeric(6,0), billtoprty character(10), ship_to character(10), sold_to character(10), zsalescat character(10), plant character(4), doc_num character(10), doc_item numeric(6,0), material character(18), prod_hier character(18), zprdhier1 character(21), zprdhier2 character(23), zprdhier3 character(23), zprdhier4 character(24), zprdhier5 character(24), currency character(5), zprdhier6 character(23), bill_date character(10), zfiscper numeric(6,0), fiscper numeric(7,0), inv_qty numeric(17,3), zpcacost numeric(17,2), zcountry1 character(2), zregion2 character(15), crm_endcst character(10), bill_qty numeric(17,3), ze2e_prt character(10), zbmccost numeric(17,2), znet_inv1 numeric(17,2), zfingeo character(20), deliv_numb character(10), deliv_item numeric(6,0), zshtoctry character(3), zsotoctry character(3), zbicountr character(3), sys_created_by character(20), sys_created_date timestamp(6) without time zone, zbpcconty character(32), zbuel_fin character(30), mcmtbilldate numeric(8,0), request character(30), item_categ character(4), salesorg character(4), matl_type character(4), base_uom character(3), fiscper3 numeric(3,0), recordmode character(1), zcountry2 character(2), zextsales character(1), zendcst_s character(10), zbu_sg_l1 character(20), zbu_sg_l2 character(40), zfin_desc text, zgtm_csl2 character(20), zgtm_csl1 character(10), zdcg_csl1 character(20), zdcg_csl2 character(40), zdcg_csl3 character(100), zsolutnl1 character(20), zsolutnl2 character(40), zsolutnl3 character(40), zsolutnl4 character(40), zzbpcbu character varying(20), zprodfly character varying(64), zprodt_l1 character varying(64), zbpcser character varying(64), zprdsg_l1 character varying(64) ); ALTER TABLE dcg.brick_base_ebr OWNER TO i_ds; -- -- Name: COLUMN brick_base_ebr.doc_number; Type: COMMENT; Schema: dcg; Owner: i_ds -- COMMENT ON COLUMN dcg.brick_base_ebr.doc_number IS 'so number'; -- -- Name: brick_base_ebr zoh_ees15_pkey; Type: CONSTRAINT; Schema: dcg; Owner: i_ds -- ALTER TABLE ONLY dcg.brick_base_ebr ADD CONSTRAINT zoh_ees15_pkey PRIMARY KEY (bill_num, bill_item, comp_code, fiscvarnt, fiscyear, ze2e_flg, zsourceid, doc_number); -- -- Name: brick_base_ebr insert_brick_base_ebr_partition_trigger; Type: TRIGGER; Schema: dcg; Owner: i_ds -- CREATE TRIGGER insert_brick_base_ebr_partition_trigger BEFORE INSERT ON dcg.brick_base_ebr FOR EACH ROW EXECUTE PROCEDURE dcg.brick_base_ebr_partition_trigger(); -- -- Name: TABLE brick_base_ebr; Type: ACL; Schema: dcg; Owner: i_ds -- GRANT SELECT ON TABLE dcg.brick_base_ebr TO p_jiaohx; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_base_ebr TO a_app; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_base_ebr TO p_sunpan1; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_base_ebr TO p_cuiyue3; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_base_ebr TO a_mbgapp_dev; GRANT SELECT ON TABLE dcg.brick_base_ebr TO p_wangrh8; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_base_ebr TO p_yangxy23; GRANT ALL ON TABLE dcg.brick_base_ebr TO ccfuser; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_base_ebr TO i_talend; -- -- PostgreSQL database dump complete pg_dump -d ccfdb -s -t dcg.brick_shipment [postgres@slpnmhudtkt-sns backup]$ pg_dump -d ccfdb -s -t dcg.brick_shipment -- -- PostgreSQL database dump -- -- Dumped from database version 10.3 -- Dumped by pg_dump version 10.3 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: brick_shipment; Type: TABLE; Schema: dcg; Owner: ccfuser -- CREATE TABLE dcg.brick_shipment ( bukrs character varying(4), gjahr numeric(4,0), monat numeric(2,0), belnr character varying(10), budat numeric(8,0), cpudt numeric(8,0), cputm character varying(16), shkzg character varying(1), matnr character varying(18), werks character varying(4), prctr character varying(10), menge character varying(13), wrbtr numeric(13,2), netpr numeric(11,2), ebeln character varying(10), ebelp numeric(5,0), lifnr character varying(10), ltsnr character varying(10), vbel2 character varying(10), posn2 numeric(6,0), zzgeo character varying(50), zzsgeo character varying(50), zsreg character varying(15), land1 character varying(2), auart character varying(4), prdha character varying(18), prdha1 character varying(1), prdha4 character varying(4), prdha7 character varying(7), prdha11 character varying(11), prdha15 character varying(15), v_name1 character varying(35), maktx character varying(40), vtext character varying(38), vtext_1 character varying(38), vtext_2 character varying(38), vtext_3 character varying(38), vtext_4 character varying(38), vtext_5 character varying(38), so_vtext character varying(38), sd_vbeln character varying(10), sd_posnr numeric(6,0), sd_kunnr character varying(10), sd_vkorg character varying(4), sd_vkbur character varying(4), sd_auart character varying(4), sd_matnr character varying(18), c_name1 character varying(35), zsbh character varying(1), bezei character varying(38), ktext character varying(38), sys_created_date timestamp(6) with time zone, sys_create_by character varying(20), id bigint DEFAULT nextval('dcg.brick_shipment_id_seq'::regclass) NOT NULL, buzei numeric(3,0), segment character varying(40), zprctr character varying(10), zdcg_csl1 character varying(64), zdcg_csl2 character varying(64), zdcg_csl3 character varying(64), zprdsg_l1 character varying(64), zprodt_l1 character varying(64), zzbpcbu character varying(64), zbpcser character varying(64) ); ALTER TABLE dcg.brick_shipment OWNER TO ccfuser; -- -- Name: COLUMN brick_shipment.bukrs; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.bukrs IS 'Company code'; -- -- Name: COLUMN brick_shipment.gjahr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.gjahr IS 'Fiscal year'; -- -- Name: COLUMN brick_shipment.monat; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.monat IS 'Period'; -- -- Name: COLUMN brick_shipment.belnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.belnr IS 'Accounting Number'; -- -- Name: COLUMN brick_shipment.budat; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.budat IS 'Posting date'; -- -- Name: COLUMN brick_shipment.cpudt; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.cpudt IS 'Entry date'; -- -- Name: COLUMN brick_shipment.cputm; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.cputm IS 'Entry Time'; -- -- Name: COLUMN brick_shipment.shkzg; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.shkzg IS 'Debit/Credit '; -- -- Name: COLUMN brick_shipment.matnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.matnr IS 'Material Code'; -- -- Name: COLUMN brick_shipment.werks; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.werks IS 'Plant'; -- -- Name: COLUMN brick_shipment.prctr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prctr IS 'Profit center'; -- -- Name: COLUMN brick_shipment.menge; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.menge IS 'GR quantity'; -- -- Name: COLUMN brick_shipment.wrbtr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.wrbtr IS 'Brick Amount'; -- -- Name: COLUMN brick_shipment.netpr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.netpr IS 'Brick Unit Price'; -- -- Name: COLUMN brick_shipment.ebeln; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.ebeln IS 'Po(H)'; -- -- Name: COLUMN brick_shipment.ebelp; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.ebelp IS 'Po item(H)'; -- -- Name: COLUMN brick_shipment.lifnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.lifnr IS 'Vendor(H) '; -- -- Name: COLUMN brick_shipment.ltsnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.ltsnr IS 'Manufacture Plant'; -- -- Name: COLUMN brick_shipment.vbel2; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vbel2 IS 'Sale order(H)'; -- -- Name: COLUMN brick_shipment.posn2; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.posn2 IS 'So Item(H)'; -- -- Name: COLUMN brick_shipment.zzgeo; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.zzgeo IS 'Geo'; -- -- Name: COLUMN brick_shipment.zzsgeo; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.zzsgeo IS 'Sub geo'; -- -- Name: COLUMN brick_shipment.zsreg; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.zsreg IS 'Sub Region'; -- -- Name: COLUMN brick_shipment.land1; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.land1 IS 'Country'; -- -- Name: COLUMN brick_shipment.auart; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.auart IS 'SO Order type(H)'; -- -- Name: COLUMN brick_shipment.prdha; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prdha IS 'Product Hierarchy '; -- -- Name: COLUMN brick_shipment.prdha1; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prdha1 IS 'Product Hierarchy1'; -- -- Name: COLUMN brick_shipment.prdha4; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prdha4 IS 'Product Hierarchy2'; -- -- Name: COLUMN brick_shipment.prdha7; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prdha7 IS 'Product Hierarchy3'; -- -- Name: COLUMN brick_shipment.prdha11; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prdha11 IS 'Product Hierarchy4'; -- -- Name: COLUMN brick_shipment.prdha15; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.prdha15 IS 'Product Hierarchy5'; -- -- Name: COLUMN brick_shipment.v_name1; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.v_name1 IS 'Vendor Name'; -- -- Name: COLUMN brick_shipment.maktx; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.maktx IS 'Material Name'; -- -- Name: COLUMN brick_shipment.vtext; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vtext IS 'PH Description '; -- -- Name: COLUMN brick_shipment.vtext_1; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vtext_1 IS 'PH1 Description '; -- -- Name: COLUMN brick_shipment.vtext_2; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vtext_2 IS 'PH2 Description '; -- -- Name: COLUMN brick_shipment.vtext_3; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vtext_3 IS 'PH3 Description '; -- -- Name: COLUMN brick_shipment.vtext_4; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vtext_4 IS 'PH4 Description '; -- -- Name: COLUMN brick_shipment.vtext_5; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.vtext_5 IS 'PH5 Description '; -- -- Name: COLUMN brick_shipment.so_vtext; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.so_vtext IS 'Sales org name'; -- -- Name: COLUMN brick_shipment.sd_vbeln; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_vbeln IS 'End Cust So'; -- -- Name: COLUMN brick_shipment.sd_posnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_posnr IS 'End Cust So item'; -- -- Name: COLUMN brick_shipment.sd_kunnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_kunnr IS 'S&D customer'; -- -- Name: COLUMN brick_shipment.sd_vkorg; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_vkorg IS 'S&D sale org'; -- -- Name: COLUMN brick_shipment.sd_vkbur; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_vkbur IS 'S&D sale office'; -- -- Name: COLUMN brick_shipment.sd_auart; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_auart IS 'S&D Order type'; -- -- Name: COLUMN brick_shipment.sd_matnr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sd_matnr IS 'S&D material'; -- -- Name: COLUMN brick_shipment.c_name1; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.c_name1 IS 'Customer Nanme'; -- -- Name: COLUMN brick_shipment.zsbh; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.zsbh IS 'Direct/Replenish'; -- -- Name: COLUMN brick_shipment.bezei; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.bezei IS 'Sales office name'; -- -- Name: COLUMN brick_shipment.ktext; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.ktext IS 'Profit center name'; -- -- Name: COLUMN brick_shipment.sys_created_date; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sys_created_date IS 'Sys Created Date'; -- -- Name: COLUMN brick_shipment.sys_create_by; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.sys_create_by IS 'Sys Created By'; -- -- Name: COLUMN brick_shipment.id; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.id IS 'ID'; -- -- Name: COLUMN brick_shipment.buzei; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.buzei IS 'Doc Item'; -- -- Name: COLUMN brick_shipment.segment; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.segment IS 'Segment'; -- -- Name: COLUMN brick_shipment.zprctr; Type: COMMENT; Schema: dcg; Owner: ccfuser -- COMMENT ON COLUMN dcg.brick_shipment.zprctr IS 'P&L Profit Center'; -- -- Name: brick_shipment brick_shipment_pkey; Type: CONSTRAINT; Schema: dcg; Owner: ccfuser -- ALTER TABLE ONLY dcg.brick_shipment ADD CONSTRAINT brick_shipment_pkey PRIMARY KEY (id); -- -- Name: TABLE brick_shipment; Type: ACL; Schema: dcg; Owner: ccfuser -- GRANT SELECT ON TABLE dcg.brick_shipment TO p_jiaohx; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_shipment TO i_ds; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_shipment TO a_app; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_shipment TO p_sunpan1; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_shipment TO p_cuiyue3; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_shipment TO a_mbgapp_dev; GRANT SELECT ON TABLE dcg.brick_shipment TO p_wangrh8; GRANT SELECT,INSERT,DELETE,TRUNCATE,UPDATE ON TABLE dcg.brick_shipment TO p_yangxy23; -- -- PostgreSQL database dump complete --