package Common::DB::Schema::RPS::Sale;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use base (qw/Common::DB::DBIxCore/);

## table
__PACKAGE__->table('sale');

## columns
__PACKAGE__->add_columns(qw/
    sale_id
    file_id
    service_id
    import_status
    product_id
    product_type
    format_type
    media_type
    date_begin
    date_end
    service_product_id
    client_product_id
    upc
    isrc
    artist_name
    album_name
    track_name
    label_name
    track_num
    units
    price
    wholesale_price
    retail_price
    free
    currency_code
    conversion_rate
    country_code
    line_num
    map_id
    wholesale_rate
    retail
    payout_type
    price_type
    sales
    sales_revenue
    returns
    returns_revenue
    total_revenue
    average_price
    price_level
    channel
    outlet
    configuration
    lic_track_id
    mcps_adjustment
    comments
    date_created
    date_modified
    mechanical_royalty_status
    ca_mechanical_royalty_status
    uk_mechanical_royalty_status
    artist_royalty_status
    label_royalty_status
/);

## primary key
__PACKAGE__->set_primary_key('sale_id');

1;