交易明细
周
PaymentReports 卖家ID 国家ID public class PaymentReport { public int Id { get; set; } [Required(AllowEmptyStrings = false)] public string PartnerName { get; set; } [Required(AllowEmptyStrings = false)] public string CountryCode { get; set; } public DateTimeOffset Date { get; set; } public string SettlementId { get; set; } public string Type { get; set; } public string OrderId { get; set; } public string SKU { get; set; } public string Description { get; set; } public int? Quantity { get; set; } public string Marketplace { get; set; } public string AccountType { get; set; } public string Fulfillment { get; set; } public string OrderCity { get; set; } public string OrderState { get; set; } public string OrderPostal { get; set; } public string TaxCollectionModel { get; set; } public decimal? ProductSales { get; set; } public decimal? ProductSalesTax { get; set; } public decimal? ShippingCredits { get; set; } public decimal? ShippingCreditsTax { get; set; } public decimal? GiftWrapCredits { get; set; } public decimal? GiftwrapCreditsTax { get; set; } public decimal? CostPoints { get; set; } public decimal? PromotionalRebates { get; set; } public decimal? PromotionalRebatesTax { get; set; } public decimal? SalesTaxCollected { get; set; } public decimal? MarketplaceWithheldTax { get; set; } public decimal? LowValueGoods { get; set; } public decimal? TotalSalesTaxLiable { get; set; } public decimal? TCS_CGST { get; set; } public decimal? TCS_SGST { get; set; } public decimal? TCS_IGST { get; set; } public decimal? SellingFees { get; set; } public decimal? FbaFees { get; set; } public decimal? OtherTransactionFees { get; set; } public decimal? Other { get; set; } public decimal? Total { get; set; } } }
交易明细周
原表数据需求
date/time settlement id type order id sku description quantity marketplace account type fulfillment order city order state order postal tax collection model product sales product sales tax shipping credits shipping credits tax gift wrap credits giftwrap credits tax Regulatory Fee Tax On Regulatory Fee promotional rebates promotional rebates tax marketplace withheld tax selling fees fba fees other transaction fees other total
附加，更新时间，下载时间，卖家ID, 市场ID， 邮箱账号，