Inventory Ledger Details
Inventory Ledger Details

Inventory Ledger Details

📂
icon
Table name Seller: inventory_ledger_details

The inventory ledger report operates like a bank statement for a seller’s FBA inventory, providing end-to-end inventory reconciliation. The detail table shows details about all inventory events in a fulfillment center, including reason codes for inventory adjustments.

Statistics

Updated: Daily

Backfill: 1 year

Key Metrics

quantity

disposition

reason

Data Dictionary

Inventory Adjustment Reason Codes

Code
Type
Reason
Definition
6
-
Damaged at Amazon fulfillment center
A decrease to your carrier-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
7
-
Damaged at Amazon fulfillment center
A decrease to your expired inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
E
-
Damaged at Amazon fulfillment center
A decrease to your sellable inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
H
-
Damaged at Amazon fulfillment center
A decrease to your customer-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
K
-
Damaged at Amazon fulfillment center
A decrease to your defective inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
U
-
Damaged at Amazon fulfillment center
A decrease to your distributor-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level.
D
-
Inventory disposed of
A decrease to your inventory level because inventory has been disposed of
F
+
Inventory found
An increase to your inventory level because missing inventory has been found
N
+
Inventory found
An increase to your inventory level because inventory that was incorrectly assigned has been transferred to your account or because you received an Amazon reimbursement
M
-
Inventory misplaced
A decrease to your inventory level because inventory is missing from a bin location in a fulfillment center
5
-
Inventory misplaced
A decrease to your inventory level because inventory is missing from a bin location in a fulfillment center
3
+
Product redefinition transfer in
Two products with separate identifiers (SKUs) are determined to be the same item. One SKU will be removed from your inventory (code 4) and added (code 3) as the other SKU.
4
-
Product redefinition transfer out
Two products with separate identifiers (SKUs) are determined to be the same item. One SKU will be removed from your inventory (code 4) and added (code 3) as the other SKU.
O
-
Inventory correction
Units that have been transferred out of your account because they were incorrectly received into your inventory or because Amazon has reimbursed you for them
P
+
Inventory disposition change
Units of a certain disposition are added to your inventory after the removal from a different disposition. This code always follows a code 6, 7, E, H, K, U, or Q adjustment.
Q
-
Inventory disposition change
Units of a certain disposition are removed from your inventory and then added back to your inventory as a different disposition. This code is always followed by a P code adjustment.
image