The Settlement Data Feed report lists all settlements downloaded/imported into Communique.
Column Headings & Field Mappings
Settles
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
|
|