Advertisement
aadddrr

tt_summary_for_report_achievement_and_target_20180424

Apr 24th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE tt_summary_for_report_achievement_and_target
  2. (
  3.     session_id character varying(50),
  4.     tenant_id bigint,
  5.     salesman_id bigint,
  6.     original_target_amount numeric,
  7.     target_amount numeric,
  8.     original_year_to_date_accumulative_amount numeric,
  9.     year_to_date_accumulative_amount numeric,
  10.     salesman_level bigint,
  11.     group_brand_parent_code character varying(50),
  12.     salesman_handle_id bigint,
  13.     salesman_handle_level bigint
  14. )
  15. WITH (
  16.   OIDS=FALSE
  17. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement