SALES DATA

mail@pastecode.io avatar
unknown
java
2 years ago
4.4 kB
1
Indexable
Never
package com.garage11.domain;

import lombok.Builder;
import lombok.Data;
import lombok.ToString;
import lombok.experimental.Tolerate;
import org.hibernate.annotations.CreationTimestamp;

import javax.persistence.*;
import java.math.BigDecimal;
import java.sql.Timestamp;

@Entity
@Table(name = "sales")
@Data
@Builder
@ToString
public class Sales {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Long id;

    @Column(name = "seller_id", length = 20)
    private String sellerId;

    @Column(name = "seller_name", length = 150)
    private String sellerName;

    @Column(name = "seller_surname", length = 150)
    private String sellerSurname;

    @Column(name = "seller_email", length = 150)
    private String sellerEmail;

    @Column(name = "seller_type", length = 20)
    private String sellerType;

    @Column(name = "buyer_id", length = 20)
    private String buyerId;

    @Column(name = "buyer_name", length = 150)
    private String buyerName;

    @Column(name = "buyer_surname", length = 150)
    private String buyerSurname;

    @Column(name = "buyer_email", length = 150)
    private String buyerEmail;

    @Column(name = "buyer_type", length = 20)
    private String buyerType;

    @Column(name = "car_id", length = 100)
    private String carId;

    @Column(name = "vehicle_title", length = 200)
    private String vehicleTitle;

    @Column(name = "vehicle_year")
    private Integer vehicleYear;

    @Column(name = "vehicle_brand", length = 40)
    private String vehicleBrand;

    @Column(name = "vehicle_model", length = 40)
    private String vehicleModel;

    @Column(name = "vehicle_body_style", length = 30)
    private String vehicleBodyStyle;

    @Column(name = "vehicle_transmission_type", length = 20)
    private String vehicleTransmissionType;

    @Column(name = "vehicle_fuel_type", length = 20)
    private String vehicleFuelType;

    @Column(name = "vehicle_version", length = 200)
    private String vehicleVersion;

    @Column(name = "vehicle_kilometers")
    private Integer vehicleKilometers;

    @Column(name = "plate_number", length = 10)
    private String plateNumber;

    @Column(name = "vehicle_color", length = 20)
    private String vehicleColor;

    @Column(name = "engine_no", length = 30)
    private String engineNo;

    @Column(name = "chassis_number", length = 30)
    private String chassisNumber;

    @Column(name = "city", length = 30)
    private String city;

    @Column(name = "order_channel", length = 20)
    private String orderChannel;

    @Column(name = "payment_type", length = 30)
    private String paymentType;

    @Column(name = "payment_name", length = 50)
    private String paymentName;

    @Column(name = "payment_type_id")
    private Long paymentTypeId;

    @Column(name = "payment_method", length = 50)
    private String paymentMethod;

    @Column(name = "order_id")
    private Long orderId;

    @Column(name = "order_status", length = 30)
    private String orderStatus;

    @Column(name = "sales_type", length = 30)
    private String salesType;

    @Column(name = "gmv")
    private BigDecimal gmv;

    @Column(name = "commission_amount")
    private BigDecimal commissionAmount;

    @Column(name = "commission_percent")
    private BigDecimal commissionPercent;

    @Column(name = "commission_amount_exc_vat")
    private BigDecimal commissionAmountExcVat;

    @Column(name = "net_rev_exc_vat")
    private BigDecimal netRevExcVat;

    @Column(name = "credit_amount")
    private BigDecimal creditAmount;

    @Column(name = "amount")
    private BigDecimal amount;

    @Column(name = "created_date")
    @CreationTimestamp
    private Timestamp createdDate;

    @Column(name = "settlement_date")
    private Timestamp settlementDate;

    @Column(name = "settlement_status")
    private Integer settlementStatus = 0;

    @Column(name = "seller_claim_amount")
    private BigDecimal sellerClaimAmount;

    @Column(name = "sap_payment_completed_date")
    protected Timestamp sapPaymentCompleteddate;

    @Column(name = "workflow_id")
    protected Long workflowId;

    @Column(name = "campaign")
    private String campaign;

    @Tolerate
    public Sales() {
    }

}