create table transactions (
  order_id text not null,
  group_id text not null,
  order_total numeric not null,
  shipping_cost numeric not null,
  currency_code text not null,
  store_number integer not null,
  sales_rep text,
  last_modified_date date,
  banner text references banners not null,
  credit_card ,
  promos ,
  items ,
  ip_address text,
  source text not null,
  customer ,
  additional_data 
);
comment on table transactions is '
  Defines data expected to come in from OMS describing a transaction
';

comment on column transactions.source is '
  Order source (web, store, etc)
';
comment on column transactions.additional_data is '
  Additional `envelope` data sent through our system to f-s, should include InAuthId
';