Column

Table

Data Field

Type

Description

Settle ID

Settles

SettleID

Data

Settlement ID

Feed ID

Settles

FeedID

Data

Feed ID

Import

Settles

ImportDate

Data

Date Settlement was imported

Start

Settles

StartDate

Data

Start Date for the settlement period

End

Settles

EndDate

Data

End Date for the settlement period

Deposit

Settles

DepDate

Data

Deposit Date for the settlement

Dep Amt

Settles

DepAmt

Data

Deposit Amount

Nbr Ords

Settles

OrdsCnt

Data

Number of Orders within the Settlement

Sales

Settles

SalesProd

Data

Total Product Sales for Settlement

Tax

Settles

SalesTax

Data

Total Sales Tax for Settlement

Ship Fee

Settles

SalesShip

Data

Total Ship Fee collected for Settlement

Sales Oth

Settles

SalesOther

Data

Total Other Sales collected for Settlement

Revenue

Settles

SalesRev

Data

Total Sales Revenue collected for Settlement

Ord Fees

Settles

FeesOrd

Data

Total Order Fees for Settlement

Promo Fees

Settles

FeesPromo

Data

Total Promo Fees for Settlement

Ship Fees

Settles

FeesShip

Data

Total Ship Fees for Settlement

Other Fees

Settles

FeesOther

Data

Total Other Fees for Settlement

Fees

Settles

FeesTotal

Data

Total Fees for Settlement

Sales Net

Settles

Proprietary Algorithm

Calculated

Total Net Sales for Settlement

Nbr Ref

Settles

AdjCnt

Data

Total Number of Refunds for Settlement

Ref Sales

Settles

AdjSales

Data

Total Sales Refunded

Ref Fees

Settles

AdjFees

Data

Total Fees Refunded

Ref Credits

Settles

AdjCredits

Data

Total Credits Applied

Net Ref

Settles

AdjTotal

Data

Total Net Refunds for Settlement

Nbr Other

Settles

OthCnt

Data

Total Count of Other Transactions

Other

Settles

OthAmt

Data

Total Amount of Other Transactions