You have ALL cartons in the two carton tables, including reserve cartons -- but only active cartons are batched by the warehouse management system, so you will not have corresponding records in TRCART23 for the reserve cartons. Also, occasionally there are multiple lines in a carton with the same sku. This is because the customer ordered it that way and SPR preserves this. These are the column names, in order, for each file: Fields of table CDCART23: Pickticket Control Number (aka order number) Carton#(Unique number for each shipping carton) Carton Line Nbr StyleField1 of sku(These3 fields must be concatenated to get the full SKU) Style SfxField 2 of sku ColorField 3 of sku To Be Packed Units(Units called for in this box) Units Packed(Units packed in this box, may be less if there was a shortage) Zone Location that the item is to be pulled from Aisle Bay Level Position Date Created (Date and time this record was created in the database - indicates when the order was waved and picking documents were printed) Time Created Fields of table CHCART23 Carton# Pickticket Control Number Print Wave(The Wave number for the wave this carton was printed with) Pack Code(This field is '01' if the carton was from reserve, and blank if it was from active) Truck Plan ID(I think you can ignore this field for now) Date Created Time Created Fields of table TRCART23 Truck Nbr(Unique Batch Number) Area(This field should have been blank. Ignore it.) Zone Aisle Bay Level Position Style Style Sfx Color Carton Line Nbr Ctn/Pkt qty(Quantity to be picked for this carton and line) Carton#(Carton ID this line will be pickedfor) Pickticket Control Number Pkt Line Nbr Print Wave Date Created Time Created