Hey @Seller_EdMkiu5XTXkvU
I searched online for 'payment settlement report + "shipment-fee-amount"' to find definitions in the developer documentation and came across an Excel file with the information. Since Excel files can pose security risks, I decided not to link directly to it but instead copied the definitions here for your reference.
Here's a detailed breakdown:
----
Field Name: settlement-id
Definition: Amazon's unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number of digits is 20.
Example: 236628501
----
Field Name: settlement-start-date
Definition: The start date of the settlement period being reported. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-03T16:00:00-07:00
----
Field Name: settlement-end-date
Definition: The end date of the settlement period being reported. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-10T16:00:00-07:00
----
Field Name: deposit-date
Definition: The date that the funds from the settlement period will be deposited into the merchant's bank account. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-15T16:00:00-07:00
----
Field Name: currency
Definition: The currency for the transaction - USD, GBP, EUR, CAD, JPY. All order, adjustment, fee, and event data will have the same currency.
Example: USD
----
Field Name: transaction-type
Definition: The type of transaction - Order, Adjustment, OtherFee, or MiscEvent
Example: Order
----
Field Name: order-id
Definition: Amazon’s unique, displayable identifier for an order. This is a numeric value. Total number of characters is 19. The value is represented as 3 numbers, a dash (-), 7 numbers, a dash (-) followed by another 7 numbers.
Example: 058-7987646-0553626
----
Field Name: marketplace-name
Definition: The name of the Marketplace where the order was placed. This value is a string with a maximum length of 50 characters.
----
Field Name: order-fee-type
Definition: The type of fee charged in the order-fee-amount column.
Example: Commission
----
Field Name: order-fee-amount
Definition: The amount of a particular fee charged for this order. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 0.34
----
Field Name: posted-date
Definition: The date that the item (order, adjustment, misc, or other) was debited or credited to the merchant's account. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-03T21:11:10-07:00
----
Field Name: order-item-code
Definition: Amazon’s unique, displayable identifier for an item within the order. This is a numeric value. Total number of digits is 14.
Example: 63043395314814
----
Field Name: sku
Definition: A merchant-defined unique identifier for a product. This is an alphanumeric value. The minimum number of characters is 1 and the maximum number of characters is 40.
Example: 1012
----
Field Name: quantity-purchased
Definition: The number of this item that were purchased. This is a numeric value. The maximum number of digits is 12.
Example: 1
----
Field Name: price-type
Definition: The type of price specified in the price-amount column.
Example: GiftWrapTax
----
Field Name: price-amount
Definition: The amount that the buyer paid for the type of price specified in the price-type column. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 5.36
----
Field Name: item-related-fee-type
Definition: The type of fee charged in the item-related-fee-amount column.
Example: Commission
----
Field Name: item-related-fee-amount
Definition: The amount of a particular fee charged in relation to this item. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 5.68
----
Field Name: misc-fee-amount
Definition: The amount of miscellaneous charges/credits to the account. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 6.39
----
Field Name: promotion-id
Definition: Merchant-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50.
Example: 90103summer
----
Field Name: promotion-type
Definition: The type of promotion referred to by the values in the promotion-id and promotion-amount columns.
Example: Shipping
----
Field Name: promotion-amount
Definition: The amount of promotional discount applied to the item due to the promotion specified in the promotion-id column. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 5.16
----
Field Name: other-amount
Definition: Additional charges/credits that do not fall under one of the other amount types. The transaction type for this amount will be specified in the transaction-type column.
Example: 5.99
----
