ccfdb=# \dS+ dcg.brick_base_ebr Table "dcg.brick_base_ebr" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ------------------+--------------------------------+-----------+----------+---------+----------+--------------+- ------------ bill_num | character(10) | | not null | | extended | | bill_item | numeric(6,0) | | not null | | main | | comp_code | character(4) | | not null | | extended | | ze2e_flg | character(1) | | not null | | extended | | fiscvarnt | character(2) | | not null | | extended | | zsourceid | character(10) | | not null | | extended | | fiscyear | numeric(4,0) | | not null | | main | | sales_off | character(4) | | | | extended | | profit_ctr | character(10) | | | | extended | | doc_type | character(4) | | | | extended | | doc_number | character(10) | | not null | | extended | | so number s_ord_item | numeric(6,0) | | | | main | | billtoprty | character(10) | | | | extended | | ship_to | character(10) | | | | extended | | sold_to | character(10) | | | | extended | | zsalescat | character(10) | | | | extended | | plant | character(4) | | | | extended | | doc_num | character(10) | | | | extended | | doc_item | numeric(6,0) | | | | main | | material | character(18) | | | | extended | | prod_hier | character(18) | | | | extended | | zprdhier1 | character(21) | | | | extended | | zprdhier2 | character(23) | | | | extended | | zprdhier3 | character(23) | | | | extended | | zprdhier4 | character(24) | | | | extended | | zprdhier5 | character(24) | | | | extended | | currency | character(5) | | | | extended | | zprdhier6 | character(23) | | | | extended | | bill_date | character(10) | | | | extended | | zfiscper | numeric(6,0) | | | | main | | fiscper | numeric(7,0) | | | | main | | inv_qty | numeric(17,3) | | | | main | | zpcacost | numeric(17,2) | | | | main | | zcountry1 | character(2) | | | | extended | | zregion2 | character(15) | | | | extended | | crm_endcst | character(10) | | | | extended | | bill_qty | numeric(17,3) | | | | main | | ze2e_prt | character(10) | | | | extended | | zbmccost | numeric(17,2) | | | | main | | znet_inv1 | numeric(17,2) | | | | main | | zfingeo | character(20) | | | | extended | | deliv_numb | character(10) | | | | extended | | deliv_item | numeric(6,0) | | | | main | | zshtoctry | character(3) | | | | extended | | zsotoctry | character(3) | | | | extended | | zbicountr | character(3) | | | | extended | | sys_created_by | character(20) | | | | extended | | sys_created_date | timestamp(6) without time zone | | | | plain | | zbpcconty | character(32) | | | | extended | | zbuel_fin | character(30) | | | | extended | | mcmtbilldate | numeric(8,0) | | | | main | | request | character(30) | | | | extended | | item_categ | character(4) | | | | extended | | salesorg | character(4) | | | | extended | | matl_type | character(4) | | | | extended | | base_uom | character(3) | | | | extended | | fiscper3 | numeric(3,0) | | | | main | | recordmode | character(1) | | | | extended | | zcountry2 | character(2) | | | | extended | | zextsales | character(1) | | | | extended | | zendcst_s | character(10) | | | | extended | | zbu_sg_l1 | character(20) | | | | extended | | zbu_sg_l2 | character(40) | | | | extended | | zfin_desc | text | | | | extended | | zgtm_csl2 | character(20) | | | | extended | | zgtm_csl1 | character(10) | | | | extended | | zdcg_csl1 | character(20) | | | | extended | | zdcg_csl2 | character(40) | | | | extended | | zdcg_csl3 | character(100) | | | | extended | | zsolutnl1 | character(20) | | | | extended | | zsolutnl2 | character(40) | | | | extended | | zsolutnl3 | character(40) | | | | extended | | zsolutnl4 | character(40) | | | | extended | | zzbpcbu | character varying(20) | | | | extended | | zprodfly | character varying(64) | | | | extended | | zprodt_l1 | character varying(64) | | | | extended | | zbpcser | character varying(64) | | | | extended | | zprdsg_l1 | character varying(64) | | | | extended | | Indexes: "zoh_ees15_pkey" PRIMARY KEY, btree (bill_num, bill_item, comp_code, fiscvarnt, fiscyear, ze2e_flg, zsourcei d, doc_number) Triggers: insert_brick_base_ebr_partition_trigger BEFORE INSERT ON dcg.brick_base_ebr FOR EACH ROW EXECUTE PROCEDURE d cg.brick_base_ebr_partition_trigger() Child tables: dcg.brick_base_ebr_2018005, dcg.brick_base_ebr_2018010, dcg.brick_base_ebr_2019001, dcg.brick_base_ebr_2019002, dcg.brick_base_ebr_2019003, dcg.brick_base_ebr_2019004, dcg.brick_base_ebr_2019005, dcg.brick_base_ebr_2019006, dcg.brick_base_ebr_2019007, dcg.brick_base_ebr_2020001, dcg.brick_base_ebr_2020002, dcg.brick_base_ebr_2020004, dcg.brick_base_ebr_2020005, dcg.brick_base_ebr_2020006, dcg.brick_base_ebr_2020007, dcg.brick_base_ebr_2020008, dcg.brick_base_ebr_2020009, dcg.brick_base_ebr_2020012 \dS+ dcg.brick_shipment ccfdb=# \dS+ dcg.brick_shipment Table "dcg.brick_shipment" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ------------------+-----------------------------+-----------+----------+---------------------------------------- --------+----------+--------------+-------------------- bukrs | character varying(4) | | | | extended | | Company code gjahr | numeric(4,0) | | | | main | | Fiscal year monat | numeric(2,0) | | | | main | | Period belnr | character varying(10) | | | | extended | | Accounting Number budat | numeric(8,0) | | | | main | | Posting date cpudt | numeric(8,0) | | | | main | | Entry date cputm | character varying(16) | | | | extended | | Entry Time shkzg | character varying(1) | | | | extended | | Debit/Credit matnr | character varying(18) | | | | extended | | Material Code werks | character varying(4) | | | | extended | | Plant prctr | character varying(10) | | | | extended | | Profit center menge | character varying(13) | | | | extended | | GR quantity wrbtr | numeric(13,2) | | | | main | | Brick Amount netpr | numeric(11,2) | | | | main | | Brick Unit Price ebeln | character varying(10) | | | | extended | | Po(H) ebelp | numeric(5,0) | | | | main | | Po item(H) lifnr | character varying(10) | | | | extended | | Vendor(H) ltsnr | character varying(10) | | | | extended | | Manufacture Plant vbel2 | character varying(10) | | | | extended | | Sale order(H) posn2 | numeric(6,0) | | | | main | | So Item(H) zzgeo | character varying(50) | | | | extended | | Geo zzsgeo | character varying(50) | | | | extended | | Sub geo zsreg | character varying(15) | | | | extended | | Sub Region land1 | character varying(2) | | | | extended | | Country auart | character varying(4) | | | | extended | | SO Order type(H) prdha | character varying(18) | | | | extended | | Product Hierarchy prdha1 | character varying(1) | | | | extended | | Product Hierarchy1 prdha4 | character varying(4) | | | | extended | | Product Hierarchy2 prdha7 | character varying(7) | | | | extended | | Product Hierarchy3 prdha11 | character varying(11) | | | | extended | | Product Hierarchy4 prdha15 | character varying(15) | | | | extended | | Product Hierarchy5 v_name1 | character varying(35) | | | | extended | | Vendor Name maktx | character varying(40) | | | | extended | | Material Name vtext | character varying(38) | | | | extended | | PH Description vtext_1 | character varying(38) | | | | extended | | PH1 Description vtext_2 | character varying(38) | | | | extended | | PH2 Description vtext_3 | character varying(38) | | | | extended | | PH3 Description vtext_4 | character varying(38) | | | | extended | | PH4 Description vtext_5 | character varying(38) | | | | extended | | PH5 Description so_vtext | character varying(38) | | | | extended | | Sales org name sd_vbeln | character varying(10) | | | | extended | | End Cust So sd_posnr | numeric(6,0) | | | | main | | End Cust So item sd_kunnr | character varying(10) | | | | extended | | S&D customer sd_vkorg | character varying(4) | | | | extended | | S&D sale org sd_vkbur | character varying(4) | | | | extended | | S&D sale office sd_auart | character varying(4) | | | | extended | | S&D Order type sd_matnr | character varying(18) | | | | extended | | S&D material c_name1 | character varying(35) | | | | extended | | Customer Nanme zsbh | character varying(1) | | | | extended | | Direct/Replenish bezei | character varying(38) | | | | extended | | Sales office name ktext | character varying(38) | | | | extended | | Profit center name sys_created_date | timestamp(6) with time zone | | | | plain | | Sys Created Date sys_create_by | character varying(20) | | | | extended | | Sys Created By id | bigint | | not null | nextval('dcg.brick_shipment_id_seq'::re gclass) | plain | | ID buzei | numeric(3,0) | | | | main | | Doc Item segment | character varying(40) | | | | extended | | Segment zprctr | character varying(10) | | | | extended | | P&L Profit Center zdcg_csl1 | character varying(64) | | | | extended | | zdcg_csl2 | character varying(64) | | | | extended | | zdcg_csl3 | character varying(64) | | | | extended | | zprdsg_l1 | character varying(64) | | | | extended | | zprodt_l1 | character varying(64) | | | | extended | | zzbpcbu | character varying(64) | | | | extended | | zbpcser | character varying(64) | | | | extended | | Indexes: "brick_shipment_pkey" PRIMARY KEY, btree (id)