                  Table "public.stmst_sku"
          Column          |         Type         | Modifiers 
--------------------------+----------------------+-----------
 fpp_code                 | text                 | not null
 brn_code                 | text                 | not null
 sku                      | text                 | not null
 group_code               | text                 | not null
 qty_on_hand              | numeric(16,3)        | 
 qty_on_ind               | numeric(16,3)        | 
 qty_on_repair            | numeric(16,3)        | 
 qty_on_loan              | numeric(16,3)        | 
 qty_in_brn               | numeric(16,3)        | 
 qty_out_brn              | numeric(16,3)        | 
 qty_in_cus               | numeric(16,3)        | 
 qty_out_cus              | numeric(16,3)        | 
 qty_in_supp              | numeric(16,3)        | 
 qty_out_supp             | numeric(16,3)        | 
 qty_in_oth               | numeric(16,3)        | 
 qty_out_oth              | numeric(16,3)        | 
 qty_in_goods             | numeric(16,3)        | 
 qty_out_goods            | numeric(16,3)        | 
 stktype_code             | character varying(2) | 
 tax_code                 | text                 | 
 curr_cst                 | numeric(16,3)        | 
 curr_cst_l               | numeric(16,3)        | 
 curr_rsp_ca              | numeric(16,3)        | 
 curr_rsp_ca_l            | numeric(16,3)        | 
 curr_rsp_cr              | numeric(16,3)        | 
 curr_rsp_cr_l            | numeric(16,3)        | 
 mth_sls_qty              | numeric(16,3)        | 
 mth_sls_cst              | numeric(16,3)        | 
 mth_sls_cst_l            | numeric(16,3)        | 
 mth_sls_disc             | numeric(16,3)        | 
 mth_sls_disc_l           | numeric(16,3)        | 
 mth_sls_nett_excl        | numeric(16,3)        | 
 mth_sls_nett_excl_l      | numeric(16,3)        | 
 max_hold_qty             | numeric(16,3)        | 
 min_hold_qty             | numeric(16,3)        | 
 qty_on_hold              | numeric(16,3)        | 
 qty_dp                   | numeric(16,3)        | 
 mth_sls_qty_und          | numeric(16,3)        | default 0
 mth_sls_cst_und          | numeric(16,3)        | default 0
 mth_sls_cst_l_und        | numeric(16,3)        | default 0
 mth_sls_disc_und         | numeric(16,3)        | default 0
 mth_sls_disc_l_und       | numeric(16,3)        | default 0
 mth_sls_nett_excl_und    | numeric(16,3)        | default 0
 mth_sls_nett_excl_l_und  | numeric(16,3)        | default 0
 qty_in_br_domb           | numeric(16,3)        | default 0
 qty_out_cus_br_own_del   | numeric(16,3)        | default 0
 mat_sls_qty              | numeric(16,3)        | 
 ytd_sls_qty              | numeric(16,3)        | 
 mat_sls_cst              | numeric(16,3)        | 
 ytd_sls_cst              | numeric(16,3)        | 
 mat_sls_disc             | numeric(16,3)        | 
 ytd_sls_disc             | numeric(16,3)        | 
 mat_sls_nett_excl        | numeric(16,3)        | 
 ytd_sls_nett_excl        | numeric(16,3)        | 
 ly_mth_sls_nett_excl     | numeric(16,3)        | 
 ly_ytd_sls_nett_excl     | numeric(16,3)        | 
 stk_turn_qty_on_hand_cst | numeric(16,3)        | 
 no_mths_history          | integer              | default 0
Indexes: stmst_sku_pk primary key btree (fpp_code, brn_code, sku),
         stmst_sku_idx5 unique btree (fpp_code, brn_code, sku, group_code, stktype_code),
         stmst_ffp_brn_sku_idx btree (fpp_code, brn_code, sku),
         stmst_sku_idx1 btree (sku, brn_code),
         stmst_sku_idx2 btree (fpp_code, brn_code),
         stmst_sku_idx3 btree (fpp_code, sku, stktype_code),
         stmst_sku_idx4 btree (fpp_code),
         stmst_sku_idx7 btree (brn_code),
         stmst_sku_idx8 btree (stktype_code),
         stmst_sku_uidx1 btree (fpp_code, sku, brn_code, stktype_code)
Foreign Key constraints: stmst_sku_fk FOREIGN KEY (group_code, sku) REFERENCES item(group_code, sku) ON UPDATE NO ACTION ON DELETE NO ACTION

  count  
---------
 3115015
(1 row)

